• Query for Tables (Office 2000)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Query for Tables (Office 2000)

    Author
    Topic
    WSjpzinn
    AskWoody Lounger
    September 7, 2006 at 7:14 pm #435145

    I am a high school Business Education teacher and am teaching a course on Computer Applications. I have an ASP application where I am putting tests online for students. The applications will grade the tests and give the students immediate feedback. Rather than replicate the whole thing for each different test, I want to have a separate table for each test, all in one database. It is hard to explain the whole thing to you but what I’ve been wanting to do is to be able to dynamically fill a combo box with available tests so the faculty members can select the test they want to have the students take. I wanted to do that by getting a list of the tables into a RecordSet. I had almost given up hope because the typical SELECT statement retrieves things from a table rather than retrieving the names of the tables. Then I received the Woody’s Access Watch which arrived at just the right time. Now I just have to figure out how to adapt what you’ve written for my purposes. However, when using the link in the email to retrieve the files, I can’t find the files. The archive at http://www.helenfeddema.com/access.htm only goes to #148 and the WAW information says the files are in #150! One additional question is whether or not I can use ADO instead of DAO since I’m already using ADO in my application. Thanks for all your help. J. P. Zinn

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSHansV
      AskWoody Lounger
      September 7, 2006 at 7:39 pm #1027644

      Helen Feddema’s site hasn’t been kept up-to-date recently, and the Access Watch website isn’t working well either at the moment.

      You should be able to use either DAO or ADO to open a recordset on the following SQL statement:

      SELECT Name FROM MSysObjects WHERE Flags In (0,2097152) AND Type=1 ORDER BY Name

      Reply | Quote
    Viewing 0 reply threads
    Reply To: Query for Tables (Office 2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    June 2025
    S M T W T F S
    1234567
    891011121314
    15161718192021
    22232425262728
    2930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.