how do u turn confirmation message off in Access

[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.

 

[Guest]

How are you planning to run your macro overnight?

 

[Guest]

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.

 

[Guest]

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.

 

[Guest]

I plan to run the macro manually, at the end of the working day. I am
referring to the confirmation message you describe below.

 

[Guest]

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.

 

[Guest]

Thanks for the info.

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.