Embedded Objects

[Jimmy]

Please help... I need to force jpeg/pdf objects to display
in a form & report. I'm trying to build a directory
database for our state association in Access 2002. I have
2 objects as embedded, OLE, and bound in each county's
form unique to each record. I've tried the objects as
jpegs, pdf, etc. but the form and reports only display the
icon for file even if you Insert the OLE. The only thing
that works is bmp & Adobe Photoshop formats, but bitmaps
are too large to use for my large number of records. Even
my IT guy is stumped.

 

[Chris Kennedy]

Hi,

Thank you for using the Microsoft Access Newsgroups.

You wrote:
"..I've tried the objects as jpegs, pdf, etc. but the form and reports only
display the icon for file even if you Insert the OLE. The only thing that
works is bmp & Adobe Photoshop formats,.."

What are running into is related to needing to have an OLE Server program
installed on the computer your are embedding the JPEG images. Try
installing Microsoft Photo Editor (for OfficeXP it is not installed by
default) then embedd your JPEG images.

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

 

[SA]

Jimmy:

You can get PDFs to display on forms, but you will not get them to work on
reports. To display them (PDFs) on a form, you have to add an "Adobe
Acrobat Active X Control" form the toolbox controls item to the form and
size it. Then in the src property of that control specify the path to the
PDF on your hard drive (You can change the pdf file for each record by
storing the path in the db and then using the OnCurrent event of the form to
change the src value to the path you've stored for the record. (i.e. don't
include them in the db in OLE objects!) The same works for jpegs, i.e.
don't put them in the db; but rather place and Image control on the form /
report and then in the OnCurrent event for forms and OnPrint event for the
report, specify the picture property of the image control to be the path to
the jpeg.