The following article shows how to mark out and interrogate a calendar with the mouse. *In the real world, we’d open a form to read and write meaningful diary entries to a database. This exercise simply reveals the mechanics of right_clicking,...
Read more »Data on a server can be modified by examining the records ‘client-side’ in Excel VBA, changing them as required, and saving them back to the server. A more efficient way of doing this, particularly if the database is at a remote location and...
Read more »Where data downloaded from a database exceeds a combo box’s range, the new items are simply not shown. To counter this, the range that underlies List or Combo boxes needs to expand or contract to match the data. This article examines how to do this...
Read more »