I need help!!!

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

Guest

I am trying to create a form or something similar to display employee
information with a picture. I am just started using Access and don't have a
lot of experience with it. If there is anyone out there that could help me
out I would really appreciate it. I have a form designed and information
entered into an Access database.
 
The easiest that I have found is build a master form with the employee
information in it including a AutoNumber, BadgeNumber, or Personal ID number
for each employee.
Use a separate EMPLOYEE Table

Build a separate form (SubForm) and place the number in it
Use a separate EMP_PHOTO Table here

Scan in photos as JPEG and place in this table asigning each the same number
as that on the employee table.

Now open the Employee table and SELECT SUBFORM and select the EMP_PHOTO
form. It will ask if you want to find a specific records reply with yes and
select the two numbers that are suppose to match.

This will allow you to scroll through the Employee records and see the
photos for each.

GOOD LUCK

Dwight
 
The Northwinds database that comes with Access has a form exactly like you
want. Have you looked at the Northwinds sample?

Rick B
 
Back
Top