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