Modifier & VBA Articles & Links

avatar of david-musgraveDavid Musgrave13

This is a page to provide links to Modifier & VBA related articles and materials. Note that articles which mention specific versions are often valid for other versions as well.

Knowledge Base (KB) Articles

How to add a hidden field by using Modifier with Visual Basic for Applications in Microsoft Dynamics GP (KB 951230) Secure Link

Error message when you expand a scrolling window by using VBA in Microsoft Dynamics GP: "Run-time error '1008': Unsafe Operation" (KB 951231) Secure Link

How to use ActiveX Data Object (ADO) with VBA on a window with Microsoft Dynamics GP and with Microsoft Business Solutions - Great Plains 8.0 (KB 942327) Secure Link

How to use an ActiveX Data Object (ADO) with VBA on a report in Microsoft Dynamics GP (KB 954619) Secure Link

Information about the new connection objects in VBA that replace the RetrieveGlobals.dll and RetrieveGlobals9.dll files in Microsoft Dynamics GP 10.0 (KB 936115) Secure Link

Error message when you run the UserInfoGet.CreateADOConnection VBA function in Microsoft Dynamics GP 10.0: "Login failed for user '[User Name]'" (KB 941457) Secure Link

Formats Not Exported to .Package Files (KB 851092) Secure Link

A user who is not an administrator experiences VBA permission problems in Microsoft Dynamics GP (KB 929612) Secure Link

Error "VBA Cannot be initialized. Cannot Import this package because it contains VBA components." when importing a package file in Microsoft Dynamics GP (KB 861062) Secure Link

Type mismatch error comparing currency fields in VBA (KB 843656) Secure Link

 

Training Materials

Modifier with Visual Basic for Applications (VBA) in Microsoft Dynamics GP 9.0 Secure Link

Direct download of archive file

Note: The training materials are for version 9.0. Don't worry, this is the latest version and everything is still valid for later versions of Microsoft Dynamics GP and Dexterity.

  

26-Apr-2011: Added direct link to training materials.

Comments (13)

  1. Developing for Dynamics GP says:
    25 July 2008 at 02:22

    The Modifier & VBA Articles & Links page and the Dexterity Articles & Links page have been

    Reply
  2. Developing for Dynamics GP says:
    21 October 2008 at 06:23

    Over the years I have had many requests for training on the various tools available for customising or

    Reply
  3. Tell says:
    5 May 2009 at 08:33

    Where can i down load the full version of econnect for GP10. i.e version which will create the objects in database.

    Reply
  4. Scott Stephenson says:
    5 May 2009 at 09:56

    Hi Tell. The database objects for eConnect are now (with GP 10.0) automatically installed by the standard server install for GP.

    If you need to re-install just the eConnect objects, a Database Maintenance tool was created for this purpose. This tool is installed with GP client for 10.0 SP2 or later.

    Scott

    Reply
  5. TracyB says:
    12 May 2010 at 12:03

    I am trying to import my customization package onto a new laptop and I am receiving an error saying "Class not registered.  Looking for object with CLSID:{AC9F2F90-E887-11CE-9F68-00AA00574A4F}"  I've searched knowledge base and cant find anything.  

    Thanks in Advance

    Reply
  6. David Musgrave says:
    12 May 2010 at 17:06

    Hi Tracy

    I would say that your code references some external object or resource that is not installed on the target machine.  Check your code for external references.

    As this is a blog "comments" section and not a support site, if you have further questions then log a support incident or post your question to the public newsgroups or forum.

    David

    Reply
  7. Natalie says:
    7 April 2011 at 05:38

    Is there a way to loop through a grid using vba?

    Reply
  8. David Musgrave says:
    7 April 2011 at 21:21

    Hi Natalie

    For your other comment (which I have deleted) on why VBA does not work, I would look at the following KB article, or log a support case.  Blog comments is not a good method of providing support.

    mbs.microsoft.com/.../KBDisplay.aspx

    As for looping through a grid.  Your best choice (if possible) is to open a detail window (for example Sales Item Detail Entry from the Sales Transaction Entry window) and use the browse buttons to go to the start and then move through the data. If no expansion window is available, then use VBA SendKeys command to either use down arrow to move through or focus to the last editable field and send a tab.

    I will write a blog post on this later

    David

    Reply
  9. Web Client - Modifier says:
    4 March 2015 at 06:30

    In the desktop application it is possible using Modifier and VBA to implement a customization on a form.  Do such modifications propagate to the Web Client,  Is it possible to implement similar modifications to forms in the Web Client.

    Reply
  10. Clive says:
    4 March 2015 at 07:03

    Web Client - Modifier

    In the desktop application it is possible using Modifier and VBA to implement a customization on a form.  Do such modifications propagate to the Web Client,  Is it possible to implement similar modifications to forms in the Web Client.

    Reply
  11. David Musgrave says:
    9 March 2015 at 19:15

    Hi Clive

    You can use Modifier to change the form and that will work on the web client (as it is Dexterity based).

    However, VBA code will not work as Visual Basic for Applications is not supported on the web client.

    Instead, you can use Visual Studio Tools and V# or VB.Net to add your scripting. This will work on the web client.

    David

    Reply
  12. image sensor says:
    19 January 2016 at 20:38

    I like your blog. I enjoyed reading your blog. It was amazing. Thanks a lot.

    Reply
  13. David Musgrave says:
    28 January 2016 at 15:46

    Hi image sensor

    Thanks for the feedback.

    David

    Reply
Skip to main content