Rewrite the application to have DoCmd.SetWarnings False before you run the
query (and DoCmd.SetWarnings True afterwards), or, even better, change to
use the Execute method of either the Database object, or the QueryDef
object.

     YOU KNOW HOW THE $6.00 WILL GET YOU THOUSANDS STARTS, I found this on
a bulletin
     board and   decided to try it. WELL, I FIGURED THAT IT WAS A LOAD OF
CRAP, I THOUGHT
    THAT WHY ON EARTH AM I    GOING TO SEND ANY MONEY TO PEOPLE THAT I
DON'T KNOW.FOR WHAT,
    TO BE ON SOMEONE'S MAILING LIST.
    COME ON FOR GOODNESS SAKE, I AM A FINANCE MAJOR, I THOUGHT NO WAY. SO
AFTER ABOUT 6
    MONTHS OF  SEEING THESE LIST APPEAR ON THE CAMPUS FUN BOARD. I DECIDED,
WHAT THE HELL.
    I FIGURED WHATS
    $6.00.  SO AT FIRST, NOTHING ABOUT THE FIRST TWO WEEKS, THEN JUST WHEN
I WAS GETTING
    READY TO   GIVE MY FRIENDS THE SPEECH ABOUT "SPAM AND WHAT A SCAM" I
PICKED UP MY MAIL,
    ON A THURSDAY,
    THAT WAS ABOUT ALMOST END OF THE THIRD WEEK I HAD RECIVED $612.00 THAT
THURSDAY.
    NOW I AM
    IN MY SIXTH
    WEEK AND AM AT ALMOST $4,000 DOLLARS. I QUESS NUMBERS DON'T LIE.SO FAR
I HAVE BOUGHT
    SOME   FURNITURE, GOT MY CAR FIXED, GAVE MY MOM SOME MONEY, AND PAID
SOME ON ONE OF
    MY STUDENT LOANS.  THE MONEY IS STILL COMMING IN. WHAT A PROFIT, OFF
SUCH A SMALL
    INVESTMENT. I KNOW THAT THIER ARE OTHER LISTS OUT THERE. THAT'S
GREAT,BUT WHAT
     I WILL SAY IS THAT THE PEOPLE ON THIS LIST HAVE PLAYED FAIRILY AND
HONESTLY, AND WITH             INTREGRITY.
     IF YOU DO CHOOSE THIS LIST PLEASE PLAY AS FAIR  AS OTHERS HAVE.
     THE GOOD FORTUNE WILL COME TO YOU IF YOU DO. NOW ONTO THE SHOW....

  A while back,I saw this article on a bulltien board it said
 that you send $1.00 to each of the 6 names and address stated in the
 article.
 You then place your own name and address in the bottom of
 the list at #6, and post the article in at least 200 newsgroups.
 (There are thousands)  I
 figured: what have I got to lose except 6 stamps and $6.00,
 right?
 Then I invested the measly $6.00. WELL, GUESS WHAT !!...
 within 7 days, I started getting money in the mail! I was shocked! I
 figured it would end soon, but the money just kept coming in. In my
 first week, I made about $25.00. By the end of the second week I had
 made a total of over $1,000.00! In the third week I had over
 $10,000.00 and it's still growing. This is now my fourth week and I
 have made a total of just over $18,000.00 and it's still coming in
 rapidly.
 It's certainly worth $6.00, and 6 stamps,
...Also, make sure you print a copy of this
 article NOW, so you can get the information off of it as you need it.
 I promise you that if you follow the directions exactly, that you
 will start making more money than you thought possible by doing
 something so easy!
 Suggestion: Read this entire message carefully! (print it out or
 download it.) Follow the simple directions and watch the money come in!
 It's easy. It's legal. And, your investment is only $6.00 (Plus postage)
 Follow these directions EXACTLY, and $50,000 or more can be
 yours in 20 to 60 days. This program remains successful because of
 the honesty and integrity of the participants. Please continue its
 success by carefully adhering to the instructions.
 You will now become part of the Mail Order business. In this business
 your product is not solid and tangible, it's a service, perfectly legal.
 You are in
 the business of developing Mailing Lists. Many large corporations are
 happy to pay big bucks for quality lists. However, the money made
 from the mailing lists is secondary to the income which is made from
 people like you and me asking to be included in that list.
  Here are the 4 easy steps to success:

 STEP 1: Get 6 separate pieces of paper and write the following on
 each piece of paper; " PLEASE PUT ME ON YOUR MAILING LIST "
 and include you name and address

 STEP 2: get 6 US $1.00 bills and place ONE inside EACH of the 6 pieces of
 paper so the bill will not be seen through the envelope (to prevent
 thievery).

 STEP 3: place one paper in each of the 6 envelopes and seal
  You should now have 6 sealed envelopes, each with a piece of
  paper stating the above phrase,PLEASE PUT ME ON YOUR MAILING LIST,
  your name and address, and a $1.00 bill.

 STEP 4: Mail the 6 envelopes to the addresses below:
 What you are doing is creating a service. THIS IS ABSOLUTELY
 LEGAL! You are requesting a legitimate service and you are paying for
 it! Like most of us I was a little skeptical and a little worried
 about the legal aspects of it all. So I checked it out with the U.S.
 Post Office (1-800-725-2161) and they confirmed that it is indeed
 legal!

 #1) Janie Green
   133 Holly Hedges Dr.
   Florence, MS 39073

#2) Kevin Lee
   8377 Apt. #-I Montgomery Run Rd.
   Ellicott City, MD 21043

#3) OVERTON
   P.O. BOX 18818
   SO. LAKE TAHOE, CA 96151

 #4) Anthony Palone
   P.O. Box 17121
   Clearwater, FL. 33762-0121

 #5) Rich Trine
   P.O. Box 471034
   Tulsa, Ok. 74147-1034

 #6) B.G.
   8150 FISHER ST
   WARREN MI, 48089

Now, take the #1 name off the list that you see above, move
 the other names up (6 becomes 5, 5 becomes 4, etc...) and add YOUR
 Name as number 6 on the list and then start posting this on other groups.

 STEP 5: Change anything you need to, but try to keep this article as
 close to original as possible. Now, post your amended article to at
 least 200 newsgroups. (I think there are close to 24,000 groups) All
 you need is 200, but remember, the more you post, the more money you make!

 This is perfectly legal! If you have any doubts, refer to Title 18
 Sec. 1302 & 1341 of the Postal lottery laws.
 Keep a copy of these steps for yourself and, whenever you need money,
 you can use it again, and again.
 PLEASE REMEMBER that this program remains successful because of the
 honesty and integrity of the participants and by their carefully
 adhering to the directions.
 NOTE: Retain every name and address sent to you,
 either on a computer or hard copy and keep the notes people send you.
 This VERIFIES that you are truly providing a service. (Also, it might
 be a good idea to wrap the $1 bill in dark paper to reduce the risk of
mail theft.)
 So, as each post is downloaded and the directions carefully followed,
 six members will be reimbursed for their participation as a List
 Developer with one dollar each. Your name will move up the list
 geometrically so that when your name reaches the #1 position you will
 be receiving thousands of dollars in CASH!!! What an opportunity for
 only $6.00 ($1.00 for each of the first six people listed above) Send

it now, add your own name to the list and you're in business
---DIRECTIONS ----- FOR HOW TO POST TO NEWSGROUPS------------

 You do not need to re-type this entire letter to do your own
 posting. Simply put your cursor at the beginning of this letter and
 drag your cursor to the bottom of this document, and select 'copy'
 from the edit menu. This will copy the entire letter into the
 computer's memory.
 Step 1) Open a blank 'notepad' file and place your cursor at the top
 of the blank page. From the 'edit' menu select 'paste'. This will
 paste a copy of the letter into notepad so that you can add your name
 to the list.
 Step 2) Save your new notepad file as a .txt file. If
 you want to do your postings in different settings, you'll always
 have this file to go back to.
 Step 3) Use Netscape or Internet explorer and try searching for
 various newsgroups (on-line forums, message boards, chat sites,
 discussions.)
 Step 4) Visit these message boards and post this article as a new
 message by highlighting the text of this letter and selecting paste
 from the edit menu. Fill in the Subject, this will be the header that
 everyone sees as they scroll through the list of postings in a
 particular group, click the post message button. You're done with
 your first one! Congratulations...THAT'S IT! All you have to do is
 jump to different newsgroups and post away, after you get the hang of
 it, it will take about 30 seconds for each newsgroup!

 **REMEMBER, THE MORE NEWSGROUPS YOU POST IN, THE MORE MONEY YOU WILL
MAKE!!
 BUT YOU HAVE TO POST A
 MINIMUM OF 200**
 That's it! You will begin receiving money from around the world within
days!
 You may eventually want to rent a P.O.Box due to the large amount of mail
you
 will receive. If
 you wish to stay anonymous, you can invent a name to use, as long as
  the postman will deliver it.
 **JUST MAKE SURE ALL THE ADDRESSES ARE CORRECT.**
 Now the WHY part:
 Out of 200 postings, say you receive only 5 replies (a very low example).
 So then I made $5.00 with your name at #6 on the letter. Now,
 each of the 5 persons
 who just sent you $1.00 make the MINIMUM 200
 postings, each with your name at #5 and only 5 persons respond to each
 of the original 5, that is another $25.00 for you, now those 25 each
 make "200 MINIMUM" posts with your name at #4 and only 5 replies each, I
 will bring in an additional $125.00! Now, those 125 persons turn
 around and post the "MINIMUM 200" with your name at #3 and only receive 5
 replies each, you will make an additional $626.00! OK, now here is the
 fun part, each of those 625 persons post a "MINIMUM 200" letters with
 your name at #2 and they each only receive 5 replies, that just made you
 $3,125.00!!! Those 3,125 persons will all deliver this message to 100
 newsgroups with your name at #1 and if still 5 persons per 100
 newsgroups react you will receive $15,625,00! With an original
 investment of only $6.00! AMAZING! The thing to remember is: do you
 realize that thousands of people all over the world are joining the
 internet and reading these articles everyday?,THIS WORKS BECAUSE
 Estimates are at 20,000 to 50,000
 new users, every day, with thousands of those joining the actual internet.

You could add the following code to the Load event of your startup
form.

   Application.SetOption "Confirm Action Queries", False
   Application.SetOption "Confirm Document Deletions", False
   Application.SetOption "Confirm Record Changes", False

TC