You do not have sufficient privileges on this system to modify the VBA project

Wonderful.

This is on my dev box, where I'm a Domain Admin. But I gave some thought…

We've released several free VBA addons for Dynamics GP ( click to email & email on customer maintenance addons). We've had several people ask us to show them how to install a VBA addon that modifies a screen or report. Here are the steps:

#1-Login to GP as SA.

#2-Click on Microsoft Dynamics GP > Tools > Customize > Customization Maintenance and import the package file we…

Hi folks!

I have been asked a number of times about some of the Modifier with Visual Basic for Applications (VBA) customizations featured on my blog and those over at Developing for Dynamics GP. It's no secret that I co-author a number of development posts with my friend David Musgrave in the spirit of educating and delivering some of the best articles to the end-user and development communities alike.

In light of this, this week I will deliver a 3-day Online Modifier with Visual Basic for Applications workshop, featured right here on this blog, that will step through a real-life customization from end to end.

What you will need

For the workshop, you will need a registered copy of Microsoft Dynamics GP v10, the Fabrikam sample company, and familiarity with the overall Dynamics GP navigation.

Prerequisites

This…

Well you learn something new every day and today our tame Dex developer is sat next to me in the office (some say he writes code in his sleep, others say he has dexterity tattooed on his heart, all we know is, he is called Jon) so picking up all sorts of things.


This one however is really simple and very useful. Often we will develop modifications for clients on our systems…

Dynamically Get GP database connection information when using VBA:

'Class Module: GP Dex_VBA_Link
'Author: Matt…

This has come up time and time again on message boards I frequent on the web. People are always asking how they can access SQL Tables and other objects through VBA to extend GP. It's pretty simple to add a field to a window with Modifier or create a user form in VBA but many seem to wonder how to access the database to really make things happen.

You can find all you need to know on Customer/PartnerSource. I'm only disclosing the same information here and a little of what I have learned to complement that information.

When Microsoft Dynamics GP 9.0 was released, a change was made in the password policy. This change required changes in how Microsoft Dynamics GP Dexterity works with passwords and in how the RetrieveGlobals.dll file works with passwords. The RetrieveGlobals.dll file was available for all earlier versions but does not work with Microsoft Dynamics GP 9.0. Therefore, you must replace the RetrieveGlobals.dll file with the new RetrieveGlobals9.dll file. The new RetrieveGlobals9.dll file is an ActiveX file. It returns the following information:

•The current user ID
•The current company to which you are logged in
•The current SQL data source
•The current user date in Microsoft Dynamics GP 9.0

The RetrieveGlobals9.dll file also returns an ActiveX Data Objects (ADO) connection object that lets you connect to Microsoft Dynamics GP data. The…

Guys,

A got allot of mails requesting to have Item Security functionality to distribute sites items and show…

Overview

Welcome to the first installment of this 3-day workshop! The workshop will be conducted today Monday, Wednesday, and Friday. The format is simple: get your laptop or PC with Dynamics GP 10.0 and follow the instructions below. Try to complete each section of the workshop and post your questions. That's it!

Today's workshop will focus on the essentials of Modifier by working with the Equipment Maintenance window in the Field Service series. The topics to be covered are as follow:

• Adding a window to Modifier
• Adding extra fields and controls to a modified window
• Working with field properties
• Linking fields to prompts
• Linking lookups to fields
• Granting security to modified windows

Modifying the Equipment Maintenance Window

The Equipment Maitenance window will require a new field, the Regulatory Entity, and a new Lookup button that will call our Customer Lookup window.

1) Open the Equipment Maintenance window. Go to Cards > Field Service > Equipment.

2) From Tools menu, select Customize, then choose Modify Current Window to open Modifier

3) Click the Static Text tool on the Toolbox window to add…

By now you may have painfully noticed that all the SOP Entry screen buttons have disappeared and replaced a bunch of graceful action button drop-down list objects. That's cool! Yeah, right! Now you are faced with upgrading all the customizations that depended on the Save and Delete actions previously executed through regular push buttons.

To make the changes to your customization code you must use the ActionButton.Value method to find the value of the chosen action (Save,…

using  

[code language=’vb’]

cmd.Parameters.Append cmd.CreateParameter("@dtDate",…

A request to restrict SOP Lookup Widnow to only return Documents for which the User is responsible came up yesterday on the http://groups.google.com/group/microsoft.public.greatplains/topics. This is a somewhat common request that is easily addressed using VBA. This example only works for v10 but you could easily convert it to previous version by following the steps in http://mbsguru.blogspot.com/2006/04/ado-connections-through-vba-in.html.

This example assumes that the UserIDs are stored in the Sales Person ID field in Customer Maintenance and that…

I've run into this several times, but I never bothered to figure out the cause or solution.

In GP 9, sometimes when you attempt to add new fields to…

When the job is simple, I'll usually just do it in VBA.

Here's a handy piece of code that demonstrates data access from Dynamics.

 


Dim cn As New…

There was a post in Microsoft GP Developer Newgroup, Suppress Dialog Box. The question is briefed as follows:

On the Cash Receipts Entry window, the message "Account is empty. Do you want to save the changes with errors?" needs to be suppressed as the users are not allowed to enter an Account in the CR Distribution Window.

The owner of the post was trying to handle this with VBA's Window_BeforeModalDialog() event. The message was still…