Looking for control to browse files

[Peter-Paul Jansen]

Hi,

I am pretty new to and unexperienced with access (2007 is the one I
amworking with)
I have made a database (of 1 table) to record registered mail and such.

I have added a hyperlink field which contains the link to a specific
transmittal document showing the contents of the mail item.
I have added it to the form and it works fine. If I click on the link it
opens the (Word) transmittal file). So far so good.

What I want is a control that lets me browse for the transmittal file,
something like a simple Open dialog

Can someone point me to the right documentation, please

TIA

Peter-Paul Jansen
Rijswijk, The Netherlands

 

[Mark Andrews]

http://www.mvps.org/access/api/api0001.htm

You can also change it to allow for multiple files to be selected using ctrl
click.

Mark Andrews
RPT Software
http://www.rptsoftware.com

 

[Mrs. Ugh]

I have a command button with the following code in the "On Click" event:

Private Sub BrowseForLocation_Click()
On Error GoTo Err_BrowseForLocation_Click


Me!ResponseLocation.SetFocus
DoCmd.RunCommand acCmdInsertHyperlink


Exit_BrowseForLocation_Click:
Exit Sub

Err_BrowseForLocation_Click:
MsgBox Err.Description
Resume Exit_BrowseForLocation_Click

End Sub


BrowseForLocation is the button name, and ResponseLocation the name of the
hyperlink field.
Jill

 

[Peter-Paul Jansen]

I have 3 different answers. No doubt one of them will work.

Thank you very much for the quick responses,
Mark, Mrs Ugh and Ken

Peter-Paul