How do I display image on a form in Access 2003?

  • Thread starter Thread starter jm
  • Start date Start date
J

jm

I have an Access 2000 database with a OLE Object field at the table
level. I just generated the form (well the person that did it did.)
When I insert the image in 2000, I hit create from file and link.
Then the picture will be displayed on the form.

I also have a computer with Microsoft Access 2003. When I do the same
procedure, creating from file and linking, this time the picture name
shows up, the file name, but not the picture itself. Pictures that
were inserted from 2000 are displayed.

When I go back and open it in Microsoft Access 2000, the picture is
NOT displayed, only the name (for that record only.)

What is happening?

I also noticed that at the table level the picture column has as its
OLE object "Package" whereas the other ones inserted with Access 2000
says OLE 3.0.

The user is not embedding the picture as best I can tell. On the
other hand, I can see not file path either, so they must be. I know
not to do this, but thought that by linking it it would solve the
problem.

How can I tell if a picture is truly linked or embedded? I didn't see
it on the properties. I am thinking that since no VBA was done to
tell the image control to use a path, that the only reason pictures
are showing up at all is because the person is embedding them
(although it claims from link.)

Any advice is appreciated.
 
Hi,

My name is Amy Vargo. Thank you for using the Microsoft Access Newsgroups.

Office 2003 does not ship with Microsoft Photo Editor. If you have a
previous version of Office, you can install it from there. If not, you can
use an image control on a form to view the image. You can store the path
to the image in a Text field and can view that image with the Image control.

Please review the following article for more information.

210100 ACC2000: How to Display an Image from a Folder in a Form or in a
Report
http://support.microsoft.com/?id=210100

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


Regards,

Amy Vargo
Microsoft Access Engineer


This posting is provided 'AS IS' with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.
 
Back
Top