Recent content by CJaneCode

Hi, FancyPrarie ~ This worked like a charm. Many thanks! CJaneCode

Thanks, FancyPrarie. I understand in an intuitive sense what you mean about needing to trap the error - I set the On NoData property and did get the message box (thanks to your instructions) as well as the ensuing error (run-time error 2501). I think that I need to modify the event procedure...

Is there a simple solution available in Access for the situation where a user selects fields that result in the selection of ZERO rows via the BuildWhere function? As it is working now in my application, if criteria are defined that results in ZERO rows, my report opens (but doesn't display any...

Hi, FancyPrarie ~ I would like to test what BuildWhere is returning, but when I add a command button on my form and add the code that you specified in the OnClick event, Access returns the message that it cannot find the macro "MsgBox BuildWhere(Me)". Do you know what I am missing? Thanks!!!

Hi, FancyPrarie ~ I have changed my combo boxes to list boxes and have chosen the Extended MultiSelect property. Now when I am in the form, if I select so much as one value in one list box, Access opens a dialog box prompting me to enter the parameter value. Let's say that I select the value...

Thanks, FancyPrarie! This is very helpful.

Hi, FancyPrarie ~ Okay, now I understand that I can't select multiple values in a combo box. It also seems as though I can't do this with a list box, either. What I'm considering now is including three combo boxes for each of my four selection criteria - and asking the user to select one to...

Hi, FancyPrarie ~ A thousand pardons. Please ignore my first question in my last post. As I'm sure you noticed right away, I made a mistake. The default value for a combo box in form view (not design view) is a blank (not "unbound"), and I'm fine with that. My second question still stands...

Hi, FancyPrarie ~ This is fabulous! I have the form and BuildWhere function working now, with four combo boxes on the form to house my selection criteria. I have a couple of questions that don't have much to do with your function but are more about combo boxes (to which I am new). At this...

Okay, here it is: Where=Impact and Financial Data.ATDATES,String Thanks!

Hi, FancyPrarie ~ Okay, I restored the frm argument in your BuildWhere routine. Now I'm getting closer I think! I still have only one list box in my form (for simplicity - I'll add two more after I get this working). Now when I click on the control that I have set up to invoke my report...

Thanks, FancyPrarie. I am afraid that my VB skills are so basic (pun intended) and my Access skills are so rusty that I may need more hand-holding! I have a form set up that opens the report (Phil4tektips first step when he was helping was1). I also have a form set up that includes a list box...

I am attempting to use FancyPrarie's BuildWhere module and am running into some difficulty. I am a statistician by trade who has only dabbled in VB (mostly via editing others' code). Phil4tektips, you extended an offer to was1 to talk through the steps for using FancyPrarie's code. Would you...