database does not work

Discussion in 'Microsoft Access Forms' started by daniel west, May 19, 2011.

  1. daniel west

    daniel west Guest

    the form i have created has first name, last name and then 20 check
    box options. Also, i want to make sure that they do not pick more than
    4 checkboxes. i need the submit button to check that not more than 4
    checkboxes are checked, i want to save the names and choices, then
    start a new entry and exit
     
    daniel west, May 19, 2011
    #1
    1. Advertisements

  2. On Thu, 19 May 2011 11:50:21 -0700 (PDT), daniel west
    <> wrote:

    >the form i have created has first name, last name and then 20 check
    >box options. Also, i want to make sure that they do not pick more than
    >4 checkboxes. i need the submit button to check that not more than 4
    >checkboxes are checked, i want to save the names and choices, then
    >start a new entry and exit


    Do you have a question, Daniel? You haven't asked one.

    Your database needs to be based on Tables, not starting with your Form. A form
    does not contain data; it's just a window, a tool to let you manage data in
    tables.

    And while your checkbox interface may be tempting - and even may be useful as
    a user interface - it's a very poor choice of a data STORAGE structure. You
    have (it seems) a classic many to many relationship: each Person has one or
    more (up to four?) choices; each of your twenty Choices can be selected by
    zero, one or more People. The proper design for this is three tables:

    People
    PersonID <primary key, perhaps an autonumber>
    LastName
    FirstName
    <other biographical data as appropriate>

    Options
    OptionID <primary key, probably Number manually assigned 1 - 20>
    Option <text, verbal description of this option>

    Choices
    PersonID <who made this choice>
    OptionID <which choice did they make>

    You can then design a Form to fit this data structure... rather than the other
    way around.

    Here are some resources that may help you through the thickets of relational
    database design.

    Jeff Conrad's resources page:
    http://www.accessmvp.com/JConrad/accessjunkie/resources.html

    The Access Web resources page:
    http://www.mvps.org/access/resources/index.html

    Roger Carlson's tutorials, samples and tips:
    http://www.rogersaccesslibrary.com/

    A free tutorial written by Crystal:
    http://allenbrowne.com/casu-22.html

    A video how-to series by Crystal:
    http://www.YouTube.com/user/LearnAccessByCrystal

    MVP Allen Browne's tutorials:
    http://allenbrowne.com/links.html#Tutorials

    --

    John W. Vinson [MVP]
    Microsoft's replacements for these newsgroups:
    http://social.msdn.microsoft.com/Forums/en-US/accessdev/
    http://social.answers.microsoft.com/Forums/en-US/addbuz/
    and see also http://www.utteraccess.com
     
    John W. Vinson, May 19, 2011
    #2
    1. Advertisements

  3. daniel west

    daniel west Guest

    how do i setup a button that saves, quits and checks data.


    On May 19, 4:31 pm, John W. Vinson
    <jvinson@STOP_SPAM.WysardOfInfo.com> wrote:
    > On Thu, 19 May 2011 11:50:21 -0700 (PDT), daniel west
    >
    > <> wrote:
    > >the form i have created has first name, last name and then 20 check
    > >box options. Also, i want to make sure that they do not pick more than
    > >4 checkboxes. i need the submit button to check that not more than 4
    > >checkboxes are checked, i want to save the names and choices, then
    > >start a new entry and exit

    >
    > Do you have a question, Daniel? You haven't asked one.
    >
    > Your database needs to be based on Tables, not starting with your Form. Aform
    > does not contain data; it's just a window, a tool to let you manage data in
    > tables.
    >
    > And while your checkbox interface may be tempting - and even may be useful as
    > a user interface - it's a very poor choice of a data STORAGE structure. You
    > have (it seems) a classic many to many relationship: each Person has one or
    > more (up to four?) choices; each of your twenty Choices can be selected by
    > zero, one or more People. The proper design for this is three tables:
    >
    > People
    >   PersonID <primary key, perhaps an autonumber>
    >   LastName
    >   FirstName
    >   <other biographical data as appropriate>
    >
    > Options
    >   OptionID <primary key, probably Number manually assigned 1 - 20>
    >   Option <text, verbal description of this option>
    >
    > Choices
    >   PersonID <who made this choice>
    >   OptionID <which choice did they make>
    >
    > You can then design a Form to fit this data structure... rather than the other
    > way around.
    >
    > Here are some resources that may help you through the thickets of relational
    > database design.
    >
    > Jeff Conrad's resources page:http://www.accessmvp.com/JConrad/accessjunkie/resources.html
    >
    > The Access Web resources page:http://www.mvps.org/access/resources/index.html
    >
    > Roger Carlson's tutorials, samples and tips:http://www.rogersaccesslibrary.com/
    >
    > A free tutorial written by Crystal:http://allenbrowne.com/casu-22.html
    >
    > A video how-to series by Crystal:http://www.YouTube.com/user/LearnAccessByCrystal
    >
    > MVP Allen Browne's tutorials:http://allenbrowne.com/links.html#Tutorials
    >
    > --
    >
    >              John W. Vinson [MVP]
    >  Microsoft's replacements for these newsgroups:
    >  http://social.msdn.microsoft.com/Forums/en-US/accessdev/
    >  http://social.answers.microsoft.com/Forums/en-US/addbuz/
    >  and see alsohttp://www.utteraccess.com
     
    daniel west, May 21, 2011
    #3
  4. David-W-Fenton, May 21, 2011
    #4
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Jeff
    Replies:
    1
    Views:
    780
    Duane Hookom
    Jul 14, 2003
  2. Guest

    database engine does not recognize as valid field name

    Guest, Nov 9, 2004, in forum: Microsoft Access Forms
    Replies:
    1
    Views:
    392
    Douglas J. Steele
    Nov 10, 2004
  3. Guest

    ASP script does not update Access Database

    Guest, Sep 12, 2006, in forum: Microsoft Access Forms
    Replies:
    1
    Views:
    266
    Brendan Reynolds
    Sep 13, 2006
  4. Guest
    Replies:
    8
    Views:
    320
    Guest
    Nov 14, 2007
  5. Yoshie
    Replies:
    1
    Views:
    157
    Beetle
    Jan 8, 2009
Loading...

Share This Page