Function QODBCConnect

Places your connection string into a one-word function. You will see this function throughout this site.


Why try to remember that QODBC connection string? Place it in a function and forget about it.


Function QODBCConnect() As String
'make the QODBCConnect string equal to whatever your connection string is
QODBCConnect = "ODBC;DSN=QuickBooks Data;SERVER=QODBC"
End Function

How to Use

Instead of typing something like this:

        qDef.connect = "ODBC;DSN=QuickBooks Data;SERVER=QODBC"

Type This:

        qDef.connect = QODBCConnect

Popular Posts