Macro/code to run "make-table query" from command button on form?

  • Thread starter Thread starter PJ
  • Start date Start date
P

PJ

I designed a query in Access 2007 that presents the dynasets in a popup
formfor the user to review and accept by hitting a command button, thus
either updating or adding the dynasets to an existing table.

I cannot figure out how the macro should be designed or what code I need...

Can anyone provide help, please?
 
PJ,

If it adding or updating records in an existing table, then it wouldn't be a
Make-table query. It would be an Append query or an Update query.

In either case, you can use an OpenQuery action in your macro to run the
append or update.

Once you have it working correctly, you can then add a SetWarnings/No action
before the OpenQuery action, to suppress the action query confirmation
prompts.
 
Back
Top