how do u turn confirmation message off in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to run a macro overnight that contains action queries. The problem is
how do I turn the confirmation message off. I have used
Tools_Options_Edit/find tab_Action Queries. The issue is that the queries use
data from tables hosted in America. Access help states that this is classed
as a 'data access page' and checking the action queries box will not work.
Can anyone please advise of a fix. Thanks.
 
Currently I run the macro during the day and I have to continually click on
the confirmation message prompts. This is time consuming. Ideally if I can
remove the confirmation message then the macro can be run overnight.
 
Are you referring to a confirmation message such as:
"you are about to add XXX Row(s)."?
When I asked how you planed to run your macro overnight, I meant how do plan
to run the application overnight. Are you setting something up in Windows
scheduler?
I think I have a solution for your problem, but need just a little more
information.
 
I plan to run the macro manually, at the end of the working day. I am
referring to the confirmation message you describe below.
 
Try adding "Set warnings" to the first line of your macro. This setting
should be set to "no" by default. I beleive this has the same effect as the
VBA code of "DoCmd.SetWarnings False" wich will turn off all warnings.
Let me know if this works.
 
Thanks for the info.

Mike said:
Try adding "Set warnings" to the first line of your macro. This setting
should be set to "no" by default. I beleive this has the same effect as the
VBA code of "DoCmd.SetWarnings False" wich will turn off all warnings.
Let me know if this works.
Click to expand...
 
Back
Top