DAO 3.51 to DAO 3.6 NULLs question 
Author Message
 DAO 3.51 to DAO 3.6 NULLs question

I've been using VB6 with DAO 3.51 and Access 97 databases.  Recently I got
VB6 SP3 which included DAO 3.6 so I thought that I would change my
references from DAO 3.51 to DAO 3.6.

However, I've noticed that the queries I run which search for NULL values in
Access 97 tables don't work when using the DAO 3.6 reference.  Does anybody
know why ?

--
Graham



Tue, 08 Jan 2002 03:00:00 GMT  
 DAO 3.51 to DAO 3.6 NULLs question
Graham,

I haven't used DAO 3.6 just yet, but I was wondering how you test for Null
values.

Have you tried this one:

Field Is Null

--
Regards

VB-Joker
Carsten Thomsen/MCSE
ICQ 40719070

PLEASE post ALL replies to the newsgroup(s) so we can all benefit from the
discussion!

Quote:
> I've been using VB6 with DAO 3.51 and Access 97 databases.  Recently I got
> VB6 SP3 which included DAO 3.6 so I thought that I would change my
> references from DAO 3.51 to DAO 3.6.

> However, I've noticed that the queries I run which search for NULL values
in
> Access 97 tables don't work when using the DAO 3.6 reference.  Does
anybody
> know why ?

> --
> Graham



Tue, 08 Jan 2002 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Reference DAO 3.6 Object Library or DAO 2.5/3.51 Compatibility Library

2. upgrade from DAO 3.51 to DAO 3.6??

3. Referencing DAO 3.51 and DAO 3.60

4. DAO 3.51 and DAO 3.60

5. Crystal Report Error After Upgrading from DAO 3.51 to 3.6

6. References to MS DAO 3.51, 3.60, 2.5

7. Moving from DAO 3.5 to DAO 3.6

8. Convert DAO 3.5 to DAO 3.6 Jet Engine 4.0

9. DAO 3.6 vs DAO 3.5 (VB6.0 sp3)

10. Upgrade from DAO 3.5 to DAO 3.6

11. DAO 3.6 and DAO 3.5

12. DAO 3.5 & DAO 3.51 work differently

 

 
Powered by phpBB® Forum Software