Ideas / templates.. Please help!!

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

Guest

I need to make some kind of database for keeping track of safety gear and
tools given to employees. Does anyone know where to find a template like
this? I've tried to figure out how to build a database from scratch, and I
can't make one for the life of me! I need something that has a page for each
employee, with an area where I can fill in safety gear given to them on a
daily basis.

Thanks in advance!
 
You need the following tables:
TblEmployee
EmployeeID
EmployeeFirstName
EmployeeLastName

TblSafetyEquipment
SafetyEquipmentID
SafetyEquipmantName

TblSafetyEquipmentLog
SafetyEquipmentLogID
EmployeeID
SafetyEquipmentID
DateToEmployee
DateReturned


PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Now once I have made these Tables, how do I make it so that I can enter
multiple records for each employee? I want it to look up an employee by name,
and then list all tools/ gear given to each person, and so that I can add to
it daily...

(sorry I have never worked with access before! And I need to make a system
as soon as possible!)

Thanks!
 
You need a form to enter employees into TblEmployee and then be able to look
up employees. You need a form to enter safety equipment into
TblSafetyEquipment. You need a subform based on TblSafetyEquipmentLog on
your employee form to be able to select a safety equipment item, enter when
it was assigned to an employee and later enter when it was returned.

Since you have never worked with Access before, you probably do not have a
clue as to what I am talking about. I can set this up for you for a very
reasonable fee and can have it to you quickly. Contact me if you want my
help.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Now once I have made these Tables, how do I make it so that I can enter
multiple records for each employee? I want it to look up an employee by name,
and then list all tools/ gear given to each person, and so that I can add to
it daily...
Click to expand...

Create a Form based on TblEmployee. Use the Toolbox "Subform" tool - with the
magic wand icon on the toolbox selected - to create a Subform based on
TblSafetyEquipmentLog. This subform would have a Combo Box bound to
SafetyEquipmentID, based on TblSafetyEquipment. Again the toolbox wizard can
help you set this up.

This Form is very much like the Orders form in the Northwind sample database -
with tblEmployee playing the role of Orders, tblSafetyEquipment the role of
Products, and tblSafetyEquipmentLog the role of OrderDetails. You might want
to see how it was done in this form.

Steve's advice is accurate, but his soliciting of paid business goes against
the traditions of this newsgroup. Take his invitation if you wish - but what
you're asking to do is pretty simple to do yourself, and you should not need
to pay for it.

John W. Vinson [MVP]
 
Steve: For the past few weeks it looked like you had learned the erros of
your ways, but it appears you were only testing the waters.

These newsgroups are not provided for you to prey on unsuspecting victims.
So, can you please go away for another year.

John... Visio MVP
 
Back
Top