view tables and queries in access 2010 runtime

Posted on 2011-05-03
Last Modified: 2012-05-11
I am new to Access 2010. I am a little familiar with the ribbons that can be created but is there a way to allow the user to see the tables and queries similar to the navigation pane when you create a runtime version?
Question by:dlord54
    LVL 77

    Accepted Solution

    Not in the navigation pane.

    You have to build such a list if you want the users to see it.

    You can use queries based on msysobjects table to get a list of tables and/or queries and create listboxes or comboboxes from such queries.


    Select [Name] from msysobjects where type = 1 and [name] not like "msys*" and [name] not like "f_*"
    LVL 11

    Assisted Solution

    You can create a Form object the lists the tables in a List Box control.  You can integrate the Query objects into the same List Box, or create another one.

    But ... what is your intent in providing this capability?  If its to provide acces to the data that is presented via the Queries, or the data that is stored in the Tables, then the path for doing that is to create Form objects that expose that data to the user.

    Author Closing Comment

    Thanks for your help. I now know the direction that I need to take.
    LVL 11

    Expert Comment

    FYI ...

    Tables ...

    Select [Name] from msysobjects where type In (1,4,6) and [name] not like "msys*" and [name] not like "USys*"

    Queries ...
    Select [Name] from msysobjects where type = 5 and [name] not like "~*"

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now