Search results

Hello, I have been working on a split database and one of my forms involves copy data from one table on the back-end database to another back-end table. Prior to copying the data to the destination table I copy it to two temp tables to modify and insert new data. My issue is that when I am...

I am trying to write a series of queries that are activated by a form button; however, when the first query results two entries (the form is in not in data entry) in the "Downtimes" table, and unless all of the fields are filled in on the form most of the data will not be entered into the either...

Hello, I am having a lot of problems writing a query to run in a vba module. I am trying to use an insert-select statement for all of the values except for one, and for that exception, I am trying to use a variable value or another query. Here is the code: strDwnSystemsSQL = "INSERT INTO...