Image Field A2002

  • Thread starter Thread starter Bobby Baxter
  • Start date Start date
B

Bobby Baxter

Access 2002 WinXP Pro

I am building a database for my flowers, their characteristics, and images.

I want to have a thumbnail and larger image linked to each record. How do I
create the image fields and get the right pictures in there to match each
flower cultivar.

Thanks,
Bobby


--
Bobby Baxter
TheGardenSite.com

~~~~~~~~~~~~~~~~~~~~~~~~~~~
TheGardenSite.com: http://thegardensite.com
Daylily.Net: http://daylily.net
Happy Moose: http://happymoosegardens.com
Garden Discussion Forum: http://happymoose.com

Specializing in designing web sites for plant lovers!
 
hi,
In your table, in the flower's record,put the file path to
the picture.
then put an image control on your form.
to change the pic in the image control, change the image
control's Picture property to the new file path.
this can be done with dlookup
Me.Image1.Picture = DLookup("[filepath]", "table", "[id]
='" & Me.Text0 & "'")
where filepath is the file with the file path.
table is the table containing the file path.
id is the record id of the flower in the table.
me.text0 is the text box on your form that has the
id.

this can be done in a report too. see this site
http://www.microsoft-
accesssolutions.co.uk/bound_image_report.htm
 
Back
Top