Another pb with access 1.1 database. 
Author Message
 Another pb with access 1.1 database.

Do someone know how to know if a field is empty in an access database 1.1?
I've tried to compare the result with a string nul, but VB doesn't take care
of it. How can i do it ?

Thank you for your help.



Tue, 09 Dec 1997 03:00:00 GMT  
 Another pb with access 1.1 database.

Quote:

>Subject: Another pb with access 1.1 database.
>Date: Fri, 23 Jun 1995 11:54:48 LOCAL
>Do someone know how to know if a field is empty in an access database 1.1?
>I've tried to compare the result with a string nul, but VB doesn't take care
>of it. How can i do it ?

The string: "" is NOT a NULL value, it's an empty string.

You check it this way...

   If IsNull( Data1.Recordset("MyField") ) Then
         ' Do something about it....
   Else
         ' All is well...
   EndIf

Dag.



Tue, 09 Dec 1997 03:00:00 GMT  
 Another pb with access 1.1 database.
Look at the 'isnull' function in VB3.0


Tue, 09 Dec 1997 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Crystal 1.0 database error when connecting to Access 1.1 database

2. Using SQL To access Access 1.1 Database in VB

3. VB3 problems opening Access 1.1 database

4. Sorting access 1.1 databases

5. Access 1.1 database structure printing utility

6. Help requested: VB corrupts access 1.1 database

7. read an old protect Access database (version 1.1) with VB5

8. Help - Access database migration 1.1 --> 3.5

9. Help - Access database migration 1.1 --> 3.5 problems

10. read an old protect Access database (version 1.1) with VB5

11. error 3041: try to load old database (Access 1.1/2.0)

12. VB3, Access 1.1 multi user access

 

 
Powered by phpBB® Forum Software