Re: Opening other office files with Access

Yes it would and some design notes...

I would setup the code to assume that the documents are on a drive and in a path that MOST users would be using by default. (Such as c:\documents and settings\all users\Access Documents, or F:\shared files\finance\myWorkGroup\Access Documents if the docs reside on a server). Then I would add code that tests if the document exists in the default path, if it does not I would use the Windows Common Dialog to prompt the user to select the path to the file. The next step would be to capture the path and in someway to save it so that Access uses the user-provided path instead of the default.

Gina Whipp wrote: 
Posting the code would help...

"Carter Wexler" <CarterWexler@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:14E47414-2808-4AB3-9E50-FCAB8800B9AA@xxxxxxxxxxxxxxxx

In my db I have a button on a form that when clicked it will open up the word
document associated with the document location in a text box. I set up error
trapping to catch those who have the drive mapped as a different letter which
gives them the opportunity to input the drive letter in a textbox which
creates the path.

The problem I am having is that even when the drive is correct the error
messages pop up. How can I keep this from happening.
--
Carter 



.