Search results

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

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

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

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