MSAccess Macro

%3CLINGO-SUB%20id%3D%22lingo-sub-1142006%22%20slang%3D%22en-US%22%3EMSAccess%20Macro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1142006%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20build%20a%20macro%20that%20runs%20a%20series%20of%20queries%20that%26nbsp%3Bcreate%20a%20temporary%20table%20and%20then%20modify%20certain%20fields%20within%20this%20new%20table.%20I%20do%20not%20need%20the%20user%20to%20respond%20to%20the%20query%20warning%20messages.%20How%20do%20I%20suppress%20these%20messages%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1142006%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1143008%22%20slang%3D%22en-US%22%3ERe%3A%20MSAccess%20Macro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1143008%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F539559%22%20target%3D%22_blank%22%3E%40dmsitech%3C%2FA%3EDo%20this%20in%20VBA%2C%20not%20in%20a%20macro.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUse%20the%20Currentdb.Execute%20function%20to%20execute%20each%20query%20in%20turn%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECurrentdb.Execute%20%22MyQuery1%22%2C%20DBFailOnError%3C%2FP%3E%3CP%3ECurrentdb.Execute%20%22MyQuery2%22%2C%20DBFailOnError%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20so%20on%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
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
Highlighted

@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