putting picture in my inventory item input form (1 Viewer)

[hfsitumo2001]

I tried to put picture of item in the form of my inventory. My question, will it make slower movement of form if we want to browse?. My number of item is just 125 items. The method is like the sample of the inventory sample from MS Access, there is a field in the table for the attachement, but we can put the picture in the subfolder of where the database is

 

[The_Doc_Man]

Putting actual pictures in a database is possible (embed via OLE) but it is more efficient if you just put all of your pictures in a single folder either where the database is or in a sub-folder thereof. Then include the fully qualified device/folder/name.type of the file as a text field. When the form is navigated, have something in the Form_Current routine load the text field contents to the .Picture property.

Include a Bound Image on your Microsoft Access forms | Database Solutions for Microsoft Access | databasedev.co.uk

Database Solutions for Microsoft Access: How to include a bound picture on form - While it's possible to actually store the images within the Microsoft Access database itself as OLE objects, normally it's not the preferred way. When you embed an OLE object in a table, you're storing a lot of...

www.databasedev.co.uk

 

[hfsitumo2001]

Putting actual pictures in a database is possible (embed via OLE) but it is more efficient if you just put all of your pictures in a single folder either where the database is or in a sub-folder thereof. Then include the fully qualified device/folder/name.type of the file as a text field. When the form is navigated, have something in the Form_Current routine load the text field contents to the .Picture property.

Include a Bound Image on your Microsoft Access forms | Database Solutions for Microsoft Access | databasedev.co.uk

Database Solutions for Microsoft Access: How to include a bound picture on form - While it's possible to actually store the images within the Microsoft Access database itself as OLE objects, normally it's not the preferred way. When you embed an OLE object in a table, you're storing a lot of...

www.databasedev.co.uk

DoC-Man, the inventory sample of MS Access has a column for attachment and when I make form and add field attachments, I put all the pictures in a folder too. Is it not the same as you said?

 

[The_Doc_Man]

I haven't looked at that sample but it sounds similar. All you need is the file specification to load to the .Picture property of the image control, which would most conveniently be done in the Form_Current event.

 

[hfsitumo2001]

I haven't looked at that sample but it sounds similar. All you need is the file specification to load to the .Picture property of the image control, which would most conveniently be done in the Form_Current event.

I do not see any procedure of the current event of the control source, the control source of the frame image is just saying "Attachment", and when we hover our mouse on the frame, there is a tip that says " double click to add picture or edit" and then it will guide us to do it by popping up this box: