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

Tabbed view – tabs vanish in Access

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

Custom tags for form controls – the case to use them for

by Jonathan Halder | Jan 26, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding

I wrote a couple of times last week about custom tags and creating a class that could store custom tag information. I am further refining the requirements of the class using a real world example of something I will be using it for. I’m bringing in an enum here...

Custom tags for form controls – considering usage options

by Jonathan Halder | Jan 21, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding

Yesterday, I talked about creating a class for custom tags for form controls. In particular, I have a class I’ll call FormResizer. I want FormResizer to be able to set and read top, left, width, and height properties for the original attributes of the control so...

Custom tags for form controls – the idea

by Jonathan Halder | Jan 20, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding

Every Access control has a tag property which stores a string. I’ve used this property before to store information about a control I’ll need later. Kind of a poor man’s custom property. Let’s say you want to store something in that tag...

VBA Class initialization Options

by Jonathan Halder | Jan 17, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding

In other languages, when you build a class, there are things called constructors which can take parameters when you instantiate the class as an object in order to initiate it. This is very handy, as you can abbreviate what you need to do into a much smaller number of...

Access Fields bound to a function – updating once or per record

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

    • Copying and modifying code / forms / objects
    • Two Form Filtering strategies
    • Poking around to find new customers
    • Setting up an automated Access App upgrade strategy
    • Sometimes one makes dumb mistakes :P

    Recent Comments

    1. RichardRost on Why I think hourly billing is nuts
    2. Using combo boxes to select an entry and update form fields | Access JumpStart on Hiding duplicate records using running totals over a group
    3. | Access JumpStart on Super Simple Code Kata
    4. Mike Wolfe on Running parallel SQL server databases for testing
    5. Custom Tags For Custom tags for form controls – reimagined code | Access JumpStart on Custom tags for form controls – the case to use them for

    Archives

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