Delete Query and Macro

[JayDawg]

I created a macro to delete the contents of a particular table when
closing Access. How do I turn off the function that gives the warning
messages so it just does it without having to hit OK?

[Tom van Stiphout]

On 21 Jun 2006 20:58:39 -0700, "JayDawg" <he******@cox.net> wrote:

Before your code, put another line:
Docmd.Setwarnings False
Since you're on your way out there is no need for
Docmd.Setwarnings True
after your query call, but in my eyes you would still get extra points
for that.

-Tom.

I created a macro to delete the contents of a particular table when
closing Access. How do I turn off the function that gives the warning
messages so it just does it without having to hit OK?

[JayDawg]

Tom thanks for the response but I am a real novice to this, how do I
get to the VBA code. I set it to run the macro when the switchboard
shuts down.

Tom van Stiphout wrote:

On 21 Jun 2006 20:58:39 -0700, "JayDawg" <he******@cox.net> wrote:

Before your code, put another line:
Docmd.Setwarnings False
Since you're on your way out there is no need for
Docmd.Setwarnings True
after your query call, but in my eyes you would still get extra points
for that.

-Tom.

I created a macro to delete the contents of a particular table when
closing Access. How do I turn off the function that gives the warning
messages so it just does it without having to hit OK?

[JayDawg]

Never mind I found what I was looking for, you dont evenneed to get
into the code, there is a tab in the options menu called edit/find,
that has a check box for confirmations on action queries and such.

JayDawg wrote:

Tom thanks for the response but I am a real novice to this, how do I
get to the VBA code. I set it to run the macro when the switchboard
shuts down.

Tom van Stiphout wrote:

On 21 Jun 2006 20:58:39 -0700, "JayDawg" <he******@cox.net> wrote:

Before your code, put another line:
Docmd.Setwarnings False
Since you're on your way out there is no need for
Docmd.Setwarnings True
after your query call, but in my eyes you would still get extra points
for that.

-Tom.

I created a macro to delete the contents of a particular table when
closing Access. How do I turn off the function that gives the warning
messages so it just does it without having to hit OK?

[Bob Quintal]

"JayDawg" <he******@cox.net> wrote in
news:11**********************@p79g2000cwp.googlegr oups.com:

Never mind I found what I was looking for, you dont evenneed
to get into the code, there is a tab in the options menu
called edit/find, that has a check box for confirmations on
action queries and such.

You'll regret setting those to off the first, second and third
times you accidentally delete several hours of work. I speak
from experience.Better to learn a little bit about code, and
save some grief later.

1) Open your switchboard in design mode.

2) if the properties popup opens at the same time, skip the next
step.

3) Hover over the toolbar icons until you find one labeled
properties and click it to open the properties popup.

4) The popup has several tabs. find the EVENTS tab.
there is an event labled "On Close" It possibly has the name of
your macro beside it.

5) click the down arrowhead at the right. select event
procedure. An elipse (three dots...) will appear to the right.

6) Click on the elipse, the Visual Basic Editor will appear,
with the cursor positioned between two lines of code. The first
should say "Private Sub Form_Close() and the next "End Sub"

7) Add the following between those lines.

Docmd.Setwarnings False
docmd.runSQL "DELETE * from tablename"
Docmd.Setwarnings True

Note: change tablename to the real name of the table.

8) Save and close.

Congratulate yourself.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com