Move Info from One Table to Another

Move Info from One Table to Another

A brief summary summary of the “OP’s” (Original Posters) question HERE. The question prompted me to create this set videos.

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)

Play Video

… …

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)

Play Video

… …

Move Info from One Table to Another 3

Move Info from One Table to Another 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)

Play Video

… …

Move Info from One Table to Another 4

Move Info from One Table to Another 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)

Play Video

… …

Move Info from One Table to Another 5

Move Info from One Table to Another 5

Video 5 (1:52)

Here I demonstrate how to show the last record entered in a form.

Video 5 (1:52)

Play Video

More - Heading HERE:-

… …

Move Info from One Table to Another 6

Move Info from One Table to Another 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)

Play Video

… …