Update/append query message box

[RCMetrics]

Hi,

Is there a way to disable the "you are about to modify X amount of records..." when running an update query or even an append query?

It's nice to know what will happen to the table but I know that it's now well setup that I don't need to worry how many records are getting modified... so I just want to avoid clicking "ok" all the time...

Any ideas?

Thanks

 

[Andrew Fergus]

Hi
Are you running this query from the query screen or from a form?
Andrew

 

[RCMetrics]

From a form

 

[Andrew Fergus]

Hi

Assuming you are clicking a button to run the query, you will have used either a macro or VBA to run the query. Before the open query line, insert a new line and add the command (for a macro) SetWarnings -> No or (for VBA) DoCmd.SetWarnings (WarningsOff). After the open query line, insert another new line to turn the warnings back on.

If you used the wizard to create the button and are unsure as to how to make these changes, then go into the design of your form, right click the button on your form -> Properties -> Event tab -> On Click -> click the 3 dots to the very right of this box to open the VBA editor.

HTH, Andrew

 

[RCMetrics]

Works fine.

Thanks