Recent content by mbath20110

think I got it ... what made it tricky (a detail that I may have left out) is that my data source (query) was actually several tables already joined. But, on your advice, I played around with pulling down more than one instance of each table. As you correctly noted, that had the bonus effect...

join the table ... considered something like that but wasn't sure how to proceed. you mean like, join the table to itself??

Have a report that gets its data from a query. I want the report to contain data from different records from the data source. Let me explain. The report has fields for current year and prior year and under each of those fields is the corresponding data. (i.e. 2004 will show two corresponding...

correction meant to say, 'when I replaced mine with yours' sorry

just on your snippet . the entire code (as I'm sure you may have guessed) is simply cobbling together a series of WHERE statements and then assembling them at the end of the procedure. On the code I sent you, if I DON'T attempt to use a LIKE statment (just use the straight cboClient) it works...

almost thanks for the reply ... I think I'm almost there ... getting a compile error and the final closing parenthesis is highlighted as the offender.

howdy folks, having a syntax issue. trying to build a SQL statement in VBA that creates/allows for LIKE operators. Here's what I've got so far: strWHERE = strWHERE & " AND ((tblCLIENT.ClientName) = " & "LIKE " & " '*'cboClient '*' " & ")" but when I run it, I get a 3075 runtime error...

thanks!!! your solution worked like a charm ... thanks ...

? so I'm clear. is that, requery the combo box in the Unload event of the second form (which is my results form)?

have a form with a combo box which looks to a table to get its list. the user drops down the combo box, selects their criteria then clicks 'Find'. My code behind the 'Find' button sets the form's visible property to 'False' then opens another form in which the data is limited to what the...

apologies to dcx ... didn't get your response before my last post. thanks for your help ....

code included folks, thanks for all the responses ... still a little stumped. here's my code: Set qdf = CurrentDb.CreateQueryDef("qryExample") qdf.SQL = "SELECT tblCLIENT.ClientName FROM tblCLIENT WHERE (tblCLIENT.ClientName)=" & Me!cboClient I have declared the necessary variables...

Am trying to use VBA to dynamically build a SQL statement that will end up being the data source for another form. (want to enable my users to enter in criteria as they see fit on a search form, collect their criteria and then build the statement programatically in SQL). I'm so close I can...