I have created a short cut command that allows me to launch a macro with a parameter from the start/run command or via a shortcut. It works exactly the way I want it to. I want to know if it is possible to create a hyperlink with this command so I can put it in an email message so the user can click on the hyperlink and it will launch the database and run the macro with the parameter.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Create Hyperlink to launch Access97 macro
- Thread starter ReeH
- Start date
Why don't you put the code you want to start in the autoexec macro, that way it will trigger however it's opened. If you want different things to happen to different people, put some name checking code in.
Ben ----------------------------------
Ben O'Hara
bo104@westyorkshire.police.uk
----------------------------------
Ben ----------------------------------
Ben O'Hara
bo104@westyorkshire.police.uk
----------------------------------
- Thread starter
- #3
Ben,
The hyperlink changes dynamically causing the macro to open a form with a unique record. I can't use the autoexec macro because I only want the macro to launch for a specific person and for a specific record. It is unknown which person will need to view which record until run time and the email is generated.
The hyperlink changes dynamically causing the macro to open a form with a unique record. I can't use the autoexec macro because I only want the macro to launch for a specific person and for a specific record. It is unknown which person will need to view which record until run time and the email is generated.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Solved
- Locked
- Question
