You can select the appearance of control when it is empty. It can be a Contact sign, Photo sign of simple gray brick (None).

AccessImagine scripting options

Image

Represents picture in control, you can read and write it to manipulate with images.

Changed

Checks if image was changed from the last time this function was called.

PreviewJPG(Size) and PreviewOLE(Size)

These functions generate small previews of image in control. Size specifies the longest side of preview, if omitted it defaults to 64 pixels. If you need to save OLE previews along with your images, insert this in Exit event procedure of AccessImagine object:

“Pics” – a subfolder in the folder, where your database file is stored

“.” – keep images in the same folder with the database file

If empty.jpg image is present at StoragePath location, it will be used for empty control display

HideButtons

Set this to “Yes” if you don’t want to show the control buttons. It will look just like regular image this way.

OnClick

You can select the control’s behaviour when the user clicks the image.

None – do nothing

ShowFullPicture – show picture in new window, scaling it down to fit the screeen, if it is too big

ShowPanPicture – show picture in new window 1:1 size, giving the ability to pan via a hand tool

OpenPictureFile – open picture with the external application, that is associated with JPG filetype

Scripting options

EmptyText

The text shown where there is no image (usually “No Image“). Can be set to empty string.

Image

Represents the picture in the control, both reads and writes are allowed.

ImageBind

Data bound to control (like ControlSource). Use it for late binding or if usual field binding is not available (i.e. at Access 97)

InstantScan (delay)

Makes instant scanner/webcam image capture without user’s assistance. Will wait delay seconds after device initialization before taking image (it may be needed for some cams that adjust focus/brightness at first few seconds).

Changed

Checks if image has been changed since the last invocation of this function.

PreviewJPG(Size)and PreviewOLE(Size)

These functions generate small previews of the image in control. Size specifies the longest side of the preview, if omitted it defaults to 64 pixels. If you need to save OLE previews along with your images, add the following code to Exit event procedure of the AccessImagine object:

ShowFullPicture and ShowPanPicture and OpenPictureFile

184 Comments

Please allow one more question. In the StoragePath property of my ole picture field I used a dot (“.”) as path, so as to have the captured image stored in the same folder as the main file of the database that includes the field the ole is bound to – as it is indicated in this documentation. However, instead of doing so the captured image is systematically stored in the C:\UserName\Documents folder. Am I doing something wrong?

I get it from a camera. I said script because there is a section called “Scripting options”. I have managed to rotate using a button and TurnRight option in VB. I do not know why but though ActiveX Object was working perfectly to get the images, AccessImagine was not in the list of available VB references and TurnLeft/Right was not working. So I downloaded it again and now I can use it in VB…

We have successfully installed your program under access 97 and it is happily saving images as desired. We have added some code to check if the image already exists in a certain directory, and provided for multiple images associated with the same ID. We now notice that those images which have been viewed under access the program writes the jpg file into the My Documents directory (with a different file date)

Hello. I am storing thumbnails of external images in an SQL server 2012 table with a field type of image. Everything works properly. When I try to store the same data in a field of type varbinary(max) it fails. Microsoft will no longer support image in the future (SQL Server 2016+). Any suggestions? Thanks.

I have developed an MS-Access 2010 database and I use AccessImagine in it, whereby one of the fields in a form captures images via a Microsoft LifeCam HD USB camera.

It all works fine, in general, with the following exception. Sometime clicking the image field to capture an image doesn’t work – it says camera unavailable. Statistically, for 150 images captured on a typical day, this happens once or twice. It is only after exiting the MS-Access application and restarting it that things work again.

I picked my brain and did all the troubleshooting I can think of but can’t find why this happens. I checked that the camera driver is up to date. Any idea? Any suggestion I can try? Thanks.

Firstly, I’m a bit of a newby with Access 2007. I have a database that keeps track of stock and inventory for car parts. The data is imported from a Website and includes the URL of the image that is displayed for each part on the website. The field name in the Parts table is called [PartImageURL].

I have successfully installed your control but can’t figure out how to configure your control so that it references the [PartImageURL]field and displays the image from the website in the control….

Hi!
At first – very good program :-) By now I’m using only demo, but I consider to buy full version.

I have one issue. I have some Access projects, that doesn’t need any pictures. But if I open this kind of MS Access files on computers, that only have Access runtime environment (with full MS Access is the same), the computer can not open file because of missing AccessImagine. I can’t / don’t want to install AcessImagine on every computer, so is there any possibility to switch off your plugin for unneeded files?
Looking forward to hearing from you :-)
Best regs
Jed

Hi!
Is there any way to take a snapshot without delay?
The .scan method “loads” the camera and then takes the snapshot, so there is a few delay. Is it possible to mantain the cam loaded, so when you click a button, it immediately gets the image?

Dear Max, Great tool which adds tremendous value to my database application. A query about ImageBind. I cannot seem to work out how to use it to change or provide a ControlSource at runtime. Would you provide an example of code? thanks, Lance

Hallo,
I have used the paint.net as standard application for jpg-files in Windows 7/Access 2003 for a long time. Now I have changed to Windows 10/Access 2016 and OnClick/OpenPictureFile doesn’t work with paint.net. Could you bring it back?

If I assign paint.net to jpg-files as standard application, the jpg opens with paint.net when I double-click the file. If I try to open the picture with AccessImagine, nothing happens. The same behaviour I see with paint from Microsoft and with GIMP (Version 2.8).

If I assing IrfanView (Version 4.27) or the Windows Photos App to jpf-files, AccessImagine opens the picture with the assigned application as well as a double-click on the file in the file system.

Testimonials

Love the control, by the way. Greatest find yet for my model train inventory database. Stores all pics externally and saves them as JPG (unlike my current program, which SAYS jpg but they are actually BMPs)- Mike

AccessImagine is one of the most productive tools I’ve found in a long time. It saved hours of work and is so simple to use that it makes the average Access user a power user instantly when the goal is to insert images.- Dan

That was f**** awsome! I loved the way you have solved it with the sliding button's and the easy drag-and-drop. This is good programming :)- MrDeej