Deleting a table in access 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Before running the query, SetWarnings Off. After running the query,
SetWarnings On.

HTH
 
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.
 
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
 
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...
 
Back
Top