Make-Take

[bonusmarch]

I need to duplicate a table in the same database when a button is clicked. How do I code that? Also, is it possible to use the same default name so the query won't have to ask you for the table name everytime?

 

[genomon]

Set up a recordset object in VBA and try the .Clone method

 

[bonusmarch]

I need more details in how to clone. Is it possible if you post up an example? I am a new beginner in Access.

 

[Rhonin]

Try this, you can then append the required records to the table. This allows you to specify the name and primary key.


CREATE TABLE ThirdTable (FirstName TEXT, LastName TEXT, SSN INTEGER
CONSTRAINT MyFieldConstraint PRIMARY KEY);

 

[tlbroadbent]

You could do this in a the click event of the button.

Dim strSQL As String

'Assume you want to copy the Depts table to DeptsCopy
'Create the SQL statement
strSQL="SELECT Depts.* INTO DeptsCopy FROM Depts;"

'Turn off warning messages
DoCmd.SetWarnings False

'Copy the table by executing the SQL statement
DoCmd.RunSQL (strSQL)

'Turn on warning messages
DoCmd.SetWarnings True
Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.