ElderX
Materials
- Oct 18, 2000
- 39
I have an Access Database (2000) which I use to track process equipment. I have photos (400px x 300px) linked to a form in an "image control". I would like to be able to click the photo and then zoom in on the photo in order to view in greater detail. I was thinking of using a macro to run a photo editor but not quite sure how to specify the path to the photo file in the command line for the runapp macro. Can anyone provide the syntax or another way to do this.
The photos are stored on a network drive in a sub directory and are named the same as the equipment number. here is the code I use to link the photos to the form:
Private Sub Form_Current()
On Error GoTo Err_Command97_Click
tankPic.Picture = "L:\Eng\Process Safety\TankPhoto\" & EquiptNo.Value & ".jpg"
Exit_Command97_Click:
Exit Sub
Err_Command97_Click:
tankPic.Picture = "L:\Eng\Process Safety\TankPhoto\NT.jpg"
Resume Exit_Command97_Click
End Sub
Thanks ElderX
The photos are stored on a network drive in a sub directory and are named the same as the equipment number. here is the code I use to link the photos to the form:
Private Sub Form_Current()
On Error GoTo Err_Command97_Click
tankPic.Picture = "L:\Eng\Process Safety\TankPhoto\" & EquiptNo.Value & ".jpg"
Exit_Command97_Click:
Exit Sub
Err_Command97_Click:
tankPic.Picture = "L:\Eng\Process Safety\TankPhoto\NT.jpg"
Resume Exit_Command97_Click
End Sub
Thanks ElderX
