Docmd.RunSQL - suppress Yes/No

D

davesmith202

Employee of Access World

Local time

Today, 02:49

Joined

Jul 20, 2001

Messages

522

• Jul 27, 2010

• #1

When I run the code below, it pops up a question to ask if I wish to delete the data. How do I set it up so that it automatically does it without this question?

Code:

DoCmd.RunSQL ("DELETE * FROM tblStage2ParsedData;")

Thanks,

Dave

 

N

namliam

The Mailman - AWF VIP

Local time

Today, 03:49

Joined

Aug 11, 2003

Messages

11,695

• Jul 27, 2010

• #2

3 ways to do this but I will tell you 2.
1)
Docmd.setwarnings false
docmd.Runsql "Delete .."
Docmd.setwarnings false

2)
Currentdb.Execute "Delete .."

good luck

 

D

davesmith202

Employee of Access World

Local time

Today, 02:49

Joined

Jul 20, 2001

Messages

522

• Jul 27, 2010

• #3

Thank you!

 

gemma-the-husky

Super Moderator

Staff member

Local time

Today, 02:49

Joined

Sep 12, 2006

Messages

16,052

• Jul 27, 2010

• #4

the difference between the two is that

once you suppress errors, then the first method may fail, and you will not know

the second can be used to inform you in the case of errors, and is a better idea.