Using the Search Bar

The search bar on the Customers window, Products window, and Invoices window consists of two list box controls, one text box control, and several command buttons. To search all records meeting your specific criterion, follow the steps below:

(For Example: Let's say you open the Customers window and want to find all customers whose name contains Off):

  1. Select a search field from the first list box. In this example, you select Name from the first list box.
  2. Excel Invoice Manager: Search bar
  3. Select a search operator from the second list box. The search operators you can select vary according to the type of the field you selected in the first list box. For text field, the operators you can use are: Equals, Contains, Starts With, Ends With, Is Less Than, Is Greater Than. For a numeric field, the allowed operators are: Equals, Is Less Than, and Is Greater Than. In this demonstration example, you select Contains from the second list box.
  4. Excel Invoice Manager: Search bar
  5. Enter the search key value in the text box. In this example, you enter Off.
  6. Excel Invoice Manager: Search bar
  7. Click the Search button. The data list will display all records meeting your criterion.
  8. Excel Invoice Manager: Search bar
  9. To display all records again (i.e. remove the criterion), click the Reset button.
  10. If you click the Set as Default button, the current search options in the field name box and search operator box will be saved. For example, in the Products data list window, if you select Product Name from the search field box, and select Contains from the search operator box, and then click the Set as Default button, these options are saved. After that, each time you open the Products window or Product-Selection window, these options are restored.
Excel Invoice Manager Free Download and Try (4.17 MB)
Home Contact Us Privacy Link to Us
copyright © Office-Kit.com, all rights reserved