Best way to design database

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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
 
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.
 
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.
 
Back
Top