MS Access Validation Rule Desperate help needed

[Kushika 0]

I have to create a whole project using Microfost Access. I have a field which will eventaually contain details of a a list of people's DOBs. I have added an input mask, so that it it displays the place holder __/__/____However, how can I validate this field. For example, not it is possible to type 30/10/1991 [dd/mm/yyyy]. How can this be changed so that it validates it correctly?

[yordan 10]

Doesn't this : http://forums.xisto.com/topic/89052-topic/?findpost=1064340413
look like what you wanted ?

[Kushika 0]

No, I need a validation rule to be in Access; my db isn't connected to a website ibn any way.

[iGuest 3]

Table not reading the text box from the FormMS Access Validation Rule

Hello,

On my form I created an automated Text box (Posting Status) that is reading the date of the Expiration Date field (PostingExpiration), comparing it to today date (TextNow), and then automatically filling in text.  For example, if the expiration date is less than today date then the Posting Status will be "Expired".  Like wise, if the expiration date is greater than today date then the Posting Status will be "Active". See my two examples below:

Posting Expiration Date:  5/18/2009  Posting Expiration Date:  8/10/2009

Today Date:  7/20/2009 Today Date:  7/20/2009

Posting Status:  Expired Posting Status:  Active

This is the formula that I created in Posting Status Text box Control Source property:

Control Source:  =IIf([PostingExpiration]>=[TextNow],"Active",IIf([PostingExpiration]<[TextNow],"Expired"," "))

It looks good on the form and is doing what it suppose to do but when I look at the Table, the Posting Status column is blank.  It doesn't look like it is reading it from the Form.

Can someone please help me solve this mystery?

Thank you so much!

question by Nina

Keywords: vba validation rule

[iGuest 3]

Formula In FormMS Access Validation RuleI need to build a formula into a form so that if data is input into the width (in) box that it automatically calculates the width (m). However, if there is 0 in the width (in), you can overwrite the formula and key in the width (m) manually. Is this possible?-reply by Lynn

[iGuest 3]

Binding Data to a Combo-BoxMS Access Validation Rule

I want to know how to bind data in a Combo Box. Actually I have two Combo BoxesChanging the values in one Combo Box reflects data binding from a Table to Another Combo Box.

-reply by Saurav

[iGuest 3]

How to Link ID field and Names field to Display by each other in from MS Access Validation Rule

Sir,

Good morning

 I am working as a Access programmer in a reputed company I need a help from your side that in want to get procedure to create link between ID and Names field Mean.

when I select NAme in the Names field automatically ID should be display in ID field as well as I shuld save the concern table please help me in this regard

 

-question by Mohd Ajaz Ali

[iGuest 3]

Replying to yordanTry using an input mask. That works for me