Need help building a form

[Cesar333]

Hello all. Very new here and I would like some guidance on building a form for my company's employee equipment sign-out sheets. What I am looking to do is put barcode labels on pieces of equipment that an employee will use on a daily basis and also on their company badges. The employee would have to scan their badge and then scan the tool that they would to use. The form would date/time stamp they check out of the equipment. It also has to block anyone else from checking in/out tool.

I already have the barcode fonts for access and the scanning gun. I assume i would have to create 2 different tables? 1-employees, 2-equipment?

At the end of all this i would like to have a report built for the entire shift.



Any help would be greatly appreciated.

[CJ_London]

You would need 3 tables

tblEmployees
EmployeePK autonumber
EmployeeBarCode number/text depending on code - use your barcode font on this field to generate your barcode labels
EmployeeName text
...
...

tblEquipment
EquipmentPK autonumber
EquipmentBarCode number/text depending on code - use your barcode font on this field to generate your barcode labels
EquipmentName text
...
...

tblIssues
IssuePK autonumber
EmployeeFK long
EquipmentFK long
Issued Boolean - yes means issued out, No means returned
IssueDT datetime - default=now()

barcode readers are just like any input device and they can be configured to issue a carriage return when triggered to automatically go to the next control. Your form would be based on the tblIssues table and you will need vba code to 'translate' the read barcode to the appropriate PK.

You could use the barcode as a PK instead of autonumber, but I don't recommend it since it might get reused.