Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Windows Listing

Status
Not open for further replies.

Hmadyson

Programmer
Mar 14, 2001
202
US
I would like to create a listing of all open forms in Access in my own commandbar. I saw thread707-1157070, but it doesn't seem to work for me.

I am trying to add control 830 which should list the open windows, but it will not let me add it.

I also wrote some code that adds all of the open forms to my popup commandbar. Unfortunately I am unable to get it to run. The easiest would be if the code would run when you press the popup button, but that doesn't work. My database has tons of forms and I do not want to add code to all of them in order to get this to work.

Does anyone have any solutions?

Thanks so much.
 




Please post Access VBA questions in Forum705.

Skip,
[glasses]Don't let the Diatribe...
talk you to death![tongue]

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
May you please post your code, and you can assign a button that fires a macro in any type of command bar

--> View --> Command Bar --> personalized -->


1.In the Command paperclip, you can slide any type of button you like (in a toolbox)

2. you can right click it (while your personalized command prompt is opened) and assign any type of command, one of wich is called "execute a macro"

3.From there you will be able to execute a macro...

In this macro you can do any type of operations you would like to do to your form, including opening it.

"Knowing that you know is the greatest sign of stupidity, knowing that you are ignorant is the best proof of intelligence.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top