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

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?
 
S

Steve Schapel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Command button to look up and copy data from a query to a table 0
Run Query on Subform Using VBA Macro Button 1
ACCESS 2007: CREATE A BUTTON ON FORM TO LAUNCH MS WORD 1
Command Button to Macro in Contact Script Code 0
Launch code from Macro Problem 2
Macro button on Form 1
Performing a make table query from a form button 16
Make-Table query and macro 3

Top