Find a file in access

[dvannoy]

I have a database that tracks manifest document #'s and certain data regarding the manifest.
What we want to do is, scan the original manifest document onto the server. with the file name being the manifest number.(GIF or JPEG format) And in the database create a button that will prompt you for the manifest # and be able to find it on the server. All the manifest's that are scanned will have a unique file name and will all be located in the same directory.

Is something like this possible?

Any help would be appreciated

Thanks in Advance

DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[DougP]

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 = &quot;p:\ViewPhotos\Photos\&quot; & Me![ID] & &quot;.jpg&quot;
Label20.Caption = &quot;File: &quot; & &quot; p:\ViewPhotos\Photos\&quot; & Me![ID] & &quot;.jpg&quot;
End If

End Sub

Also I used a unique ID for the Pictures name so when I click the navigation 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)
DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[dvannoy]

It wont let me insert an image control..I tryed to register the Micorsoft image control 6.0 but i guess i donot have the file .ocx

Or am I doing something wrong?

Is there a different type of image control?

Thanks DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[dvannoy]

Never mind I got it...just was to early in the morning..

Anyways thanks it works..I am trying to use an input box to enter the doc# and show only that pic...

do you have any input for me?

Thanks

DVannoy
A+,Network+,CNA
dvannoy@onyxes.com