Photo Database

[damienjude]

I am making a photo database for a friend of mine. He's a photographer for his company and has photos based on events from many years.

Whenever there is a farewell for his colleague he would have to search photos of them to make a farewell video, which means going through many events from many years.

I decided to save the photo's path into the database in order to save space an it has a text datatype. There is a image box on the form and the path is the control source just to make sure that the photo's path has been keyed in correctly.

He knows how to key in the photos path into the access form but I don't know how I can lead him back to the photo.

He'd use a query to search for the colleague and it would be converted into a continuous form. On the form I had the idea of changing the textbox of the photo's path into a hyperlink but it wouldn't lead me back to the photo.

Help please

 

[boblarson]

If you just want to open a Windows Explorer to the file you should be able to use:

Dim strPath As String
strPath = Me.YourTextBoxHereWithFilePathAndName
Application.FollowHyperlink Left(strPath, InStrRev(strPath, "\"))

 

[damienjude]

Sorry but I am very new to microsoft access, so where do I input that code?