Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

URGENT - access date of birth validation

Discussion in 'Information Technology' started by MINA, Oct 29, 2005.

  1. MINA

    MINA
    Expand Collapse
    Guest

    Hello

    I would like to create a date of birth field where the validation should be

    user enters their date of birth like: 27-11-1969 and the rule should
    calculate if the birth date is younger than 18 or older then 65 if should
    warn and not allow the entry.

    so if I enter 02-04-2000 I should get a warning.

    I am very new to Access I have tried a few things but not sure where to
    write this rule, I assume it will be in the date sheet as a validation rule..

    Millions of thanks
     
  2. Loading...

    Similar Threads Forum Date
    URGENT PLZZ HELP: KAAM LUST BODY MASSAGE SPA ISSUE Sikh Youth Jul 9, 2015
    Sikh News Spate Of Attacks By Islamist Insurgents Rattle Sikh Community In Pakistan Breaking News Apr 19, 2015
    SciTech Urgent Need to Remove Space Debris Breaking News Apr 25, 2013
    Urgent! Need help with some gender equality questions! Questions and Answers Jan 7, 2013
    General URGENT! Video on reality of sexual grooming gangs in the UK - please share Hard Talk Nov 21, 2012

  3. Ofer

    Ofer
    Expand Collapse
    Guest

    Hi Mina
    Open the table in design view, and focus on the date field.
    One of the properties is ValidationRule Property, in it write
    Between DateAdd("yyyy",-18,Date()) And DateAdd("yyyy",-65,Date())

    In the ValidationText Property write the message you want to be displayed
    --
    If I answered your question, please mark it as an answer. That way, it will
    stay saved for a longer time, so other can benifit from it.

    Good luck



    "MINA" wrote:

    > Hello
    >
    > I would like to create a date of birth field where the validation should be
    >
    > user enters their date of birth like: 27-11-1969 and the rule should
    > calculate if the birth date is younger than 18 or older then 65 if should
    > warn and not allow the entry.
    >
    > so if I enter 02-04-2000 I should get a warning.
    >
    > I am very new to Access I have tried a few things but not sure where to
    > write this rule, I assume it will be in the date sheet as a validation rule..
    >
    > Millions of thanks
    >
     
  4. MINA

    MINA
    Expand Collapse
    Guest

    I am so pleased thanks very much I think it works.. now I have to figure out
    how Access to come up with a better promtp when the user enters a value
    outside the rule.. like a caption caming more meaning full etc.. But thanks
    very much..

    Mina

    "Ofer" wrote:

    > Hi Mina
    > Open the table in design view, and focus on the date field.
    > One of the properties is ValidationRule Property, in it write
    > Between DateAdd("yyyy",-18,Date()) And DateAdd("yyyy",-65,Date())
    >
    > In the ValidationText Property write the message you want to be displayed
    > --
    > If I answered your question, please mark it as an answer. That way, it will
    > stay saved for a longer time, so other can benifit from it.
    >
    > Good luck
    >
    >
    >
    > "MINA" wrote:
    >
    > > Hello
    > >
    > > I would like to create a date of birth field where the validation should be
    > >
    > > user enters their date of birth like: 27-11-1969 and the rule should
    > > calculate if the birth date is younger than 18 or older then 65 if should
    > > warn and not allow the entry.
    > >
    > > so if I enter 02-04-2000 I should get a warning.
    > >
    > > I am very new to Access I have tried a few things but not sure where to
    > > write this rule, I assume it will be in the date sheet as a validation rule..
    > >
    > > Millions of thanks
    > >
     
  5. MINA

    MINA
    Expand Collapse
    Guest

    hello

    would you consider giving few hours training on Access 2003 for later today,
    Sat , Sun or Monday in London?

    Thanks

    "Ofer" wrote:

    > As you can see in the prev post, you can use the ValidationText Property to
    > write a message you want to be displayed when there is an error
    > --
    > If I answered your question, please mark it as an answer. That way, it will
    > stay saved for a longer time, so other can benifit from it.
    >
    > Good luck
    >
    >
    >
    > "MINA" wrote:
    >
    > >
    > > I am so pleased thanks very much I think it works.. now I have to figure out
    > > how Access to come up with a better promtp when the user enters a value
    > > outside the rule.. like a caption caming more meaning full etc.. But thanks
    > > very much..
    > >
    > > Mina
    > >
    > > "Ofer" wrote:
    > >
    > > > Hi Mina
    > > > Open the table in design view, and focus on the date field.
    > > > One of the properties is ValidationRule Property, in it write
    > > > Between DateAdd("yyyy",-18,Date()) And DateAdd("yyyy",-65,Date())
    > > >
    > > > In the ValidationText Property write the message you want to be displayed
    > > > --
    > > > If I answered your question, please mark it as an answer. That way, it will
    > > > stay saved for a longer time, so other can benifit from it.
    > > >
    > > > Good luck
    > > >
    > > >
    > > >
    > > > "MINA" wrote:
    > > >
    > > > > Hello
    > > > >
    > > > > I would like to create a date of birth field where the validation should be
    > > > >
    > > > > user enters their date of birth like: 27-11-1969 and the rule should
    > > > > calculate if the birth date is younger than 18 or older then 65 if should
    > > > > warn and not allow the entry.
    > > > >
    > > > > so if I enter 02-04-2000 I should get a warning.
    > > > >
    > > > > I am very new to Access I have tried a few things but not sure where to
    > > > > write this rule, I assume it will be in the date sheet as a validation rule..
    > > > >
    > > > > Millions of thanks
    > > > >
     
  6. Ofer

    Ofer
    Expand Collapse
    Guest

    As you can see in the prev post, you can use the ValidationText Property to
    write a message you want to be displayed when there is an error
    --
    If I answered your question, please mark it as an answer. That way, it will
    stay saved for a longer time, so other can benifit from it.

    Good luck



    "MINA" wrote:

    >
    > I am so pleased thanks very much I think it works.. now I have to figure out
    > how Access to come up with a better promtp when the user enters a value
    > outside the rule.. like a caption caming more meaning full etc.. But thanks
    > very much..
    >
    > Mina
    >
    > "Ofer" wrote:
    >
    > > Hi Mina
    > > Open the table in design view, and focus on the date field.
    > > One of the properties is ValidationRule Property, in it write
    > > Between DateAdd("yyyy",-18,Date()) And DateAdd("yyyy",-65,Date())
    > >
    > > In the ValidationText Property write the message you want to be displayed
    > > --
    > > If I answered your question, please mark it as an answer. That way, it will
    > > stay saved for a longer time, so other can benifit from it.
    > >
    > > Good luck
    > >
    > >
    > >
    > > "MINA" wrote:
    > >
    > > > Hello
    > > >
    > > > I would like to create a date of birth field where the validation should be
    > > >
    > > > user enters their date of birth like: 27-11-1969 and the rule should
    > > > calculate if the birth date is younger than 18 or older then 65 if should
    > > > warn and not allow the entry.
    > > >
    > > > so if I enter 02-04-2000 I should get a warning.
    > > >
    > > > I am very new to Access I have tried a few things but not sure where to
    > > > write this rule, I assume it will be in the date sheet as a validation rule..
    > > >
    > > > Millions of thanks
    > > >
     
  7. Ofer

    Ofer
    Expand Collapse
    Guest

    Supply a return ticket and I'm there.

    mybe next time, but thanks for the offer
    Ofer

    Good luck



    "MINA" wrote:

    >
    > hello
    >
    > would you consider giving few hours training on Access 2003 for later today,
    > Sat , Sun or Monday in London?
    >
    > Thanks
    >
    > "Ofer" wrote:
    >
    > > As you can see in the prev post, you can use the ValidationText Property to
    > > write a message you want to be displayed when there is an error
    > > --
    > > If I answered your question, please mark it as an answer. That way, it will
    > > stay saved for a longer time, so other can benifit from it.
    > >
    > > Good luck
    > >
    > >
    > >
    > > "MINA" wrote:
    > >
    > > >
    > > > I am so pleased thanks very much I think it works.. now I have to figure out
    > > > how Access to come up with a better promtp when the user enters a value
    > > > outside the rule.. like a caption caming more meaning full etc.. But thanks
    > > > very much..
    > > >
    > > > Mina
    > > >
    > > > "Ofer" wrote:
    > > >
    > > > > Hi Mina
    > > > > Open the table in design view, and focus on the date field.
    > > > > One of the properties is ValidationRule Property, in it write
    > > > > Between DateAdd("yyyy",-18,Date()) And DateAdd("yyyy",-65,Date())
    > > > >
    > > > > In the ValidationText Property write the message you want to be displayed
    > > > > --
    > > > > If I answered your question, please mark it as an answer. That way, it will
    > > > > stay saved for a longer time, so other can benifit from it.
    > > > >
    > > > > Good luck
    > > > >
    > > > >
    > > > >
    > > > > "MINA" wrote:
    > > > >
    > > > > > Hello
    > > > > >
    > > > > > I would like to create a date of birth field where the validation should be
    > > > > >
    > > > > > user enters their date of birth like: 27-11-1969 and the rule should
    > > > > > calculate if the birth date is younger than 18 or older then 65 if should
    > > > > > warn and not allow the entry.
    > > > > >
    > > > > > so if I enter 02-04-2000 I should get a warning.
    > > > > >
    > > > > > I am very new to Access I have tried a few things but not sure where to
    > > > > > write this rule, I assume it will be in the date sheet as a validation rule..
    > > > > >
    > > > > > Millions of thanks
    > > > > >
     
  8. MINA

    MINA
    Expand Collapse
    Guest

    where are you based please?

    Thanks

    "Ofer" wrote:

    > Supply a return ticket and I'm there.
    >
    > mybe next time, but thanks for the offer
    > Ofer
    >
    > Good luck
    >
    >
    >
    > "MINA" wrote:
    >
    > >
    > > hello
    > >
    > > would you consider giving few hours training on Access 2003 for later today,
    > > Sat , Sun or Monday in London?
    > >
    > > Thanks
    > >
    > > "Ofer" wrote:
    > >
    > > > As you can see in the prev post, you can use the ValidationText Property to
    > > > write a message you want to be displayed when there is an error
    > > > --
    > > > If I answered your question, please mark it as an answer. That way, it will
    > > > stay saved for a longer time, so other can benifit from it.
    > > >
    > > > Good luck
    > > >
    > > >
    > > >
    > > > "MINA" wrote:
    > > >
    > > > >
    > > > > I am so pleased thanks very much I think it works.. now I have to figure out
    > > > > how Access to come up with a better promtp when the user enters a value
    > > > > outside the rule.. like a caption caming more meaning full etc.. But thanks
    > > > > very much..
    > > > >
    > > > > Mina
    > > > >
    > > > > "Ofer" wrote:
    > > > >
    > > > > > Hi Mina
    > > > > > Open the table in design view, and focus on the date field.
    > > > > > One of the properties is ValidationRule Property, in it write
    > > > > > Between DateAdd("yyyy",-18,Date()) And DateAdd("yyyy",-65,Date())
    > > > > >
    > > > > > In the ValidationText Property write the message you want to be displayed
    > > > > > --
    > > > > > If I answered your question, please mark it as an answer. That way, it will
    > > > > > stay saved for a longer time, so other can benifit from it.
    > > > > >
    > > > > > Good luck
    > > > > >
    > > > > >
    > > > > >
    > > > > > "MINA" wrote:
    > > > > >
    > > > > > > Hello
    > > > > > >
    > > > > > > I would like to create a date of birth field where the validation should be
    > > > > > >
    > > > > > > user enters their date of birth like: 27-11-1969 and the rule should
    > > > > > > calculate if the birth date is younger than 18 or older then 65 if should
    > > > > > > warn and not allow the entry.
    > > > > > >
    > > > > > > so if I enter 02-04-2000 I should get a warning.
    > > > > > >
    > > > > > > I am very new to Access I have tried a few things but not sure where to
    > > > > > > write this rule, I assume it will be in the date sheet as a validation rule..
    > > > > > >
    > > > > > > Millions of thanks
    > > > > > >
     
  9. MINA

    MINA
    Expand Collapse
    Guest

    NI number - validation

    Hello

    A new question on NI numbers and validation assuming below

    National Insurance Number
    1. Must be 9 characters.
    2. First 2 characters must be alpha.
    3. Next 6 characters must be numeric.
    4. Final character can be A, B, C, D or space.
    5. First character must not be D,F,I,Q,U or V
    6. Second characters must not be D, F, I, O, Q, U or V.
    7. First 2 characters must not be combinations of GB, NK, TN or ZZ (the term
    combinations covers both GB and BG etc.)

    and how do I write a validation rule on this!!! Sorry for the stream of
    questions...

    Thanks

    "MINA" wrote:

    >
    > where are you based please?
    >
    > Thanks
    >
    > "Ofer" wrote:
    >
    > > Supply a return ticket and I'm there.
    > >
    > > mybe next time, but thanks for the offer
    > > Ofer
    > >
    > > Good luck
    > >
    > >
    > >
    > > "MINA" wrote:
    > >
    > > >
    > > > hello
    > > >
    > > > would you consider giving few hours training on Access 2003 for later today,
    > > > Sat , Sun or Monday in London?
    > > >
    > > > Thanks
    > > >
    > > > "Ofer" wrote:
    > > >
    > > > > As you can see in the prev post, you can use the ValidationText Property to
    > > > > write a message you want to be displayed when there is an error
    > > > > --
    > > > > If I answered your question, please mark it as an answer. That way, it will
    > > > > stay saved for a longer time, so other can benifit from it.
    > > > >
    > > > > Good luck
    > > > >
    > > > >
    > > > >
    > > > > "MINA" wrote:
    > > > >
    > > > > >
    > > > > > I am so pleased thanks very much I think it works.. now I have to figure out
    > > > > > how Access to come up with a better promtp when the user enters a value
    > > > > > outside the rule.. like a caption caming more meaning full etc.. But thanks
    > > > > > very much..
    > > > > >
    > > > > > Mina
    > > > > >
    > > > > > "Ofer" wrote:
    > > > > >
    > > > > > > Hi Mina
    > > > > > > Open the table in design view, and focus on the date field.
    > > > > > > One of the properties is ValidationRule Property, in it write
    > > > > > > Between DateAdd("yyyy",-18,Date()) And DateAdd("yyyy",-65,Date())
    > > > > > >
    > > > > > > In the ValidationText Property write the message you want to be displayed
    > > > > > > --
    > > > > > > If I answered your question, please mark it as an answer. That way, it will
    > > > > > > stay saved for a longer time, so other can benifit from it.
    > > > > > >
    > > > > > > Good luck
    > > > > > >
    > > > > > >
    > > > > > >
    > > > > > > "MINA" wrote:
    > > > > > >
    > > > > > > > Hello
    > > > > > > >
    > > > > > > > I would like to create a date of birth field where the validation should be
    > > > > > > >
    > > > > > > > user enters their date of birth like: 27-11-1969 and the rule should
    > > > > > > > calculate if the birth date is younger than 18 or older then 65 if should
    > > > > > > > warn and not allow the entry.
    > > > > > > >
    > > > > > > > so if I enter 02-04-2000 I should get a warning.
    > > > > > > >
    > > > > > > > I am very new to Access I have tried a few things but not sure where to
    > > > > > > > write this rule, I assume it will be in the date sheet as a validation rule..
    > > > > > > >
    > > > > > > > Millions of thanks
    > > > > > > >
     
  10. Ofer

    Ofer
    Expand Collapse
    Guest

    RE: NI number - validation

    Israel,

    Now about your other question, are you serious?
    If you are, I wont be able to help you today, you can start a new post,
    there are amazing people here that I'm sure will help you.
    If no luck then I will be able to come back to you tomorow

    Sorry
    Good luck



    "MINA" wrote:

    > Hello
    >
    > A new question on NI numbers and validation assuming below
    >
    > National Insurance Number
    > 1. Must be 9 characters.
    > 2. First 2 characters must be alpha.
    > 3. Next 6 characters must be numeric.
    > 4. Final character can be A, B, C, D or space.
    > 5. First character must not be D,F,I,Q,U or V
    > 6. Second characters must not be D, F, I, O, Q, U or V.
    > 7. First 2 characters must not be combinations of GB, NK, TN or ZZ (the term
    > combinations covers both GB and BG etc.)
    >
    > and how do I write a validation rule on this!!! Sorry for the stream of
    > questions...
    >
    > Thanks
    >
    > "MINA" wrote:
    >
    > >
    > > where are you based please?
    > >
    > > Thanks
    > >
    > > "Ofer" wrote:
    > >
    > > > Supply a return ticket and I'm there.
    > > >
    > > > mybe next time, but thanks for the offer
    > > > Ofer
    > > >
    > > > Good luck
    > > >
    > > >
    > > >
    > > > "MINA" wrote:
    > > >
    > > > >
    > > > > hello
    > > > >
    > > > > would you consider giving few hours training on Access 2003 for later today,
    > > > > Sat , Sun or Monday in London?
    > > > >
    > > > > Thanks
    > > > >
    > > > > "Ofer" wrote:
    > > > >
    > > > > > As you can see in the prev post, you can use the ValidationText Property to
    > > > > > write a message you want to be displayed when there is an error
    > > > > > --
    > > > > > If I answered your question, please mark it as an answer. That way, it will
    > > > > > stay saved for a longer time, so other can benifit from it.
    > > > > >
    > > > > > Good luck
    > > > > >
    > > > > >
    > > > > >
    > > > > > "MINA" wrote:
    > > > > >
    > > > > > >
    > > > > > > I am so pleased thanks very much I think it works.. now I have to figure out
    > > > > > > how Access to come up with a better promtp when the user enters a value
    > > > > > > outside the rule.. like a caption caming more meaning full etc.. But thanks
    > > > > > > very much..
    > > > > > >
    > > > > > > Mina
    > > > > > >
    > > > > > > "Ofer" wrote:
    > > > > > >
    > > > > > > > Hi Mina
    > > > > > > > Open the table in design view, and focus on the date field.
    > > > > > > > One of the properties is ValidationRule Property, in it write
    > > > > > > > Between DateAdd("yyyy",-18,Date()) And DateAdd("yyyy",-65,Date())
    > > > > > > >
    > > > > > > > In the ValidationText Property write the message you want to be displayed
    > > > > > > > --
    > > > > > > > If I answered your question, please mark it as an answer. That way, it will
    > > > > > > > stay saved for a longer time, so other can benifit from it.
    > > > > > > >
    > > > > > > > Good luck
    > > > > > > >
    > > > > > > >
    > > > > > > >
    > > > > > > > "MINA" wrote:
    > > > > > > >
    > > > > > > > > Hello
    > > > > > > > >
    > > > > > > > > I would like to create a date of birth field where the validation should be
    > > > > > > > >
    > > > > > > > > user enters their date of birth like: 27-11-1969 and the rule should
    > > > > > > > > calculate if the birth date is younger than 18 or older then 65 if should
    > > > > > > > > warn and not allow the entry.
    > > > > > > > >
    > > > > > > > > so if I enter 02-04-2000 I should get a warning.
    > > > > > > > >
    > > > > > > > > I am very new to Access I have tried a few things but not sure where to
    > > > > > > > > write this rule, I assume it will be in the date sheet as a validation rule..
    > > > > > > > >
    > > > > > > > > Millions of thanks
    > > > > > > > >
     
  11. MINA

    MINA
    Expand Collapse
    Guest

    RE: NI number - validation

    Hi

    Wow.. you are far! not sure if I can afford the fare..

    I had problems starting a new post but just now have created one.. Anyway..
    so we will see what happens.. Your answers for tomorrow will be OK too..

    Thanks again

    Mina

    "Ofer" wrote:

    > Israel,
    >
    > Now about your other question, are you serious?
    > If you are, I wont be able to help you today, you can start a new post,
    > there are amazing people here that I'm sure will help you.
    > If no luck then I will be able to come back to you tomorow
    >
    > Sorry
    > Good luck
    >
    >
    >
    > "MINA" wrote:
    >
    > > Hello
    > >
    > > A new question on NI numbers and validation assuming below
    > >
    > > National Insurance Number
    > > 1. Must be 9 characters.
    > > 2. First 2 characters must be alpha.
    > > 3. Next 6 characters must be numeric.
    > > 4. Final character can be A, B, C, D or space.
    > > 5. First character must not be D,F,I,Q,U or V
    > > 6. Second characters must not be D, F, I, O, Q, U or V.
    > > 7. First 2 characters must not be combinations of GB, NK, TN or ZZ (the term
    > > combinations covers both GB and BG etc.)
    > >
    > > and how do I write a validation rule on this!!! Sorry for the stream of
    > > questions...
    > >
    > > Thanks
    > >
    > > "MINA" wrote:
    > >
    > > >
    > > > where are you based please?
    > > >
    > > > Thanks
    > > >
    > > > "Ofer" wrote:
    > > >
    > > > > Supply a return ticket and I'm there.
    > > > >
    > > > > mybe next time, but thanks for the offer
    > > > > Ofer
    > > > >
    > > > > Good luck
    > > > >
    > > > >
    > > > >
    > > > > "MINA" wrote:
    > > > >
    > > > > >
    > > > > > hello
    > > > > >
    > > > > > would you consider giving few hours training on Access 2003 for later today,
    > > > > > Sat , Sun or Monday in London?
    > > > > >
    > > > > > Thanks
    > > > > >
    > > > > > "Ofer" wrote:
    > > > > >
    > > > > > > As you can see in the prev post, you can use the ValidationText Property to
    > > > > > > write a message you want to be displayed when there is an error
    > > > > > > --
    > > > > > > If I answered your question, please mark it as an answer. That way, it will
    > > > > > > stay saved for a longer time, so other can benifit from it.
    > > > > > >
    > > > > > > Good luck
    > > > > > >
    > > > > > >
    > > > > > >
    > > > > > > "MINA" wrote:
    > > > > > >
    > > > > > > >
    > > > > > > > I am so pleased thanks very much I think it works.. now I have to figure out
    > > > > > > > how Access to come up with a better promtp when the user enters a value
    > > > > > > > outside the rule.. like a caption caming more meaning full etc.. But thanks
    > > > > > > > very much..
    > > > > > > >
    > > > > > > > Mina
    > > > > > > >
    > > > > > > > "Ofer" wrote:
    > > > > > > >
    > > > > > > > > Hi Mina
    > > > > > > > > Open the table in design view, and focus on the date field.
    > > > > > > > > One of the properties is ValidationRule Property, in it write
    > > > > > > > > Between DateAdd("yyyy",-18,Date()) And DateAdd("yyyy",-65,Date())
    > > > > > > > >
    > > > > > > > > In the ValidationText Property write the message you want to be displayed
    > > > > > > > > --
    > > > > > > > > If I answered your question, please mark it as an answer. That way, it will
    > > > > > > > > stay saved for a longer time, so other can benifit from it.
    > > > > > > > >
    > > > > > > > > Good luck
    > > > > > > > >
    > > > > > > > >
    > > > > > > > >
    > > > > > > > > "MINA" wrote:
    > > > > > > > >
    > > > > > > > > > Hello
    > > > > > > > > >
    > > > > > > > > > I would like to create a date of birth field where the validation should be
    > > > > > > > > >
    > > > > > > > > > user enters their date of birth like: 27-11-1969 and the rule should
    > > > > > > > > > calculate if the birth date is younger than 18 or older then 65 if should
    > > > > > > > > > warn and not allow the entry.
    > > > > > > > > >
    > > > > > > > > > so if I enter 02-04-2000 I should get a warning.
    > > > > > > > > >
    > > > > > > > > > I am very new to Access I have tried a few things but not sure where to
    > > > > > > > > > write this rule, I assume it will be in the date sheet as a validation rule..
    > > > > > > > > >
    > > > > > > > > > Millions of thanks
    > > > > > > > > >
     

Share This Page