Replacement for Nz Function:

http://www.themssforum.com/VisualBasic/Emulate-Access/

extract:...

Nz() isn't really necessary in VB if you're dealing
with known variable types. For strings, you can simply concatenate "" to the
end of a value. If that value is Null, the result will be "". For numbers,
you can do the same and wrapper it with Val(). You'll get back 0 for "".
Samples:

MyString = SomeRecordset("NullableStringField").Value & ""

MyNum = Val(SomeRecordset("NullableNumericField").Value & "")

PowerBasic Brilliant Compiler!

VBnet (excellent resource for Windows API)

The VB Zone (some good tutorials and freecode classes)

SQLitening Database System is a great multi-connection, multi-threaded server application that allows the SQLite3 database system to handle multiple SQL requests from different users over a network or internet. Source code is freely available.

Datenhaus Database System is a great multi-connection, multi-threaded server application that allows the SQLite3 database system to handle multiple SQL requests from different users over a network or internet. Very much a DAO feel to it.

Aivosto ( great info on string manipulation and speed comparisons of vb functions)