A fixed date would be handled like (note the # delimiter):
If Me.tbxDate > #1/1/2011# Then
Note also that in VBA the date must be in US format. Doesn't matter for your example, but to VBA 10/1/11 is October 1st, not January 10th.
Paul
--- In MS_Access_Professionals@yahoogroups.com, lsyrkin <no_reply@...> wrote:
>
> I need to run a piece of code if a date in a text box Data is later then a specific date. What is the best way to do it?
>
> The logic is:
>
> If tbxDate > 1/1/2011 Then
> <Code>
>
> End If
>
> Thank you.
>
__._,_.___
MARKETPLACE
.
__,_._,___
Tidak ada komentar:
Posting Komentar