Listing Table Names in Combo Box


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Listing Table Names in Combo Box

  1. #1
    Jeremy Shipley Guest

    Listing Table Names in Combo Box


    Can anyone tell me how to list a DB's Table Names in a combobox in access97?

  2. #2
    Douglas J. Steele Guest

    Re: Listing Table Names in Combo Box

    Easiest way is to use the following SQL as the record source for the combo
    box:

    SELECT MSysObjects.Name
    FROM MSysObjects
    WHERE (((MSysObjects.Name) Not Like "MSys*") AND ((MSysObjects.Type)=1))
    ORDER BY MSysObjects.Name;

    HTH

    --

    Doug Steele, Microsoft Access MVP
    Beer, Wine and Database Programming. What could be better?
    Visit "Doug Steele's Beer and Programming Emporium"
    http://I.Am/DougSteele/


    Jeremy Shipley <jshipley@daytonparts.com> wrote in message
    news:39170ed9$1@news.devx.com...
    >
    > Can anyone tell me how to list a DB's Table Names in a combobox in

    access97?



  3. #3
    James Mahoney Guest

    Re: Listing Table Names in Combo Box


    "Jeremy Shipley" <jshipley@daytonparts.com> wrote:
    >
    >Can anyone tell me how to list a DB's Table Names in a combobox in access97?


    You could use the DAO tabledefs collection. For each table in an access
    database there's a corresponding tabledef


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center