Results 1 to 7 of 7
  1. #1
    Amyfb is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Mar 2021
    Posts
    60

    Diagramming the Forms build workflow - a draft attempt

    I'd like to know if the forms build workflow can be modeled along the lines of this diagram.



    My brain wants a nice sequence of steps to execute.

    All the tutorials I watch bounce all around the different components of forms design and it's proving near to impossible for me to weed out the 'don't do the way i just showed you , do it this way instead'.

    I've built forms, and some of them have working pieces. But anything that requires a conditional is where I can't figure out how to make all the right bits and then stitch them together.

    Does this diagram help anyone to follow my thinking? This is what I think I've learned from all my studying so far. If it's correct, then it feels like I should be pretty close to enlightenment. Especially about those pesky variables I've been nattering on about in another thread. If it's wrong and someone can explain further, even better. For any useful idea, I'll be grateful beyond words.

    formsPlanning.pdf

    cheerios
    amyfb

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,352
    I've never used anything like this, except maybe in my head. If it helps you to put it on paper, then use it.

    What do you mean by 'requires a conditional' - filtered data for forms and comboboxes?
    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
    Amyfb is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Mar 2021
    Posts
    60
    Quote Originally Posted by June7 View Post
    I've never used anything like this, except maybe in my head. If it helps you to put it on paper, then use it.

    What do you mean by 'requires a conditional' - filtered data for forms and comboboxes?
    requires a conditional is about if something is selected or not, or, which something is selected from an option group.

    do you have anything in your head about a sequence of design events that you can share? do you do one control at a time, or do you write up all the functions first, or anything like that?

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,352
    I would probably create form and place the controls I expect are needed then tackle coding one event at a time, making sure it works before moving to next.

    Still not sure what you mean be 'requires a conditional' - something like filtering a report based on selection in combobox or option group?

    Maybe this will help http://allenbrowne.com/ser-62.html
    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
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    9,653
    I think you're over complicating things but that's just my opinion. Also seems like you'd put in a lot of time just getting a flow chart (?) correct, only to find when you build the form it doesn't do what you thought it would. That makes the plan document obsolete? However, it's not an opinion to say that a textbox has no rowsource property and an optiongroup has no OnChange event so not sure what effect such errors could have on the plan. In those two cases, probably nothing as there are alternatives.

    To each their own, I guess but I would not spend the time to create such charts.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    Iím telling everyone it's good to eat dried grapes. Itís all about raisin awareness.

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,352
    I remember diagramming work processes in flow charts in Introduction to Computing 101 about 50 years ago. Surely flow charting still has usefulness in planning but hardly seems worth effort at form design level.
    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
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    1,316
    Amy,
    See if anything here can help you?
    http://msaccessgurus.com/tools.htm?f...H5bByhkVtzwqTc
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?search_query=debug+access+vba



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

Similar Threads

  1. Table design for a dates driven workflow in Access
    By mbenton in forum Database Design
    Replies: 6
    Last Post: 05-03-2016, 08:39 AM
  2. Replies: 7
    Last Post: 12-10-2013, 02:45 PM
  3. first attempt to build a database but need alot of help !
    By komet122 in forum Database Design
    Replies: 3
    Last Post: 03-07-2013, 12:09 PM
  4. Is this redundant? NFL Draft DB
    By GenericHbomb in forum Database Design
    Replies: 2
    Last Post: 08-01-2011, 09:46 AM
  5. Replies: 1
    Last Post: 04-01-2011, 01:28 PM

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