by Jonathan Halder | Jan 31, 2025 | MS Access, MS Access Queries, MS Access VBA Coding
Enjoy! ‘Creating a Passthrough query read only recordset on the fly in VBA ‘Put this in a normal module, call it from any other module ‘This is requiring DAO.Database and DAO.QueryDef objects so that ‘ the recordset will survive after the...
by Jonathan Halder | Jan 23, 2025 | Blogging, MS Access, MS Access Queries
If you have a table with duplicated rows, a common requirement is to try to normalize those rows by extracting distinct information from each row, placing it into another table, and relating them with an ID. But how do you find if there are any differences between...
by Jonathan Halder | Jan 22, 2025 | Blogging, MS Access, MS Access Queries, MS Access VBA Coding
I’ll get back to working on the custom tags class tomorrow. Today I want to share a solution I worked out in order to swap numeric values in an Access DAO SQL statement. So, I had a need to import records into a table where there may be existing records of the...
by Jonathan Halder | Jan 10, 2025 | Blogging, MS Access, MS Access Forms, MS Access Queries, MS Access Reports, MS Access VBA Coding
Another gotcha in Access is when you use a function of any kind as a query field or as a bound field on a form or report. This can also be done in Conditional Formatting fields in forms and reports. Let’s say you bind a continuous form field to the builtin...
by Jonathan Halder | Jan 8, 2025 | Blogging, MS Access, MS Access Forms, MS Access Queries, MS Access Tables, MS Access VBA Coding
Today I had a weird problem that took me about 2 hours to track down. I had a normal form in Continuous view that was not triggering an error of any kind, but would not write to the record. It could see all the records, you could navigate to them, and I had a delete...
by Jonathan Halder | Dec 27, 2024 | Blogging, MS Access, MS Access Queries
Today I was splitting an address out of a table in order to replace the functionality of a single embedded address to multiple addresses. I had a Job table with the fields: Job Table fields: Job_ID, Address, city_job, state_job, zip_job And I am going to be removing...
