Category Archives: VBA
Dealing with File Names
Access applications can use Jet databases, other databases (as linked tables), or SQL Server. But sometimes you need to work with files on your hard disk. Bogdan Zamfir provides you with every function that you’ll need to work with file … Continue reading
DAO verses ADO – DAO isn’t Done Yet
There’s been a lot of talk these days about how obsolete DAO is and how all code should be ported to use ADO and ADOx as soon as you can manage. Michael and Karleen, however, discuss several areas where ADO … Continue reading
Convert Embedded Macros
Convert macros that are attached to a form or report This process converts to VBA any macros that are referred to by (or embedded in) a form or report (or any of its controls) and adds the VBA code to … Continue reading
Comparing DAO and ADO Recordsets
This month, Russell turns his attention to the Recordset object and shows the similarities and differences between the DAO and ADO Recordsets. The title of this article is almost certainly a lie. As I’ll show you, the number of methods, … Continue reading
An Average Column: I Mean, What Mode is Your Median
This month, Doug Steele follows up on an earlier article by Chris Weber to look at different ways to calculate “measures of central tendency”: mean, median, and mode. How can I calculate the median for my data? Before launching into … Continue reading
