Membership directory WITH PHOTOS


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.
 
Ad

Advertisements

G

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.
 
A

Arvin Meyer

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.

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
 
Ad

Advertisements

L

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top