By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,101 Members | 1,335 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,101 IT Pros & Developers. It's quick & easy.

Date Validation

P: 8
I am currently creating an access database within it I have a Table which identifies members, I have a field name Guarantor and data type of text iI would like a message to prompt the user to select a guarantor if the member is under 16 years old.
May 13 '07 #1
Share this Question
Share on Google+
5 Replies


JConsulting
Expert 100+
P: 603
I am currently creating an access database within it I have a Table which identifies members, I have a field name Guarantor and data type of text iI would like a message to prompt the user to select a guarantor if the member is under 16 years old.
Do you have a field that holds the birthday as a date?
May 13 '07 #2

P: 8
Yes I do DOB of members
May 13 '07 #3

JConsulting
Expert 100+
P: 603
Yes I do DOB of members
Expand|Select|Wrap|Line Numbers
  1. if DateDiff("yyyy", DOB, Date) <17 then
  2. msgbox"Select someone older"
  3. else
  4. 'your normal code here
  5. end if
  6.  
May 13 '07 #4

P: 8
Expand|Select|Wrap|Line Numbers
  1. if DateDiff("yyyy", DOB, Date) <17 then
  2. msgbox"Select someone older"
  3. else
  4. 'your normal code here
  5. end if
  6.  

Hi

That worked thanks. I'm new to Access and VB so struggling with some of the code (well most of it)

thankyou
May 13 '07 #5

JConsulting
Expert 100+
P: 603
Hi

That worked thanks. I'm new to Access and VB so struggling with some of the code (well most of it)

thankyou
happy to help.
J
May 13 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.