Search results

Hello, I have a user form with a date range and combo box filter. The user selected filtered results are displayed in a subform. I placed a print report button on the user form, but I'm getting the following error when the button is pressed: Run-time error '3075': Syntax error (missing...

I think my database failed to attach in the last message, so here it is. I would really appreciate it if someone could please take a look at it and offer any insight as to what's going wrong. This is the final step in my database! Thank you in advance!! dkinnz

Thanks for the reply but that doesnt seem to be the problem. I change the field name anyway just in case. Attached is my database if anyone would please take a closer look. I could really use some help with this as I've tried everything. Thank you!!

I have a user form with a date range and combo box filter. The user selected filtered results are displayed in a subform. I placed a print report button on the user form, but I'm getting the following error when the button is pressed: Run-time error '3075': Syntax error (missing operator) in...

got it working...here's what i did Dim varFam As Variant Dim strField As String Dim strWhere As Variant Const conDateFormat = "\#mm\/dd\/yyyy\#" strField = "Date" strWhere = "1=1 " If Me.cboTest <> "" Then varFam = varFam & "and [TestField]='" & Me.cboTest & "' " End If If...

Hey everyone, I'm trying to implement an example of a date range filter that I found (it uses a start date text box and end date text box), but I'm having a lot of trouble getting the code right. I'm trying to combine the date filter criteria with another combo box filter criteria. Here's...

Hi ya'll, I'm having difficulty getting my combo box filtering working the way I'd like it to. The problem that I'm having is the fact that I'm performing "OR" cases across three columns of data looking for values that match what's selected in those two combo boxes. So then when I go to...

Thanks for the reply neileg and ghostjung. You're right, it does just appear to be creating duplicate records. I'm really depressed now as I have no idea what to do from here...If anyone else has any solutions I could really use some help!!!! Neileg, I'm giving that linked table trick a try...

Hello Forum, I have a problem with duplicate records in my query. I know why the duplicate records are occuring and I have spent a ridiculous amount of time trying to fix the problem, but I'm really at a lost and am quite desperate for some help. Here's some background info that shows the...

I’ll just state my question/problem right off the bat: Is there a way (hopefully using query criteria, but VBA code would be fine also) to compare the values of one table with another table by looking for similar/partial text? This problem is kind of complicated to explain, so please bear with...

I’ll just state my question/problem right off the bat: Is there a way (hopefully using query criteria, but VBA code would be fine also) to compare the values of one table with another table by looking for similar/partial text? This problem is kind of complicated to explain, so please bear with...

Cool. Thanks Stopher. I really appreciate your help with this. Cheers, dkinnz

Stopher, Not sure if you know why this is happening, but if I select "All" from the Group combo box (cboGroup), the other combo boxes are blank. I'd like to still be able to filter by the other combo boxes if no specific choice is made in the first combo box. Thanks, dkinnz

Wow, that is some good stuff. Mile Grazie for your help!!!! I was initially using IF..Then statements, but someone suggested using the Select Case instead. I agree though, IF..Then is much neater. I'll be sure to post my completed database when I'm finished. I think it may help some...

I was able to figure out how to add in the "AND" to create multiple combo box filter conditions (see code below). But, I'm still having trouble with inserting the "All" option into the cascading combo boxes to return all records if a specific combo box value is not selected. If you have any...

I was able to figure out how to add in the "AND" to create multiple combo box filter conditions (see code below). But, I'm still having trouble with inserting the "All" option into the cascading combo boxes to return all records if a specific combo box value is not selected. If you have any...

Hi all, I originally posted the following in the Forms section, but I think it belongs here. My main goal in the project that I'm working on is to have multiple cascading combo boxes to filter the records. Through searching this forum, I was able to put together some cascading combos, but I...

Adding "All" to cascading combos and Multiple combo box Filtering Thank you unclejoe! It works great! However, I've recently run into a related problem...If anyone else has any insight as well I'd really appreciate it! My main goal in the project that I'm working on is to have multiple...

Hi all, I have a combo box with an "All" option, but I'm having trouble figuring out why it fails to return any records. I'm using a search command button to filter the records. I've attached my database and the specific code I'm using is below. I really, really appreciate any help that can be...

Thank you a ton for your reply! It works perfect now! I owe ya a drink. -dkinnz