Results 1 to 4 of 4

Thread: List of Columns

  1. #1
    Join Date
    Mar 2008
    Posts
    29

    Question Unanswered: List of Columns

    Hi all,
    I want to get list of columns through query.
    we can get tables with " SELECT * FROM MsysObjects WHERE type = 1 ".
    Like this what is the query to display list of columns.
    Thank you in advance.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Access doesn't have this in system tables IIRC. You need to use the object model.

    Perhaps best to give an overview of exactly what you want to do so we can give you an overall answer this time.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I am only aware of one method; but it is through opening a recordset in VBA code and looking at the attributes of each column. It's not pretty, but it does work.

    P.S. I don't have the code, just know it exists.
    George
    Home | Blog

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    You can use the DAO or ADOX object models too.
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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