Membership Roster with Picture

N

nbslarson

I am a rank beginning and I need to create a roster of our volunteers,
including their picture.

I have the table set up and the form, but I'm having a great deal of
difficulty inserting the pictures.

Can you please offer some guidance?
 
S

Steve

First, store the pictures in a separate folder. Your table should have a
field (text data type) to store the complete path to the picture of each
volunteer.

To display the picture on a form, add an image control from the toolbox. An
image control has a Picture property. Set the Picture property to the field
in your table that contains the path to the picture of each volunteer.

Look at the Northwind sample database on your computer. Northwind has a form
that does this.

Steve
(e-mail address removed)
 
N

nbslarson

Thank you for answering, Steve, but I must be doing something wrong. I have
the path information stored on the table for the volunteer information. All
pictures are stored on my C drive in a folder named Volunteers.

The table is set to
Field Name-Picture
Date Type - Text

The form has a box on it with the name picture, control source picture
(relating back to the table).

When I tried to add an image fro the toolbox, the software kept asking me to
select a particular file.

Can you please assist me once again?!
 
S

Steve

Try this ........

1. Change the field name in your table to Photo.
2. Add an image control to your form. When it asks you to select a file,
just click OK.
3. Select the image control and open properties. Go to the Format tab and
delete anyyhing in the Picture property. Go to the Other tab abd set the
Name to VolunteerPhoto.
4. Add a textbox to your form. Set its Name to Photo. Set it's Control
Source to Photo.
5. Put the following code in the form's Current event:
Me!VolunteerPhoto.picture = Me!Photo

It should look like:
Private Sub Form_Current()
Me!VolunteerPhoto.picture = Me!Photo
End Sub

Steve
 

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