ACCESS FEED: Re: [MS_AccessPros] Re: VBA question: my date variables are defaulting to 12/30/1899 and I can't figure out why!

Kamis, 01 Desember 2011

Re: [MS_AccessPros] Re: VBA question: my date variables are defaulting to 12/30/1899 and I can't figure out why!

you're welcome, Shay ;) happy to help

Warm Regards,
Crystal

*
(: have an awesome day :)
*

________________________________
From: Shay Holmes

Thank you, Crystal, Bill & John! I really appreciate the help and wisdom
you all share with us!

~*~*~*~*~*~*~
Shay Bella Holmes
~*~*~*~*~*~*~

On Wed, Nov 30, 2011 at 8:57 AM, Bill Mosca wrote:

> **
>
>
> Shay
>
> I'm glad you found and posted the solution. When using dates as parameters
> I ALWAYS pass them as Variants. If you pass them as anything else they
> default to their initialized value if null.
>
> The Variant can be tested using IsNull or IsMissing. The others won't pass
> those tests.
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com
> Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile/Bill.Mosca
>
>
>

[Non-text portions of this message have been removed]