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...

Okay, I have figured out how to use the DLookup feature (thank you greatly for the direction on that!) and that part is working correct. When I run the following code now, the correct table opens up and it shows it is being filtered but no data in the date range specified shows up. Where...

I understand what you are saying and I had thought about doing a query to control the data easier but I could not edit the data from the query. I searched around looking for a reason as to why the query behaved this way and couldn't find a reason since I don't know the right terms to find the...

Okay, I have figured out how to use the DLookup feature (thank you greatly for the direction on that!) and that part is working correct. When I run the following code now, the correct table opens up and it shows it is being filtered but no data in the date range specified shows up. Where do I...

My ignorance shows my skill level, I apologize I didn't explain this further to start with. In the SEDates table there is two fields, StartDate and EndDate. There is only one record in the table that is changed as needed. I refer back to this set of dates many times during the bi-weekly use of...

I have never done something like this before. I presume by your comment I need to store the values from [SEDates].[StartDate] and [SEDates].[EndDate] in the VBA code and use them instead of a reference to the actual table? If that is the case, how do I get the values to be fetched from the...

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...

That is considerably better and it works like a charm! THANKS!!

When I run the code, I get a popup box that says Compile error: Syntax Error. when I click ok, I am taken to the code with Private Sub StartShiftAdd() in yellow and 'MsgBox ("Started Shift Add") CurrentDb.Execute "INSERT INTO Payroll (SchoolName, ShiftWeight, DefaultGuard, WorkingGuard...

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...

What I want to do is be able to enter a start date in a form (IE 9/30/2012) and have generated a table that would contain a listing of each shift in tbl_cg_shifts based off the yes/no checkboxes for Mon, Tue, Wed, Thurs, Fri being checked and that days date being correct. So if the first date is...

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...

I am kicking this around with my limited knowledge of access and I have a question: I have a table that lists shifts and a weighted value associated with it. Is it possible in another table (attendance days) that if a shift is selected from a lookup refernce, the weighted value can be...

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...