Opening other office files with Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top