Get File Name and Path

[Edgar Thoemmes]

Hi

Is there equivalent code in access to the Application.GetOpenFileName()
which I can use to assign a path and file name to a variable?

I want to use this on a form so that I can return a hyperlink to a file
without typing the whole address everytime.

TIA

 

[Allen Browne]

See:
Call Windows File Open/Save Dialog box
at:
http://www.mvps.org/access/api/api0001.htm

If you just want the user to select a hyperlink, you may be able to use:
RunCommand acCmdInsertHyperlink