limit date input to a sunday date in access

[Guest]

Can I limit a date input on a form to be only a Sunday date in the year? if
So could you show me how? thank you I am using office professional 2003
with access 2033 as the data base.

 

[Guest]

On the before update event of the field you can write the code

If WeekDay(Me.[DateFieldName]) <> 1 Then
MsgBox "Must be Sunday"
Cancel = True 'wont let the user continue
End If

 

[Guest]

i am sorry but I must be doing something wrong because I keep getting syntax
errors. It suggestes that I hane added and operater with out operand Could
you please expand thankyou
RLM

On the before update event of the field you can write the code

If WeekDay(Me.[DateFieldName]) <> 1 Then
MsgBox "Must be Sunday"
Cancel = True 'wont let the user continue
End If
--
\\// Live Long and Prosper \\//
BS"D

Can I limit a date input on a form to be only a Sunday date in the year? if
So could you show me how? thank you I am using office professional 2003
with access 2033 as the data base.

 

[Guest]

Can you post the code you have?

--
\\// Live Long and Prosper \\//
BS"D

i am sorry but I must be doing something wrong because I keep getting syntax
errors. It suggestes that I hane added and operater with out operand Could
you please expand thankyou
RLM

On the before update event of the field you can write the code

If WeekDay(Me.[DateFieldName]) <> 1 Then
MsgBox "Must be Sunday"
Cancel = True 'wont let the user continue
End If
--
\\// Live Long and Prosper \\//
BS"D

Can I limit a date input on a form to be only a Sunday date in the year? if
So could you show me how? thank you I am using office professional 2003
with access 2033 as the data base.

 

[sarong17uk]

Sunday date

Can I limit a date input on a form to be only a Sunday date in the year? if
So could you show me how? thank you I am using office professional 2003
with access 2033 as the data base.

The DATEPART function is useful;
Usage: DATEPART(w, date) returns 1 - 7 with 1 being a Sunday.
Hope this helps.
Good luck!