Jump to content


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.

Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.


Msaccess/excel Picture Display

  • Please log in to reply
No replies to this topic

#1 mshemari


  • Members
  • 1 posts
  • Local time:05:58 PM

Posted 19 June 2008 - 01:55 PM

Here is my setup:
I have MSAccess 2007 operating in compatibility mode (2003) linked to Excel (also running in compatibility mode (97-2003)) sheets as a datasource. One of the fields in the Excel sheet is a full path file specification to a .jpg picture file, one file specification (picture) per Excel row.

In Access, I have created a report based on the Excel spreadsheet's data.
The report has a Group Header section that would generate a header for each Excel row.
In the Group Header section of the report, I placed an Image control.
In the Group Header's On Format event, I placed the following code:

If Not Me![PictureFileSpec] = "" Or Not IsNull(Me![PictureFileSpec]) Then
Me![ImageCtrl].Picture = Me![PictureFileSpec]
Me![ImageCtrl].Picture = ""
End If

Where PictureFileSpec is the fullpath data coming from the Excel table.

Other pertinent ImageCtrl properties are:
Size Mode = Stretch
Picture Type = Linked

The pictures appear IF I view them in Print Preview mode.
They do NOT appear if a simply Open the report and view each record.

What am I missing with the Report/Open option as opposed to the Report/Print Preview option?

Thanks for any ideas and assistance.


BC AdBot (Login to Remove)


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users