Automating an Make Table/Append/Delete Query

[Guest]

Hello,

I have three queries that I would like to run at the time that a Database
opens. One query makes a copy of a linked table that is updated daily and
makes a table called "DeltekCopy" and we perform all our calculations /
relationships ect against it. the second is an append query that looks in the
nelwy created DeltekCopy table for a not null value in a field called [term
date] and if it is valid sweeps the data out of there and into a table called
SrvcAwardTermed. the third query deletes the records out of Deltek copy that
were just put into SrvcAwardTermed.

Two things ... how do i automate this so that it runs in the correct order ?
Very Important.

and how do I make it so that if the data that is getting moved into
SrvcAwardTermed is already there - the data is just deleted ?

Please advise,

Stephen Akins

 

[Guest]

hi,

Use the Access StartUp options (Tools > Start Up) and select a form to
launch automatically when Access application is started.

In this form place your code or queries to run in the Open event. Close the
form when your required code is executed and call the next form to be opened
for the application.

Regards,