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.

Photo

Msaccess/excel Picture Display


  • Please log in to reply
No replies to this topic

#1 mshemari

mshemari

  • Members
  • 1 posts
  • OFFLINE
  •  
  • Local time:04:41 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]
Else
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.
WHY??

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

Thanks for any ideas and assistance.


mshemari

BC AdBot (Login to Remove)

 





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users