Run multiple Append Queries

[joeserrone]

Hello,
I would like to have 1 button on a form that would run 2 append queries I created. They are bot going to the same table. Is there a way to do that?

Thanks

Joe

 

[boblarson]

doesn't matter which tables they go. You can run those queries by using this in the command button's click event:

With CurrentDb
    .Execute "YourQueryNameHere"
    .Execute "YourQuery2NameHere"
End With

 

[maxmangion]

Hi Bob,

Is the difference between your code and the DoCmd.OpenQuery only that the .Execute suppresses the query default warnings (for action queries) or there are other advantages as well?

Thank You

 

[boblarson]

Hi Bob,

Is the difference between your code and the DoCmd.OpenQuery only that the .Execute suppresses the query default warnings (for action queries) or there are other advantages as well?

Thank You

The main benefit that I know of is to keep from getting the warning messages and not having to mess with turning them off/back on again.

 

[maxmangion]

Thank You