Recent content by msreed

This same code(Select Case OPTCLIENT) works in another area but not here. I keep playing with how to direct my ClientID and so far nothing works. Select Case [optOwnerReports] Case 4 strRPT = "rptComprehensiveRevenueSummary_byClient" Select Case [optCLIENT] Case 1...

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

Hey Dan thanks for the response. I understand what you are are telling me, unfortunately when I changed to code the report ran, but for all clients. I'm going to keep your logic and try and tweak it some. Thanks. Missy

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

The trim function worked, thank you for your help!

Yes, the record added the R to the BillNo, but with a space in between the two. Is there a way I can get rid of that?

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 commented out both refresh and repaint. The code will now run but it still does not get rid of the record I just paid.

I changed myform as form to my form as subform, it liked that but now it gets hung-up on refresh. I'll see what I can do about that.

Run time error '13' type mismatch, it debugs on set myform

Code, I commented out the 2 things I've tried. Call ResetUserID Dim DB, DB_BE As Database Dim rstToPay, rstPayments, rstActivity, rstDUE As Recordset Set DB_BE =...

I didn't realize that I bracketed my statement, I didn't do that in the code. I realize that I should understand what your asking me, please excuse my ignorance, I am trying to do better on my terminology. What do you mean where am I calling the command from?

I tried using this code also, but no luck. Me!frmBILLSDuesub_OLD.Requery I do not receive any errors with anything I have done so far, it just simply doesn't perfom the function.