Results 1 to 5 of 5
  1. #1
    drd0spt is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Feb 2014
    Posts
    3

    Question about Validation Rule

    I have a DBo save existing students on exams,

    5 tables:

    Students
    Courses
    Module
    Discipline
    Registration



    on the Registration i have the follow fields to fill:

    Course(existent course from the course table) || (lookup field from course)
    Student(Existent Student from the student table) || (lookup field from student)
    Module(Existent module from the module table) || (lookup field from module)
    Discipline(Existent discipline from the discipline table) || (lookup field from module)
    Done(yes or no field to know)


    i need a validation rule to validate that the same student cant register two times in a row in the same course/module/discipline .

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849
    Why a Validation rule? Why can't you use some logic in the BeforeUpdate to ensure this.

  3. #3
    John_G is offline VIP
    Windows XP Access 2003
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    Hi -

    The first question I have is: why can't a student register in the same course/module/discipline more than once? What happens if they fail on the first try? Or is it only twice in a row that they cannot do, but twice with a break in between is OK?

    I am also not sure that your table structure is correct - are students able to be in two different disciplines or two different modules at the same time? If you have shown the complete structure of your Registration table, then you need more fields in it I think.

    Can you clarify, please?

    John

  4. #4
    drd0spt is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Feb 2014
    Posts
    3
    Quote Originally Posted by orange View Post
    Why a Validation rule? Why can't you use some logic in the BeforeUpdate to ensure this.
    how do i do that ?

  5. #5
    drd0spt is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Feb 2014
    Posts
    3
    Quote Originally Posted by John_G View Post
    Hi -

    The first question I have is: why can't a student register in the same course/module/discipline more than once? What happens if they fail on the first try? Or is it only twice in a row that they cannot do, but twice with a break in between is OK?

    I am also not sure that your table structure is correct - are students able to be in two different disciplines or two different modules at the same time? If you have shown the complete structure of your Registration table, then you need more fields in it I think.

    Can you clarify, please?

    John

    Well you are right is it possible to put a alert box saying (look you have register for this before)

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

Similar Threads

  1. Validation rule question
    By julius in forum Access
    Replies: 0
    Last Post: 02-25-2012, 04:10 PM
  2. Validation Rule
    By rbiggs in forum Forms
    Replies: 4
    Last Post: 08-23-2011, 05:24 PM
  3. Validation Rule
    By ritzzy in forum Access
    Replies: 1
    Last Post: 04-13-2011, 01:33 PM
  4. Help with validation rule
    By Desstro in forum Programming
    Replies: 5
    Last Post: 02-27-2011, 08:05 PM
  5. Validation Rule
    By smitstev in forum Access
    Replies: 5
    Last Post: 06-30-2009, 09:58 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