Database: MS Access
Subject: SetWarnings macro action
I am running macos to run several action queries that replace existing tables with new data based on parameter dates. There are several tables to update and to avoid the annyance of promts system messages have added an argument at the beginning of the macro to switch the warning off:
Action: SetWarnings
Argument: No
everything...
paullynch
Last Activity: Jun 7 '07, 04:11 PM
Joined: Apr 3 '07
Location:
-
setwarnings action default assumptions
-
MS Access Action Query Messages
Problem running action queries: MS Access
On running an access macro with runquery actions that run various action queries which create/delete and replace several tables, I am trying to avoid the pop up messages that tell me the existing tables will be deleted/replaced/created etc.
In the options I have turned off the confirm action queries tick box - but it doesn't seem to be making any difference I am stil getting the prompts....
No activity results to display