I am running a Macro on my switchboard that runs 6 queries (3 append and 3 Delete)and it produces 6 pop up boxes...Is there a way I can pre-set yes and not have the pop up boxes appear?
I am running a Macro on my switchboard that runs 6 queries (3 append and 3 Delete)and it produces 6 pop up boxes...Is there a way I can pre-set yes and not have the pop up boxes appear?
If they're the warnings, you can use SetWarnings before and after running the queries.
I believe you can turn off these warning in Options:
- Click on the Office Button (top left)
- Click on Access Options (bottom right of dialog box)
- Click on Advanced(left)
- Go down to the'Confirm' section
- Untick Action Queries
- Click Okay
Linq ;0)>
Sure, but that's machine specific. Not much use if the application will be used on others.