Is there a keystroke to "jump" to Queries in an Access DB? Access help says to click on "Queries".
-brian
help getting to Access Queries
Moderators: Dorian (MJT support), JRL
You can query data in an Access DB directly from within Macro Scheduler transparently using VBScript. No need to automate the Access user interface at all. See:
http://www.mjtnet.com/index.htm?vbsdb.html
http://www.mjtnet.com/index.htm?vbsdb.html
MJT Net Support
[email protected]
[email protected]
- Bob Hansen
- Automation Wizard
- Posts: 2475
- Joined: Tue Sep 24, 2002 3:47 am
- Location: Salem, New Hampshire, US
- Contact:
Hi Support,support wrote:You can query data in an Access DB directly from within Macro Scheduler transparently using VBScript. No need to automate the Access user interface at all. See:
http://www.mjtnet.com/index.htm?vbsdb.html
The link you posted above only brings up your home page for me...
Did you mean this URL: http://www.mjtnet.com/vbsdb.htm
jpuziano
Note: If anyone else on the planet would find the following useful...
[Open] PlayWav command that plays from embedded script data
...then please add your thoughts/support at the above post -
Note: If anyone else on the planet would find the following useful...
[Open] PlayWav command that plays from embedded script data
...then please add your thoughts/support at the above post -
This is what I was looking for! I've been trying to use the VBSTART with absolutely no success... it's much easier to just call the desktop shortcut.SkunkWorks wrote:If you want MacroScheduler to use a link to your desktop, use a line like the following...
exe>C:\Documents and Settings\user\Desktop\MyQuery.lnk
OR
Run>C:\program files\some app\MyProgram.exe
In my case, an Access Macro shortcut is .mam rather than .Ink and it is working!