Danny Lesandrini

Creating in-memory ADO recordsets may be a solution in search of a problem, but I find the process fascinating and there’s been at least one occasion where it was just the right thing for my application. Maybe it’s just what you need too. The download has everything you’ll need to check it out. Working with […]

If your database has a table with "person" information, odds are it has an email column. If your users collect email addresses, odds are they want to send emails to persons in the database and before long, someone’s going to get it into their head to send out an email "blast" or batch. There are […]

One of the truly great features of Microsoft Access is the [WhereCondition] parameter of the OpenForm() and OpenReport() methods. Forms and reports are easily filtered by passing a Where clause as simple text to the Open method of a form or report. As shown in the screen shot, IntelliSense helps you see where to insert […]

In mid-July I received an invitation to preview the Microsoft Office 2010 Technical Beta, including Microsoft Access. While some of the exciting new server-specific features and capabilities are still under the nondisclosure agreement, I’m free to describe what’s new in version 14 of client application. In fact, you can see the new Office 2010 Technical […]

I know of one Access developer who believes that the Access MDB format is evil and that ADPs (Access Data Projects) should be used exclusively. On the other hand, I found one well-known Access developer who believes there are “no advantages to an ADP.” The truth, of course, lies somewhere in-between. Neither is evil and […]

The function, DistListPeek(), peeks into all the distribution lists and allows you to extract the names and email addresses. As you might expect, the Outlook Security model doesn’t like it when code does this either, so again your users will get a security dialog asking for permission to proceed. It seems like the Redemption library […]

Sooner or later, every Access VBA developer is asked to make Access play nice with Microsoft Outlook. Sending emails from Access is popular but so is creating appointments, tasks and contacts. The ability to read and process Outlook emails is also very useful, as is the ability to extract names and emails from the user’s […]

I admit that certification doesn’t make one an IT superhero but it’s something every developer should consider. While I was earning a handful of certifications back in the late 1990’s some of my colleagues were inclined to minimize their importance but I can honestly say I’m glad I put forth the effort and expense to […]

Ok, this truly is a ‘basics’ article. I’ve never been fond of the TreeView & ListView because the library file that exposes these controls, MSComCtl.ocx, always seemed to behave a little quirky. It was as if I could never be sure which version of the controls any given user would have on their computer and […]

The search for fresh user interface and menu systems continues. Readers of my article Something Not Entirely Unlike Access have asked for more suggestions. Frankly, I didn’t think I had anything more, but a recent new application request prompted me to try a new approach, and what follows is the result. You can download the […]

Let me begin by revealing that I’m not an expert with bitmasks. However, this fact should bring a little comfort to the uninitiated because it means that anyone can implement multiple selections using a bitmask field and operators. Odds are, you’ve been using them for years, but simply didn’t notice it. If you’ve ever set […]

Managing files should be really simple in Access, but it’s not. Well, once you get familiar with the File Scripting Object (FSO), it’s not so bad, but getting started is the painful part. To help you along, this month’s download includes sample code for both Access (early bound) and VB Script (late bound). Here’s what […]