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

Removing Query Message Box

manoj9849967222
P: 48
Hi All

I have designed a form with a command button & the command button is linked to a query. Every thing is ok & is working.

But when ever i press the Command Button Message Box pops up saying "You are about to run a append query that will modify data in your table" & Then the other message box saying "You are about to append 2 row(s)".

Is there any way so that these message box does not pop up.

Please help

Regards
Manoj
Aug 5 '07 #1
Share this Question
Share on Google+
3 Replies


missinglinq
Expert 2.5K+
P: 3,532
Expand|Select|Wrap|Line Numbers
  1. DoCmd.SetWarnings False
  2. 'Your code goes here
  3. DoCmd.SetWarnings True
  4.  
Be absolutely sure to add the second line after your code for the Append Query!

Linq ;0)>
Aug 5 '07 #2

manoj9849967222
P: 48
Expand|Select|Wrap|Line Numbers
  1. DoCmd.SetWarnings False
  2. 'Your code goes here
  3. DoCmd.SetWarnings True
  4.  
Be absolutely sure to add the second line after your code for the Append Query!

Linq ;0)>

Ohhhhhhh.. my god Its working.
Thanks for the help Missinglinq
Thanks again.
Aug 5 '07 #3

missinglinq
Expert 2.5K+
P: 3,532
Glad we could help!

Linq ;0)>
Aug 5 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.