advanced microsoft access training courses in london - Auto run query when linked table changes?

The UK's most regular instructor-led training courses.
Training information: advanced microsoft access training courses in london · Access training · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Auto run query when linked table changes?

Kevin has attended:
Access Introduction course

by - delegate Kevin [2 posts] (2007 Feb 15 Thu, 15:16) Reply

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.

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 29 Fri	Bayswater	0	FULL
2003	2008 Sep 3 Wed	Southwark	3	book now	£224	£235
2007	2008 Sep 24 Wed	Bloomsbury	0	FULL
2003	2008 Oct 8 Wed	Southwark	5	book now	£219	£235
2003	2008 Oct 24 Fri	Bloomsbury	7	book now	£190	£224
2003	2008 Oct 29 Wed	Bayswater	8	book now	£110	£224
Full Schedule: See all 55 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Auto run query when linked table changes?

by - trainer Carlos gold contributer [391 posts] (2007 Feb 20 Tue, 09:51) Edited on 2007 Feb 20 Tue, 09:51 Reply

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

· 3 Useful Things You'll Learn in Microsoft Access Training Courses
· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps
· Microsoft Access Mistakes to Avoid
· Access VBA Training Adds Power to your Databases
· Innovation with Microsoft Access

Access tip:

Modal forms

If you have created a form / switchboard and dont want people to get away from using the switchboard, you can change the form properites for Modal to On.

View all Access hints and tips