It works. Thank you Paul!
--- In MS_Access_Professionals@yahoogroups.com, "Paul" <pbaldy72@...> wrote:
>
> 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