mjwcai
asked on
Access 2007 Macro hangs with SetWarnings
Created a Macro in Access 2007 to run a query. The query runs fine, database is trusted, the confrim action queries is off. When I setwarnings to No or Yes before the query, the macro hangs. When I remove the setwarnings, everything runs fine again, but I don't want the confirmation prompts. I would like to run this macro as a scheduled task so I do not want any prompts.
Suggestions?
Suggestions?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
How do I get a VBA to work in a scheduled task?
As a scheduled task I would assume you would be using the Windows Task Scheduler.
See:
How to Start Access by Using the Windows Schedule Service
Alternative:
Scheduler Utility
See:
How to Start Access by Using the Windows Schedule Service
Alternative:
Scheduler Utility
ASKER
I guess my question was how do I get the VBA into the macro so I can run as a scheduled task - I have never used VBA before - but I figured it out and got it working
ASKER