Danny Lesandrini

I have said it before, and I will say it again; Access is the best reporting tool on the market. Anyone who thinks otherwise just has not experienced the power of writing reports in Microsoft Access. Power? Yes, and plenty of it. Follow along as I demonstrate just a few examples of things you can […]

Buy this book I want to explain how I came to be in possession of this book. Though I’ve been programming with MS Access for over 7 years, I only just recently joined my local Microsoft Access User Group .  I finally rearranged my life so I could attend meetings and joined the group. The […]

This should be easy! Yes, deleting duplicates should be easy, but it’s not. A Google search for newsgroup posts about deleting duplicates scored over 2500 hits. Clearly, this is a common problem. The confusion is compounded, no doubt, by the existence of the built-in Find Duplicates query wizard. While this wizard does a great job of helping […]

The Problem Coming up with a meaningful title for this article was the hardest part. The issue is one that I have seen a couple times in the Access newsgroups, but it is hard to describe without a specific example. One post to comp.databases.ms-access some years ago put it this way: I would like to […]

A while back, I replied to a post at the Comp.Databases.MS-Access newsgroup with the subject line of "What’s the simplest way to merge two databases?" The user had attempted to bring in the data using the File | Get External Data menu option, but he discovered that all he accomplished was to import his tables. […]

When was the last time you gave thought to the naming conventions you use? Do all of your methods contain regular error handling code? What about “flower box” comment blocks in method headers? If you’ve never been good about coding standards, or if your good intentions are sometimes sacrificed when you’re working in “crunch mode”, […]

Microsoft Access is a two-fold blessing for programmers. In addition to being a fantastic development platform, its wide popularity as an office productivity tool helps to sustain a market for end user data reporting utilities. Savvy developers know how to cash in on this opportunity by writing focused applications with a clear objective in mind. […]

download code for this article Access XP now simplifies the import and export of XML, but how will you put this new feature to work? Perhaps the question of how to make good use XML will become clearer as your database applications begin to interact with .NET projects, but you don’t have to wait. In […]

download code for this article So you’re dying to use XML in your applications, but you don’t know where to begin. You’ve heard that XML is easy to import and export from Access XP, but you have yet to come up with a good use for it. The following article explains how to use XML […]

You only get one chance to make a good first impression. What first impression do your Microsoft Access applications give? No matter how clever your code, when a client sees misspelled words on forms and reports, it screams, “Loser”! Up until now, spell checking object properties in Access has largely been a manual process. All […]

I first saw a reference to SQL Compare in a SQL Server newsgroup post back around the summer of 2000. We were in the process of converting hundreds of MS Access queries into SQL Server stored procs, and development was fast and furious. Although we tried to consistently document schema changes, we invariably missed things. […]

Having read a lot of SQL Server books written for DBAs, I was anxious to see what Louis Davidson had to say about SQL Server 2000 from the developer’s point of view in Professional SQL Server 2000 Database Design, published by Wrox Press. In his “Who is this book for?” paragraph, he indicates that this […]