Infinite
More left to learn.
- Local time
- Today, 09:10
- Joined
- Mar 16, 2015
- Messages
- 402
In this post, I would like to know HOW to stop a query for running.
http://www.access-programmers.co.uk/forums/showthread.php?t=283902
In that post, I apparently mistyped my first question, so it was taken in the wrong context (in NO part to the responder(s))
What I want, is the have to data already, and if I want the most recent data, then run the query. So lets say I have a frmQuery, and it is based off of qryQuery. But the qryQuery takes 8 days to run, so I only want it to run once, and see the data in frmQuery. But if the user wants the most recent data, then they may run qryQuery. How do I do that with VBA code?
Thanks!
http://www.access-programmers.co.uk/forums/showthread.php?t=283902
In that post, I apparently mistyped my first question, so it was taken in the wrong context (in NO part to the responder(s))
What I want, is the have to data already, and if I want the most recent data, then run the query. So lets say I have a frmQuery, and it is based off of qryQuery. But the qryQuery takes 8 days to run, so I only want it to run once, and see the data in frmQuery. But if the user wants the most recent data, then they may run qryQuery. How do I do that with VBA code?
Thanks!