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 Secure Link (CustomerSource)
Modifier/VBA Samples for Great Plains 8.0 Secure Link (PartnerSource)

Modifier/VBA Samples for Microsoft Dynamics GP 9.0 Secure Link (CustomerSource)
Modifier/VBA Samples for Microsoft Dynamics GP 9.0 Secure Link (PartnerSource)

Modifier/VBA Samples for Microsoft Dynamics GP 10.0 Secure Link (CustomerSource)
Modifier/VBA Samples for Microsoft Dynamics GP 10.0 Secure Link (PartnerSource)

Modifier with VBA for Microsoft Dynamics GP 10.0 Sample Applications

Modifier/VBA Samples for Microsoft Dynamics GP 2010 Secure Link (CustomerSource)
Modifier/VBA Samples for Microsoft Dynamics GP 2010 Secure Link (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.