Needing Direction

[Brad]

I'm considering creating my first database in Access 2003 and I am still
learning how to use it. I would be taking inventory of my belongings in my
home for insurance purposes. I would need to include photos as well. I would
like to be able to export the database to html and saved to a CD rom so that
I can just mail it to my insurance company and all they have to do is open up
the html file and walla, they have a list of everything with images visible
in the form. I wouldn't mind that it could be search as well. Such as a drop
box on the form that you can change what field to search by and then the
empty box out to the side. Maybe someone already created this database? I
don't know. I did look around the MS templates website and didn't find
anything that matched what I was looking for. Any help is greatly appreciated.

 

[Brian]

Pretty broad strokes here, so just a couple of pointers. To store pictures,
set the data type of the field in the table to OLE object. On the form where
you want to link/display this, create a Bound Object Frame with ControlSource
of Object (let's call it Picture1).

Then create a button (let's call it ButtonPick) that will allow you to pick
the picture from its location and insert it into the field in the table:

Private Sub ButtonPick_Click
Picture1.SetFocus
DoCmd.RunCommand acCmdInsertObject
End Sub