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 ...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top