VBA Snippets: Select Records from Microsoft Dynamics ODBC Connection

This post is part of the series on VBA Snippets.

In yesterdays post, I covered adding an ODBC connection to Microsoft Dynamics GP VBA for use n windows or reports. The below is an example of a SQL query using the ODBC connection.

SOPType and SopNUmber (highlighted) are fields from a window added to the VBA.

This example retries a list of fields from the Sales Transaction Amounts Work…

Continue Reading Ian Grieve’s Article on their blog

VBA Snippets: Select Records from Microsoft Dynamics ODBC Connection

This post is part of the series on VBA Snippets. In yesterdays post, I covered adding an ODBC connection to Microsoft Dynamics GP VBA for use n windows or reports. The below is an example of a SQL‎…

Blog Syndicated with Ian Grieve’s Permission