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
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
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.
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.
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
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
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
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
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.
Wrongly posted 3 time due to internet prob sorry
Shall i make a table of My all table or Query
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.