Search results

That was it . . . . It's working now . . . . Thanks again ! ! !

I added a few other fields and now receiving errors (as shown below). Can you see the cause ? Run-time error '3346'; Number of query values and destination fields are not the same. Dim strSQL As String, strFormFirstName As String, strFormMiddleName As String, strFormLastName As String...

This worked . . . I had to change the colon to semicolon. Thanks ! ! !

This did not work.

I'm having trouble with the proper placement of the quotes for a Do.Cmd.RunSQL VBA statement. The SQL code works. Would someone add the DoCmd.RunSQL statement and quotes in the proper place for the below code ? Eventually, "Evans" will become a variable rather being hardcoded. Thanks ! ! ...

Two (2) databases . . . I'm looking into using one (1) database and hiding 'Buttons' and files. This may solve my problem.

Yes

I'm using MS Access

I tried the "Link" statement for the tables needed for the other database table. The data did appear, but when I deleted the records from the source table, it was also deleted from the other table (receiving table). When the user enters their information I want to delete it after their review...

Yes

I'm trying to retrieve data from a database table (create by a form within the database) to another database table. In other words, the users enters data, then after completion (creation of a report via table). I then want the database table data to automatically exported to another database...

Thank you for responding ! ! ! Let's me further explain, I'm trying to create a process that will allow a user to enter data into a database table (via MS Access form) and upon exiting (via button) automatically export the data into another database table. That is . . . automatic export...

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.