How do I supress the warning message one gets when running a Make table Query?? Access wants the user to confirm the deletion of a table before it proceeds....can U turn this function off??
8 2893
DoCmd.SetWarnings False works in VBA mode, but you'll have to call the query from vba to get that to work... And don't forget to turn them back on again later by changing the False to True :-)
Regards,
Scott
How do I supress the warning message one gets when running a Make table Query?? Access wants the user to confirm the deletion of a table before it proceeds....can U turn this function off??
- DoCmd.SetWarnings False 'turn Warnings OFF
-
DoCmd.OpenQuery "qryMakeTable", acViewNormal, acEdit
-
DoCmd.SetWarnings True 'turn Warnings ON again
DoCmd.SetWarnings False works in VBA mode, but you'll have to call the query from vba to get that to work... And don't forget to turn them back on again later by changing the False to True :-)
Regards,
Scott
Sorry Scott, must have been working on this one at exactly the same time.
Sorry Scott, must have been working on this one at exactly the same time.
Never a problem! The exact method may be more helpful than just a point in the right direction :-)
Regards,
Scott
Never a problem! The exact method may be more helpful than just a point in the right direction :-)
Regards,
Scott
Thanks, Guys!! Worked like a charm!!
Thanks, Guys!! Worked like a charm!!
We are always glad to be of service.
- DoCmd.SetWarnings False 'turn Warnings OFF
-
DoCmd.OpenQuery "qryMakeTable", acViewNormal, acEdit
-
DoCmd.SetWarnings True 'turn Warnings ON again
Can I make a late addition here. If you have error handling code in your routines (and of course, everyone does), make sure that you turn warnings back on in the error handling.
I lost a lot of data once, where a delete had failed, error handling picked up the failure, but left the system with warnings set off.
Can I make a late addition here. If you have error handling code in your routines (and of course, everyone does), make sure that you turn warnings back on in the error handling.
I lost a lot of data once, where a delete had failed, error handling picked up the failure, but left the system with warnings set off.
Excellant point and one to surely remember! We take Error Handling for granted, usually because of the increased length of the code segments that it would entail. Certain items should always be turned ON/OFF in Error Handlers such as rolling back Transactions, turning the Hourglass back to its Normal state, closing Recordsets, etc. Thanks again for bring this point to our attention, Lysander.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Gordon |
last post by:
I have 2 tables t and t1. In this case, t1 is a copy of t. I want to
delete rows from t1 based on criteria on the t table and a relationship
between t ad t1 (in this case the id column). In the...
|
by: Jim Moseby |
last post by:
I stumbled across this while trying to update a table with a timestamp type column. At the time, I didn't know that the timstamp column would update itself when a row was changed. A kind gentleman...
|
by: Tony W. |
last post by:
I have a MySQL question about changing the info in a table:
I am using MySQL Server version: 3.23.58
I have a table called sign_region2 and it contains thousands of
references to signs and the...
|
by: David Link |
last post by:
Hi All,
Here's a Conditional drop_table func for those interested. There was a
thread on this a long time back.
We do this all the time :
DELETE TABLE sales;
CREATE TABLE sales (...);
|
by: Doc |
last post by:
Per earlier post, I am trying to save 'out' production data from a
program called Solomon - basically (I think) this was /is an Access/Sql
based program.
We are updating to different application...
|
by: No Spam |
last post by:
Dear Access 2003 users,
Can anyone assist me with creating either code (preferred) or a query
that would remove a single field (called ID) from a table? And as a
bonus question, can anyone...
|
by: MartinR |
last post by:
I would like to know the code that i should use to delete a record
without the message box saying "You are about to delete a record, are
you sure..." poping up.
At the moment i am using the...
|
by: Serge Rielau |
last post by:
Hi all,
Following Ian's passionate postings on problems with ALTOBJ and the
alter table wizard in the control center I'll try to explain how to use
ALTOBJ with this thread. I'm not going to get...
|
by: john_aspinall |
last post by:
Here's the overview:
Im building an eCommerce web site using ASP. It has an Access DB at
the back end. Im receiving the Product info from a series of CSV
files. Ive created a Table in Access...
|
by: foolproofplan |
last post by:
I have a situation where I need to convert an xml file into two types
of tables in html. I have never done anything like this before, so I
have been reading up on it online. However, I am not 100...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |