MS Access and FileMaker...

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

Please support our MS Access and FileMaker Pro advertiser: 50% off 6 Months Dedicated Server Hosting from 1&1!

•

Join Date: Nov 2005

Posts: 1

Reputation: jayboi2005 is an unknown quantity at this point

Solved Threads: 0

jayboi2005 jayboi2005 is offline

Offline

Newbie Poster

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

Nov 19th, 2005

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

•

Join Date: Oct 2005

Posts: 115

Reputation: Kegtapper is an unknown quantity at this point

Solved Threads: 4

Kegtapper

Offline

Junior Poster

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

Nov 24th, 2005

Use [Now] as a default value

•

Join Date: Jan 2006

Posts: 8

Reputation: pker walker is an unknown quantity at this point

Solved Threads: 0

pker walker pker walker is offline

Offline

Newbie Poster

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

Jan 24th, 2006

i also need the validation rule plz can some1 help?

•

Join Date: Oct 2005

Posts: 115

Reputation: Kegtapper is an unknown quantity at this point

Solved Threads: 4

Kegtapper

Offline

Junior Poster

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

Jan 24th, 2006

•

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

Posts: 8

Reputation: pker walker is an unknown quantity at this point

Solved Threads: 0

pker walker pker walker is offline

Offline

Newbie Poster

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

Jan 27th, 2006

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

•

Join Date: Oct 2005

Posts: 115

Reputation: Kegtapper is an unknown quantity at this point

Solved Threads: 4

Kegtapper

Offline

Junior Poster

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

Jan 27th, 2006

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

•

Join Date: Jan 2006

Posts: 8

Reputation: pker walker is an unknown quantity at this point

Solved Threads: 0

pker walker pker walker is offline

Offline

Newbie Poster

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

Jan 28th, 2006

•

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