Pictures

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I need know the best way to handle the following situation:

I have a table with student data including the student id. There is a
separate field for the first name and the last name.
I want to include another field for a student picture.
I assume linking the other pictures is better than embedding them in the
database.
The pictures are on a cd from the photo studio. Each picture has a file name
in the format of lastname_firstname.jpg.

I was going to rename the pictures using the student id, but that is a lot
of work.
Is there an easier way? I don't know the best way to link the correct
picture with the correct record. Also, the studio might have misspelled a few
names so I will probably have to know how to deal with that also.

Sincerely,

Rob
 
You need a text field in your Student table that stores the complete path to
the photo of each student. Once you have that, create an image control on
your student form to display the student picture. Look up the Picture
property of the image control in the Help file to see how to make it work.
 
"PC D" <[email protected]> schreef in bericht
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications 'Resource ????
Over 1175 users have come to me from the newsgroups requesting help '1175 users ????
(e-mail address removed)
Click to expand...

--
To Steve:
Why don't you just get lost? No-one wants your advertising/job hunting here!
Over 650!! users from the newsgroups have visited the website to read what kind of a 'resource' you are... (rapidly increasing..)

To the original poster:
Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html

Arno R
 
Back
Top