Move Info from One Table to Another

Move Info from One Table to Another 1

Move Info 1

Video 1 (0:26)

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

The 6 videos here demonstrate how to extract a particular row by:-

  • Selecting a checkbox in a datasheet view
  • Utilise SQL :-
  • With Select Statement,
  • A Recordset Loop
  • And an Insert Statement

Video 1 (0:26)

More Info on Move Info:-

… …

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)

More Info on Move Info:-

… …

Move Info from One Table to Another 3

Move Info 3

Video 3 (8:08)

In this video I demonstrate 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)

More Info on Move Info:-

… …

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)

More Info on Move Info:-

… …

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)

More Info on Move Info:-

… …

Move Info from One Table to Another 6

Move Info 6

Video 6 (9:12)

Here, I Demonstrate 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)

More Info on Move Info:-

… …