how to include multiple bound pictures on a form using image contr

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am createing an Access web product database that will store product photos.
I have created a table with the path to the images. Each record will have
at least 4 images. I can display one image on a form using the image control
and with the following vb:

Private Sub img_thumbnail_AfterUpdate()
On Error Resume Next
Me![img_thumb].Picture = Me![img_thumbnail]
End Sub

Private Sub Form_Current()
On Error Resume Next
Me![img_thumb].Picture = Me![img_thumbnail]
End Sub

My problem, however, is that I have mutliple images (and paths) per record
in this table to display on a form and I don't know how to do this. I've
tried creating a new image control on the form and replicating the above vb
but that gives me all sorts of crazy errors.
any ideas or help much appreciated!
 
Dump the image controls, and add OLE Object fields to your table. Then
display the OLE Objects on your form, just like you would a textbox.
 
That is what I had originally...OLE Object fields but changed it for a
variety of reasons (i.e. lg database size, problems streaming images to web
pages etc).

Is it very complicated to add multiple images on a form with an Image control?
My end goal is to send recordsets to a product web page (using ColdFusionMX).

Thanks,
Toby

ManningFan said:
Dump the image controls, and add OLE Object fields to your table. Then
display the OLE Objects on your form, just like you would a textbox.

I am createing an Access web product database that will store product photos.
I have created a table with the path to the images. Each record will have
at least 4 images. I can display one image on a form using the image control
and with the following vb:

Private Sub img_thumbnail_AfterUpdate()
On Error Resume Next
Me![img_thumb].Picture = Me![img_thumbnail]
End Sub

Private Sub Form_Current()
On Error Resume Next
Me![img_thumb].Picture = Me![img_thumbnail]
End Sub

My problem, however, is that I have mutliple images (and paths) per record
in this table to display on a form and I don't know how to do this. I've
tried creating a new image control on the form and replicating the above vb
but that gives me all sorts of crazy errors.
any ideas or help much appreciated!
Click to expand...
Click to expand...
 
Back
Top