*This post is locked for comments
Thanks for the responses. I have 10+ years experience using Dex and have dabbled in VBA. I would love to use Dex but the window I am working with is a third party window. I needed to add new fields to this window as additional filters therefore Dex is not an option. I know I can filter 3rd party tables using the anonymous table found in Pushing the Limits of Dex so I my thoughts now is to create a new dex table, populate the table with my new filter fields using VBA script prior to the scrolling window populating, and then use the data in this table in a dex trigger to filter the records....unless someone else has another idea?
Soma, again, is correct. I write this just to add emphasis to what he said. The reject script is a slow way to filter. While it's cool that you can do it, I rarely use it in production because of the poor performance. Dexterity is, in my opinion as well, the only efficient way to do it.
Dexterity may seem daunting to begin with, but if you are comfortable using Modifier with VBA, you will not have a problem with Dexterity. Heck, I can do it :) and I started my GP life as an accountant. Not to push my own book (though I am), I've got a small project in it where you can walk through and actually create an 'application' that integrates with GP. Opening GP lookup windows, and putting filters on those windows is included in this mini project. Here's a link to the publisher - www.packtpub.com/.../book
You might like Dexterity more than you think. You might even convert all of your VBA code to Dex! If it's in Dex, it will work in the new Web client, VBA will not.
Kind regards,
Leslie
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,387
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
