Display Image

[Guest]

I have a table of about 2057 rows. Of these rows there are about 457 unique
vendors. I would like to have a form based off of a query of this table that
will display the vendor's logo on top. So as the form is up different vendors
will have different Logos

I was playing with the OLE Object as a field in the table, but it doesn't
seem to be working.

Is there a way I can do this?

Thanks,
Jessie

 

[Guest]

You can do this programmatically, or with the OLE Object data type. Using the
OLE data type is simpler and equally effective. Create a field in the table
with the OLE data type. Save and close the table. Open the form in
design-time mode. Drag-and-drop the field onto the form from the list of
fields pane, or select the picture-box or image control with the wizard
option turned 'on'. To associate pictures to a record, in runtime, right
click on the image control.

 

[Guest]

I have the field there and dragged it to the form, but when I add the picture
it just displays the file name instead of the picture.

what am I doing wrong?