Jan 30 2020 05:52 PM
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,
Jan 31 2020 06:48 AM
@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