by Jonathan Halder | May 5, 2025 | Blogging, MS Access, MS Access Reports, MS Access VBA Coding
I was using a quick technique today to hide certain fields on a report detail section that were repeating. There is a very quick solution to this in which you can use the “Hide Duplicates” property in the Format properties of a text box let’s say....
by Jonathan Halder | Apr 2, 2025 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access Reports, MS Access Tables, MS Access VBA Coding, Versioning
In today’s adventure, I have a complex application I am updating from an older version of our Access Jump Start application template from when we were calling it RDF (Rapid Development Framework). I am doing this so I will have access to some of the newer...
by Jonathan Halder | Mar 27, 2025 | Blogging, MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access Reports, MS Access Tables, MS Access VBA Coding
Did you know that you can drag and drop items from the navigation pane in one Access database to another Access database? I used this feature today as I needed to copy a somewhat complex form to display a series of entries in a linked table in both databases filtered...
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 | Feb 7, 2025 | Blogging, MS Access, MS Access Forms, MS Access Reports, MS Access VBA Coding
Ok, should have done a screen shot, and I could go back and recreate it and get one, but not in the time I have right now… 😀 I was working in an app and had a Class outside of a form that had a function to get a reference to the form by name if it had been lost....
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...
