Images in Access

[Woodies_46]

Ok I would just like to know if this is possible and if it is could
some one point me in the right direction.

What i would like to do is to have an access form which has a image
frame in it but no image, then I would like to have a subform linked to
a table that has the path names for these maps.

What I was thinking, is it possible for someone to click the name of
the map which is linkd to the path and have have the image show up in
the image frame so you can click through all the maps see which one u
want then print it out.

Sorrry if its a bit hard to understand..

Any help would be really good

Cheers

 

[TC]

Make form 'frmMain' with:
(1) An empty image frame, and
(2) A subform control.

Make form 'frmSub' with:
(1) recordsource = the table name,
(2) display mode (?) = "continuous forms". (I can't quite remember the
property name, & I don't have Access here to check. Just look for the
form level property whose values are "single form", "datasheet" or
"continuus forms".)

Then name frmSub in the subform control of frmMain. (Again, I can't
quite remember the property name, grr %$#@)

Now you have a main form with a blank image control, and a subform
listing all the records from the relevant table. That is the framework
on which you can build. Get to there, then ask again for how to go
further.

 

[Larry Linson]

Ok I would just like to know if this is possible
and if it is could some one point me in the right
direction.

It certainly is possible, and I later refer to where you can get not only a
"pointer in the right direction" but an example database illustrating three
approaches to handling images in Access. You might be able to use code for
one of those approaches as your "jumping off place" to get started.

What i would like to do is to have an access
form which has a image frame in it but no image,
then I would like to have a subform linked to
a table that has the path names for these maps.

I would consider using a ComboBox for showing / selecting the paths, instead
of a Subform Control. It just seems a somewhat simpler approach.

What I was thinking, is it possible for someone
to click the name of the map which is linkd to
the path and have have the image show up in
the image frame so you can click through all
the maps see which one u want then print
it out.

The sample imaging databases at http://accdevel.tripod.com illustrate three
approaches to handling images in Access, and the download includes an
article discussing considerations in choosing an approach. Two of the
approaches do not use OLE Objects and, thus, avoid the database bloat, and
some other problems, associated with images in OLE Objects.

If you are printing the images in reports, to avoid memory leakage, you
should also see MVP Stephen Lebans' http://www.lebans.com/printfailures.htm.
PrintFailure.zip is an Access97 MDB containing a report that fails during
the Access formatting process prior to being spooled to the Printer Driver.
This MDB also contains code showing how to convert the contents of the Image
control to a Bitmap file prior to printing. This helps alleviate the "Out of
Memory" error that can popup when printing image intensive reports.

Larry Linson
Microsoft Access MVP

 

[Woodies_46]

Thanks Guys.

Yeah I downloaded the sample database off http://accdevel.tripod.com
and had a look, it seems to do the job pretty well.

I was just wonering could you explain to me what the difference between
the three different types are, becuase when I use the BLOB and external
file way I can see the picture in the display but when I use the OLE
object way it just shows me the path. Just want to be sure which one is
safer to use.

Cheers