Link to a specific Form from Excel

[Guest]

I've posted this to the excel forum but thought I'd post it here too seeing
it's also related to access.

I would like to create an Excel hyperlink directly to one of my MSAccess
forms, ie, NOT the main 'switchboard' menu.

Any ideas ??

 

[[MVP] S.Clark]

AFAIK, Excel can link to data, but not to UI objects. So, you can link to
the recordsource of the form, but not the form itself.

 

[[MVP] S.Clark]

When Access opens, you can pass a parameter using the /x switch. With this,
you can specify a Macro to run when it opens. In that Macro, you can
specify the form to open.

Something like:

"C:\Program Files\Microsoft Office\...\msaccess.exe" "c:\...\mydata.mdb" /x
MyMacro

MyMacro
Openform "MyForm"