Access JumpStart
  • Homepage
  • Blog
Select Page
  • Homepage
  • Blog

Access Report Sorcery: Making the Last Page Play by Different Rules

by Jonathan Halder | Jul 17, 2025 | Blogging, MS Access, MS Access Reports, MS Access VBA Coding

I had a customer with an Access database who wanted me to tack a page with completely different info and format to the last page of a main report. This main report would run in an automated fashion and is emailed to a list of users and it is also able to be run...

Comparing 2 data sets visually

by Jonathan Halder | Jun 20, 2025 | Blogging, MS Access, MS Access Queries, MS Access Reports, MS Access VBA Coding

I was asked by a customer to mark fields in red that changed each week in a report. So what strategy did I come up with? Well first I need to store the data from the original run of the report. The customer wants to know what changed since the last automated report...

Hiding duplicate records using running totals over a group

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....

Upgrading our AJS template

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...

Dragging and dropping between Access Files

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...

Using Passthrough Queries for Reports in Microsoft Access

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...
« Older Entries

Get a Daily Email

An email loaded with my tips and musings.

    We won't send you spam. Unsubscribe at any time.

    Recent Posts

    • VS Code, AI, and Me: A Beginner’s Tale of Plugins and Possibilities
    • Access Report Sorcery: Making the Last Page Play by Different Rules
    • Persistent Intelligence (In Progress): Exploring AI Tools for Managing and Modifying Access Codebases
    • Don’t let a “perfect storm” get you down!
    • When life gets overwhelming… choose to stop.

    Recent Comments

    1. Jonathan Halder on Mastering CROSS JOIN in SQL Server: From Cartesian Products to Reusing Calculated Columns
    2. Colin Riddington on Mastering CROSS JOIN in SQL Server: From Cartesian Products to Reusing Calculated Columns
    3. Neil Sargent on Two Form Filtering strategies
    4. RichardRost on Why I think hourly billing is nuts
    5. Using combo boxes to select an entry and update form fields | Access JumpStart on Hiding duplicate records using running totals over a group

    Archives

    • July 2025
    • June 2025
    • May 2025
    • April 2025
    • March 2025
    • February 2025
    • January 2025
    • December 2024
    • November 2024
    • October 2024
    • September 2024
    • August 2024
    • July 2024
    • June 2024
    • May 2024
    • April 2024
    • March 2024
    • February 2024
    • January 2024
    • December 2023
    • November 2023
    • December 2022
    • March 2022
    • January 2022
    • June 2021
    • November 2020
    • October 2020
    • September 2020
    • August 2020
    • July 2020
    • June 2020

    Categories

    • Blogging
    • MS Access
    • MS Access Features
    • MS Access Forms
    • MS Access Queries
    • MS Access Reports
    • MS Access Tables
    • MS Access VBA Coding
    • TDD
    • Uncategorized
    • Versioning
    Copyright © Halder Consulting Inc.