Results 1 to 2 of 2

Thread: Count the number of Columns or Fields in a MS Access 97

  1. May 25th, 2001, 07:09 AM #1
    hoconnor
    hoconnor is offline

    Thread Starter
    New Member
    Join Date
    May 2001
    Location
    Dublin, Ireland
    Posts
    2

    Count the number of Columns or Fields in a MS Access 97

    Using DAO I want to return the number of columns/fields from a particular access table to my vb application.
    Thanks in anticiaption
    Reply With Quote Reply With Quote
  2. May 25th, 2001, 02:19 PM #2
    rickm
    Guest
    Define your recordset:
    dim RS as DAO.Recordset

    Open your recordset:
    RS.Open <SQL>,other parameters

    GetFields:
    Debug.print RS.Fields.Count
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width