I am new to the forum and not really a code writer. I have copied the following code that uses the hyperlink function to connect a Field with a file stored on a server:
Private Sub Photo_Click()
Photo.HyperlinkAddress = "F:\Photos\InProcessPhotos\" & RepairOrderID.Value
End Sub
It works but only if the file name in the photos folder matches exactly. Is there a way to have the code look at just the first 5 characters and ignore the rest. that way I can put some more descriptive names to the file. Example is current file name = 25696, and I want it to return a file named 25696Red2010Porche.
Thank you
Private Sub Photo_Click()
Photo.HyperlinkAddress = "F:\Photos\InProcessPhotos\" & RepairOrderID.Value
End Sub
It works but only if the file name in the photos folder matches exactly. Is there a way to have the code look at just the first 5 characters and ignore the rest. that way I can put some more descriptive names to the file. Example is current file name = 25696, and I want it to return a file named 25696Red2010Porche.
Thank you
