[AccessD] Did you know? Or more correctly - I never knew...

The url points to old Office VBA magazine site which went out of
business, I wonder who bought it and where the files went.
I have heard rumors about them being placed in Compuserve.

Michael R Mattys wrote:

>----- Original Message ----- 
>From: "JWColby" <jwcolby at colbyconsulting.com>
>To: "'Access Developers discussion and problem solving'" 
><accessd at databaseadvisors.com>
>Sent: Monday, August 28, 2006 10:44 AM
>Subject: [AccessD] Did you know? Or more correctly - I never knew...
>
>-Snip-
>  
>
>>It turns out that even though the base query pulls out only the records 
>>with
>>dates, it apparently hands ALL the records up to the query built on top of
>>the base query and since some of those records have nulls in the dates, 
>>the
>>appointment function complains about nulls passed in to the date fields.
>>    
>>
>-Snip-
>  
>
>>So... why is it doing this, and is there a way to force the base query to
>>only pass up the filtered result set such that only valid dates are 
>>pulled?
>>    
>>
>-Snip-
>
>The fastest way to get the desired result set would be to append to a temp 
>table.
>As to why ... there was a Deconstructing Querydefs article by Ken Getz a few
>years ago that might help to explain it.
>The link at http://www.developershandbook.com/downloads.htm is dead.
>I wonder if anyone saved the article?
>
>Michael R. Mattys
>MapPoint Developer
>www.mattysconsulting.com 
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada