MSAccess Macro

[dmsitech]

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,

[#2]

@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