July 24, 1999

NZ – Check whether a value is Null

‘ Check if a value is Null. If not it returns the value, ‘ otherwise it returns the ValIfNull argument, or zero/null string’ if the second argument is omitted” This

Reuse a Recordset’s Connection

ADO lets you create a Recordset without creating an explicit Connection object, using the following syntax: Dim rs As New ADODB.Recordsetrs.Open “Authors”, “DSN=Pubs” If you later want to create another

Export DAO databases to any ISAM format

Everyone tells you how to import, but even MS-VB techs start coughing when you ask how to export with DAO! In fact, their own documentation clearly states that it can