Using Photos as Selection

[ferrisj]

In an earlier post I explained I was doing an inventory for my work place. we have 4 models of computers in our office. I would like to be able to track which model each person is using. I have create a table will two fields one is the record and the other is an OLE field with a picture of each model stored. I am having trouble thinking about the form. I would basically like the photos to work as a drop down box, but i understand why that will not work. Can anyone else think of a way I could all the people to use which picture of the computer they are Inventorying?

 

[Remou]

I hope use are using Access 2007, otherwise your database is likely to get very large very quickly.

I think the best bet would be a pop-up form that shows pictures of each model and allows the user to select the picture, the main table can then be updated with the unique ID for that model.

 

[MajP]

You could do this with a listview control but those are not the easiest controls to use. But you could simply use a subform that is formatted to look like a listbox. Get rid of the navigation buttons, min max buttons, etc. If you only have a couple of pictures then you are OK but as Remou points out Acces will bloat quickly. However, I assume that when you click in the subform picture you will save the computer ID to the inventory table. DO NOT COPY THE PICTURE MULTIPLE TIMES. You only show the picture on a form or report through a query. So your tables should be something like

tblComputers (information about computers)
computerID_PK
computerName
computerModel
oleCompPicture (the picture)
(other COmputer fields)

tblPeople
intPersonID_PK
strFirstName
strLastName
(other people field)

juncTblInventory
intPersonID_fk
intComputerID_fk

So I pull a name down from a combobox and populate my personID_fk. Then I click on a picture and save the ID of the computer.

For a form or report I then link tblPeople and tblComputers to junction table juncTblInventory.