Microsoft Access Pros QuickBooks Link Developer's Guide - Functions

qbConnectionOpen(Optional ByVal binShowStatus As Boolean = True)

This function opens a connection to the QuickBooks Company file in tblQbSetup with binCurrent = True. Note: Call qbConnectionOpen before bulk transactions, and be sure to call qbConnectionClose after all transactions or any errors. If you are only doing a single transaction, for instance, pushing one invoice, it is not necessary to call qbConnectionOpen first. By explicitly opening the connection, the connection to QuickBooks is only opened once, instead of once per transaction.

  • binShowStatus – if true, the Status Bar is set when the connection is opened.

This function closes the open connection to the QuickBooks Company file.