Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #8999

Re: Problem using Access accdb front end to data on Sharepoint

Show all headers | View raw

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

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

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