Best way to design database

[Guest]

Hi all,
I have many forms and reports in my database, and want to manage/access all
of them from the Main form. I wonder what is the best way to open a
form/report from the Main form: Click a button to open every form/report or
keep a table that contains all form/report names, and select the form/report
from the Listbox/Combo Box in the Main form ? I hope this is clear.
Thanks for any idea.

 

[tina]

if you really have *many* forms and reports, i'd probably go with a listbox
format. a main or "menu" form should be quick to navigate, so it shouldn't
be too big - certainly not bigger than the available screen space. and give
some serious thought to how you list those forms and reports in a listbox -
it should be in a logical, predictable pattern, so that users can very
quickly find the object they're after.

hth

 

[Brendan Reynolds]

You might want to think about whether those forms and reports can be divided
into categories. Your main menu form would then have a button for each
category, which would open a sub-menu form with commands to launch forms
and/or reports in that category. For example many of my apps have a main
menu form with just five buttons ...

Edit/View (Main Subject of App Here)
Edit/View Other Items
View/Print Reports
Other Tasks
Exit

 

[Guest]

I use a treeview control with a subform. The node key contains the relevant
form name to open for the selected 'form'.

It used to be a list-box with subform.....

Good Luck!
Steve.

 

[Guest]

Thanks for all ! But I still wonder which technique has the best performance
? In another centence, I want to re-create my DMB file that has smaller size,
memory-saving, and looks professionally.
Best regard.