Recent content by Jake55923

Finally figured out that my problem had to do with parentheses. I changed this: strWhere = strWhere & " ([tbl RA Data].[Current Defect]) Like '*" & Me.[Defect] & "*' OR ([tbl RA Data].[Current Prob Descr]) Like '*" & Me.[Defect] & "*' AND" To this: strWhere = strWhere & " (([tbl RA...

Wayne thanks for your response, but I can't figure out where I need (or don't need) the single quotes you mentioned. For your information, the line of code that is highlighted when i debug is: qryDef.SQL = strSQL & " " & strWhere & "" & strOrder Thanks

Doug - You were right...thanks so much

Any ideas on why this code will not work when I enter a parameter in the Defect field in my form? I get a "Run-time error '3075' Syntax error in string expression". I borrowed this code from this website & I am not that familiar with it. It does work for any combination of the Machine, Review_By...

I am running 2000. The code is run from a form where the user clicks the print button & ideally 11 reports would print, each with the appropriate title. Could you explain more about the code in the report's load or open event that would put the correct title in place? Thanks a lot.

Hello, I am trying to print a series of 11 reports where each report corresponds to a certain department. I would like to use only one report ("rpt Incomplete" in my code), but have a dynamic title that corresponds to the correct department on the printed reports. For example, the first printed...

I cannot figure out how to transfer this sequel statement into vba code. I know the syntax for the overall select statement, but the count portion is giving me trouble. SELECT [tbl Safety].Department, [tbl Safety].Status, Count([tbl Safety].Status) AS CountOfStatus FROM [tbl Safety] GROUP BY...

Got it. Thanks for the quick response guys!!

I am building a query and don't know how to return all records that have text that is similar to a user-entered parameter. For example, I have a text box named Defect where the user enters the defect they wish to search for. If the user enters "broken", I would want to see all records that...