Search results for query: *

I created a string filter in a private sub and I get an error; "Can't find the field referred to in your expression" I have used this same expression in a Public sub and it works fine. What do I need to do differently to get it to work in the Private sub? strFILTER =...

I am asked to modify a form & report to allow for the selection of a client. There are functions already built in this already huge form so I would like to use what is already there. I am getting errors telling me that the report isn't opened or is misspelled. This error occurs on the Filter. I...

I created a listbox on a form that is set so that you can select multiple items. The rowsourcetype is a table and I have the first column bound, but hidden. I can't select anything from this listbox. No errors, I just can't choose. What am I missing? Thanks.

Amateuar needs to know, Is this thes best way to do this? I have created a report where I want the user to determine the criteria (without using parameters in a query). I have a form that lists reports, I will add this one here, but I wanted to add a pop-form that lets the user select...

I want to populate a field in a table from a field on my form but I want to add to the data, is that posible? For example, the BillNo on my form reads: 2000031039134MAP, I want it to populate with: 2000031039134MAPR. I tried the following but neither one of them worked. Any help would be...

I have a form/subform. After I update data (pay bills) in the subform I want to requery that subform. The subform only looks at unpaid bills. I do this by checking all bills I want to pay, then I hit a command button on the main form. This command hits the appropriate tables and pays bills. I...

Does this error generally indicate a particular problem? I am trying to debug and so far I haven't found my problem. I have a form/suform issue. In the main form I am calling on a calculated field in the subform. I have this exact situation working in another area so I can't figure out why this...

I needed to change an existing sub-form that was updateable b/c the wrong fields were selected. Since then I can't update my record. The SQL code I used is: Forms![frmHUBPayments]![frmBILLSDuesub_OLD].Form.RecordSource = "SELECT tblBillHeaders.HeaderID, tblBillHeaders.ClientID...