create table from table

's Computer Specifications

What is the VBA code for creating an empty table from an existing empty
table?

Thx.

--
Bill

's Computer Specifications

On Tue, 27 Jan 2009 13:49:30 -0800, Bill H. wrote:

> What is the VBA code for creating an empty table from an existing empty
> table?
>
> Thx.

DoCmd.CopyObject , "NewTableName", acTable, "OldTableName"

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

's Computer Specifications

Thank you!

but how to automatically delete the newtablename if it already exists
without getting the access prompt?

"fredg" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Tue, 27 Jan 2009 13:49:30 -0800, Bill H. wrote:
>
>> What is the VBA code for creating an empty table from an existing empty
>> table?
>>
>> Thx.
>
> DoCmd.CopyObject , "NewTableName", acTable, "OldTableName"
>
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Import data to contact table and create record in related table	=?Utf-8?B?YmthdWZtYW4=?=	Microsoft Access Queries	2	1st May 2007 04:20 PM
To have month and year as part of the table name in CREATE TABLE or MAKE TABLE Query	ichew@scs.com.sg	Microsoft Access Getting Started	1	18th Apr 2006 06:38 AM
Create Table Primary Key after Make Table Query And Update Table	=?Utf-8?B?Uk5VU1pAT0tEUFM=?=	Microsoft Access Queries	1	3rd May 2005 08:07 PM
create a source table from a special pasted value dynamic crossed table	Arthemus	Microsoft Excel Misc	1	29th Sep 2003 08:59 PM
create a source table from a special pasted value dynamic crossed table	Arthemus	Microsoft Excel Programming	1	29th Sep 2003 08:59 PM