Results 1 to 10 of 10
  1. #1
    buchasia is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2017
    Posts
    9

    Drop Down List From Which i can open all table or Query or Report

    Dear Friends


    Instead of Making Button from which i can open single Table or query or Report Shall i make a Drop Down List From Where i link all table or Query or Report to open
    thanks
    buchasia@gmail.com

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    You cannot select more than one list item in a combo (drop down) - unless the combo row source is based on a multivalue field, and we don't want to go there.
    You need a listbox, which doesn't drop down. There's lots of code examples out there on how to iterate over the selected items in a listbox. The listbox has to be set to allow multiple choices. You probably still need a button to start the code that will do something with your choices.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    choice-davegri-v01.zip
    Here's a complete working db with 3 tables, 3 queries, 3 reports and one form.
    The form has a listbox and a combobox. The combobox dropdown allows you to select either tables, queries or reports to show in the listbox.
    Clicking an item in the listbox will open that object for viewing.

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Here's another similar example which allows you to list all database objects by type and view/edit/run any selected item
    http://www.mendipdatasystems.co.uk/v...cts/4594424205
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  5. #5
    buchasia is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2017
    Posts
    9
    Thanks for reply
    Support i have 10 table
    i need one Drop-down list to be placed on the form So i open my all table from the above drop-down list
    so i want to map my all the table in the said drop-down list for easy navigation
    thanks

  6. #6
    buchasia is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2017
    Posts
    9
    Thanks for reply
    Support i have 10 table
    i need one Drop-down list to be placed on the form So i open my all table from the above drop-down list
    so i want to map my all the table in the said drop-down list for easy navigation
    thanks

  7. #7
    buchasia is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2017
    Posts
    9
    Thanks for reply
    Support i have 10 table
    i need one Drop-down list to be placed on the form So i open my all table from the above drop-down list
    so i want to map my all the table in the said drop-down list for easy navigation
    thanks

  8. #8
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Not clear why you have posted the same item three times.
    Davegri and I have provided two examples for you to look at
    If you like what you see, you can import either of those into your own app and use them with little or no alterations needed.
    Otherwise, look at the code and adapt for your own purposes.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  9. #9
    buchasia is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2017
    Posts
    9
    Wrongly posted 3 time due to internet prob sorry
    Shall i make a table of My all table or Query

  10. #10
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    You do not need to create another table listing your tables.
    My approach uses the list of database objects in the hidden system table MSysObjects.
    Dave's approach is slightly different but also uses built in methods.
    As I said before, you can use either method in your own app with almost no effort at all.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 09-15-2017, 07:57 AM
  2. Replies: 7
    Last Post: 09-03-2015, 11:31 AM
  3. Replies: 1
    Last Post: 09-04-2012, 02:32 PM
  4. Open form from a drop down list
    By ildanach in forum Forms
    Replies: 15
    Last Post: 05-21-2009, 05:40 AM
  5. Open Form with a drop down list box
    By Rinehart in forum Forms
    Replies: 0
    Last Post: 08-10-2008, 08:53 PM

Tags for this 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
  •  
Other Forums: Microsoft Office Forums