Search results

I changed my two comboboxes to be cascading to fine tune what the user could select, but now the filter does not work. I have the EmployeeID and the date, but for some reason it always gives me the open form action was cancelled. It seems like the variables are correct, but the form won't...

Wow, that works slick. I am still trying to figure out all of the details how you accomplished this. Thanks for your help.:D

Here is a small sample of the database that is not working. I put this together to try some things, but I am still failing to get the second combobox to populate based on the first choice. I believe it could be something pretty simple so I post this in hopes that someone can point out how I am...

Thanks for the response. It still does not work. I get the employee values and I changed the other combobox value to TimecardDate instead of date. I am looking up the values from two separate tables (Employees and Timecard Dates)to pull into the timecard table where I give the timecard a...

That didn't seem to work for me. I choose the employee name, but the second combobox doesn't populate with the dates. It seems like it should work, but I must be missing something. Any other ideas? I am beating my head against the wall at this point.

I am still a bit lost. I used the code from a previous link on this forum, but I am not sure how to apply this to my table for my comboboxes. This is what I have. Private Sub cboEmployee_AfterUpdate() With Me![cboDate] If IsNull(Me!cboEmployee) Then .RowSource = "" Else .RowSource = "SELECT...

This seems like a pretty hot topic right now, but I am running into problems with this. I am trying to filter a timesheet using two listboxes. I must be doing something wrong. I have an timesheet table that pulls information from the employee table and date tablem to create the timesheet...

Still running into problems with this. Here is the database. Perhaps you will look at this and see the problem right away. Thanks for your assistance.

Okay, that helped me along. It seems I am getting all of the criteria loaded correctly into the variables now. When I run it I get a type mismatch for some reason and I am really not sure why. The form I am trying to open has two text fields, employee and date. The form opens with the...

I have the dates in a combobox. Basically I am trying to do both. I am loading it to a variable to use as criteria. Perhaps I am mistaken in trying to do it this way and I can simply use the combobox as a criteria? Anyway, I have two criteria. One is the user and the other is the date. I...

Thanks for the response. I have run into a bit of a problem. One of my listboxes for my criteria is a list of dates. I can't seem to get the date value out of the listbox. I guess it is actually a combobox if that makes a difference. How can I get the date value from the combobox? I have...

I looked through the forum and I am not finding an exact match to my problem. It seems simple enough, but I can't seem to sort it out. I am working on a timesheet program. On one form I have 2 listboxes. One has all of the employees, and the other contains dates the timecard needs to be...

Thanks, that got it. I looked at both of those settings on each of the forms, but I didn't change one of the settings so it wasn't working. Now it is. Thanks for the assist. Dave

I have placed a subform on my switchboard to show when a particular piece of equipment is needing calibration. The subform is a form based on a query. I have two columns that show out for repair or out for calibration and they have a checkbox to indicate the status. My thought was to be able...