I have managed to dynamically reference a bunch of filepaths in my database saved to a field called FilePath. The links are full filepaths in the following format. I have added the square brackets to identify items that vary depending on the item uploaded:
H:\BackupOfAttackments\[ID]\[File Name including extension]
This gives something like the following:
H:\BackupOfAttachments\ID\Design 12335434 - Revision 1.xlsm
My current code for my open-file style Button is:
avlist is the full filepath of H:\BackupOfAttachments\ID\Design 12335434 - Revision 1.xlsm.
How do I get Access/VBA to open the file? I am looking for a way to do this that can handle all file extensions.
I don't think this needs an example database to be uploaded to aid with this, but if it does I would be more than happy to create one.
H:\BackupOfAttackments\[ID]\[File Name including extension]
This gives something like the following:
H:\BackupOfAttachments\ID\Design 12335434 - Revision 1.xlsm
My current code for my open-file style Button is:
Code:
Private Sub FinishIconFleet_Click()
Dim avlist As String
avlist = Me.lstAvailable.Column(1)
Debug.Print avlist
End Sub
avlist is the full filepath of H:\BackupOfAttachments\ID\Design 12335434 - Revision 1.xlsm.
How do I get Access/VBA to open the file? I am looking for a way to do this that can handle all file extensions.
I don't think this needs an example database to be uploaded to aid with this, but if it does I would be more than happy to create one.