Results 1 to 9 of 9
  1. #1
    KMan is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    12

    Enter Information in Fields that Enters into Other Fields as Well at Same Time or soon after.

    Hello,
    Is it possible to have a master Access table where I can type in customer ID, account name, account ID, and description and then have these fields autopopulate in other tables since they would contain the same information? I came in late to project so database design isn't perfect and I now need to figure out a workaround. Any ideas on how to go about doing this? Also, I don't want past information to be added to the other tables. Only the new information that is entered.

    Thanks

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    database design isn't perfect and I now need to figure out a workaround
    best workaround is to redesign, otherwise you'll be needing workarounds on workarounds.

    otherwise your workaround is to have code in the form before insert event to execute various insert queries to your target tables - then you will need additional code to delete those inserted records if your main form insert fails.

    Since you are using 2010, you can also look at using data macros which you can find on the ribbon in the table design view.

  3. #3
    KMan is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    12
    Should my data macros be after insert type? After I insert info in main table it enters into other tables?

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    no idea, I don't use them. Suggest try on test data and see what happens

  5. #5
    KMan is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    12
    My database is also linked. Is it still possible to use data macros?

  6. #6
    KMan is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    12
    Thanks for the help.

  7. #7
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    Is it still possible to use data macros?
    providing all the tables are in the same back end, I don't see why not, again, give it a try.

  8. #8
    KMan is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    12
    I wound up creating some append queries that will take the info over and then creating a macro to run all four append queries with one click. Thanks for the guidance.

  9. #9
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    as pointed about before, that is OK so long as none of the queries fail for some reason - could be any reason from some invalid data causing one or more updates to fail to a powercut. Suggest you read up on Begintrans, Committrans etc here

    https://msdn.microsoft.com/en-us/lib...(v=vs.85).aspx

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Cannot enter information in certain fields
    By AccessNewbie123 in forum Forms
    Replies: 9
    Last Post: 08-07-2015, 01:13 PM
  2. Enter parameter value when fields are correct
    By grahamYSA in forum Access
    Replies: 1
    Last Post: 07-09-2015, 02:03 AM
  3. Replies: 4
    Last Post: 04-03-2014, 10:34 AM
  4. Fill multiple fields with the same information
    By ben_jamin in forum Access
    Replies: 4
    Last Post: 07-23-2013, 07:24 AM
  5. can't enter data in some form fields
    By ashiers in forum Forms
    Replies: 1
    Last Post: 09-18-2008, 12:37 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums