Hi everyone.
I'm pretty new to Access and i need some help to run auto execute query.
I have a Table A.
I have another program interacting with it and updating it's fields and adding new ones automatically
set by certain time everday.
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).
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
that i have been set it to execute every 4.am everyday.
But what happend is,it kept automatically execute wrongly in time and keep duplicate the same field in the table.
Please help out.
I'm pretty new to Access and i need some help to run auto execute query.
I have a Table A.
I have another program interacting with it and updating it's fields and adding new ones automatically
set by certain time everday.
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).
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
that i have been set it to execute every 4.am everyday.
But what happend is,it kept automatically execute wrongly in time and keep duplicate the same field in the table.
Please help out.
