Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Rotate image on Access report

Posted on 2013-06-18
3
Medium Priority
?
2,429 Views
Last Modified: 2014-03-11
Hello Experts,

I have an Access 2003 report, with several image controls.
The images are loaded at the Load event.

Now i need to rotate these images 90 degrees counter clockwise.
Does someone knows how to doe this?

With kind regards,

Gijsbert
0
Comment
Question by:sonnevelt
3 Comments
 
LVL 27

Expert Comment

by:jjafferr
ID: 39258454
Hi

This cannot be done with native Access :(

You can either Pre-Rotate the image/s , or I think there are some plug-ins that can do this.

jaffer
0
 
LVL 31

Expert Comment

by:Helen Feddema
ID: 39259933
Open them in an app that can rotate them (even the Windows Picture & Fax Viewer will do), rotate it, and re-save it, then re-import the images.
0
 
LVL 21

Accepted Solution

by:
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 1500 total points
ID: 39268161
There is a third-party control named DBPix that will do what you want.

See: http://www.ammara.com/support/help/html/mimagerotate.html

There is also this: http://access.bukrek.net/

and

Stephen Lebans wrote:

The Image control does not expose a method to rotate the contents of the
control. If you must have this functionality then the easiest method that
would involve little or no programming would be to use a third party ActiveX
control that supports rotation. Search for the DBPix control.

If you do not mind coding a bit, the ImageClass on my site does support
rotation for the standard Image control.
http://www.lebans.com/imageclass.htm
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

926 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question