Click here to
Subscribe to
our Newsletter
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Sometimes you need to run VBA (Visual Basic for Applications) scripts after a successful login attempt. Using the OK Button on the Company Selection window does not always work as the login could still fail. For example, the user is already logged into the selected company. Also this does not help capture the logging out.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Not long after I joined Microsoft in May 2001, I found myself working as part of a global development team for Asia Pacific. The team was based in Manila in the Philippines and was involved in a regional research project to check the feasibility of releasing a version of Great Plains eEnterprise v6.0 for China.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
The following VBA example extends the Reference field on the GL Transaction Entry window from string field of 30 characters to a text field of 200 characters. The first 30 characters of the text field are populated into the original string field so it will contain data when viewed on a non-modified window or report.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
When using the Modifier to add a list field (drop down list, button drop down list, listbox, multi-select list box) to a window as a local field, the only option available to populate the list was to add static values. This is because there is no functionality available in VBA to add items to a Dexterity list field.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Back in my past, when I ran Winthrop Dexterity Consultants, I wrote a game in Dexterity (approx 1999). This game is called BlackBox and is based on the original board game by Eric Solomon.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Back in 1998, when I was working with Sequel Technology (the Western Australian partner for Great Plains), we were implementing Great Plains Dynamics 4.0 for a couple of sites and were using add-on products for Service Management and Job Costing.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
The following example shows how easy it is to use VBA to add a line number to a SOP Document.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I often get told that it is impossible to customize a report which uses a temporary table, and in particular a temporary table which uses single fields for multiple purposes. While I admit that these reports are more challenging to customize they are far from impossible.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
The following Report Writer and VBA example demonstrates how data from any SQL table can pulled into a report regardless of the product the table is related to. This technique can also be used when it is not possible to create the table relationship needed to add the report in the Report Writer. It works as long as you can create a query that will uniquely select the data you need based on the data on the report or from the already linked tables.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I have been asked many times how to have different company logos and details on invoice documents depending on the company you are logged into.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
The following Report Writer and VBA example demonstrates how data from any SQL table can pulled into a report regardless of the product the table is related to. This technique can also be used when it is not possible to create the table relationship needed to add the report in the Report Writer. It works as long as you can create a query that will uniquely select the data you need based on the data on the report or from the already linked tables.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
The following Report Writer example demonstrates how it is possible to show different logo images on a report based on a defined condition.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
The following VBA example adds two additional fields to the Sales Prospect Maintenance window and Sales Prospect Report.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
The following VBA example allows a window to remember its size and position the next time it is opened. This is really handy for transaction windows that you would like to see more lines at one time.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I have finally succumbed and joined the blogsphere.
I plan to use this blog as a reference site containing sample code, sample applications and articles that I have created.