Results 1 to 12 of 12
  1. #1
    JoshuaEir is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2015
    Posts
    28

    Cool Using less screens and clicks.


    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

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    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.

  3. #3
    JoshuaEir is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2015
    Posts
    28
    What types of code needs to be modified? Do you know of a succinct demonstration of this?

    Thanks,
    JoshEir

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    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.

  5. #5
    JoshuaEir is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2015
    Posts
    28
    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!)

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    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.

  7. #7
    JoshuaEir is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2015
    Posts
    28
    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

  8. #8
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    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.

  9. #9
    JoshuaEir is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2015
    Posts
    28
    Well, I was thinking the subform is dependent upon the completion of the parent? form.

  10. #10
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Joshua,

    What are some strategies for simplifying a database program so that it has less clicks and screens?
    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.
    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.

  11. #11
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    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.

  12. #12
    JoshuaEir is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2015
    Posts
    28

    Thanks.

    Thank you June7,

    JoshuaEir

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Login screens with SharePoint
    By JustAnElf in forum SharePoint
    Replies: 3
    Last Post: 03-26-2014, 03:49 AM
  2. Replies: 1
    Last Post: 02-01-2014, 05:27 PM
  3. Print screens or something better
    By crowegreg in forum Database Design
    Replies: 2
    Last Post: 09-17-2013, 12:11 PM
  4. Responding To Clicks On Treeview Nodes
    By Hack in forum Programming
    Replies: 3
    Last Post: 04-12-2012, 06:46 AM
  5. How to not add Record if User clicks a BUTTON
    By taimysho0 in forum Programming
    Replies: 7
    Last Post: 12-06-2011, 10:49 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums