What type of query should I use here? 1

[jasonmac]

Hello everyone. I am working in access '97 for this application. I have a table that needs to be refreshed every time the application is opened. Right now I'm using a create table query and running it in the on open even of a form. However, the user is required to answer yes to questions such as, "tblFinal will be deleted to create the new table", "you are about to paste ### rows", ect...

Should I be using an append or update query maybe? Can someone please tell me how to let this query update the table seemlessly at runtime?

Thanks,
Jason

 

[luceze]

Turn your warnings off before running the make table query.

docmd.setwarnings false
docmd.OpenQuery "YourQueryName"
docmd.setwarnings true


HTH,
Eric

 

[jasonmac]

That worked like charm. I can already see where that will be extremely useful in other applications. A star to you!

 

[luceze]

You're Welcome!