Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-access > #9000
| From | BobAlston <bobalston9@yahoo.com> |
|---|---|
| Newsgroups | comp.databases.ms-access |
| Subject | Re: Problem using Access accdb front end to data on Sharepoint |
| Date | 2014-02-11 18:50 -0600 |
| Organization | A noiseless patient Spider |
| Message-ID | <ldegg9$pnl$1@dont-email.me> (permalink) |
| References | <lde89g$85b$1@dont-email.me> <ldeeth$hmq$1@dont-email.me> |
On 2/11/2014 6:23 PM, BobAlston wrote: > On 2/11/2014 4:30 PM, BobAlston wrote: >> I am using Access 2010 with Sharepoint Access Services 2010 in a system. >> I have been using this since March 2013 with good success. >> >> I am just now seeing some missing data on the tables. This is foreign >> key data that should be automatically set by use of the form - subform >> relation. >> >> (I just changed the design to make the missing foreign key required. I >> will see if that helps any. I also added new tracking fields for >> who/when created and last updated key records.) >> >> When I look at the data table for the sub form, I find that these >> instances have occurred recently - in the past few days. I can see >> where the record added immediately before is fine while the record added >> immediately after is missing the foreign key from the form-subform >> relation. The problem records DO have other data entered in the record >> that looks correct. >> >> The software has been used for months. the first 370 records created in >> the subform are just fine. Only SOME recent ones are problems. >> >> Albert or anyone else with EXPERIENCE with Access - Sharepoint have >> suggestions? >> >> >> >> thanks >> >> Bob > I wonder if the issue was that the main form had not yet been > updated/written to the database and thus there was no main form key. > I put in code after update for the last name field, which I would > anticipate would be entered before anything in a sub form, but who knows. > > This thread suggests code for the subform's container field on enter event. > > http://www.utteraccess.com/forum/Preventing-subform-data-e-t1946149.html the above was a good guess but not my issue. I have code that forces an update after last name is entered and it is required. And the related record tabs will not work if the related master record key is null.
Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Problem using Access accdb front end to data on Sharepoint BobAlston <bobalston9@yahoo.com> - 2014-02-11 16:30 -0600
Re: Problem using Access accdb front end to data on Sharepoint BobAlston <bobalston9@yahoo.com> - 2014-02-11 18:23 -0600
Re: Problem using Access accdb front end to data on Sharepoint BobAlston <bobalston9@yahoo.com> - 2014-02-11 18:50 -0600
Re: Problem using Access accdb front end to data on Sharepoint "Albert D. Kallal" <PleaseNOSpamkallal@msn.com> - 2014-02-12 18:00 -0700
csiph-web