Coming Soon: Microsoft Dynamics GP 2013 Cookbook | azurecurve

View azurecurve’s Feed on Twitter View azurecurve’s pheed View azurecurve’s facebook page · View azurecurve’s Google+ View azurecurve.co.uk · azurecurve.com · Browse… Browse Categories · Browse Tags

Read more here:
Coming Soon: Microsoft Dynamics GP 2013 Cookbook | azurecurve

April 11, 2013 · Ian Grieve · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 224

Review of Developing Microsoft Dynamics GP Business Applications – Part 5

I started reviewing Leslie Vail’s book, Developing Microsoft Dynamics GP Business Applications, which was published at the end of December by Packt Publishing, a few weeks ago. To do this review I decided to take a read through and complete … Continue reading

Excerpt from:
Review of Developing Microsoft Dynamics GP Business Applications – Part 5

April 11, 2013 · Ian Grieve · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 144

Quick Tip: VBA ADO Connection Run-time error ‘3709’

David Meego - Click for blog homepageIt has been a long time since I shared a Quick Tip for Visual Basic for Applications (VBA), but I have had this one waiting for me to write up for a while.

When using VBA on a window with ActiveX Data Object (ADO) to connect to SQL Server to read and/or write data to tables, the best practice is to open the ADO connection on the Window_BeforeOpen() event and to close the ADO connection using the Window_AfterClose() event.

This is similar to the best practice for reports discussed in the Using ADO with VBA with Report Writer post.

There is one big difference in behaviour between windows and reports that can cause problems with this technique…. cue dramatic music…..

Windows have a user interface which might cause a dialog to open and the window closure to be aborted.

 

OK, big deal, why should this cause a problem for us?

Well, let’s work with the following scenario:

  1. The user opens the window and the Window_BeforeOpen() event opens the ADO connection.
     
  2. The user is working in the window and the VBA code is reading and writing via ADO as desired.
     
  3. The user is has finished editing data in the window (but has not saved) and closes the window.
     
  4. The “Do you want to Save, Discard or Cancel?” dialog opens and the user decides to cancel.
     
  5. The window closure is aborted and the window stays open.
     
  6. The user continues working and the next time VBA attempts to use ADO, the following error shows up: 

Run=time error ‘3709’:

Requested operation requires an OLE DB Session object, which is not supported by the current provider.

So what happened?

The issue here is that while the Dexterity WIN_POST script aborted the window closure, the script itself as still executed. Therefore the VBA Window_AfterClose() script also executed… and closed the ADO connection even though the window remained open.

 

The solution to this issue is to make sure that the Window_AfterClose() script does not close the ADO connection if Cancel was selected on the pop up dialog.

Please see the Knowledge Base (KB) Article below for details of the solution including example scripts:

 

Hope you find this one useful.

David

See more here:
Quick Tip: VBA ADO Connection Run-time error ‘3709’

April 11, 2013 · David Musgrave · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 565

SSRS data specific report drill through to Bing Maps – Microsoft …

Using Sparklines & Data Bars to Visualize Data in SQL Server Reporting Services Reports | Dynamics GP Insights. by mpolino. on 28 May 2013. 0 comments. View More 

View original post here:
SSRS data specific report drill through to Bing Maps – Microsoft …

April 10, 2013 · mpolino · No Comments
Tags: , , , , , ,  · Posted in: Blogs I Follow Total Views: 146

Vote for David Musgrave–2013

I am in full agreement with Jivtesh. Though I think this whole ‘list’ thing is nothing more than a brilliant marketing idea of Dynamics World, still, to not have David Musgrave on the list should only CONFIRM IT IS A FRAUD.

C’mon people, we know who the superstars are. We do not need some web site determining  the best of the best. I think we all know that it’s David Musgrave, and it has been for years.

But, if it’s a vote that they need, vote for David and vote often. Even if it is a marketing scheme, I’ll buy in just to get the right man at the top of the list.

Until next post!

Leslie

View article:
Vote for David Musgrave–2013

April 10, 2013 · Leslie Vail · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 176

Review of Developing Microsoft GP Business Applications

Wow!

I am honored that my book, Developing Microsoft GP Business Applications is being reviewed in detail by Ian Grieve. I just learned of this today, he has 5 parts already reviewed. The reviews start here: http://www.azurecurve.co.uk/2013/02/review-of-developing-microsoft-dynamics-gp-business-applications-part-1/

Ian is completely independent and I will definitely be reading his reviews and be able to make the book better because of them. I’ve only read the 5th article, and am so very impressed by his thoroughness and honesty.

He talks about what’s good, and what could be improved, I am elated to learn that someone so exceptional is taking this much time reviewing my book!

Thank you Ian!

Until next post,

Leslie

See more here:
Review of Developing Microsoft GP Business Applications

April 10, 2013 · Leslie Vail · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 208

Microsoft Dynamics GP 2013 Web Client First Run On … – azurecurve

View azurecurve’s Feed on Twitter View azurecurve’s pheed View azurecurve’s facebook page · View azurecurve’s Google+ View azurecurve.co.uk · azurecurve.com · Browse… Browse Categories · Browse Tags

Read more here:
Microsoft Dynamics GP 2013 Web Client First Run On … – azurecurve

April 10, 2013 · Ian Grieve · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 174