Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / September 2007

Tip: Looking for answers? Try searching our database.

Personal Collections Database

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
John Cripps - 21 Sep 2007 12:28 GMT
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
Signature

John Cripps

Arvin Meyer [MVP] - 21 Sep 2007 13:09 GMT
You may be able to adapt one of these templates:

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

Signature

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

> Does anyone know where I might obtain a (free) database template for a
> personal collection?
[quoted text clipped - 4 lines]
> Would be grateful for any help for a fairly-new and inexperienced user.
> Thanks
John Cripps - 21 Sep 2007 13:42 GMT
Thanks Arvin.

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

I am using Access 2003.

John

Signature

John Cripps

> You may be able to adapt one of these templates:
>
[quoted text clipped - 8 lines]
> > Would be grateful for any help for a fairly-new and inexperienced user.
> > Thanks
Arvin Meyer [MVP] - 21 Sep 2007 14:33 GMT
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/

Signature

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

> Thanks Arvin.
>
[quoted text clipped - 18 lines]
>> > Would be grateful for any help for a fairly-new and inexperienced user.
>> > Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.