help getting to Access Queries

Technical support and scripting issues

Moderators: Dorian (MJT support), JRL

Post Reply
bhogue
Newbie
Posts: 9
Joined: Fri Jul 08, 2005 5:25 pm

help getting to Access Queries

Post by bhogue » Thu Jul 14, 2005 6:57 pm

Is there a keystroke to "jump" to Queries in an Access DB? Access help says to click on "Queries".

-brian

User avatar
support
Automation Wizard
Posts: 1450
Joined: Sat Oct 19, 2002 4:38 pm
Location: London
Contact:

Post by support » Thu Jul 14, 2005 7:00 pm

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
MJT Net Support
[email protected]

User avatar
Bob Hansen
Automation Wizard
Posts: 2475
Joined: Tue Sep 24, 2002 3:47 am
Location: Salem, New Hampshire, US
Contact:

Post by Bob Hansen » Thu Jul 14, 2005 9:20 pm

You can also make a shorttcut to your Access query, and have Macro Scheduler use the shortcut.

You can left click on the query and drag to your desktop, OR,
You can right click on the query and Create Shortcut.
Hope this was helpful..................good luck,
Bob
A humble man and PROUD of it!

dseibold
Newbie
Posts: 15
Joined: Mon Mar 06, 2006 7:13 pm
Location: Stockton, CA
Contact:

Post by dseibold » Wed Mar 29, 2006 11:16 pm

How do I get Macro Scheduler to use the shortcut to the access query? I can't find any examples anywhere...

User avatar
jpuziano
Automation Wizard
Posts: 1085
Joined: Sat Oct 30, 2004 12:00 am

Post by jpuziano » Wed Mar 29, 2006 11:25 pm

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
Hi Support,

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 - :-)

User avatar
pgriffin
Automation Wizard
Posts: 460
Joined: Wed Apr 06, 2005 5:56 pm
Location: US and Europe

Post by pgriffin » Thu Mar 30, 2006 2:30 pm

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

dseibold
Newbie
Posts: 15
Joined: Mon Mar 06, 2006 7:13 pm
Location: Stockton, CA
Contact:

Post by dseibold » Thu Mar 30, 2006 6:59 pm

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
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.
In my case, an Access Macro shortcut is .mam rather than .Ink and it is working!

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts