I have an existing database that runs a script everyday to print out mailing labels. The script worked properly until the username was changed to a new user in the scheduler. I have not been able to get the prompts to be automatically answered. In the macro under Actions I have added SetWarnings to "yes" but I am still receiving the prompts. This is how the macro is setup: Action Arguments Comments Open Query EmptyCoupons, Datasheet, Edit Empty Table RunSavedImprortExport LoanCoupons ImportLoan Coupons SetWarnings No OpenReport LoanCoupons, Print,,Normal Quit Exit
I have moved the SetWarings below the OpenReport but have received the same results. I have also set the warning to Yes and received the sam results.
Any suggestions will be greatly appreciated.
Thanks Mary
This conversation is currently closed to new comments.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Access 2007
Action Arguments Comments
Open Query EmptyCoupons, Datasheet, Edit Empty Table
RunSavedImprortExport LoanCoupons ImportLoan Coupons
SetWarnings No
OpenReport LoanCoupons, Print,,Normal
Quit Exit
I have moved the SetWarings below the OpenReport but have received the same results. I have also set the warning to Yes and received the sam results.
Any suggestions will be greatly appreciated.
Thanks
Mary