Well, I thought I finish my Access database, but now someone wants to expand on it. The database is an Employees database for HS and now they think it would be prefect if an attendence calender or database to keep track of each employees attendence and link it, with EmployeeNumber, to my database. First of all, is this even possible, without having extensive C programing? If so, any ideas for a starting point? They are currently using a preprinted card with all of the dates of the year on it and then they write in the hours that each employee worked for each day of the week, with one card for each employee. I have Access 2000, professional Edition, to build this with.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Is this Even Possible in Access???? 1
- Thread starter quest4
- Start date
-
1
- #2
I don't see why not. I'd add a table to the existing database called tblAttendance and create a relationship with the main table on EmployeeID. I'd also add fields for Date, Hours (or TimeIn DateTime and TimeOut), Code (ie. Sick, Reg, Comp, Vac....) and maybe a Verified field if there is a verification process.
Each Employee can have upto 365 records in a year (most years). So, this is a table that should be archived regularly. Like every two years or so.
If you had to you could create another project and link it to your old database. If your using DAO set you workspace to the old database. With ADO use a connection object.
Each Employee can have upto 365 records in a year (most years). So, this is a table that should be archived regularly. Like every two years or so.
If you had to you could create another project and link it to your old database. If your using DAO set you workspace to the old database. With ADO use a connection object.
- Thread starter
- #3
I've set up a day and time database that tracks when employees come to work by said employees choosing their name and clicking in, then clicking out when they leave. Works great! However, we track about 50 employees meeting with about 600 students on an hourly basis. I take time sheets and attendance for students from this database. Follow the previous answer and you've got it made.
- Status
