I have a macro that runs the OutputTo action to export 2 Word documents. This works fine. The problem I have is that it prompts for overwrite everytime it's ran. Which means the woman who runs it has to sit and watch it run so she can make sure and click OK twice. What's the best way around this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Force macro to automatically overwrite
- Thread starter tomed
- Start date
thornmastr
Programmer
Consider converting your macro to VB code which which will give you considerable more flexibility. Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com
Hi
Sorry to butt in. Have you tried switching off the warning message facility by dechecking in the Tools/Options/EditFind?
There is a Check box for action query as well.
However, I find that even if you turned this off, it still pops up warning messages when the database is operated in Acces RunTime.Has someone a way out of this?
Cheers
Vijay
Sorry to butt in. Have you tried switching off the warning message facility by dechecking in the Tools/Options/EditFind?
There is a Check box for action query as well.
However, I find that even if you turned this off, it still pops up warning messages when the database is operated in Acces RunTime.Has someone a way out of this?
Cheers
Vijay
thornmastr
Programmer
docmd.setwarnings = false Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question