To run two queries with a single command button

NaveenNandigam

Registered User.
Local time
Today, 14:08
Joined
Mar 31, 2005
Messages
14
Hi, I want to run a append query and a delete query by clicking a command button.Can anyone help me regarding this?????
Thanks in Advance
Naveen
:confused:
 
2 ways.
Create a macro with both queries and run the macro from the button.
Create VBA that does DOCMD.RUNQUERY "Queryname" twice with each query.
 
I could be wrong, but I think it's
DoCmd.OpenQuery "<QueryName>"
alternatively
DoCmd.RunSQL "<SQL Statement>"
 

Users who are viewing this thread

Back
Top Bottom