Search results

Thanks guys, I ended up getting working with the following: Dim f As Object Set f = Application.FileDialog(3) With f ' Allow Mulitple Selections .AllowMultiSelect = False ' Set the title of the dialog box. ' .Title = "Please select file to link" ' Clear out the...

Thanks for the reply Mark, I'll try and explain a bit. The idea is each record will need to be 'linked' in someway to a pdf or doc file that lives on a shared drive. I currently have a field for the user to add a hyperlink to the file, which works but does not give the best user experience...

Hello, I have a form displaying records. I would like the user to be able to select a button, browse for a file on a shared drive and link it to that record. I have been exploring hyperlinking, which works for the most part, although I need it to display the share name rather than the drive...

I should mention that at the moment this code opens my template succesfully but then leaves an error message in access saying ' Run-time error '-2147217904 (80040e10)': No value given for one or more required parameters.'

Hi everyone, First post so go easy. Originally, I was attempting to get the output of a query in access to export to an excel template. This beat me. So I decided to try and use output the table the query referenced and filter it in VBA using a combo box. This is beating me now. This...