•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 360,994 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,477 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Database Design advertiser:
Views: 4453 | Replies: 2
 |
•
•
Join Date: Jan 2006
Location: england
Posts: 8
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
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!!!
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!!!
•
•
Join Date: Apr 2004
Posts: 207
Reputation:
Rep Power: 5
Solved Threads: 6
Posting Whiz in Training
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?
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?
•
•
•
•
NIKE just mod it!
HND Business IT
CCNA
MSCE
•
•
Join Date: Jan 2006
Location: england
Posts: 8
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
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? |
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Database Design Marketplace
Linear Mode
•
•
•
•
access advertising antivirus apple c# code computer console daniweb database design development drm exploit firefox game google internet ip ipod key linux malware microsoft mobile mozilla mp3 news office open operating os pc photo research security serial server software spyware survey system upgrade virus vista web windows xbox 360 xp zune
- Microsoft Access 2003 Validation Rule (MS Access and FileMaker Pro)
- Microsoft Access date validation Need a solution (Computer Science and Software Design)
- Microsoft Access date validation (Computer Science and Software Design)
Other Threads in the Database Design Forum
- Previous Thread: New Table Design
- Next Thread: Need Help
