Access 2007

By mslonecker ·
Tags: Software
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.


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums