Access Date & Time Validation Question

Expand Post »

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 6:43 pm.

Similar Threads

Display client's PC Date & Time in ASP.NET
Microsoft Access date validation Need a solution in Computer Science
Microsoft Access date validation Need a solution in Database Design
Access Date Problem in Computer Science
arrange date&time column in MySQL

hvelador

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Sep 2006

Permalink

Dec 24th, 2006

Re: Access Date & Time Validation Question

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.

carolraydon

Reputation Points: 10

Solved Threads: 3

Junior Poster in Training

Offline

57 posts
since Mar 2006

Permalink

Mar 31st, 2007

Re: Access Date & Time Validation Question

Click to Expand / Collapse Quote 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

Rupeshba

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Mar 2007

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: Microsoft Nested If statements with if, then, else

Next Thread in MS Access and FileMaker Pro Forum Timeline: Export data to Excel Template

DaniWeb Message

Cancel Changes

User Name
Password