Search results

I want the print record color to be determined by a box that is checked on a form that prints the report. I been trying, but no position results

I want the print record color to be determined by a box that is checked on a form that prints the report. I been trying, but no position results

Is it possible to change the text color (when printing) based on the value of another field ? I want to check if a checkbox is selected on a form, if so I want the entire line (print record) to print in red. It looks like "Conditional Formatting" will not do this.

June7/Uncle Gizmo, That did it . . . Thanks ! ! !

Anybody see what is wrong with the content in my 'Testit' query criteria ? I'm trying to pass dates from a form (i.e. Date_Selected) to my query (i.e. By_Selected_Date_Query) ? The syntax used is below. Also, I've attached the database. Between [Form]![Date_Selection]![StartDate] And...

isladogs, I appreciate this. I will definitely keep your post in mind the next I run into a problem. Thanks again ! ! !

isladogs, Thanks, but I have a solution. I will keep this post in mind, when I have any other problem.

Micron, Remember, I was originally getting a Run-time error '3075' with the single quote in the [Company_Name] field of the table. This solution solved my problem. I could not get the other suggestions to work. Thanks again for your help ! ! !

Micron, To resolve the problem, I did the following: 1. Replace all single quotes with double quotes in the [Company Name] field of the table. This eliminated the Run-time error '3075'error. 2. Added an event ('On Open') that calls an update query when the report opens. The update query...

The_Doc_Man/Mark/Micron, Also, I replace the single quote with double quotes in the original name in [Company Name] table.

The_Doc_Man/Mark/Micron, Thanks to all of you. I ended up creating a SQL Update queries (see below). This was the easy solution for me. UPDATE [Sales Tax Table] SET [Sales Tax Table].[Company Name] = Replace([Company Name],Chr(34),"'");

Micron, How would your solution look with my DoCmd.RunSQL statement ? See statement below . . . strCompany = strQuote & [strCompany] & strQuote DoCmd.RunSQL "Insert Into [Sales Tax Table] ([Company Name], Grocery_Amount, Amount, Grocery_Date, Category) Values ('" & [strCompany] & "', '" &...

Mark, If you're referring to 'fnAnySQL() parameter query'. I did, but it's too complicated for me. I'm looking for a simpler solution.

Ok, I tried the solution mentioned in the article. Did I interpret it correctly ? See below for error and code. strCompany = strQuote & [strCompany] & strQuote DoCmd.RunSQL "Insert Into [Sales Tax Table] ([Company Name], Grocery_Amount, Amount, Grocery_Date, Category) Values ('" &...

Doc_Man/Mark, I'm back . . . I see the problem. It's the single quote in [Company Name] or [strCompany] (i.e Xyz's) for the DoCmd.RunSQL statement (as shown below). DoCmd.RunSQL "Insert Into [Sales Tax Table] ([Company Name], Grocery_Amount, Amount, Grocery_Date, Category) Values ('" &...

Doc_Man, The value Xyx's is an example of the value in the field [Company Name] in the [Category Table] table. DLookup Statement Me.Category_Name = DLookup("[Category]", "[Category Table]", "[Company Name] = [Name_Choose] ")

Doc_Man, I'm getting the below error . . . Run-time error '3075' Syntax error (missing operator) in query expression For the value of Xyx's

Thanks to everyone ! ! ! I ended up using the following 'DLookup' statement. Me.Category_Name = DLookup("[Category]", "[Category Table]", "[Company Name] = [Name_Choose] ") I did run into a problem with values with single quotes in [Company Name] (i.e. Lowe's, Catherine's, Sonic's .etc.)...

Mark, The msgbox displays the correct SQl code, but how can I retrieve the results. Dim strSQL As String Dim rs As DAO.Recordset MsgBox Me.Name_Choose & " <==> " & Me.Category_Name strSQL = "SELECT [Category] FROM [Sales Tax Table] WHERE [Company Name] = '" & Me.Name_Choose & "'" MsgBox strSQL...

OK, I tried the 'Dlookup' command, but I'm getting a syntax error. Dlookup("[Category]","[Sales Tax Table]","[Company Name]= '" & Me.Name_Choose & "'") What's wrong ?