Assigning a different graphic to each access record

G

Guest

My database records information about various planning
applications and I would like to include a photograph of
each individual building relevant to that record ie. the
report needs to pick up the file for that picture from
somewhere else.

I have worked out how to embed a picture on the report,
and how to show the SAME graphic on each record but a
DIFFERENT picture seems to be eluding me!

Has anyone worked out how to do this - would appreciate
your comments. Thanks for your help.
 
M

[MVP] S.Clark

Bound Object Frame.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
E

Exponent

There are a variety of ways to handle images in Access, each with different pros and cons depending on your
specific requirements. Here are the main approaches:

* OLE Embedding (Bound OLE Frame)
Usually causes a massive storage overhead (5 to 100 *times* for jpeg images). Reliant on a very specific
system configuration (external application and file registrations) which can be a particular problem when
installing and maintaining systems with multiple users. Images are usually stored uncompressed and wrapped
in proprietary headers, so it can be impossible to extract the original data and difficult to interoperate
(e.g. with VB, asp, IE etc).

* OLE Linking (Bound OLE Frame)
Usually causes a massive storage overhead (5 to 100 *times* for jpeg images, even though 'linked'). Reliant
on a very specific system configuration (external application and file registrations) which can be a particular
problem when installing and maintaining systems with multiple users.

* 'Linking' or 'Embedding' with the Access Image Control
Relies on the relevant office graphics filters. Needs workarounds for image control problems, including
'scroll-too-quick crash, suppress 'Image Loading' dialog. More coding required, particularly if 'Embedding'
(extracting images to temporary files for display).

* Finally, you could consider using a 3rd party control, such as our own, designed to overcome these and
other problems, and to provide enhanced functionality, such as EXIF info, lossless jpeg rotation, zoom/pan/scroll,
resampling & thumbnailing, built-in file browsing and much more. See sig below for more info.
 
Top