MSAccess Macro

Occasional Visitor

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