Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Create Table from another Tables Properties? (A2k (9.0.4402) SR-1)

    Create Table from another Tables Properties?

    A2k (9.0.4402) SR-1

    How do I create a table that contains the following structure and properties from another existing table?

    strTableName text
    strFieldName text
    strDescription text
    strCaption text

    Thanks, John Graves

  2. #2
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Create Table from another Tables Properties? (A2k (9.0.4402) SR-1)

    John:

    You could use the ADOX library to create the table and fields in code, or....Copy the existing table (Ctl - C), paste (Ctl - V), and choose to paste only the structure. I hope this helps.
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •