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

Calculating the height of a sub-report

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

MS Office Dev Team is not perfect and neither are we!

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

What’s Your Work Flow?

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

Quick tip: DAO.Database AffectedRecords property

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

TDD – one small change at a time

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

    • When Your Access Power Users Want Subdatasheets—Here’s the Fix
    • Pair Programming Dreams and TDD Goals: A Personal Dev Update
    • Stuck with a Non-Updateable Query in Access? Try This Simple Fix
    • Access Report Layouts: The Page Header Fix You Didn’t Know You Needed
    • Focus your Access skills

    Recent Comments

    1. RichardRost on When Your Access Power Users Want Subdatasheets—Here’s the Fix
    2. RichardRost on Breaking the Triangle: Can You Really Have It All in Access Software Projects?
    3. Jonathan Halder on Mastering CROSS JOIN in SQL Server: From Cartesian Products to Reusing Calculated Columns
    4. Colin Riddington on Mastering CROSS JOIN in SQL Server: From Cartesian Products to Reusing Calculated Columns
    5. Neil Sargent on Two Form Filtering strategies

    Archives

    • August 2025
    • 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.