When you store your images externally (with AccessImagine or not), you can use regular MS Access image control to display them at reports. Access 2007+ is required for this trick.
This technique may be helpful if you experience AccessImagine images printing problems.
1. Insert regular image control and press “Cancel” when it suggests to browse for picture file.
2. Bind it to the filename field (let it be Pic_Filename).
3. Let’s say your pictures are stored at c:\Pic. Change the binding text to this expression:
=”c:\Pic\”+[Pic_Filename]
Thats all you need.
I need like that.. Not embedded in database
Do you need some help?
Help me to save ole image in external path by renaming to Employee ID
You may use OLEtoDisk for this task.
http://www.lebans.com/oletodisk.htm
thanks mate
Hi Max D
I tried it but it says “Sorry..this OLE object contains an unsupported format, Please select a different Record to Export”
mm… can u guide me to put storage path to OLE object & naming the file to Employee Id…it is better.. sorry for disturbances.
Have you used the ExtractInventoryOLE.zip?
Yes…It gave me above error.
I’m using Windows 8.1, Ms Office 2010 “.accdb” file format. ExtractInventoryOLE says .accdb not support then I export to .mdb my working table which include Ole column by accessimagine everything done in order..but it popup that error.
Oh, I misunderstood you! I thought you have legacy OLE data in your database.
If you want to save pictures, that was inserted via AccessImagine, check “How to export…” question here – https://access.bukrek.net/support
I tried following but nothing happened..
Private Sub Command90_Click()
For i = 1 To N
Picture9.SaveFile “d:\mypics str[paempcode] .jpg”
DoCmd.GoToRecord , , acNext
Next i
End Sub
if u can please rectify my coding
1.I put storage path d:\Mypics
2.Table data type as “Text”
pic is saving correctly in that folder but naming is scan , scan1, scan2 and so on….
On the table Labour ID field is “PAEMPCODE” I need to name pics by Labour ID according to record.
Please help & forgive me disturbing u.
Here is 2 parts. If you want AccessImagine to save images with Labour ID, bing AccessImagine to PAEMPCODE field (and keep StoragePath set).
In your code I see one / missing – “d:\mypics\str[paempcode].jpg”
After so many attempt I done as u said. bringing Labour ID to AccessImagine is working perfect. That is what I really want sir Max D. I’m really grateful to you. Thank you very much again & again.
Hi, I am using your tool in a report extracting the image from an external source, and I see the correct image in the report, but when I print it out it prints blank. Am I forgetting something, or is there another way to do this?
Which AccessImagine version do you use?
i have same problem here version 1.74 of accessimagine that i am working with
How can I set exposure compensation levels when I take a picture?
Some coding examples would be very useful. I am trying to load a JPEG on change of a control as a test case.
me.pic99.controlsource=”b:\VehPic\”+[14935174.jpg]
as suggested above just doesn’t work.
The answer is probably blindingly obvious once you know the answer. Can you help please?
It is done this way:
Pic.LoadFile “c:\pic\mypic.jpg”
Take a note, that ActiveX control events doesn’t work in MS Access.
More scripting info here – https://access.bukrek.net/documentation
Hi, can you tell me by what mechanism your Easy Picture Control actually is connecting with the devices? I am curious because I tried to connect to my webcam (which is connected by a usb) via WIA and it does not find it. Your control connects no problem!
Thank you for any insight!
Are you sure that AccessImagine connects with WIA?
Pressing right mouse button on Use Device icon selects the way of connection.
Hello all, anyone else had the problem that the image is displayed in report view mode but in print view mode nothing is shown?
Try to lower printer resolution in printer settings.