Ad:

MS Access and FileMaker Pro Discussion Thread
Unsolved
Views: 8482

Nov 19th, 2005

Any help with a Defult Value and Validation RULE. MICROSOFT ACCESS

Expand Post »

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

Similar Threads

Microsoft Access 2003 Validation Rule in MS Access and FileMaker Pro
MS Access validation rule help in MS Access and FileMaker Pro

jayboi2005

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Nov 2005

Permalink

Nov 24th, 2005

Re: Any help with a Defult Value and Validation RULE. MICROSOFT ACCESS

Use [Now] as a default value

Kegtapper

Reputation Points: 13

Solved Threads: 4

Junior Poster

Offline

115 posts
since Oct 2005

Permalink

Jan 24th, 2006

Re: Any help with a Defult Value and Validation RULE. MICROSOFT ACCESS

i also need the validation rule plz can some1 help?

pker walker

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

8 posts
since Jan 2006

Permalink

Jan 24th, 2006

Re: Any help with a Defult Value and Validation RULE. MICROSOFT ACCESS

Quote originally posted by pker walker ...

i also need the validation rule plz can some1 help?

Quote 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

Kegtapper

Reputation Points: 13

Solved Threads: 4

Junior Poster

Offline

115 posts
since Oct 2005

Permalink

Jan 27th, 2006

Re: Any help with a Defult Value and Validation RULE. MICROSOFT ACCESS

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

pker walker

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

8 posts
since Jan 2006

Permalink

Jan 27th, 2006

Re: Any help with a Defult Value and Validation RULE. MICROSOFT ACCESS

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

Kegtapper

Reputation Points: 13

Solved Threads: 4

Junior Poster

Offline

115 posts
since Oct 2005

Permalink

Jan 28th, 2006

Re: Any help with a Defult Value and Validation RULE. MICROSOFT ACCESS

Quote 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

pker walker

Reputation Points: 10

Solved Threads: 0

Newbie Poster

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.

Previous Thread in MS Access and FileMaker Pro Forum Timeline: need date validation help

Next Thread in MS Access and FileMaker Pro Forum Timeline: Access - Duplicate a number of fields when opening a new form

DaniWeb Message

Cancel Changes

User Name
Password

Any help with a Defult Value and Validation RULE. **MICROSOFT ACCESS**

Re: Any help with a Defult Value and Validation RULE. **MICROSOFT ACCESS**

Re: Any help with a Defult Value and Validation RULE. **MICROSOFT ACCESS**

Re: Any help with a Defult Value and Validation RULE. **MICROSOFT ACCESS**

Re: Any help with a Defult Value and Validation RULE. **MICROSOFT ACCESS**

Re: Any help with a Defult Value and Validation RULE. **MICROSOFT ACCESS**

Re: Any help with a Defult Value and Validation RULE. **MICROSOFT ACCESS**

This thread is more than three months old

Any help with a Defult Value and Validation RULE. MICROSOFT ACCESS

Re: Any help with a Defult Value and Validation RULE. MICROSOFT ACCESS

Re: Any help with a Defult Value and Validation RULE. MICROSOFT ACCESS

Re: Any help with a Defult Value and Validation RULE. MICROSOFT ACCESS

Re: Any help with a Defult Value and Validation RULE. MICROSOFT ACCESS

Re: Any help with a Defult Value and Validation RULE. MICROSOFT ACCESS

Re: Any help with a Defult Value and Validation RULE. MICROSOFT ACCESS