Updating Image Controls In Real-Time

[Nightvoice]

I have an application that saves its screenshots rotated 90° clockwise. The Access app I've written so far addresses this by running a PowerShell script that correctly rotates the image file 90° counterclockwise upon a button click and resaves it, and the goal is to get the display of the image control referencing it to update as well (it's linked via the .Picture property). So far, I've tried the .Refresh, .Repaint, .Recalculate, .Requery actions and several other things to no avail. If I click on the parent table form record the control is linked to, it refreshes correctly, but this is a pain. Any ideas?

 

[xavier.batlle]

Have you tested to reset (set again) the .Picture property? I've tested it and after reseting it the image is updated on the screen

 

[theDBguy]

For me, using .Refresh works. Maybe add a DoEvents or two?

 

[xavier.batlle]

For me, using .Refresh works. Maybe add a DoEvents or two?

@theDBguy
It doesn't work for me. If I change the underlying image without changing its .Picture property executing a form .Refresh doesn't update the image on the screen.

 

[theDBguy]

@theDBguy
It doesn't work for me. If I change the underlying image without changing its .Picture property executing a form .Refresh doesn't update the image on the screen.

Oh, I see. I think the difference is, in mine, I am using the Control Source property instead of the Picture property.

 

[isladogs]

I also use the Picture property in my Folder Image Viewer example app:

Folder Image Viewer

The example database shows how thumbnail images can be displayed for selected images in a folder. It also allows images to be rotated so they always display properly in Access

isladogs.co.uk

This automatically rotates or flips the image horizontally or vertically as appropriate, together with an option to save the modified version.
For example

 

[Nightvoice]

Thanks for the input, guys. I tried your suggestions and still no luck; it won't refresh the image unless I manually click the other subform record it queries on. I looked at the Folder Image Viewer file, but when I open it it and populate the file list it doesn't even give me any options.

 

[isladogs]

With the Folder Image Viewer what happens when you select one of the images in the list box?

 

[Nightvoice]

With the Folder Image Viewer what happens when you select one of the images in the list box?

This is all it gives me.

 

[isladogs]

The first image F1 is correctly orientated.
Have you tried the others e.g. F2 is flipped horizontally and the app also displays a corrected version

Similarly F3 is rotated through 180 degrees, F4 is flipped vertically etc . .
Did you look at the other images as well?.

 

[Nightvoice]

It's not giving me the "Reset Image Orientation to Normal" button or any other buttons in the display section.

 

[isladogs]

Please show a screenshot when image F2 is selected - same as my screenshot in post #10.

Also can you confirm your Access version, build, update channel, bitness and Office language as this info may be relevant.
I think you are using Access 2007 32-bit English.
My example app is only guaranteed to work in Access 2010 or later.

 

[isladogs]

Just tested in A2007.
After fixing 2 missing references, unfortunately the WIA code doesn't work in that version.
It will work if you can update to a newer version from A2010 onwards

 

[Albert D. Kallal]

Just re-set (re-apply) the path name to the control. Works for me.

eg:

Image1.Picture = Image1.Picture

R
Albert

 

[Nightvoice]

I am using Access 2007, unfortunately. I tried Albert's idea with no success. Thanks regardless.

 

[isladogs]

Perhaps time to consider updating to a newer version.