+ Reply to Thread
Results 1 to 7 of 7

Registration form - Ideas

  1. #1
    Registered User
    Join Date
    06-28-2010
    Location
    Raleigh
    MS-Off Ver
    Excel 2003
    Posts
    31

    Registration form - Ideas

    Hi.. I am looking for suggestion / guidance on the best approach.

    I have a user form that users can register for classes. They select they name and class they want. They can also go in and delete entry later if they decide not to take class. This works great. I want to make some enhancements. In table that holes the classes I added fields that holds the about of slots available for each class and another field that holds number of slots taken. Then I based a query of that table and added expression to calculate the difference. Basically number of slots remaining.

    The goal is so users can see whether or not class slots are available. Once the max is reached I don't want users to be able to add or signup. But would like them to see if any slots available or not per class.

    Does anyone have any suggestion on this approach? Perhaps a sample code with something similar.

    Thanks in advance.

  2. #2
    Forum Contributor
    Join Date
    06-02-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    146

    Re: Registration form - Ideas

    My suggestion would be to attach what you have so far. We have no idea of your data layout, what userform controls are called or anything about the file you already have. That would mean building something from scratch based on guesswork and potentially the extra time needed to advise you how to adjust anything provided to fit your file.

    Your request for help is unlikely to attract much attention without the example file.

    Beth.

  3. #3
    Registered User
    Join Date
    06-28-2010
    Location
    Raleigh
    MS-Off Ver
    Excel 2003
    Posts
    31

    Re: Registration form - Ideas

    Makes a lot of sense. Attached is my documents in there basic form. Basically user enters student ID and selects class and submit. I would like them to see the available slots when they select a class. If slots available they can submit. Need to some how reduce the classes available as students register for classes. If classes is full, would just like to make that selection visible but just state that it is full.

    Hope this makes sense.

    Thanks to all in advance.
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor
    Join Date
    02-02-2016
    Location
    Indonesia
    MS-Off Ver
    2013
    Posts
    573

    Re: Registration form - Ideas

    Your data is in Access database, so shouldn't this thread be in Access Programming / VBA / Macros section?
    You can ask the moderator to move it there.
    Last edited by Akuini; Yesterday at 08:11 AM.

  5. #5
    Registered User
    Join Date
    06-28-2010
    Location
    Raleigh
    MS-Off Ver
    Excel 2003
    Posts
    31

    Re: Registration form - Ideas

    Thank you... I thought most of the work was done in excel that's why I posted it here. Well go ahead and post to access forum.

  6. #6
    Forum Moderator Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    7,595

    Re: Registration form - Ideas

    No need. I will move the thread
    You really don't have to give me rep points for moderating. It's part of the job. Keep rep points for those who find solutions

  7. #7
    Registered User
    Join Date
    06-28-2010
    Location
    Raleigh
    MS-Off Ver
    Excel 2003
    Posts
    31

    Re: Registration form - Ideas

    Any suggestion for at least incrementing the count in the slot taken field each time someone registers for a class?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1