Book

Suggestions


Enter your email address:

Delivered by FeedBurner



Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?
Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












Subscribe here
Add to 

My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Sunday, August 17, 2008 – Permalink –

Pictures in Forms

It can still be done


Photo Editor was an Office component prior to Office 2003.

In Access/Office 2003/2007 MS Photo Editor was replaced, and Office no longer includes an OLE server for images.

To work around this issue, reinstall Photo Editor.

To do this, follow these steps:

  1. Insert the Microsoft Office XP CD-ROM into your computer's CD-ROM or DVD-ROM drive.
  2. If the Office XP Setup program does not start automatically, follow these steps:

    1. Click Start, and then click Run.
    2. In the Open box, type drive:\Setup.exe, where drive is the letter of your CD-ROM or DVD-ROM drive.

  3. Start to step through the Setup process, and then select Customize for the type of Setup to perform.
  4. When you reach the Selecting Features step, set each node of the Setup tree to Not Available.
  5. Under Features to install, expand Office Tools.
  6. Click Microsoft Photo Editor, and then click Run from My Computer.
  7. Click Install Now.
  8. Click OK when Office XP Setup has completed successfully.

Microsoft Support Article: 817095

Also: Ammara.com: Pictures in Access Forms & Reports OLE Object Photo & Image Problems & Solutions

Access MVPS.org: Handle/Display images in forms/database

"While it's possible to actually store the images within the database itself as OLE objects, normally it's not the preferred way. When you embed an OLE object in a table, you're storing a lot of overhead as well. This overhead is the information about the object (such as its parent application) that Access needs to store in order to render the object properly."
Displaying photos in a form See all Topics

Labels: ,


<Doug Klippert@ 3:51 AM

Comments: Post a Comment