Modifier & VBA Samples
This page contains a summary list of the Modifier & VBA samples that have been posted.
Official Samples from CustomerSource/PartnerSource
Modifier/VBA Samples for Great Plains 8.0 (CustomerSource)
Modifier/VBA Samples for Great Plains 8.0 (PartnerSource)
Modifier/VBA Samples for Microsoft Dynamics GP 9.0 (CustomerSource)
Modifier/VBA Samples for Microsoft Dynamics GP 9.0 (PartnerSource)
Modifier/VBA Samples for Microsoft Dynamics GP 10.0 (CustomerSource)
Modifier/VBA Samples for Microsoft Dynamics GP 10.0 (PartnerSource)
Modifier with VBA for Microsoft Dynamics GP 10.0 Sample Applications
Modifier/VBA Samples for Microsoft Dynamics GP 2010 (CustomerSource)
Modifier/VBA Samples for Microsoft Dynamics GP 2010 (PartnerSource)
Modifier with VBA for Microsoft Dynamics GP 2010 Sample Applications
VBA Only Examples
VBA - Screen Size and Position Example
This example allows windows to remember their size and position on the screen.
VBA - Running VBA scripts after Login or before Logout Example
This example shows how to create a Toolbar package so that the login and logout events can be captured.
VBA - Preventing the User Login Activity window from opening Example
This examples stops the User Login Activity window from opening, thus requiring the System Administrator to remove stranded users.
VBA - Preventing Users from logging into multiple companies Example
This example shows how to use ADO to prevent a user logging into multiple companies and using more than one concurrent user license.
VBA - Welcome to Dynamics Example
This example shows how to add the "Welcome to Dynamics" wave file back to you system.
VBA - Default Lookup Sort Order Example
This example shows how to set a default sort order for a lookup window.
Modifier and VBA Examples
Modifier - Sales Prospect DUOS Example
This example demonstrates the usage of the DUOS (Dynamic User Object Store) to add user defined fields to a window and report.
Modifier - Extending the length of a Field Example
This example demonstrates using the DUOS (Dynamics User Object Store) to extend the length of a field.
Modifier - Adding a field to a scrolling window using ADO Example
This example demonstrates using an ADO (ActiveX Data Objects) connection to read data from SQL Server.
Modifier - Reading and Writing Data with ADO Example
This example demonstrates how to use ADO (ActiveX Data Objects) to read and write data from SQL Server.
Modifier - How to Expand the GL Transaction Entry Scrolling Window Example
This example shows how to access hidden fields from VBA using the Journal Entry window to demonstrate.
Hybrid Modifier, VBA, Dexterity Examples
Hybrid - Changing Screen Colours Depending on Company Example
This example allows different background colours to be selected for each company.
Hybrid - Dynamically Populating a Modifier Added List Example
This example shows how to execute Dexterity sanScript in the context of a modified window.
Hybrid - Clearing the Last User on a Terminal Server Example
This example shows how to remove the SQLLastUser setting from the dex.ini after login.
Hybrid - Running a macro to automatically close GP Example
This example shows how to create and run a macro on-the-fly from VBA.
Hybrid - Adding Record Notes to a window Example
This example shows how to add access to Record Notes to a window
Hybrid - Cheque Amount in Words Example
This examples shows how to convert a currency value into words and overcome the 80 character limit on string calculated fields
Hybrid - Purchasing Terms & Conditions Example
This example shows how to print a report from VBA using passthrough Dexterity.
Hybrid - Using Menus for Visual Studio Tools from VBA Example
This example shows how Menus for Visual Studio Tools can be called from VBA.
Hybrid - Adding Named Printers control to Reports using VBA
This example shows how to call Named Printers functions to add Named Printer control to a report.
ADO Examples
Modifier - Adding a field to a scrolling window using ADO Example
This example demonstrates using an ADO (ActiveX Data Objects) connection to read data from SQL Server.
RW - Accessing any SQL data from a Report Example
This example demonstrates how to access SQL data from a report.
Report Writer Examples
RW - Conditional Logos Example
This example demonstrates a technique to hide and show logos on a report.
RW - Accessing any SQL data from a Report Example
This example demonstrates how to access SQL data from a report.
RW - Adding Line Numbers to SOP Documents Example
This example demonstrates adding line numbers to SOP Documents.
Hybrid - Cheque Amount in Words Example
This examples shows how to convert a currency value into words and overcome the 80 character limit on string calculated fields
Hybrid - Purchasing Terms & Conditions Example
This example shows how to print a report from VBA using passthrough Dexterity.
10-May-2011: Added Sample Links for Microsoft Dynamics GP 2010.