Search results

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.

Hello All, I've created a query that includes a date field (the field is formatted in the table as date/time). The idea is when the query is run it will only pull records that are 7 days before the current day, e.g., if the query is run on the 12th, it will only show records between the 12th...

Figured it out.... varCC = Nz(DLookup("Fmgr", "tbl_fmgr", ststate), "") should be varCC = Nz(DLookup("Fmgr", "tbl_fmgr", State), "") thanks for your help

I think I found out the issue, the error occurs on this line: Nz(DLookup("Fmgr", "tbl_fmgr", ststate), "") I tested it by itself and it failed. I tested the other one and it worked fine. So I need to look at the above code and see if it's correct

I've inserted the code and still recieve the error. Here's the code (with your suggestion) msg = "Are you sure you want to close the request?" button = vbYesNo + vbDefaultButton2 title = "Close Request" response = MsgBox(msg, button, title) If response = vbYes Then...

The & didn't work. What I'm trying to do is pull email addresses from two tables based on criteria in the form. In tbl_approver, there are addresses based on client names and in tbl_mgr, there are addresses based on state. The prevailing idea is to pull the appropriate email address from...