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 »Many users hope to quickly resend the meeting invitation to the attendees who have not made any responses. This article will show you how to achieve it. In my previous article – “How to Quickly Send a Notification Mail to the Meeting Attendees...
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 »