Auto run Query on table update

fgcity

Registered User.
Local time
Today, 09:59
Joined
May 29, 2008
Messages
21
Hi everyone.

I'm pretty new to Access and i would like to make a simple process so please help out here.

I have a Table A.

I have another program interacting with it and updating it's fields and adding new ones automatically.

I need to do the following.

When a new field is entered into the table i need to automatically run a query which will copy that field to another table (new field) and then delete that field from the original table.

All this is done automatically so i need this operation to be done automatically as well.

How do i do this ?

Basically i need a solution on how to trigger a Query when the table has been updated or a new filed has been added to it.


Please help out.
 
Simple Software Solutions

What software is interacting with your Access database?

Can you not get that software to perform the action for you?

A little more info would be of help.

CodeMaster::cool:
 
Never mind the software.

I have ended up with a simple solution but i need some help.

I basically need to Auto Run a Query every 1 or 2 seconds, how do i do that?

If i create a blank form what would the code be for the timer to auto run the query every 1 or 2 seconds?
 
Simple Software Solutions

Have a timer on your form with the interval set to 1000 (one second)

Then on the event enter

DoCmd.RunSQL QuerySQL or

Qry.Execute
 
yeah,tnx that's how i did it.

Once again tnx for the help
 

Users who are viewing this thread

Back
Top Bottom