News, views and articles from our membership
Recently I was presented with situation from a business user that could not be dealt with using any of the supplied intrinsic SQL functions – at least to my knowledge anyway.
I started doing some research and before long came upon something that was completely new – to me anyway. Some of you more experienced Access folks are probably up on this, but for the rest of us, I thought it was worth this commentary.
Continue Reading: MS Access UDFs »
Introduction:
On occasion, we may want to create a database on the fly to store information. This can seem a daunting task, but in reality it is quite simple once you know how. To this end, this article describes the steps necessary to do exactly that! The following routine will create an Access database from any VBA enabled application, such as Word, Excel, Outlook, etc…
Continue Reading: Creating an Access Database (on the fly) Using VBA and SQL »
This article explains how to retrieve a recordset from a database and place it in an Excel worksheet, using an ADO connection to pass SQL strings.
Continue Reading: How To Retrieve Data From A Database To Excel Using VBA, ADO & SQL »
Follow Us