VBA – Page 5 – Winthrop Development Consultants Blog

Automating or Customizing the Report Destination Window

Nov 3, 2009 Tagged with Application, Customizations, Dexterity, Hybrid, Report Writer, VBA 14 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I have seen this issue come up a number of times. Trying to automate processes which involve reports and wanting to automate the Report Destination window. Sometimes you can add the Report Destination to Visual Basic for Applications (VBA) and sometimes the system will not add the window to VBA. This post will explain the reason for this “weird” behavior.

Developing For Dynamics GP

Hybrid – Setting a push button to Hyperspace

Oct 30, 2009 Tagged with Dexterity, Hybrid, Modifier, NDM, Patrick Roth, VBA No Comments

This is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.

Trivia question for today:

Given the following sequence of events:

In Microsoft Dynamics GP, in a control field such as Customer Number, the user types in “AARON”. The user then presses the associated lookup button.

Developing For Dynamics GP

Hybrid Development and Continuum

Oct 19, 2009 Tagged with Blogsphere, Dexterity, Hybrid, Modifier, VBA, Visual Studio Tools 5 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

In the past, I was known for my pioneering work with and promotion of Cross Dictionary Dexterity Development. More recently I have been talking up the benefits of Hybrid Development and Developing Outside of the Box.

Developing For Dynamics GP

Totalling a field in a Conditionally Suppressed Section on a Report

Oct 13, 2009 Tagged with Application, Report Writer, VBA 2 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I was recently asked how can you total a field in a report when that field is in a conditionally suppressed section. You might ask why should this be difficult. The reason for the complexity is this….

Suppressing a section just stops it being displayed at the last moment and does not exclude the section from other processing by the report writer.

Developing For Dynamics GP

Using Integration Manager with Analytical Accounting

Sep 8, 2009 Tagged with Application, Dexterity, Hybrid, Integration Manager, VBA 10 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

When you use Integration Manager on a system with Analytical Accounting (AA) installed, integrations often fail because Analytical Accounting will open windows which are unhandled by Integration Manager. However, there are time when you still want to use Integration Manager to import transactions where the Analytical Accounting information is left blank. This post provides three methods of how to make Integration Manager work when Analytical Accounting is installed.

Developing For Dynamics GP

What does Option Explicit do in VBA?

Aug 6, 2009 Tagged with Best Practice, VBA 4 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

My colleague asked me for assistance with a Visual Basic for Applications (VBA) case yesterday.

Developing For Dynamics GP

Where are Dynamics GP’s Business Rules Defined and Enforced?

Aug 2, 2009 Tagged with Application, Dexterity, eConnect, History, Integration Manager, SQL, VBA 4 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

In a recent forum post, the question of where the business logic for Dynamics GP resides was raised. This is an excellent question which, sadly, does not have a simple answer.

Developing For Dynamics GP

Modifier – How to Expand the GL Transaction Entry Scrolling Window Example

Jul 28, 2009 Tagged with Modifier, VBA 1 Comment

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

One of the customisations that I have heard requests for a number of times is to open the General Ledger Journal Entry (GL Transaction Entry) window’s scrolling window (grid) to its expanded state when the window is opened.

Developing For Dynamics GP

VBA – Determine if the Caps Lock button is enabled on Password entry

Jul 22, 2009 Tagged with Advanced Topic, NDM, Passwords, Patrick Roth, VBA 6 Comments

This is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.

With password policies in place in Dynamics 10.0 RTM, it was easy to be able for your user to ‘lock themselves out’ after a mistyped password or two.

Because Dynamics GP doesn’t give you any kind of warning that the Caps Lock key is enabled, the user wouldn’t necessarily notice this is the real issue and not a typo and all of a sudden you are locked out.

Developing For Dynamics GP

Removing References to Fields in VBA Revisited

Jun 22, 2009 Tagged with Blogsphere, Modifier, VBA 1 Comment

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Michael Johnson (the MBS Guru) has posted a great article about removing invalid references from a Visual Basic for Applications (VBA) project. This has prompted me to revisit the topic and gather together all the relevant resources from a number of blog authors.

Tag: VBA