Turn off Alert Sound

[Rita Brasher]

Whenever a query is run and requests a user response such as accepting
amending another table or deleting a table, an alert box pops up and a
chime rings to bring the alert to the user's attention. Is there a way
to turn the sound off on the alert only in Access or do I have to do
this for the entire Windows environment? I run many queries and like
listening to my music while doing so. The chime/bell is very irritating.

Thanks for any help!
Rita Brasher

 

[S.Clark]

Docmd.setwarnings False will turn the prompt off completely.

But, the sound is probably controlled by the Windows Settings.