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
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.
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.
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.
