Results 1 to 4 of 4
  1. #1
    Voodeux2014 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Nov 2014
    Location
    Slidell, LA
    Posts
    130

    Design Ideas?

    Here is what I would like to happen, just not sure of which way to approach it to make it the most user friendly.



    This is a Grant database. Current structure:

    frmMain
    cboGrant - allows you to select from currently active Grants in the DB
    lstAuthorizedTrainingProviders - once grant is selected above this listbox automatically to show authorized training providers for this grant
    cboStudent - this combobox allows you to select students that have taken a class with the selected Training Provider for the above lstbox
    lstClassesTaken - automatically populates what classes the student has taken with that company when the student is selected

    frmAddNewGrant
    txtID - autonumber to provide unique identity for grant
    txtGrantName - allows user input to name the grant
    lstTrainingProviders - lists all Training Providers that are in the database
    cmdAddNewGrant - intitiates VBA that adds the Grant information into tbl1Grants as well as adds all selected Training Providers in lstTrainingProviders to tbl2GrantTrainers in order to accurately display information on frmMain

    I would like to know the most user friendly way to be able to have the next step of the cmdAddNewGrant to either pop up a new form that has a listbox for the first selection in lstTrainingProviders in order to select what classes that Training Provider offers under the newly created grant, or a similar option in order to accomplish this task. Any ideas are welcome!

  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
    Maybe use cascading (dependent) combo/list boxes. Common topic in forum. Review http://datapigtechnologies.com/flash...combobox2.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.

  3. #3
    Voodeux2014 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Nov 2014
    Location
    Slidell, LA
    Posts
    130
    I could set it up to after creating the Grant, when adding the company via a combobox you could select the classes and have a cmbButton to either close the form, or save the information and add a new company...that could work.

  4. #4
    NTC is offline VIP
    Windows 7 64bit Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    Your post identifies what is displaying. The foundation of the database are the tables - and these can display in a variety of ways - essentially however you need. I see tables for Grants, Providers, Students, and maybe Classes (not sure about that).

    ....and there seems to be some dependencies inherent between them....which can be accomplished via queries, or lookup fields type or comboboxes - - this will all depend on your real world need both in entering data and finding/reporting on data.....

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

Similar Threads

  1. Replies: 1
    Last Post: 05-13-2015, 02:25 PM
  2. Ideas?
    By Voodeux2014 in forum Forms
    Replies: 8
    Last Post: 12-18-2014, 04:11 PM
  3. Design Ideas
    By ajs112 in forum Access
    Replies: 4
    Last Post: 10-08-2014, 02:35 PM
  4. Need your ideas and help...
    By Daryl2106 in forum Access
    Replies: 8
    Last Post: 04-05-2012, 01:00 PM
  5. Need some ideas
    By amauricio2 in forum Database Design
    Replies: 0
    Last Post: 03-02-2009, 11:03 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