Now to Make a Clone of a Table in Currentdb

  • Thread starter Thread starter Mike Thomas
  • Start date Start date
M

Mike Thomas

Is there a way in Access 2000 VBA to make a temporary, empty copy of an
existing table in the database?

In other languages I have used

SELECT * FROM customers INTO TABLE tCust WHERE False

After making the table, I add the records, test them, then add the good ones
to the permanent table customers.

Many thanks
Mike Thomas
 
Create the following code

dim db as database
db = currentdb
db.execute("Select * from customer into table tCust where FilterFieldName =
0) ' 0 = false, -1 = true in check boxes

T Martin
 
Back
Top