Membership directory WITH PHOTOS

  • Thread starter Thread starter John Havel
  • Start date Start date
J

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.
 
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.
 
John Havel said:
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.
Click to expand...

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
 
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
 
Back
Top