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 query using the ODBC connection. SOPType and SopNUmber (highlighted) are fields from a window added to the VBA.
Blog Syndicated with Ian Grieve’s Permission
More About This Author
Array
- Dyn365GP25 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Restore a Deleted Environment
- Dyn365GP24 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Delete an Environment
- Dyn365GP23 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Delete a Company
- Dyn365GP22 April 2024Upcoming Microsoft Dynamics 365 Business Central Knowledge Hub Webinars (May-Jul 2024) from MADIC dynamics