Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Nov 2001
    Location
    Burbank, Illinois, USA
    Posts
    55
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access 2000 Tables/Forms interacting w/ Front Page (2000 )

    Hello
    We set up a form in Front Page which the students will fill out for career day. We will have 6 different sessions in which different classes will go to the web page to enter their choices. This information will then filter back to an Access database. The table in Access will have a drop down box for Session and one for Career. What I need help with is, for example, for the career of Doctor, we only want 20 students to be able choose it per session. Then, for the 21st student, we want a message to pop up saying something like "You must choose another career. The limit for this choice have been reached". My question is, how do I set up the limit for each choice the students will choose?
    Any help you may give me will be greatly appreciated.

    Thanks
    Wendy

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access 2000 Tables/Forms interacting w/ Front Page (2000 )

    Please post any responses to this question in this thread
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •