open .xls & .doc files from a form?

[bschene]

This is probably a no brainer, but...
I can create a command button that will open up the applications of MS Excel & Word, but how do I create a button that will open SPECIFIC .xls & .doc FILES from a form? (I am using Access 2000)
Help & Thanks!

 

[Adrianna]

The Command button wizard will allow you to open a specific .xls or .doc or any other file for the matter through code or a macro.

If you're not familiar with writing code or don't want to waste the effort of creating a macro, I would simply suggest that you create a buttn without using the wizard, or edit the properties of the button that you have created.

Right click on the button, select properties, and then click on the ... of the Hyperlink property field. If you know that UNC path then just type that in, but selecting the file through the ... is a quick and easy way to make sure you've entered the path correctly.

If you want the link to go to a specific page or cell in the applicaiton that you're openning, use the Hyperlink SubAddress field to specify that information. You can look up the Access help files on this if you need more guidance!

 

[Fornatian]

Or even simpler, just insert a hyperlink - use Insert-Hyperlink and choose the file, a label hyperlink will be created as if by magic.