Microsoft Access parameter queries enable you to pass criteria from outside a query. This article shows how they can be called from VBA.
Editing Excel Worksheets with Microsoft Access
It’s actually possible to populate specific cells in an Excel worksheet with information from your Access database. Here’s how you do it.
Read Time:
14 Min
FREE Course – Managing Your Data with MS-Access
In early 2020, I created the online course Managing Your Data with Microsoft Access which showed how to create an entire Access application from start to finish. This course has over 5 1/2 hours of video instructions covering the creation of tables, forms and reports along with specialty topics like printing Dymo labels from Access. […]
Read Time:
2 Min
Connecting Microsoft Access to MySQL
In my latest video, I demonstrate how to use Microsoft Access as a front-end for MySQL without having to create a DSN entry on the client machine. Access easily connects to MySQL through an ODBC connection but the standard practice is to create a dedicated data source under the ODBC Data Sources Administration panel in […]
Read Time:
3 Min
Filtering Combo Boxes in Microsoft Access
Combo boxes are extremely useful in Microsoft Access and other design environments. They provide a compact control from which your users can access a drop-down menu that enables them to choose from a variety of options. In my applications, combo boxes often pull their rows from lookup tables such as product or customer lists and […]
Read Time:
2 Min
Customizing Reports in Microsoft Access
In my latest video, I go into more detail about Microsoft Access report settings. This video is also an addition to my tutorial series, Managing Your Data with Microsoft Access which is now free on YouTube. Microsoft Access has always been known for having a great report designer with which you can put together professional […]
Read Time:
3 Min
Splitting a Database in Microsoft Access
My latest video shows how to split a database in Microsoft Access to separate the data from the user interface and programming elements. Access can link to data from different file formats including Excel, text files and other Access databases. For multi-user applications, you can have an Access file with just the forms, reports, queries […]
Read Time:
1 Min
Online Course – Managing Your Data with Microsoft Access
One of the things I hear about Microsoft Access is that it’s simply too complicated for many people to work with. This is because Access is designed for building database applications that can be used to automate and manage processes. Too few resources approach it from that perspective. This leaves users and students without the […]
Read Time:
3 Min
Recovering a Corrupted Table in Access With VBA
Recently, a client started experiencing errors, seemingly at random, in the database application I managed for them. The errors immediately started mentioning corruption and then these came through … Error 3167 – Record is Deleted Getting everyone out of the system and running a Compact / Repair seemed to help, but then … “The Microsoft […]
Read Time:
1 Min
Should You Keep Using Microsoft Access?
Full Disclosure – I Owe My Career to Access I’ve been working with Microsoft Access off and on since 1997, just a few years after it was first introduced in ’92. I can realistically say that learning Access made my career in I.T.. I’d had some previous programming and database experience with Borland Paradox and […]
Read Time:
2 Min