Picture of each item of Inventory

[hfsitumo2001]

Hello, I tried to have a picture in my supplies inventory list. I was using the wizard to make a report. When I see on the report view nothing on the attachement column, anyone can give me the clue how to make it ?

 

[Ranman256]

instead of Attachment, the pictures need to be in OLE field. Then they can show in a report.
but that fills up your db fast.
Tho an additional external db to hold only the photos in a table could save space.

but someone may have a way to extract the attachment to display on the report. I don't know any.

 

[hfsitumo2001]

ok, it works for me now. The control source should be attachment not one of the 3 subname of the attachment

 

[June7]

Embedding objects in db uses up Access 2GB size limit. If there is any chance of hitting this limit, leave attachments external and just save a path to text field. Can still use Image control to load images by referencing path.

 

[The_Doc_Man]

Long-term, your best bet is to set aside a folder where you keep pictures for this purpose. Then on any form that needs the picture, in that form's OnCurrent event, load the fully qualified path/name of the picture file to the image control's .Picture property. You MIGHT wish to play with some of the other image properties so you can get it properly sized, centered in the control, etc.

EDIT: June7's comments are spot-on. Keep the pix external but where your app can find them. Trust me (and June7): You save lots of headaches by keeping the picture files external.

 

[hfsitumo2001]

instead of Attachment, the pictures need to be in OLE field. Then they can show in a report.
but that fills up your db fast.
Tho an additional external db to hold only the photos in a table could save space.

but someone may have a way to extract the attachment to display on the report. I don't know any.

I do not understand what is the different between attachment and Ole field, because actually all the pictures are all in one folder, and the attachment field takes it from the picture folder. This is for MS Access 2016. So I think the system is work is like what you meant, because the attachment has 3 sub fields which is: Attachment data, Attachment file name and attachment file type.

Thank you

 

[June7]

I have never used OLEObject type field and controls for dynamic display of images. Never had good look with, can't seem to make them work. If images are all in one folder, why are you bothering to embed in db? Once image is embedded, folder is irrelevant.

 

[The_Doc_Man]

I'm with June7 here. If you have the file in a folder and in a usable image format, all you need is the "fully qualified file specification" - with a device letter, as dev:\path\name.type or as UNC, \\systemname\sharename\rest-of-path\name.type, in a simple text field. OLE interactions never enter into the equation and you will not fill up the DB file to its 2 GB limit with file specs that rarely exceed 128 bytes, even if you have hi-res photos.

 

[hfsitumo2001]

I'm with June7 here. If you have the file in a folder and in a usable image format, all you need is the "fully qualified file specification" - with a device letter, as dev:\path\name.type or as UNC, \\systemname\sharename\rest-of-path\name.type, in a simple text field. OLE interactions never enter into the equation and you will not fill up the DB file to its 2 GB limit with file specs that rarely exceed 128 bytes, even if you have hi-res photos.

When I use file attachment now like the sample in the MS Office sample. How can I see that how many GB that I am using now, because when I see my database itself with window explorer it is only 51MB and Pictures on the picture folder is 54MB. Can anyone tell me how it can overpass the 2GB access limit?

 

[June7]

Maybe never will. If you don't think db will grow that big then by all means, embed images. Just be aware if it does hit limit, removing images and replacing with a text field will be a pain.