Click here to
Subscribe to
our Newsletter
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
GP Power Tools – Administrator Tools Module can provide this functionality without needing customizations. (https://WinthropDC.com/GPPT)
Following on from my previous post: Customising the Company Login window series Part 1 – Introduction, here is the method to create a solution using Visual Basic for Applications (VBA).
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
GP Power Tools – Administrator Tools Module can provide this functionality without needing customizations. (https://WinthropDC.com/GPPT)
Recently a comment from David M (not me) was posted on the Support Debugging Tool Portal page asking:
“We have some fairly long names for our GP companies. Well, when logging onto GP, the second “Company Login” screen cuts off the company names too short for us. The entry field for companies allow for longer strings (65 Characters) but only displays 31 characters on the pull-down list. There is plenty of real estate on this window going unused. Can anyone think of a way to enhance/fix this to display more of the company name?”
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I have been working on a recent support case that had a situation that makes me want to raise this topic again.
This is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.
It seems like a trivial subject for our dedicated readers but we had a new customer who is just learning Dexterity and he was having trouble recently trying to select items out of a ListBox. And just today the issue came up about Drop Down Lists (DDL) and getting the value selected using VBA in a different case. So this seemed like a good time to put this together.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I was recently asked about a custom button that was added to a window and how to change the internet URL that the button opened when it was closed. I was not provided with any other information or screenshots.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
It 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.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I had a case today that raised an issue that I have seen before which has a simple solution.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I have completed the development project I was working last week and have another Quick Tip that came out of the project. For the previous Quick Tips related to this project have a look at Quick Tip: Passing Variables to SQL Server and Quick Tip: Passing Date and Time Variables to SQL Server.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
As a follow on from yesterday’s post, Quick Tip: Passing Variables to SQL Server, I wanted to discuss the related topic about passing of date and time variables.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Wow, the week is almost over and I am yet to post something.
This week I was working on a small development project using Visual Basic for Applications (VBA) to execute some commands at the SQL Server level after some user interface events. The code to be executed needed to have values from the windows passed through to the Transact-SQL. Now most people just write the code and pass through the value of a string field concatenated before and after with single quotes.
sqlstring = "select * from IV00101 where ITEMNMBR = '" & CStr(ItemNumber) & "'"