By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,930 Members | 1,487 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,930 IT Pros & Developers. It's quick & easy.

Diabling Access Query notifications

P: n/a
TG
I am programatically executing several queries from one button on a
form in Access 2000 and was wondering if there was a way to disable
the popups that always display before deleting, appending, etc.
records from the db? What is happening basically is that once the
delete button is clicked it fires 7 delete queries but Access prompts
you with a yes no notification before you actually delete each one.
So can they be disabled so that the button can just fire the delte
queries and that's it?

Thanks
TG
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
TG wrote:
I am programatically executing several queries from one button on a
form in Access 2000 and was wondering if there was a way to disable
the popups that always display before deleting, appending, etc.
records from the db? What is happening basically is that once the
delete button is clicked it fires 7 delete queries but Access prompts
you with a yes no notification before you actually delete each one.
So can they be disabled so that the button can just fire the delte
queries and that's it?

Thanks
TG


Docmd.setwarnings False
.....queries here
Docmd.setwarnings True
Nov 13 '05 #2

P: n/a
You're awesome! Thanks for the reply.

TG

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.