Recent content by forms_are_nightmares

Hope this is easy and I'm just overlooking the obvious. Scenario: I have one form that two groups of users use. One group edits the form; the other won't. Rather than writing code to disable all the controls, boxes...etc. on the form, I was hoping there was a way to "lock" the form when...

Hello All, Looking for some help. Scenario: User selects multiple values from a list box, selects a value from an unbound combo box and clicks submit. I would like to write the values selected from the list box into the table. The below code works for everything but the values selected...

Will do. Thanks again.

Thank YOU very very much. That did the trick. I really appreciate your help and patience.

When I move my cursor over the yellow highlighted Me.filter = strWhere, this is what it reads...see attached

vbaInet: Yes, when I go to the code when the error occurs, the Me.filter = strWhere is highlighted. I inserted the vbNullString, nothing happens with the filter. gemma: Adate is date/time, short format. Users enter the date via a calendar box that they click and select the date. I will...

No, I just verified. Somehow the code is trying to assign a value rather than filter the value. I keep playing with the code but for some reason can't get it right.

Thanks for the reply. However it didn't work. I still get the error. When I debug, the code fails on the Me.Filter = sWhere part of the code.

Hello All, I know exactly where the code is failing but for some reason, I can't figure out the code. Scenario: I have filters on a form that will allow a user to find specific records. All filters work with the exception of the combo boxes that specify a date range. All combo boxes are...

Hello All, I'm hoping this is just an easy fix.... I found a thread that helped me put the code together to export my query into Excel. When I click the button, I receive a subscript out of range error. The sheet then opens but nothing has been imported. Any help would be greatly...

Hello. I've been searching through the threads and couldn't find anything related to my problem. Maybe I'm using the wrong search/key words? If someone knows of a thread, direct me to that as I do not want someone to duplicate work. What I would like to be able to do is update multiple...

Bob, Sorry, I was playing around with the code and didn't send the correct version: SELECT tbl_priority_sheet.PSpecialist, Count(tbl_store_WO.WO) AS CountOfWO, tbl_store_WO.CDate FROM tbl_priority_sheet INNER JOIN tbl_store_WO ON tbl_priority_sheet.ID = tbl_store_WO.ID WHERE...

SELECT tbl_priority_sheet.PSpecialist, Count(tbl_store_WO.WO) AS CountOfWO, tbl_store_WO.CDate FROM tbl_priority_sheet INNER JOIN tbl_store_WO ON tbl_priority_sheet.ID = tbl_store_WO.ID WHERE (((tbl_priority_sheet.Approve)=Yes)) GROUP BY tbl_priority_sheet.PSpecialist, tbl_store_WO.CDate HAVING...

Thanks for the clarification. However, it still won't produce any records, even though I know there should be some. Any ideas as to what is causing the issue?

Thanks JR for the quick response. It still comes up with no records. I'm not sure what the purpose of the Between statement is, though it may be that i'm not familiar enough with access.