Personal Collections Database

[Guest]

Does anyone know where I might obtain a (free) database template for a
personal collection?

I need to be able to include several photographs of eah item and include
those photos in a report (one page per item).

Would be grateful for any help for a fairly-new and inexperienced user.
Thanks

 

[Arvin Meyer [MVP]]

You may be able to adapt one of these templates:

http://office.microsoft.com/en-us/templates/CT101426031033.aspx

 

[Guest]

Thanks Arvin.

I have already looked at these and cannot find one which includes photographs.

I am using Access 2003.

John

 

[Arvin Meyer [MVP]]

The Northwind sample database which comes with Access includes photographs.
It doesn't do multiples though. I think what you need, you won't find in a
template. You are going to have to adapt a number of different techniques to
your requirements.

First, you cannot use a single form to display your photos, since you need
multiples. I suggest that you use a subform, and store the path to a Photo
CD or a place on a hard dribe where the photos shall reside, rather than
trying to store them directly in the database, otherwise the database will
bloat very quickly and you will be unhappy.

If you store the paths in a subform, you can use a bit of code like:

Private Sub Form_Current()
Me.Parent.imgControlName.Picture = Me.txtPicturePath
End Sub

and as you scroll through the subform's records, the images will display in
an image control on the main form.

I also suggest that you use one of the tutorials to get some experience
because you will need to understand some database techniques before you go
much farther.

http://www.functionx.com/access/


--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com