Autocomplete is our most sought-after free developer resource we offer. Autocomplete has been tweaked over the years and has come to a point where it provides all the functionality that is needed and it is highly-stable. Autocomplete is a set of controls (classes) which contains a data-bound drop down list similar to a combo form, but that is where the similarities end. Autocomplete displays results from a database as the user types. The information that is displayed allows the user to make a choice from the list at any point in time. The more they type, the more narrow the results become in the display. This helps speed data-entry because a user doesn't have to stop to see if they have typed enough to be somewhere near the record they are looking for because it displays as they are typing. The less a user has to type, the faster and more productive they will be.
PickDBForm is a custom control (class) that was developed based on a common request. The user check the box and then they are allowed to enter data into another field. So I created a control that combines a check box and an entry field. It has 2 data sources and all the code exists to ensure that you can only get to the entry field if the check box is selected. You will find this to be a very intuitive and neat little package.
RSRound is a custom package that was designed for rounding a number at various levels. Round to the nearest tens, hundred, hundredth position or more. This package will help you all around.
RSAge is a custom package that was designed for calculating the number of full years (age) between 2 dates.
Tempfile is our second most requested package. There are so many ways this package can be used, I could write hundreds of examples in how this package is being used. If you are interested in using this package, please feel free to contact us for help. It can be used for generating temporary files to report on, it can be used as any more table with a datadictionary can be used. That means it will honor your entry rules and validations. Here are a few ways it is currently being used:
- Multi-user temp file for reporting
- Temporary collection of order information. Once sale is completed, data is copied to the real database.
- Combining multiple tables into a single list
TimeSpan_Functions is a package developed to help manage DateTime variables. This package handles the conversion of DateTime and TimeSpan variables making it easy for you to add and subtract a TimeSpan from a DateTime variable.
DISCLAIMER:
All code provided by Redeemed Software is royalty-free unless otherwise stated.
I offer no warranty and support is limited to my understanding of your issue and my availability to assist you. You may also purchase support from Redeemed Software Company to integrate these resources into your product. Redeemed Software Company shall not be held liable for any problems that occur as a result of using this code. The code is provided as-is and should be thoroughly tested before deploying. Use at your own risk!
Downloading and/or use of the code in this section constitutes as an agreement to the terms stated above.