Hello All,
I run a daily Access query and trying to automate that process so I no longer have to run it daily. Is there a way I can do this and have it linked to an excel file? Please help!
Hello All,
I run a daily Access query and trying to automate that process so I no longer have to run it daily. Is there a way I can do this and have it linked to an excel file? Please help!
You still want the query to run each day, you just don't want to have to do it manually? Some event must take place to trigger code. Can have code behind a form set as default to open when project opens. You would still have to open the project each day. I have automated this by a VBScript that opens my project. The VBScript is run each day by a task set up in Windows Task Scheduler.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
You can create a windows task to run a program each day. I believe (almost sure) you can tell the task manager to open a path. if that is so, just run the query on startup and after that shut it down.
I tried to find a way for Task Scheduler to open a specific Access file but no success so went with the VBScript.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
June,
see post #2 here:
http://social.technet.microsoft.com/...5-ff2cb4ba9da8
I bet it works. You can also do this with a one liner in a .bat file. Right? That's a good way to ditch vbScript, which is probably more than one line to you?
I am still running XP and not seeing the options described in that link. Has the task scheduler changed for Vista and Windows7? Oh well, not a big issue, setup I have works satisfactorily. The script is about 3 lines (not with me).
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.