Results 1 to 2 of 2
  1. #1
    cortigiac is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2009
    Posts
    1

    extract command "create table" from the table access

    Hi
    I want to replicate the structure of the tables access
    There is a command for create script "create table..." from the table access.

    Thank you in advance


    Corti

  2. #2
    Rawb is offline Expert
    Windows XP Access 2000
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875
    Let me see if I understand you correctly. You want to use VBA Code to make a copy of an entire Table, right?

    If that's correct, then all you need to do is the following:
    Code:
    DoCMD.CopyObject, "CopyTableName", acTable, "OrigTableName"

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 21
    Last Post: 06-03-2009, 05:54 PM
  2. aSTR = Dir("C:\*.*") >> "Type Mismatch"
    By JGrant in forum Programming
    Replies: 1
    Last Post: 03-28-2009, 05:17 AM
  3. Create "reset filter" button
    By vanlanjl in forum Access
    Replies: 0
    Last Post: 03-03-2009, 07:36 AM
  4. Replies: 2
    Last Post: 08-31-2006, 12:19 PM
  5. "Count" and "Countif" in Reports
    By JMantei in forum Reports
    Replies: 1
    Last Post: 06-20-2006, 02:20 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums