Display Icon in each record in subform.

  • Thread starter Thread starter Spiral
  • Start date Start date
S

Spiral

Guest
I don't know if this is the right place to post this but here goes.
How do you display an icon or image in a field in a subform in Access2003?
I tried inserting an image into a field with its data type set to OLE Object.
This doesn't work. I insert a bitmap or icon file (*.ico) into the table. When I open up the subform the field displays the word "Package" for Bitmap image".
Any help would be greatly appreciated
Thank you :D
 
This Should Help...

What to do when you see "Package" instead of "Bitmap Image" in your database tables Help

When you use Datasheet view to add GIF, JPEG, and other common types of image files to an OLE Object (OLE object: An object supporting the OLE protocol for object linking and embedding. An OLE object from an OLE server (for example, a Windows Paint picture or a Microsoft Excel spreadsheet) can be linked or embedded in a field, form, or report.) field in a table, you see the word "Package" instead of the expected "Bitmap Image."

"Package" appears in the field because the OLE Object field only supports Windows Bitmap (.bmp) and Device Independent Bitmap (.dib) files. If you want to store additional types of graphic files in an OLE Object field and have Access render them properly, you must install additional software, and that software must provide the components (called OLE servers) needed to display the additional image types.

Previous versions of Microsoft Office provided a program called Microsoft Photo Editor, which in turn provided the OLE server needed to render GIF and JPEG files. The Office 2003 System replaced Photo Editor with Microsoft Picture Manager, which does not provide the needed OLE server for those types of files.

You can use either of the following techniques to work around this issue:

Store your images outside of your database and use Visual Basic® for Applications (VBA) code to display them. For more information, see the Microsoft Knowledge Base article How to display images from a folder in a form, a report, or a data access page.
Convert your GIF or JPEG images to Windows Bitmap (.bmp) files. Although BMP files are usually larger than GIF or JPEG files, they can help reduce the size of your database, because Access doesn't create additional Device Independent Bitmap (.dib) files to support them. For information about why Access creates DIB files when you use GIF or JPEG images, see the Microsoft Knowledge Base article Why OLE Objects Cause Databases to Grow.
Reinstall Photo Editor using an Office XP or Office 2000 installation CD.
Reinstall Photo Editor from Office XP

Start Setup on your installation CD. If the installation program does not start automatically, you can start it by using Windows Explorer. To do so, click Start, point to All Programs, point to Accessories, and then click Windows Explorer. Locate your CD-ROM drive and double-click Setup.exe.
Enter the product key (your initials are optional) and click Next.
Accept the terms of the license agreement and click Next.
Select the Custom installation type and click Next.
Select Choose detailed installation options for each application, and click Next.
Under Features to install, set each program to Not Available. To do so, click each item and select Not Available from the list. A red "X" should appear on each item.
Expand the Office Tools feature, click Microsoft Photo Editor, select Run from My Computer, and click Next. This forces the installation program to install only Photo Editor.
Click Install to complete the installation.

--------------------------------------------------------------------------------

Reinstall Photo Editor from Office 2000

Insert Disc 1 into your CD-ROM drive to start the installation program. If the installation program does not start automatically, you can start it by using Windows Explorer. To do so, click Start, point to All Programs, point to Accessories, and then click Windows Explorer. Locate your CD-ROM drive and double-click Setup.exe.
On the first screen, enter the product located on the CD case. You can optionally enter your initials. When finished, click Next.
Accept the terms of the license agreement and click Next.
Click Customize and click Next.
Move through the next two screens by clicking Next twice.
On the Microsoft Office 2000: Selecting Features screen, set each Office program to Not Available. To do so, click each item and select Not Available from the list. A red "X" should mark each feature.
Expand the Office Tools feature, click Microsoft Photo Editor, and select Run from My Computer from the list. This forces the installation program to install just Photo Editor.
Click Install Now to complete the installation.
More information
See these articles for more information about using images with Access:

What to do when you see filenames instead of images in your Access database explains another way of looking at and resolving problems that result from displaying unsupported graphic file types.
ACC: Why OLE objects cause databases to grow explains why storing GIF and JPEG images in an OLE Object field can rapidly inflate the size of a database.
How to save a bitmap file as an OLE object in an Access OLE Object field explains how to use VBA code to store image files in an OLE Object field and automatically start the correct container and display those files.
Use images in your Access forms, reports, and controls provides all the information you need to use images with an Access database.
Dress up your Access database, an overview of the ways you can use images with an Access database

Referenced from Site Below:
http://office.microsoft.com/en-us/assistance/HA011513811033.aspx
 
We embed Bitmap images successfully on several computers, but also have several computers that are unable to embed Bitmap Images using this method - they produce the 'Pagkage' entries.

!InvoiceHeader.SourceDoc = RSTCompanies!InvoiceHeader
!InvoiceHeader.OLETypeAllowed = acOLEEmbedded
!InvoiceHeader.Class = "Paint.Picture"
!InvoiceHeader.Action = acOLECreateEmbed

One is Vista, another is XP Pro, both have MSPaint as the default application (and therefore OLE Server) for Image files.

This paste action results in 'Package' in the table, whereas on other computers the same action causes the correct embedding of the Bitmap Image.

Some machines have Photoshop, both those that work and those that dont - very confusing.

I have tried the Microsoft Photo Editor from Office XP also, as suggested on a MS KB article. There is no different.

Can I force the OLE Server for Bitmap Images to repair, or re-register it somehow? Perhaps Photoshop is taking over the BMP extension, even though Windows thinks Paint is doing it.

I'm very confused.

Any ideas from anyone who has also had the same?

Thanks


MB
 
Last edited:

Users who are viewing this thread

Back
Top Bottom