Action query prompt

S

smk23

Is there a way to block the "you are updating x number of records" pop-up on
action queries?
THanks so much.
 
G

Graham Mandeno

Hi Sam

Yes - execute the command:
DoCmd.SetWarnings False
before running the query.

You should set it back to True afterwards.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't click link - organization policy preventing 0
action query message 1
Access 2010 DB not fuctional with multiple users 2
Word 2016 opening sooo slow 0
ASK Field Formatting 1
Update Progress Information and Reschedule work for all Tasks - Project 2003 0
Adding data to MS Access from csv file 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top