Lyndon,
Here are a couple of comments:
1) It is advisable not to put lookups into tables
2) OLE objects are bitmaps and bloat your database
3) You can use Attachments but it is far more effiecient to referential access images
The database I;m upload is a tenth of the originals size.
I have attached the images for RecordID 2 and 9. I have named them 2.jpg and 9.jpg
The Rolls Royce image is aslo attached. The Rolls Royce Images will need to attached. Properties Picture.
You will need to change the GetPictureDir back to your Path.
Naming conventions particular ID have been changed.
Functions have been created rather than Subs for the Image handling.
The ImageFile Control will show an error until the 3rd Combi-box has been updated.
Simon
Here are a couple of comments:
1) It is advisable not to put lookups into tables
2) OLE objects are bitmaps and bloat your database
3) You can use Attachments but it is far more effiecient to referential access images
The database I;m upload is a tenth of the originals size.
I have attached the images for RecordID 2 and 9. I have named them 2.jpg and 9.jpg
The Rolls Royce image is aslo attached. The Rolls Royce Images will need to attached. Properties Picture.
You will need to change the GetPictureDir back to your Path.
Naming conventions particular ID have been changed.
Functions have been created rather than Subs for the Image handling.
The ImageFile Control will show an error until the 3rd Combi-box has been updated.
Simon