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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
Would be curious to see what others come up on this
That is interesting. Never knew you could do that. Thanks Anders!
ASKER
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\AccessFormsOp enDirect\S hortcut to 1_WIDT_X_DATA_ACCESS_Impor t in Core2016.accdb.MAT
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\AccessFormsOp
"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.