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 <wrmosca@comcast.net> 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]
Tidak ada komentar:
Posting Komentar