How to get rid of the pop up question when running a make table query

[rohini]

I have a make table query which I run every time I click a particular command button.



Whenever I do that, The following question comes up on the screen :


"The existing table ' xyz' will be deleted be before you run the query

Do you want to continue anyway?"


This ofcourse delays the overall operation. How do i make sure that access does not ask this question every time?

[June7]

You are doing this with code - VBA or macro? Use:

DoCmd.SetWarnings False
code to run query
DoCmd.SetWarnings True

or

CurrentDb.Execute "sql action statement"

[rohini]

I am using a macro.

Can you tell me how to use this in macro, or otherwise the normal VBA code that can be used to run the query

[June7]

I don't use macros. What I showed are VBA code lines that would be in some event (like your button click). Select [Event Procedure] in the event property and double click the ellipses (...) to go to the procedure in VBA code editor, type code. A macro could incorporate the commands from the first example, I think the second is only VBA.

[rohini]

hmm...
umm thanks..but i still have a small problem :

you had said :

You are doing this with code - VBA or macro? Use:

DoCmd.SetWarnings False
code to run query
DoCmd.SetWarnings True

or

CurrentDb.Execute "sql action statement"



in this what is the 'code to run query'. Since i use macros, i dont know what actual code should be used here.

[June7]

Modify your macro. Use Access Help for step by step on creating and editing macros. Google the topic. Maybe this will help http://windowssecrets.com/forums/sho...cro-(Access-97)

[rohini]

uh huh! forget it i googled it.
all i really wanted was :

DoCmd.OpenQuery "Queryname", , acReadOnly

:P :P
anyway...my prob is solved using ur first answer so thanks!