I need to organize forms to use less screens and less clicks. I am wondering if this would be done using subforms. Is there a way to drag a form onto another form and the forms will continue to work?
I am using Access 2007.
Thank you, JoshuaEir
I need to organize forms to use less screens and less clicks. I am wondering if this would be done using subforms. Is there a way to drag a form onto another form and the forms will continue to work?
I am using Access 2007.
Thank you, JoshuaEir
What do you mean by 'continue to work' - some code might have to be modified.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
What types of code needs to be modified? Do you know of a succinct demonstration of this?
Thanks,
JoshEir
Depends on the code you have, if any. Test it and see what breaks. Case-by-case analysis.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I'm assuming from your response it is a simple drag to a control? The Access computer is not accessible until Monday.
JoshuaEir
Anyone? (I just think that would be so cool!)
A subform can be created by dragging a form onto another form. Another way is to drag subform/subreport control from Design ribbon and set the control's SourceObject property.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
What are some strategies for simplifying a database program so that it has less clicks and screens? I was considering using subforms but now I am wondering how this would actually be done. I was thinking that until the button is pressed on the containing form the subform would have disabled controls and when the containing form's button was pressed the subform's controls would have the enabled controls and the containing form controls would be disabled. What other ways are there?
Thank You,
JoshuaEir
Form/subform may mean less 'screens' but not necessarily less clicks - still have to click to move between subforms. I don't have code that enables/disables controls just because of change in focus. Don't really see what benefit that offers.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Well, I was thinking the subform is dependent upon the completion of the parent? form.
Joshua,
The best strategy most of the time is to have a full and complete description of the business issue/opportunity in plain simple English. Identify the business rules involved. Create a data model showing proposed tables and relationships. Create test data and scenarios and test them against the data model. Make sure it all works on paper before building the database. Now that you know the business rules are satisfied by the evolving model, use it to build the database and interfaces. Don't jump into Access or any dbms too quickly.What are some strategies for simplifying a database program so that it has less clicks and screens?
Much like building a house, or airplane or shopping center ---analyze requirements, design a few models to ensure it meets expectations, create a blueprint, build...
Good luck.
Yes, subform container could be disabled until main form record is completed. This would only be useful when moving to new record on main form - to prevent user clicking into subform and entering data without parent record committed. I often forget about this form/subform dependency because most of the databases I've built don't have this issue. I do have one where I could see this might be useful but there is zero code in that little db so we just educate the users not to enter into subforms without main form data.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thank you June7,
JoshuaEir