craigachan
Registered User.
- Local time
- Today, 12:54
- Joined
- Nov 9, 2007
- Messages
- 285
I've always like the regular menubar form older access versions. Of course with the ribbon in Ac2007 we don't have this anymore. I don't like the space that the ribbon takes up. So I've tried to combine a button with a listbox that unhides and hides. Then I use the listbox items to run a routine, open a form, etc. It almost works good. I've used the button_click to unhide the listbox (my dropdown menu) and the forms timer event to hide the listbox again.
The problem is this. Say my menubar is on Form1, When I open another form, note necessarily a form from my listbox, It seems the timer event makes me refocus on my Form1 again. But it doesn't do this consistently, only sporatically. When I turn off the timer event, I don't get this problem at all.
I basically see 2 options, and perhaps there are more. Being an amature at access, I'm wondering if there is a way to create a counter function of some sort, which is separate from the forms timer event. So that I can use the counter function to hide the menu's listbox.
The other option is to figure an event that auto hides the listbox if it is not selected.
Does anyone have any ideas? Is this the right path I'm going down? Any input would be greatly appreciated.
The problem is this. Say my menubar is on Form1, When I open another form, note necessarily a form from my listbox, It seems the timer event makes me refocus on my Form1 again. But it doesn't do this consistently, only sporatically. When I turn off the timer event, I don't get this problem at all.
I basically see 2 options, and perhaps there are more. Being an amature at access, I'm wondering if there is a way to create a counter function of some sort, which is separate from the forms timer event. So that I can use the counter function to hide the menu's listbox.
The other option is to figure an event that auto hides the listbox if it is not selected.
Does anyone have any ideas? Is this the right path I'm going down? Any input would be greatly appreciated.