If date on form < Now(+7) ???

[pookie62]

Hi,
I want to disable editing certain fields on a form if the date on this form (goes over a year) is smaller then now() + days
How do I write that ???
Now I have this, but I need those extra 7 days on top of the present datefield[txtDatumFix]

If Forms![Inschrijving].[txtDatumFix] < Now() Then
Me.AllowEdits = False
Me.AllowAdditions = False
End If

Thanks for helping out..

 

[SkipVought]

Hi,

The Now() function includes TIME. The Date() function returns the current date

If Forms![Inschrijving].[txtDatumFix] < Date()+ 7 Then

caveat: Forms![Inschrijving].[txtDatumFix] must be a REAL MS Date

So if it's NOT...

If Forms![Inschrijving].[txtDatumFix] < Format(Date()+ 7 ,"yyyy=mm-dd") Then

assuming that the text string representing the date has been entered yyyy-mm-dd, dashed 'n all.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[pookie62]

Thanks for your reply skip,
Changed the code to this:

If Forms![Inschrijving].[txtDatumFix] < Format(Date + 7, "dd-mm-yyyy") Then

Prob no wis that even futured dates forms, (it's a db with matches in it already scheduled for this year) I can't edit anything..
I need to be able to edit in those future events ofcourse, but would like to block score editting (behind a button).
With this code:

 If Forms![Inschrijving].[txtDatumFix] < Now() Then

I could edit the future dated forms..
Since this db is spread over the country, I want to give the organising club a week extra time to enter all the match data in the db.
Hope I explained better now.. ?

 

[pookie62]

Anyone ??
Please.. need this functionality very hard..
Thanks

 

[SkipVought]

What is the question?

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[PHV]

Why not simply this ?
If Forms!Inschrijving!txtDatumFix < Now() - 7 Then

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[pookie62]

Thanks PHV,
That did the trick..