by Jonathan Halder | Oct 25, 2024 | Blogging, MS Access, MS Access Tables
SQL Server Express is a version of SQL server you can install on a computer available to all your Access Front End users that will provide a more robust back end than using Access accdb files. How much does it cost? It’s free! So what’s the catch?...
by Jonathan Halder | Oct 24, 2024 | Blogging, MS Access, MS Access Forms, MS Access Reports, MS Access VBA Coding
First of all, it’s good to know that you can add a report to a sub-report control on a form. If you need to display multiple groups of data for informational purposes on the form, this can be a real game changer! I have a routine I use that’s in my library...
by Jonathan Halder | Oct 23, 2024 | Blogging, MS Access, MS Access Features
Had an interesting little bug in Office today in which a solid 2px black (#000000) border does not appear around a subform control (and this ends up applying to many other controls and shapes as well) I was really scratching my head, until I went online to find out if...
by Jonathan Halder | Oct 21, 2024 | Blogging, MS Access, MS Access VBA Coding, Versioning
When working with a particular customer, it is very beneficial to have a plan on working on their database and being able to implement your new database changes effectively. Ideally, you might have a fully automated pipeline that would allow you to test and deploy a...
by Jonathan Halder | Oct 18, 2024 | Blogging, MS Access, MS Access Queries, MS Access VBA Coding
If you’ve ever wondered whether a SQL statement you executed actually modified any records, there is a property of the DAO database object that can help you. You can get the number of affected records of a DELETE, UPDATE, or INSERT type query immediately after...
by Jonathan Halder | Oct 17, 2024 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding, TDD, Versioning
Back 6 months ago I was asked to add new fields to check for the validity of a line item on an order. This caused me to go through a rather extensive process to break dependencies on an Access form so that I could test it without having to launch the form and build an...
