Idea required :Large menu 1

[DajOne]

I started a small reporting utility 2 years ago for the business units' special needs, which takes data from our main operating system. All very simple (as are my skills or lack thereof)..

Now, the number of reports available has grown considerably for each business units and I cannot fit all the command buttons and related descriptions on one Menu form (which opens when the users start the application)

Would 'pop up' menus (Microsoft knowledge base article 210093) solve my problem or is there something simpler out there like sliding menus (like the window nemu) or ?? I came out dry on my searches.

I just need an idea (not the how to), and I will be very happy indeed to learn it...

Thanks in advance
(real sorry if this is not the forum to ask this)

 

[brightstar]

have you tried creating custom menu bars?
you could create a cascading menu bar system for something like
report area
report type
report
report
report type
report
report
report area
report type
etc etc

but if you've got loads of reports... maybe populating some combo boxes to give them a way of narrowing down the amount of options you have to display would help?
like:

report area 1 report type 1 report 1
report 2
report type 2 report 3
report area 2
report type 3 report 4
report area 3
report type 4 report 5
report 6
report 7
report 8

any good?

http://www.agonyonline.co.uk

free, anonymous advice provided by the whole world

 

[brightstar]

sorry that didnt come out so well after i submitted it!

http://www.agonyonline.co.uk

free, anonymous advice provided by the whole world

 

[jrbarnett]

DajOne

Why not have a list of reports in a table, structure something like:

ReportName (Primary key)
BusinessUnit Indexed duplicates allowed
Description

Then a form with a combo box in which you display a list of reports, and just

DoCmd.OpenReport Me.cboCombobox, acViewPreview

You can filter on the business unit field to only show relevant reports if needed to avoid people seeing unnecessary items in the box.

John

 

[DajOne]

Thanks to you both, these are very good ideas...

When you look at the tree, you cant see the forest sometimes...

THANKS!!!