Searching like Quickbooks (with fpCombo)

Posted by: murray on 3 August 2017, 11:14 am EST

  • Posted 3 August 2017, 11:14 am EST

    We're trying to set up a search utility that works similarly to Quickbooks.  In Quickbooks, if I type in "S, then it shows all the entries beginnng with "S".  If I then type "M", it woll bring up the entries with "SM", "Smith", "Smythe", etc.

    We're using Listpro version 2 in VB6.

    We tried changing the style type but it doesn't seem to make any difference in the way the combo box behaves.

    Help? Advice?

    Thanks

    Murray
  • Replied 3 August 2017, 11:14 am EST

    Hello,

    Try setting the AutoSearch Property to 2 (Multi Search)

    You can find more information about the AutoSearch property in the List Pro Help documentation that was installed with the List Pro product.
  • Replied 3 August 2017, 11:14 am EST

    Thanks.  That's helpful.  Do you have any examples of searches built with that feature of Listpro?

    What would be the advantages of upgrading to Listpro version 3?

    Thanks

    Murray
  • Replied 3 August 2017, 11:14 am EST

    The code for that would be control name.autosearch.  Here is some information about this from the help:

    The AutoSearch property allows the user to type one or more characters to search for an item in the list of an fpList control or drop-down list style fpCombo control [Style property is set to 2 (Drop-Down List)]. By default, if you set the Style property to 0 (Drop-Down Combo) or 1 (Simple Combo), the fpCombo control always performs a multiple-character search. Therefore, setting the AutoSearch property for a drop-down combo style or simple combo style fpCombo control has no effect.

    For the fpList control and the drop-down list style fpCombo control:
    Typing a character initiates a search for the first item that begins with that character. If the item found is not visible in the list, the control scrolls to the first item that matches that character or characters. The control highlights the found item. If the search character is not found and the setting is 1 (Single Char), no item is highlighted. If the setting is 2 (Multiple Char), the selection highlighting moves to the closest available match for the search string as the characters are entered (for example, to highlight "Variegated" type "var"). If none of the items begin with the first character entered, the fpCombo or fpList control does not move the selection. If the setting is 3 (Single Char (Greater or Equal)), the fpCombo or fpList control highlights the next greater item if the search character is not found. For example, the first item starting with the letter "g" will be highlighted if the user searched for the letter "f" and none of the items begin with that letter.

    For the drop-down combo style and simple combo style fpCombo control:
    Typing a character initiates a search for the first item that begins with that character. If the item found is not visible in the list, the control scrolls to the first item that matches that character or characters. The control does not select or highlight the found item. If none of the items begin with the first character entered, the fpCombo control does nothing. As the user types each additional character, the control searches for the list item that begins with those characters. If at any time none of the items match the characters typed, the fpCombo control scrolls the list so that the first row is the first item in the list again, if the list has scrolled.

    For example, assume control is displays five rows. List item "Willow Springs" is in row 10 and "Wilmington" is in row 20. When you type the letter "w", the list scrolls to "Willow Springs". When you type the letters "i" and then "l", nothing changes. If the fourth letter you type is "m", the list will scroll to "Wilmington". If the fourth letter you type is "z" (no match is found), the list scrolls so that the first row is the top row in the list.

    We still release patches for List Pro 3.  Here is a new feature list from the readme:
    Summary of New Features

    The AllowAnimate property has been added. Set this run time property to False to turn off the default animation for the drop down combo list
        The last column can now be resized beyond the right border of the list
        You can toggle the F4 key to drop down and close up the combo box list
        If you set the MultiSelect property to 2 (Extended), you can press Shift+F8 and use the Spacebar and the arrow keys to select multiple non contiguous list items

    The List Pro 3.0 controls support OLE drag-and-drop operations as described in the Reference Guide section of the online help file
        You can display text tips when the pointer is over a header or list item
        If you change the font size in a row, you can automatically adjust the height of that row to accommodate change the font size
        You can display the list of a combo box above or below the edit field
        The List Pro 3.0 controls support Microsoft's IntelliMouse┬« feature
  • Replied 29 March 2018, 4:47 pm EST

    We all know that QuickBooks is the accounting software and it provides help in business.the best advantage of this software is that you can log in your account on any computer and you can easily access this account in Quickbooks software.
    if you have any query related to QuickBooks then visit,
    [url=https://quickbooksupports.co/]Quickbooks Support[/url] here you will get the solution of your query.
  • Replied 2 April 2018, 7:39 pm EST

    QuickBooks is the best accounting software and the feature present in this software, make this software best among all the accounting software, this software is the best software for the small businesses.some time we faced an issue with our QuickBooks software for that you need to visit [url=https://quickbooksupports.co/ ]QuickBooks support[/url] for the help.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels