Search results

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

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

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