Home » Listing Details
Top Websites
  1. Dynamics GP Help
    Over 6500 resources listed.
  2. Mark Polino's DynamicAccounting.net
    Over 5100 resources listed.
  3. Rose Business Solutions Blog New
    Over 2200 resources listed.
  4. Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
    Over 1100 resources listed.
  5. Mariano Gomez at The Dynamics GP Blogster
    Over 1000 resources listed.
  6. Microsoft Dynamics Partner Community Blog
    Over 900 resources listed.
  7. Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
    Over 700 resources listed.
  8. Mohammad Daoud's Dynamics GP Blog
    Over 600 resources listed.
  9. Vaidy Mohan at Dynamics GP - Learn & Discuss
    Over 500 resources listed.
  10. Inside Microsoft Dynamics GP Official Blog
    Over 500 resources listed.
  11. eOne Business Solutions Blog
    Over 400 resources listed.
  12. About Dynamics, Development and Life
    Over 300 resources listed.
  13. Frank Hamelly at GP2theMax
    Over 300 resources listed.
  14. Dynamics CPM
    Over 300 resources listed.
  15. BKD Dynamics GP Insights Blog
    Over 200 resources listed.
  16. Leslie Vail at Dynamics Confessor Blogspot
    Over 200 resources listed.
  17. Victoria Yudin's Dynamics GP Website
    Over 200 resources listed.
    Victoria Yudin
  18. Janakiram M.P. at DynamicsBlogger
    Over 100 resources listed.
  19. VS Tools Forum
    Over 100 resources listed.
    Your Resource for Visual Studio Tools for Dynamics GP
  20. Inside Microsoft Dynamics GP Official Blog
    Over 100 resources listed.
  21. US Dynamics GP Field Team Blog
    Over 100 resources listed.
  22. Catherine Eibner MBS Developer Evangelist
    Over 100 resources listed.
  23. Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
    Over 100 resources listed.
  24. Dynamics Small Business
    Over 100 resources listed.
  25. Belinda, The GP CSI
    Over 100 resources listed.

Title:Adding AutoComplete Items with Dexterity

Dave DusekThis is a quick and easy way to add items to the AutoComplete list for a field.  I'm talking specifically about the autocomplete property on a field. 

In this case, the customer didn't want to use the lookup window to select an existing item number, they wanted it to be in the autocomplete list.  The problem is that in order for it to get into the autocomplete list, you have to select or type it at least one time.  They wanted all of the items in the autocomplete list right away without selecting or typing.  So this code does that for them.

The field we are targeting is the Item Number field.  This will populate any Item Number field in GP, but we need to pass a window field to the AutoComplete_AddStringValue() function, so in this case, we will use the SOP Entry window.  The code below was added on a form trigger so the user could select to update autocomplete items.  This code could take a while depending on how may items they have, so you have to be careful when you run it and the SOP Entry window does have to be open.  Also, the autocomplete tables are local tables, so this does have to be run on each machine for each user.

Example code to update AutoComplete data
local boolean result; local string litem; range clear table IV_Item_MSTR; get first table IV_Item_MSTR; while err() <> EOF do litem = 'Item Number' of table IV_Item_MSTR; result = AutoComplete_AddStringValue(field 'Item Number' of window SOP_Entry of form SOP Entry, litem); get next table IV_Item_MSTR; end while; warning "Update Complete.";

Dave Dusek
Dynamics GP Developer Support

Category:DEVELOPMENT: Dexterity
Link Owner:
Date Added:June 17, 2010 02:11:03 AM
Number Hits:12
RatingsAverage rating: (0 votes)

No Reviews Yet.