sldung
12-10-2001, 09:30 AM
Dear All,
I am currently developing a database system with Access 2000 and wonder if any one could help me with this issue.
Basically this system involves records with images (smaller image or Thumbnail) which need to be shown on a continuous form and a bigger image with the original size will be loaded from another application (IE in this case) by clicking the smaller image. At the moment these smaller images are stored as linked objects in an OLE Object field and displayed in the form using Bound Object Frame control. The links (file path) to bigger images, on the other hand, are stored as text, which can be loaded using shell function when the smaller image is clicked. However, this implementation is not ideal since Access cannot cope with too many images and it's impossible to upsize to SQL Server with those OLE linked objects when the database is getting too large.
I am looking for a way (or any ActiveX Control) which can be bound to a text field containing path to images and loads correct images accordingly when the path exists in a continuous form. I have tried Unbound Object Frame control, Image control and Web Browser control and none of them did this trick in a continuous form. Any tips will be greatly appreciated. Thank you for your help.
Shiang-Lung Dung
I am currently developing a database system with Access 2000 and wonder if any one could help me with this issue.
Basically this system involves records with images (smaller image or Thumbnail) which need to be shown on a continuous form and a bigger image with the original size will be loaded from another application (IE in this case) by clicking the smaller image. At the moment these smaller images are stored as linked objects in an OLE Object field and displayed in the form using Bound Object Frame control. The links (file path) to bigger images, on the other hand, are stored as text, which can be loaded using shell function when the smaller image is clicked. However, this implementation is not ideal since Access cannot cope with too many images and it's impossible to upsize to SQL Server with those OLE linked objects when the database is getting too large.
I am looking for a way (or any ActiveX Control) which can be bound to a text field containing path to images and loads correct images accordingly when the path exists in a continuous form. I have tried Unbound Object Frame control, Image control and Web Browser control and none of them did this trick in a continuous form. Any tips will be greatly appreciated. Thank you for your help.
Shiang-Lung Dung