Search results

I have a table that has 12 fields and I want to create a form that has the table shown on the bottom and on the top, 3 comboboxes that I can use to filter the data in the table below. The three combo boxes would be DateWorked, WorkingGuard and SchoolName. In the table there are many similar...

What VBA code would I use if I wanted to open a table called 'Payroll' and filter the field 'DateWorked' using dates stored in another table [SEDates].[StartDate] and [SEDates].[EndDate]? I have tried the following: DoCmd.OpenTable "Payroll" DoCmd.SetFilter , [Payroll].[DateWorked] = "Between...

I have 3 values that are received from a form. They are bulk_add_name, bulk_add_weight and bulk_add_date. what I want to do is add an entry to the table called Payroll that puts bulk_add_name into field SchoolName, bulk_add_weight into ShiftWeight and bulk_add_weight to DateWorked. I also want...

To start off with, I am a newbie to access but I am learning so much fast and I am in need of some direction of what to research to make what I need to happen. Here is some background on what tables I have going: [tbl_cg_shifts] -ShiftID primary key -School lookup value from...

I have been trying to create a attendance/time-card database for my employees. Attached is what I have so far assembled. What I am curious about next is, what is the best direction to go. I want to be able to track on a two week basis if an employee worked daily all the locations they were...

26 crossing guards that can have up to 3 default scheduled shifts a given day. 6 crossing guards fill in as a substitute if a scheduled guard cannot work a given shift If a sub fills in I need to be able to remove the shift from the scheduled guard and log that shift to the subbing guard...