Danny Lesandrini

In last month’s article, I introduced a Microsoft Access Add-In I created some years ago, which I affectionately call the DataFast Utility. It includes a number of analysis tools that assist with the process of upsizing an Access application to SQL Server. If all of your queries are simple, the utility can even create stored […]

Analyzing and Migrating Queries Back in 2000 (remember Y2K?), Marc Israel started a series of Access articles on the theme: Migrate to SQL Server. Marc suggested several titles for the series but some of them were never written and recently, readers have been asking if those topics would ever be addressed. Migrating Access Applications to […]

My last couple of articles have featured a demo app affectionately named Something Not Entirely Unlike Access. The application employs a variety of methods to obfuscate the "Accessian" features. Last month, we discussed how to automatically resize subforms, the way some browser frames work. This month, we’ll tackle navigation. Once again, the download is the […]

Resize Subform Objects Code Jumping right into the code, you’ll notice that every form includes a public function named ResizeControls() which accepts two arguments: lObjWidth and lObjHeight. This function is called by the PARENT form, and the values passed are determined by Form properties called InsideWidth and InsideHeight. You will need to adjust the Height […]

"We want you to build an application in MS Access, but we don’t want it to look like Access. In fact, we want it to look like a web page … like a browser application." Can that be done? Judge for yourself. Below is the screen shot and here is the download with the working […]

It’s been a long time since I sought out a "For Dummies" book but when I first opened Access 2007, I knew what my next book acquisition would be: Access 2007 For Dummies. The new user interface was just too different and confusing to attempt to decipher without a little help. There are a number […]

Much has been written about managing recordsets for forms, controls and reports in Microsoft Access databases, but recently I was obliged to develop an application with a slightly new twist that required some creative recordset manipulation. The requirements were as follows: 1.  Program must be an ADP (Access Data Project), not an MDB 2.  The […]

Well, it’s not exactly the Holy Grail of SQL Server utilities, but it’s close. Imagine having the convenience of IntelliSenseTM from within SQL Server Management Studio. That’s what you get with Red-Gate Software’s new utility, SQL Prompt. Back in January, I reviewed SQL Refactor, also a Red-Gate product, of which I am very fond. Shortly […]

Query analysis tools for the stout of heart. Let me begin by confessing that I am not qualified to write this article. Everything you read below comes from Internet research, primarily from two sources: 1.  MSDN: Access 2002 Desktop Developer’s Handbook 2.  Google Groups Advanced Search for ‘Showplan’ I’d like to give special thanks to […]

This month we discuss Fancy Filtering Techniques for Queries on Steroids. Before we’re done, we will have shown you three ways to return a filtered query. If you want to play with the code for this article, download it here. The first method is the one you read about in chapter 3 of Access For […]

Years ago, I created an Add-In for Microsoft Access that was a toolbox of sorts, and I called it the DataFast Utility. It’s still available for download, but never was anything more than a crude collection of scripts that I found personally useful. According to my records, it’s been downloaded nearly 3000 times over the […]

The key words for today’s query tip are simple and dynamic. There are two ways to read data from a remote Access database:    Create a link to the table and open it.    Just open it. No, I’m not pulling your leg. Today we’ll see how you can write a query in Access that points to […]