by Jonathan Halder | Feb 13, 2025 | Blogging, MS Access, MS Access Forms, MS Access Queries, MS Access Tables, MS Access VBA Coding
In today’s adventure, I discovered what I thought was a simple change was not so simple. The system I’m working on has jobs and each job has POs written as part of doing the job. Each PO is delivered to an address which is USUALLY the job address, but not...
by Jonathan Halder | Feb 11, 2025 | Blogging, MS Access, MS Access Queries, MS Access Reports, MS Access VBA Coding
There is no way to directly place Passthrough SQL into a Report RecordSource property. Reports want DAO recordsources and in some cases, need a table object to work off of. However, if you are using SQL server and want to utilize a SQL view, you can link it as a table...
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...
