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

Append and make table query,prompting for yes or no from access

P: n/a
Hi!

Is there a way that when I run a "make table query" and an "append
query" that i won't be asked those 2 or 3 questions from access like
:"you are about to run a make table...","the existing table ABCDE will
be deleated..." and so on prompting for yes or no! I would like to make
a command button which would prompt me for yes or no and then if i say
"yes" it would first run the make table query and then the append
query without access prompting me 5 times for yes or no(3 times for the
make table and 2 times for the append query)!
Any help\suggestions would be great!

Danijela

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi, before running the query turn off warnings ie: docmd.setwarnings
False

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.