I am working on a "Toners Bought and Sold" database with a "Box" field keeping track if the toner was bought either normally packaged ('Closed' box), in an open box ('Open' box) or without a box ('No' box).
I have 3 BMP files saved on my computer, 1- a closed box, 2- an open box, 3- a big X standing for 'No box'.
I want to have a field in my form to display an icon in each record, depending on the contents in the "Box" field.
My question is how do I handle images in Access?
Can I put the pictures in a Table as OleObject field and retrieve them from there? (the 'Lookup' part I'm ok with)
Should I create a certain Module?
Please help.
I have 3 BMP files saved on my computer, 1- a closed box, 2- an open box, 3- a big X standing for 'No box'.
I want to have a field in my form to display an icon in each record, depending on the contents in the "Box" field.
My question is how do I handle images in Access?
Can I put the pictures in a Table as OleObject field and retrieve them from there? (the 'Lookup' part I'm ok with)
Should I create a certain Module?
Please help.