I'm trying to use an MS Access form to control a digital camera. The camera will be used to capture images and MS Access will be used to download the images from the camera into an MS Access database or file that will be later linked to MS Access data. Any experience with this? [sig][/sig]
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Digital Camera
- Thread starter FrankPV
- Start date
Yes,
I leave the images on the hard drive, Server drive preferrably
Then I use this code to load it in an Image on a form.
This does 2 things allows you to view different formats i.e. .gif or .jpg
And keeps your database small because your are not adding images which will bloat it in a hurry.
1. So create a form whose record source is connected to your table
2. Add an Image control to the form
3. Properties of Image as follows:
Picture (none)
Picture Type linked
4. Put this code in the On_Current event of the form
Private Sub Form_Current()
If Me![ID] <> 0 Then
Me!Image14.Picture = "p:\ViewPhotos\Photos\" & Me![ID] & ".jpg"
Label20.Caption = "File: " & " p:\ViewPhotos\Photos\" & Me![ID] & ".jpg"
End If
End Sub
Also I used a unique ID for the Pictures name so when I click the naviagation buttons it would get the unique ID from the database and then load that picture.
I also added a label so you know which image it was trying to load (for troubleshooting)
[sig]<p>DougP, MCP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.[/sig]
I leave the images on the hard drive, Server drive preferrably
Then I use this code to load it in an Image on a form.
This does 2 things allows you to view different formats i.e. .gif or .jpg
And keeps your database small because your are not adding images which will bloat it in a hurry.
1. So create a form whose record source is connected to your table
2. Add an Image control to the form
3. Properties of Image as follows:
Picture (none)
Picture Type linked
4. Put this code in the On_Current event of the form
Private Sub Form_Current()
If Me![ID] <> 0 Then
Me!Image14.Picture = "p:\ViewPhotos\Photos\" & Me![ID] & ".jpg"
Label20.Caption = "File: " & " p:\ViewPhotos\Photos\" & Me![ID] & ".jpg"
End If
End Sub
Also I used a unique ID for the Pictures name so when I click the naviagation buttons it would get the unique ID from the database and then load that picture.
I also added a label so you know which image it was trying to load (for troubleshooting)
[sig]<p>DougP, MCP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.[/sig]
- Status