Membership directory WITH PHOTOS

[John Havel]

We wish to create a simple church membership directory
with photos of individuals as part of the individual's
record. The photo should be viewable when the individuals
name and record is viewed (i.e.-right on that
same "screen" or "page" when it is pulled up). We ARE NOT
programmers, experts, or technogeeks. Is there a simple
way that simple folks can do this or do we need to go to
training and certification classes for six months to make
this happen Thank you for any guidance.

 

[George Hester]

You know walking is simple that's why most people can do it easily. A good place to start to do what you want is the sample Access Database Northwind. They have pictures in there to learn what is necessary.

 

[Arvin Meyer]

We wish to create a simple church membership directory
with photos of individuals as part of the individual's
record. The photo should be viewable when the individuals
name and record is viewed (i.e.-right on that
same "screen" or "page" when it is pulled up). We ARE NOT
programmers, experts, or technogeeks. Is there a simple
way that simple folks can do this or do we need to go to
training and certification classes for six months to make
this happen Thank you for any guidance.

You can put the photo directly in the database, but it will bloat it to the
extent that have a few dozen pictures, you will decide that there are better
ways. The better way is to use an image control, and load it in the form's
On Current event like:

Private Sub Form_Current()
Me![ImageFrame].Picture = Me![txtFilePath] & Me![txtFileName]
End Sub

where txtFilePath is the path to the file: "C\Foldername\"

and txtFileName is the file name "Preacher.jpg"

Have a look at the free picture manager database on my website for all the
code you'd need:

http://www.datastrat.com/Download/Picture2K.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Larry Linson]

It will require, at least, understanding some VBA, but you can't beat the
price of the example databases at http://accdevel.tripod.com, which
illustrate three approaches to handling images in Access forms, include an
article discussing which to choose, and even some very nice (if I do say so
myself) public domain views of the New Orleans area, late 1970s, in .JPG
file format, to use for testing.

Larry Linson
Microsoft Access MVP