Search results

I need to export data from a table in a database to another database table (same table name) using VBA ? Examples are welcomed. Thanks ! ! !

theDBguy/isladogs, Well, the both you both attention to my attempt to do something that might work. I learn the hard way, it did not. isladogs, what I meant by "mapping to the textbox" is to point the textbox to the data. I discovered last night that what I'm trying could easily be done by...

theDBguy/isladogs, It appears to look like the form. Now, all I have to do is map the textboxes. Thanks for your help ! ! !

DBguy, The reason is . . . to keep from creating a report from scratch. Unless there an option to print the form with the information on the form.

Is it possible to create a REPORT from a FORM ? If so, please tell me how. Thanks ! ! !

That worked . . . Thanks ! ! !

I changed "PD_Emergency_1 " (and "PD_Conf_1") to a "Yes/No" field and retied "Conditional Formatting" and I still can't get it to work.

Check the checkbox for "Emergency", then have each print record with a check mark (i.e. "-1") print in red. The entire line.

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] & "', '" &...