Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
Measuring Height of controls using the CanGrow Property in Access (Part 3)
In the past 2 day's messages I have been wrestling with calculating the height of a report. In particular the detail section of a report inside a subreport control on a form in which the report is shown in report view (not print preview). This situation creates unique...
Measuring Height of controls using the CanGrow Property in Access (Part 2)
In Friday's message, I was working on determining the height of the detail section with a Text Box control that has the CanGrow property set to "Yes". It is possible to determine this when displaying the report in "Print Preview" mode using the OnFormat event or the...
Measuring Height of controls using the CanGrow Property in Access (Part 1)
This property is on form and report sections and many controls like Text Boxes. This seems to be a wonderful property for automatically adjusting the height of things on a form until you make the inevitable discovery: It only works in a form when you are printing the...
Access custom event registration
When registering events for controls on a subform, make sure you remember that you re-register those events after reloading the subform control via the SourceObject property. In my case, I was always loading a subform initially and the Open routine on the subform...
Access form starting on a blank record causes problems
My Access adventure today was helping work on a problem for a customer where they were getting errors on a form that was bound, and when opened automatically starts writing a default date and time to a record. The code checks to see if this record becomes valid as the...
When TDD doesn’t work
I had a problem with my Access program where I had separated the database from the business logic in order to test the business logic. My tests ran successfully on the business logic, but I had introduced an error on the db side creating the data in a live environment...
CoPilot’s refactoring abilities
I gave copilot this prompt: Rewrite this VBA function using Uncle Bob's SOLID principles:Function time_() '****************** Dim v_a As Integer Dim v_b As Integer Dim v_c As Integer '- - - - - - - - - v_a = Hour(Now) v_b = Minute(Now) '****************** If Hour(Now)...
How about an Access TDD Bootcamp?
This is an experiment today. I don't think I'll get fully through what I would want to do today, but I want to start a little series on using TDD along with a form in Access. What would the whole process look like from beginning to end? I'm thinking something like...
Test Driven Development – splitting logic from DB
In a message I sent a few days ago: Test Driven Development Fakes Are Faking me out! I was lamenting that some tests I was trying to write using a fake testing object, simply were returning the values that I needed to pass the test. I'll use a small bit of my objects...
Access development buyer profiles
When I was younger, I was a staunch DIYer (Do-it-yourself) programmer. Granted, this was a great advantage in many ways in those days. I didn't have to spend money on add-ins or have to spend time to learn how to use them. I also didn't have to spend money on software...
Test Driven Development Fakes Are Faking me out!
You write a test for the behavior you want. So far so good. You have to figure out how to interface with your system to write the test though. Today, I was adding a new type of status called "Internal Hold" for an order, and the line items each can also have that same...
SQL Server Express – Limitations?
SQL Server Express is a version of SQL server you can install on a computer available to all your Access Front End users that will provide a more robust back end than using Access accdb files. How much does it cost? It's free! So what's the catch? Not much of a...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994