Move Info from One Table to Another
A brief summary summary of the “OP’s” (Original Posters) question HERE. I’ve done a set of YouTube videos to answer the question. The first answer demonstrates the INSERT INTO method of adding records to another table. This method is where you update the underlying table by adding a new record directly into the table. However, this makes a fixed record, the whole record is added, and if you don’t want to record ALL details added, then you have a lot of deleting to do. In the second answer demonstrates the method of adding the records through a form, straight into each textbox on the Form, the text-boxes that relate to the underlying data in the table. The method sets the textbox default value. Now you can see the information and vet it without saving it to the table. This has a distinct advantages when you’re doing data modification.
The 6 videos here demonstrate how to extract a particular Row:-
- Selecting a checkbox in a datasheet view
- Utilise SQL :-
- With Select Statement,
- A Recordset Loop
- And an Insert Statement
The Videos can also be viewed in a YouTube Playlist:- Move Info from One Table to Another
Move Info from One Table to Another 1
Move Info 1
Video 1 (00:26)
Generally it’s not a good idea to move data from one table to another. However I saw this thread, and realised that the OP needed to do this, and thought this was a good opportunity for me to demonstrate the method.
Video 1 (00:26)
… …
Move Info from One Table to Another 2
Move Info 2
Video 2 (6:45)
Here I demonstrate how you can construct a Table manually from an SQL Statement. I also demonstrate how you can enhance a “Message Box” slightly, so that it gives you a more accurate idea of what your code is doing.
Video 2 (6:45)
… …
Move Info from One Table to Another 3
Move Info 3
Video 3 (8:08)
Demonstration of how to create a Recordset Loop from a Query. This reduces the amount of typing you have to make in your VBA code, reducing the chance of mistakes and making you a better coder…
I also demonstrate how you can easily insert code directly into your Code Module from “Text Files” again, speeding up your coding and reducing errors.
Video 3 (8:08)
… …
Move Info from One Table to Another 4
Move Info 4
Video 4 (7:57)
Here I demonstrate how to construct an “Insert SQL Statement”. I show how to handle a common problem, that is:- “incorrectly placed text delimiters”. The solution is very simple, “Divide and Conquer”.. Keep the SQL Statement in its most basic form. Do the complicated formatting separately in the variables, then add the variables to the SQL Statement. Now the SQL Statement takes the form of a very simple, repeating, structure. You can identify any errors immediately.
Video 4 (7:57)
… …
Move Info from One Table to Another 5
Move Info 5
Video 5 (1:52)
Here I demonstrate how to show the last record entered in a form.
Video 5 (1:52)
… …
Move Info from One Table to Another 6
Move Info 6
Video 6 (9:12)
This Video shows how to directly transfer data into a Forms controls using an SQL statement. By transferring the information into the control’s “Default Value” then the information isn’t saved. A save is only forced when new information is added to the record by the user..
Video 6 (9:12)
… …
