All About Listbox, Button Drop Lists, and Drop Down Lists


Patrick Roth - Click for blog homepageThis 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.

Continue reading

Quick Tip: Where does that customisation come from?


David Meego - Click for blog homepageThis 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.

Continue reading

Quick Tip: Working with VBA, Extender and Sales Transaction Entry


David Meego - Click for blog homepageThis 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.

Continue reading

Quick Tip: Passing Variables to SQL Server


David Meego - Click for blog homepageThis 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) & "'"

Continue reading