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

VBA Compiler Constants are handy… beware of the details

by Steven Halder | Dec 5, 2022 | MS Access, MS Access Features, MS Access VBA Coding

You can control how your project is compiled. Have one “source base” that you use for multiple purposes, environments, or in multiple “modes” of operation. You can use Microsoft defined Compiler Constants and you can define your own....

Using the Access Web Browser Control

by Steven Halder | Dec 5, 2022 | MS Access, MS Access Features, MS Access Forms, MS Access VBA Coding

The Access Web Browser Control is not a Web Browser Object, but does contain one. To access the internal workings of the control with VBA code, it is most convenient to dimension and use variables as follows, where the name of the control is “MyWebBrowserControl”: DIM...

acCmdDeleteRecord – unintended problems

by Steven Halder | Dec 5, 2022 | MS Access, MS Access Forms, MS Access VBA Coding

Case Study The issueA form contained several combo boxes linked to tables, sub-forms, and a delete button intended to delete the current record.  The client noticed while deleting records that occasionally one of the combo box linked records would get...

Get a Daily Email

An email loaded with my tips and musings.

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

    Recent Posts

    • Breaking the Triangle: Can You Really Have It All in Access Software Projects?
    • 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!

    Recent Comments

    1. RichardRost on Breaking the Triangle: Can You Really Have It All in Access Software Projects?
    2. Jonathan Halder on Mastering CROSS JOIN in SQL Server: From Cartesian Products to Reusing Calculated Columns
    3. Colin Riddington on Mastering CROSS JOIN in SQL Server: From Cartesian Products to Reusing Calculated Columns
    4. Neil Sargent on Two Form Filtering strategies
    5. RichardRost on Why I think hourly billing is nuts

    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.