help with delete, update & append queries...

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

Guest

I have a query to delete a tbl, an query to create a new table and a append
query that I currently run manually.

Is is possible to run these in sequential order on the click of a command
button?

tbl name: tblinvcomments

update Query: qryupdatecommentstblfrmdd

mk table Query:qryupdatecommentstable

delete tbl records Query:qrydeletetblinvcomments

Is this possible?

Thanks,

Brook
 
sure. just create a macro, or aVBA procedure, to run an OpenQuery action
three times, once for each query. if you're not familiar with VBA, a macro
will probably be easier for you. if you're not familiar with macros, read up
on them in Access Help, and post back if you have any specific
questions/problems.

hth
 
Thanks Tina,

I didn't even think setting up a Macro. That is what I did and it works
fine. I was just wondering if there was a way to prevent the confirmation
dialog box?

Thanks,,

Brook
 
Brook said:
Thanks Tina,

I didn't even think setting up a Macro. That is what I did and it works
fine. I was just wondering if there was a way to prevent the confirmation
dialog box?

Thanks,,

Brook
Click to expand...

You could put a "SetWarnings" action into your Macro. (And maybe
another one at the end to turn them back on.)

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
Back
Top