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