Hyperlinking to a Word Document

[stormin38]

I am an intermediate user at best with MS Access and have the 2000 version. I've got a mega project I'm working on that requires multiple switchboards generating various reports, queries and email exports. I have one switchboard that requires me to pull up Word Documents. Can I hyperlink the Word documents into a macro so when someone hits the command button on the switchboard it automatically pulls up the Word document? If so, HOW?

I have a myriad of other questions but it's late and I need sleep. I'll submit the other questions on other posts. I've been working on this project for weeks and months and would greatly appreciate any and all assistance you can lend.
Gratefully,
Tracy

 

[mp9]

For an intermediate user, try a macro with a RunCode option. Then use Shell command in the the Function Name parameter, e.g. a Function Name of =Shell("notepad 'c:\temp\test.txt'") will open that doc in Notepad...

For Word docs, try ]=Shell("winword 'c:\temp\test.doc'")

It's very bsaic, but it works. There are lots of more elegant ways if you want to get into VBA.

 

[mp9]

Oops... last post without typo's...

For an intermediate user, try a macro with a RunCode option. Then use the Shell command in the Function Name parameter, e.g. a Function Name of =Shell("notepad 'c:\temp\test.txt'") will open that doc in Notepad...

For Word docs, try =Shell("winword 'c:\temp\test.doc'")

It's very basic, but it works. There are lots of more elegant ways if you want to get into VBA.

http://www22.brinkster.com/accessory/