943,972 Members | Top Members by Rank

Ad:
Jan 24th, 2006
0

Microsoft Access date validation Need a solution

Expand Post »
right when i type the date in a need a validation for

it dusnt allow u to book any less than 7 days in advance from NOW (DATE cz i dont want time included).
If longer then 2 months in advance also dusnt let u

for as computing course work plz reply asap!!!
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
pker walker is offline Offline
8 posts
since Jan 2006
Jan 24th, 2006
0

Re: Microsoft Access date validation Need a solution

ok i've done this in the past.. can't remember exactly how it's done but if you look through your date functions you will see that to add 1 day to your date you simply +1 so put in an if statement (use code builder) that goes something like;

IF inputbox1.date < (date+1) THEN msgbox("please enter in a valid date"), inputbox1.value = date

yes i know that's not gramitically correct as havn't done access for a while but I hope you get the idea?
Reputation Points: 38
Solved Threads: 9
Posting Whiz in Training
suRoot is offline Offline
210 posts
since Apr 2004
Jan 24th, 2006
0

Re: Microsoft Access date validation Need a solution

Quote originally posted by suRoot ...
ok i've done this in the past.. can't remember exactly how it's done but if you look through your date functions you will see that to add 1 day to your date you simply +1 so put in an if statement (use code builder) that goes something like;

IF inputbox1.date < (date+1) THEN msgbox("please enter in a valid date"), inputbox1.value = date

yes i know that's not gramitically correct as havn't done access for a while but I hope you get the idea?
any chance u could find out the proper code for me and my code builder u mean on forms? i was looking for 1 on a table .... so it would be expression builder?
Reputation Points: 10
Solved Threads: 0
Newbie Poster
pker walker is offline Offline
8 posts
since Jan 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Database Design Forum Timeline: New Table Design
Next Thread in Database Design Forum Timeline: Need Help





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC