Allow User to Create Hyperlink

[Costefran]

Hi Can anyone help

I have been considering how I can attach a file (Word Doc or PDF) to a record in Access and have been told to avoid this as the DB will soon become bloated so I thought maybe there is a way that a user can create a Hyperlink on a form through a command button 'on click' event that browses for the file and location and then place the file path on the form for future users to click on and open the file

Does anyone know if this is possible

Thanks

 

[CaptainD]

This is a bit rough and it does not error trapping or any type of checks but, you can get the file name and path to save to a table and then use rundll32 to run diffrent file types if that is what you are looking for.

I created a simple table to hold the hyperlink and just used a bound form to hold the file name along with the path.

I also created a simple "Run" button to open various file types.

Needs work but this should get you going.

Option Compare Database

Private Sub cmdFilePath_Click()
Dim sFilePath As String
Dim fd As FileDialog

Set fd = Application.FileDialog(msoFileDialogFilePicker)
    fd.Filters.Clear
    fd.Show

sFilePath = fd.SelectedItems(1)
txtFilePath.SetFocus
txtFilePath.Text = sFilePath

End Sub

Private Sub cmdRun_Click()
txtFilePath.SetFocus
Shell "RunDLL32.EXE shell32.dll,ShellExec_RunDLL " & Trim(txtFilePath.Text)
End Sub

 

[Costefran]

CaptainD

Thanks very much for you ehlp

Will give it a try