I would like to create a New Table [NTable] based on a Existing Table [ETable]. I can do so with a MAKE_Table Query but I
would like to do so in CODE - to minimize the amount of Queries and to understand the use of code and the commands/methods
I did try to look in the help file and found the use of a method called OpenRecordset but I'm not sure if is the right one to
use and it gives me the error "Can't find project or library" when used (Error msg higtihgt the word "OpenRecordset")
Here is what I've been trying:
Dim NewRST As Recordset
Set NewRST = OpenRecordset("ETable")
I am really not sure how to do it. First I would just like to create a new table/recordset that is the same as the old
one, just to see if my syntax is correct and then try to add a filter.
Say ETable have four fields (Name, Surname, Number and BirthDate)
Just to understand the syntax, I would like your help on creating the new Table [NTable] so that it only contains the fields
Name, Surname and Number of only all those entries with Names starting with say "B"
I would greatly appreciate your help