98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » advanced microsoft access training courses in london - Auto run query when linked table changes? | Access forum
advanced microsoft access training courses in london - Auto run query when linked table changes? | Access forum
Resolved · Low Priority · Version Standard
Thu 15 Feb 2007, 15:16Delegate Kevin said...
Kevin has attended:
Access Introduction course
Auto run query when linked table changes?
I have an append query and a delete query i would like to automatically run each time a linked table updates (linked to excel file).
This will add the data from the linked table to a master table which contains all records and the delete query just deletes null records.
Could you tell me the best way to proceed with this?
In access?
Or can an access query be run from and excel macro?
Many thanks, Kevin.
Tue 20 Feb 2007, 09:51
Edited on Tue 20 Feb 2007, 09:51Trainer Carlos said...
RE: Auto run query when linked table changes?
Kevin
You would need to run both queries from a Macro.
You would also need some VBA code to check if the linked table has updated so as to run the above Query macro.
Carlos
Training information:
- Advanced microsoft access training courses in london
- Microsoft.access.courses
- Microsoft Access Training London
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Related tablesWhen you have related tables such as Customers and their Orders, the Customer table is the Primary table. |
