Results 1 to 6 of 6

Thread: Insert row

  1. #1
    Join Date
    Mar 2002
    Location
    Sacramento, CA
    Posts
    120

    Unanswered: Insert column

    This is what I'd like to do.

    Open an existing table
    Insert a column
    Name it FormattedDate
    Data type = Date/Time
    Format property = mm/dd/yyyy
    Close the table

    I don't believe this can be done using a macro.
    Can someone assist with code?

    Thank you,
    Michael Abrams
    Last edited by mrabrams; 10-25-03 at 17:28.

  2. #2
    Join Date
    Oct 2003
    Posts
    311
    do you mean insert a row or a colm? what do you mean name a row?

  3. #3
    Join Date
    Mar 2002
    Location
    Sacramento, CA
    Posts
    120

    I'm so embarrassed!

    Yes, I meant column !

    (When looking at the table in design view my mind saw a row. )

    Thank you for pointing that out.

    I have edited in the word 'column' to replace 'row' in the original post.


    Michael

  4. #4
    Join Date
    Sep 2003
    Posts
    228

    Re: Insert column

    Originally posted by mrabrams
    This is what I'd like to do.

    Open an existing table
    Insert a column
    Name it FormattedDate
    Data type = Date/Time
    Format property = mm/dd/yyyy
    Close the table

    I don't believe this can be done using a macro.
    Can someone assist with code?

    Thank you,
    Michael Abrams
    This might be helpful:

    http://www.utteraccess.com/forums/ac...ess244021.html

  5. #5
    Join Date
    Mar 2002
    Location
    Sacramento, CA
    Posts
    120
    Thanks ottomatic!! That is EXACTLY what I needed.

    I appreciate your knowledge and direction. Thank you.

    Michael

  6. #6
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    To insert Columns in a Table use this Syntax



    ALTER TABLE Tabelle {ADD {COLUMN Feld Typ[(Größe)] [NOT NULL] [CONSTRAINT Index] |
    CONSTRAINT Mehrfelderindex} |
    DROP {COLUMN Feld I CONSTRAINT Indexname } }


Posting Permissions

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