help getting to Access Queries

bhogue · 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

support · 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

Bob Hansen · 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.

dseibold · 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...

jpuziano · 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

pgriffin · 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 · 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!