Access Date & Time Validation Question

•

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 425,928 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 1,671 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.

Join our community!

Please support our MS Access and FileMaker Pro advertiser: Programming Forums

Thread Tools Display Modes

Views: 4732 | Replies: 2

•

Join Date: Sep 2006

Location: Dallas, TX

Posts: 1

Reputation: hvelador is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

hvelador

Offline

Newbie Poster

Access Date & Time Validation Question

Sep 14th, 2006

Hello everyone, I have an Access question.

I have two date fields (field 1 & field 2), and both are formatted for "General Date". Since they are used in a calculation of Date and time, I need both segments to be entered.

What expression can I input into the "Validation Rule" field in the "Field Properties" section of the Design View page so that the rule doesn't allow data unless it is mm/dd/yyyy hh:mm am/pm? The users are entering one part or another, but not both, and I would like to prevent that. I have seen validation rules for date or time, but not both.

Suggestions are welcome.

Thanks again,

Regards,

Horacio

Last edited by hvelador : Sep 14th, 2006 at 5:43 pm.

•

Join Date: Mar 2006

Location: Moorea, French Polynesia

Posts: 56

Reputation: carolraydon is an unknown quantity at this point

Rep Power: 3

Solved Threads: 3

carolraydon carolraydon is offline

Offline

Junior Poster in Training

Re: Access Date & Time Validation Question

Dec 23rd, 2006

You can specify how the date & time (or whatever) are entered by entering it in "input mask". It can be really frustrating for some people, though, because their input will be refused until they get it right. Give them an example if possible.

•

Join Date: Mar 2007

Posts: 4

Reputation: Rupeshba is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

Rupeshba

Offline

Newbie Poster

Re: Access Date & Time Validation Question

Mar 31st, 2007

•

Originally Posted by hvelador

Hello everyone, I have an Access question.

I have two date fields (field 1 & field 2), and both are formatted for "General Date". Since they are used in a calculation of Date and time, I need both segments to be entered.

What expression can I input into the "Validation Rule" field in the "Field Properties" section of the Design View page so that the rule doesn't allow data unless it is mm/dd/yyyy hh:mm am/pm? The users are entering one part or another, but not both, and I would like to prevent that. I have seen validation rules for date or time, but not both.

Suggestions are welcome.

Thanks again,

Regards,

Horacio

Hi...

u can make ur own "input mask" in the design field
open the side button which is on right of the input mask:
Follow this

Edit List
Make Add new by pressing "*"

Description: New Format "depend upon u...."
Input Mask: 00/00/0000 00:00 >LL
Place Holder: _
Sample Data: 03/30/2007 10:30 AM
Mask Type: Date-Time

Click Close
Next
Finish

'' that means u r fixing the format the that particular field"

Try this and reply me.. is problem

bye....
Rupesh