•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 375,245 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,192 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 MS Access and FileMaker Pro advertiser:
Views: 6613 | Replies: 6
 |
•
•
Join Date: Nov 2005
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Any help with a Defult Value and Validation RULE. **MICROSOFT ACCESS** Hi i am creating a database im ok, just havent used it for years and years. I need a defult value which will add todays date. And a validation Rule that will prevent date entries prior to 1/1/2002
Can anyone please help me!! Thanks Jay
AND MY INPUT MASK IS SHORT DATE
Can anyone please help me!! Thanks Jay
AND MY INPUT MASK IS SHORT DATE
•
•
Join Date: Oct 2005
Location: Charlotte,NC
Posts: 85
Reputation:
Rep Power: 3
Solved Threads: 2
Junior Poster in Training
Use [Now] as a default value
•
•
Join Date: Jan 2006
Location: england
Posts: 8
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
i also need the validation rule plz can some1 help?
•
•
Join Date: Oct 2005
Location: Charlotte,NC
Posts: 85
Reputation:
Rep Power: 3
Solved Threads: 2
Junior Poster in Training
Re: Any help with a Defult Value and Validation RULE. **MICROSOFT ACCESS** •
•
•
•
Originally Posted by pker walker
i also need the validation rule plz can some1 help?
•
•
•
•
Originally Posted by pker walker
i also need the validation rule plz can some1 help?
Format mm/dd/yy
Default Value Date$()
Validation Rule =[Text8]>#12/31/01#
The validation rule is used under properties of the TEXT8.text
http://www.kegtapper.net/images/Validation.jpg
And that will produce this error
http://www.kegtapper.net/images/ErrorMsg.jpg
•
•
Join Date: Jan 2006
Location: england
Posts: 8
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
set default value as ="date"() if his doesnt work
also if he isnt american he wont want the date format u have specified in post above
also if he isnt american he wont want the date format u have specified in post above
•
•
Join Date: Oct 2005
Location: Charlotte,NC
Posts: 85
Reputation:
Rep Power: 3
Solved Threads: 2
Junior Poster in Training
his text "Hi i am creating a database im ok, just havent used it for years and years. I need a defult value which will add todays date. And a validation Rule that will prevent date entries prior to 1/1/2002"
Wanted American format
Wanted American format
•
•
Join Date: Jan 2006
Location: england
Posts: 8
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by Kegtapper
his text "Hi i am creating a database im ok, just havent used it for years and years. I need a defult value which will add todays date. And a validation Rule that will prevent date entries prior to 1/1/2002"
Wanted American format
1/1/2002 can also be uk
lmao |
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
Linear Mode
•
•
•
•
access activation advertising ajax antivirus apple asp c# code computer console crack development drm exploit firefox game google internet ip ipod key linux mac malware microsoft mozilla mp3 news office open operating os pc photo product security software source spyware survey system upgrade virus vista web windows xbox 360 xp zune
- Microsoft Access 2003 Validation Rule (MS Access and FileMaker Pro)
- MS Access validation rule help (MS Access and FileMaker Pro)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: need date validation help
- Next Thread: Access - Duplicate a number of fields when opening a new form
