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

Do you like this post? Please link back to this article by copying one of the codes below.


HTML link code:

BB (forum) link code: