0

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!!!

2
Contributors
2
Replies
3
Views
11 Years
Discussion Span
Last Post by pker walker
0

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?

0

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?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.