Command for allowing user to locate external file.

  • Thread starter Thread starter Dave the wave
  • Start date Start date
D

Dave the wave

I am creating a form that allows the user to set hyperlinks to external
documents. Using the built-in features of Access97 the user has to
rightclick to get to a menu item for opening up the hyperlink editor dialog.
Now the user has to click on the browse button to find the external file.

I would like to shorten this process by either having the hyperlink edit
dialog appear when the control is single clicked, or by using a command
similar to the dialog that appears when the user clicks on the "Browse"
command button on the hyperlink edit dialog box.

In excel I would use "strFileName=GetOpenFilename("*.xls","Locate external
file")". This would open up a file explorer dialog box that would allow a
user to select a single file. Unfortunately, Access97 VBA does not include
the GetOpenFilename command. Is there an equivalent?
 
Well, it has to go in a standard module, not a class
module or form/report module.

But it can go in any standard module. I'd put it in a new
one, as the DECLAREs and TYPEs have to go at the top of
the module.


Chris Nebinger
 
Back
Top