Link to home
Start Free TrialLog in
Avatar of Paul Collins
Paul Collins

asked on

How do i open an access form from an Excel Hyperlink Button

I want to be able top open an access form an excel button with a hyperlink.

I know with Word and Excel this can be done with a # after the file name linked to a bookmark or range name but not sure how to create the link to an Access form

Thanks Paul Collins
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

You can open Access fairly easily with a command line call:

"full path to msaccess.exe" "full path to your database"

Opening a specific form can be achieved one of two ways:

1. Set a Startup form in the Access application.
2. Create an AutoExec macro where you open the desired form

Note that you may be able to get away with NOT including the path to msaccess.exe, if your file associations are set correctly on the target machine.
ASKER CERTIFIED SOLUTION
Avatar of Anders Ebro (Microsoft MVP)
Anders Ebro (Microsoft MVP)
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Paul Collins
Paul Collins

ASKER

Well it does work as you suggested. Never thought of this approach   Your website looked most interesting.
Would be curious to see what others come up on this
That is interesting. Never knew you could do that. Thanks Anders!
I was surprised at solution..Its quick and you need to keep the shortcuts you make  in a file in a specific folder so you can hyperlink to that shortcut to it but it works..  dont change the name of the shortcut but if you open it and go to security and click on Authenticated users you get the Object Name which you can use as your hyperlink.

In the example below I am opening a table "1_WIDT_X_Data_Access" in an access database called "Core2016"
However all this was created automatically by the process above.

C:\KeyFiles\101 CoreWorkArea\AccessFormsOpenDirect\Shortcut to 1_WIDT_X_DATA_ACCESS_Import in Core2016.accdb.MAT