Skip to content

Category: Tips

sort code tips and tricks

Quickly Add Items to a Dictionary

The Dictionary is a great class for managing a collection of items. A Dictionary gives you fast lookup of information which consists of two parts. The first part is a key that is a unique way to identify a value, which is the second part. These are each Variants so you can put any data type you want into the Dictionary.

Comments closed

Guest Post: Process and Structure to Control Clutter

Ever been unable to find that document you need for your next meeting?

Have you lost focus while working on one thing because you can’t stop thinking about something else? Feeling overwhelmed? There are several types of clutter: physical, technology, and mental. And that clutter is likely affecting you negatively. 

Comments closed

Tip: How To Deal with A Lot of Columns in Database Tables

Most of the time, the access to our databases tables involves a small amount of columns (fields), so the use of the Field method of the RecordSet class is the most practical approach to retrieve the selected columns values. But what can we do when the query returns, for example, dozens of columns we need to get values from?

Comments closed