Linking Field Prompts and fixing VBA Reference Errors

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

The great postings around the blogsphere just keep coming. I am not complaining as the body of knowledge they provide to community is growing all the time.

My buddy, Mariano Gomez, who is a wealth of knowledge and is always willing to help on the newsgroups has come with a great article explaining why you should ensure you link prompts when working with Modifier and Dexterity.

Mohammad Daoud has also created a really useful article which discusses how to resolve VBA (Visual Basic for Applications) reference errors.  These are usually caused by the removal of a field from a form or report without removing the VBA reference first.

The Microsoft_Dynamics_GP.vba project references some objects that cannot be found. these objects are listed in the file: C:Program FilesMicrosoft DynamicsGPDynamics.txt.

To remove the VBA references to fields no longer needed or available, follow the steps below:

  1. Copy the VBA code into a Notepad.exe window.
  2. Remove the Report or Window from VBA (Tools >> Customize >> Remove Current Window/Report from Visual Basic).
  3. Add the Report or Window back to VBA (Tools >> Customize >> Add Current Window/Report to Visual Basic).
  4. Add the required fields back to VBA (Tools >> Customize >> Add Fields to Visual Basic).
  5. Copy the VBA code back into the appropriate VBA Module.
  6. Compile the Project and Save.

Hope you find this info handy.

David

This article was originally posted on the Developing for Dynamics GP Blog and has been reposted on https://www.winthropdc.com/blog.

2 thoughts on “Linking Field Prompts and fixing VBA Reference Errors

Leave a Reply