473,324 Members | 1,856 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Removing Query Message Box

manoj9849967222
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
3 1373
missinglinq
3,532 Expert 2GB
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
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
3,532 Expert 2GB
Glad we could help!

Linq ;0)>
Aug 5 '07 #4

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

Similar topics

4
by: Drew | last post by:
I have a permission tracking app that I am working on, and I have made the insert page for it. I am having issues on how to prevent duplicates from getting entered. Currently the interface for...
4
by: Steve | last post by:
Hi, I have a table which contains records of user access and searches made within an application, this is a sample of the data: response for 101 results from database in 28906 ms I only...
4
by: Gerry Abbott | last post by:
Hi all, I've bound cbo field in a form, which draws from a list, with its 'limit to list' property set to true.When i add an entry to the form, from the list, I want to remove this item from the...
4
by: hendafe | last post by:
I have a problem of removing '/' in Access. I have a field with this record BD/02/1234. I want to automatically remove the '/' and save it in a new field record for another purpose. Presently...
4
by: Karl Seguin | last post by:
Some of our users behind firewalls (watchguard in particular) are reporting that they can't access our site. This is the type of error they are getting: 02/06/04 07:27 http-proxy: removing...
16
by: tyrfboard | last post by:
I've been searching for awhile now on how to remove duplicates from a table within an Access db and have found plenty of articles on finding or deleting duplicates. All I want to do is remove them...
2
by: firdous | last post by:
Please help me to write the query for removing the auto_increment propery of the column or drop that column. Thank you!
2
by: Chesne | last post by:
I would like to be able to utilise a combo box where once an item has been selected then that item no longer appears in that list. Is there some code anyone has which will achieve this? If I...
1
by: PerumalSamy | last post by:
Hi I am having table with more 13 lakhs records. I am having duplicate records in it. i need to remove that. I wrote the following query SELECT *
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.