Deleting a table in access 2007

[frantic_girl]

One I run the make query table I was being asked to click YES, YES, YES. I
was able to eliminate the last 2 YES questions but can not get past the " The
existing table "name" will be deleted before you run the query.

Is there a way to set it so I do not have to answer this question?

 

[Larry Daugherty]

Before running the query, SetWarnings Off. After running the query,
SetWarnings On.

HTH

 

[frantic_girl]

Larry,

is this in the actual programming for the modules or is there a button in
the 07 that I can now click to turn on and off the features.

 

[Larry Daugherty]

It is code that you'd place in the event code that runs the query. If
you are running the query manually then you'd need to use the VBE to
manually aalter the settings.. If all of the foregoing sounds like
gobbledegook then I suggest that you get a developer to place a button
on a form for you with code that does it all.

HTH

 

[NetworkTrade]

You can create a Macro that has the sole purpose of opening the query. On
the first line of the Macro use the 'Set Warnings' action and down in the
detail area it has a line where you can put 'No' for no warning...

Then you can use the Macro instead of the query itself...and there will not
be prompts...

 

[frantic_girl]

Thank you now that makes sense. I appreciate you taking the time to respond.