Status:
- Access Database Designed
- Queries Created
- Forms, Reports, etc done.
- You can enter data, run reports, etc.
- The data base is working.
Issue:
- In the background you want a program running that will...
- Watch the system clock
- At specified time intervals...
- Run a query and perform a task based on the data.
- Do this constantly from the time the operator/admin clicks a "Start App" button in Access until (maybe hours or days or weeks later) the operator/admin clicks the "Stop App" button to stop the background process from running.
Question:
- Can you do this with Access VBA so that it is all contained right in MS Access...
- as opposed to creating the Access DB then writing the "Automation Application" in another language like C++ or C# or whatever.
Thanks for any help.