Path definition

[acores]

Hi.
I need to ask the user in a customised menu something like: 'Settings >
Documents folder location', where the user would define a [path] to a folder.
Then I would use that path in the following code:

Private Sub ID_Ordem_DblClick(Cancel As Integer)
Dim nome As String
nome = Forms!frm_Obras!Doc_nome
Application.FollowHyperlink path & nome & ".doc"
End Sub

How can I do this?
Thank you in advance.

 

[pietlinden]

If I were doing this, I'd use the BrowseFolder API at accessweb.
www.mvps.org/access

It's in the APIs section.

 

[acores]

Thank you for your answer.
But, it is possible to chose the path only once and predefine it in order to
avoid the user to select the folder every time he wants to open a file?
Thank you again.


"[email protected]" escreveu:

 

[Douglas J. Steele]

Sure. Save it in a global variable once it's been selected.