displaying images...

[azlina]

hi...i'm lina..

erm...actually,i need some help from you all...i have make a database
for the 38000 images..but the problem is..the data and the images is
separate into different table(PhotoA,PhotoB,PhotoC)
i have try to combine it into the Query(Query1)..but when i combine
it..the images cannot be display..its only show the path..if you open
form frmmain...and choose one from the tables
there(PhotoA,PhotoB,PhotoC),and click to view the images...it will
display all the images in the table...

this database is just linking the images only, it just storing the
path...coz when i stored the images...its over the limitation for
access..but this database cannot display the images and the path
together...i have the file using turboupload...coz the size for the
file is big...this is the link for the file
http://d.turboupload.com/d/1024649/Copy_of_PortPass.zip.html



i hope you can help me...

Regards

 

[Joseph Meehan]

Normally it is not recommended to store images in Access. Images really
bloat the size of the file. It is better to store a link to the images.

I am also curious about using different tables. Why do you have all
those tables?

 

[Larry Linson]

erm...actually,i need some help from you all...i have make a database
for the 38000 images..but the problem is..the data and the images is
separate into different table(PhotoA,PhotoB,PhotoC)
i have try to combine it into the Query(Query1)..but when i combine
it..the images cannot be display..its only show the path..if you open
form frmmain...and choose one from the tables
there(PhotoA,PhotoB,PhotoC),and click to view the images...it will
display all the images in the table...

this database is just linking the images only, it just storing the
path...coz when i stored the images...its over the limitation for
access..but this database cannot display the images and the path
together...i have the file using turboupload...coz the size for the
file is big...this is the link for the file
http://d.turboupload.com/d/1024649/Copy_of_PortPass.zip.html

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

 

[azlina]

helo Joseph Meehan....thanks for the reply...i have store the
link...but now the problem is...i cannot arrange the picture based on
number of the employee for my company...the images have their own
number like A10.bmp,A2.bmp...and the employee also has the number like
10,2 based on their images...but now when i store the link only...it
just retrieve the images when we view it...and that make they cannot be
arrange referring to the number...this is the link to download my
project..i hope you can have a look on it...and give me some idea...the
table that i want to combine with the picture form is..Cardholder table
and the form is frmPicture...can you have a look to the
coding??http://d.turboupload.com/d/1024649/Copy_of_PortPass.zip.html....plz
help me..

Regards..