form & code allowing user to select location of associated file,

[Thardy]

I have a simple database, basically a library list of documents. I
have a column for hyperlink in my main table, but I would like to make
it so any user can be prompted to navigate to the file location on the
server, rather than have to manually type, or copy paste the address
into the form.
Any help would be greatly appreciated. Im not totally new to
Access, but quite rusty as it's been some time since I have played
with code.

Thank you,
Tracy

 

[Jeanette Cunningham]

Hi Tracy,
use the code on the Access web http://www.mvps.org/access/api/api0001.htm
to allow users to navigate to the file location on the server.

Jeanette Cunningham

 

[Thardy]

I got the code to work great, totally lost as to how to incorporate
it so that I can add a button to run it, and then save the link in
the table.

 

[Jeanette Cunningham]

Private cmdButton_Click()

Dim strFilter As String

Dim strSavetFileName as string

'Ask for SaveFileName

strFilter = ahtAddFilterItem(myStrFilter, "All Files (*.*)", "*.*")

strSaveFileName = ahtCommonFileOpenSave( _

OpenFile:=False, _

Filter:=strFilter, _

Flags:=ahtOFN_OVERWRITEPROMPT Or
ahtOFN_READONLY)



Have a bound textbox on your form that will receive strSaveFileName

me.txtSaveFileName = strSaveFileName

End Sub



Jeanette Cunningham