Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 11:00 AM (PST)
Microsoft Tech Community

MSAccess Macro

Copper Contributor

I need to build a macro that runs a series of queries that create a temporary table and then modify certain fields within this new table. I do not need the user to respond to the query warning messages. How do I suppress these messages,

1 Reply

@dmsitechDo this in VBA, not in a macro.

 

Use the Currentdb.Execute function to execute each query in turn,

 

Currentdb.Execute "MyQuery1", DBFailOnError

Currentdb.Execute "MyQuery2", DBFailOnError

 

and so on