How To Run a Query Automatically in Access 2000

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

Guest

I would like to run an Append query automatically each time a new record in
inserted in TabelA. The Append query is designed to insert the newly inserted
records in TableA to TableB without using VB scripts.
What do I need to do so the Append query is run each time TableA has a new
record in it?
 
Shariq,

Sounds redundant to me.

I might be able to understand adding a record into another table that has a
1 to 1 mapping to your TableA, but why would you want to copy the entire
record from Table A into TableB?
 
Dale, There is a 1 to 1 relationship between the tables and it works fine
when I delete a record from TableA. But, when I add a record in TableA, the
record won't get inserted in TableB.
TableA has customer details (including name and ID) but TableB has only
customer's ID and Name.
 
If you are inputting the information to TableA using a form,
You could have the OnClose event of the form run the following:

CurrentDb.Execute "NameOfYourAppendQuery", dbFailOnError

HTH
Wally Steadman
US Army in Iraq
 
Then you can't do this if you are using an .mdb. Access plus Jet (.mdb files)
does not support this functionality.

You have to switch to a different data engine. MS SQL or ...
 
Back
Top