M4 Systems - Your Trusted Technology Partner

call 0845 5000 777
Solutions Services Why M4? Why Dynamics? Products Customers Partners Support
 Skip Navigation LinksHome > Products > Microsoft Dynamics GP > Modifier with VBA Printer Friendly Version  




Microsoft Dynamics GP Microsoft Dynamics CRM Microsoft Office SharePoint Server Microsoft Gold Certified Partner

Modifier with VBA

This module allows you to change every screen slightly or dramatically: add fields, remove fields, change prompt descriptions, make fields required, make fields read-only or change tab sequences. Also allows different screens to be seen by different users. Visual Basic For Applications is the same powerful development tool which comes with Microsoft Office: this allows a layer of business logic to be added to any field on any screen. A simple example includes enforcing a coding format. Any repetitive task can probably be streamlined by adding some VBA logic.

The architecture of Dynamics GP ensures that modified forms or VBA code is kept separate from the core dictionaries. In other words, you never change the core, you only add a layer. This prevents problems with upgrades and makes troubleshooting much easier.