I'm new with Access but here are my thoughts on your subject....
I would suggest that in these days of faster machines with more RAM that the multi-tasking approach of having several forms open together fits the users requirements better.
However, that said, some people do prefer a clean-cut, one thing open at a time approach... it really depends on the user...
Have you thought about:
- Setup shortcut keys, menus and buttons to open key forms
- Allowing the user to close/open forms that they need (and leave them open if they want) thus customising their own workspace?
- Introducing a time-out effect on some forms, so that they close after a period of inactivity? Taken from this websites TIPs section you could probably amend this procedure...
(First of all you will need to create a macro to execute the Close action on the form.
Now go to the Design View of the Form and open the Properties sheet.
In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 8 seconds enter 8000, for an minute enter 60000.)
- Customise the security level so that on logging into the database the key forms are displayed for that user?
As I say - Im new with Access but these are some ideas that spring to mind...
