Displaying images in continuous forms



I have been researching for several hours on the best way to display
images in continous forms in Access 2003. For example, I want to
display employee name, email, phone, and picture for each record in
the recordset. I can have the pictures converted to any usable
format, use OLE or linking, whatever needs to be done.

So far, the 3 possible solutions I have found are:

1) OLE objects - if you don't have bitmaps associated just perfect, a
tiny thumbnail with the filename appears instead of the full image.
This may be something to do with the OLE type being stored as
"Package" rather than "Bitmap image". I couldn't figure out how to
store as "Bitmap Image", even if I did: Me.Picture1.Class =
"Paint.Picture".

2) ActiveX image control - so far, I have found a few ActiveX image
controls, however, ActiveX controls can't be used with continuous
forms.

3) ActiveX grid/list control - I couldn't find a simple datagrid or
datalist component that would simply display the picture and a few
columns. This seems like the most logical way.

Putting a command button with "click to view image" isn't really an
option because we need to be able to see multiple pictures at a time.

I know that Access 2007 is supposed to make this easier, however, it
isn't an option since no runtimes will be released until at least
June.

Has anyone successfully found a workaround to this problem?

Thanks

.



Relevant Pages

  • Re: Can I load a picture form an URL into a Picturebox?
    ... :>> control is based on IE, ... I am telling the control what to display, ... Only if they know it's a web browser control, ... :>the picture data and load it into the picture box from there, ...
    (microsoft.public.vb.general.discussion)
  • RE: Doubt in SOAP with DIME attachments!
    ... When you consider that display of a particular file types requires the ... appropriate display target (e.g. a picture box for a picture, ... Then to launch the right viewer, ... If you have a control that is compatible with the data you received in the ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Re: BMP image in forms
    ... I'm afraid that changing directions on how I display pictures is going to ... Control Access", etc.). ... Sylvain Lafontaine, ing. ... You can then use the Picture control to display ...
    (microsoft.public.access.forms)
  • Re: Runtime problem: Picture control useless without "Converters & Filters" from Offic
    ... > graphics filters. ... In that application 'picture' control is ... to having this orginal 'picture' control get 'hacked' ... >>nor BMPs to display the images. ...
    (microsoft.public.access.devtoolkits)
  • Re: Displaying images in continuous forms
    ... ActiveX image control - so far, I have found a few ActiveX image ... controls, however, ActiveX controls can't be used with continuous ... datalist component that would simply display the picture and a few ...
    (comp.databases.ms-access)