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 assignment for that user. Such as \\drive1\folder rather than C:\folder.
Hyperlinking also unfortunatly requires the user to right click on a field select edit hyperlink then browse. Not a very good end solution.
Can this be done in VBA?
THanks for your help as always.
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 assignment for that user. Such as \\drive1\folder rather than C:\folder.
Hyperlinking also unfortunatly requires the user to right click on a field select edit hyperlink then browse. Not a very good end solution.
Can this be done in VBA?
THanks for your help as always.
Linking document to record VBA
