expublish
Registered User.
- Local time
- Today, 03:27
- Joined
- Feb 22, 2002
- Messages
- 121
Hi,
I have two queries:
1) called 'Update Holiday'
2) called 'Delete Holiday'
One is an append query and the other is a delete query. I need my Database to run these two queries on the last day of each financial year - so on 31st March 2002 (31/03/02).
I do not want them run on any other dates, just once when the database is opened on 31/03/02 (the DB is used daily).
Does anyone know how to make it do this?
Oh - they need to run when I open a specific form. I don't mind using VB but will be just as happy using a macro that runs the two queries and simply runnign that on Ope Form.
TIA
Scott.
I have two queries:
1) called 'Update Holiday'
2) called 'Delete Holiday'
One is an append query and the other is a delete query. I need my Database to run these two queries on the last day of each financial year - so on 31st March 2002 (31/03/02).
I do not want them run on any other dates, just once when the database is opened on 31/03/02 (the DB is used daily).
Does anyone know how to make it do this?
Oh - they need to run when I open a specific form. I don't mind using VB but will be just as happy using a macro that runs the two queries and simply runnign that on Ope Form.
TIA
Scott.