Displaying images in continuous forms
- From: blueheelers@xxxxxxxxx
- Date: 14 Apr 2007 11:00:12 -0700
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
.
- Follow-Ups:
- Re: Displaying images in continuous forms
- From: John Mishefske
- Re: Displaying images in continuous forms
- Prev by Date: Re: Sorting Help
- Next by Date: Re: Unhandled errors; public vars/classes lose scope??
- Previous by thread: Unhandled errors; public vars/classes lose scope??
- Next by thread: Re: Displaying images in continuous forms
- Index(es):
Relevant Pages
|