How to create Access macro shortcut

  • Thread starter Thread starter Ziggs
  • Start date Start date
Z

Ziggs

I'm still using Access 97 and saw something the other day that I would
like to use that was in Access 2000. In an Access 2000 database,
there was a .mam file in a directory that launched the Access 2000
program and ran a macro. How do you set this up? Can it be done in
Access 97? If so, how?
 
Hi.
How do you set this up?
Click to expand...

Select the macro in the Database Window and right click with your mouse,
then select "Create Shortcut..." in the pop-up menu. Follow the prompts for
where to place the shortcut and what to name it. The default is:
Can it be done in
Access 97?
Click to expand...

I haven't done it in a long time in Access 97, but as I recall, the steps
are identical. In case you weren't aware, these Microsoft Access shortcuts
can be created for any of the objects listed in the Database Window, not
just macros.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
Access tables don't "launch" anything.

What is it you want to do. Don't explain it in terms of something you
might have seen somehwnere else. Explain what you want to do or to
cause to happen.

HTH
 
Hi, Larry.
Access tables don't "launch" anything.
Click to expand...

I don't know where you got the idea that someone has claimed this.
What is it you want to do. Don't explain it in terms of something you
might have seen somehwnere else.
Click to expand...

Ziggs perfectly described what he saw and wants, enabling me or anyone else
to give him instructions: Double-click on the *.MAM shortcut and Access
opens the correct database and runs a specific macro in that database
application. Ziggs wanted to know how to create the shortcut in Access 97,
if it were possible. Fortunately, it is.

It doesn't get any better than that, my friend. :-)

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
Back
Top