Needing Direction

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brad - 13 Jul 2005 16:56 GMT

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.

Reply to this Message

Brian - 14 Jul 2005 20:41 GMT

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

> 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
[quoted text clipped - 7 lines]
> 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.

Reply to this Message