Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
Tenatively laying out an application structure
Now I have some code. Here's what my form looks like so far: That contains the following module: 'Form_frmAccounts Option Compare Database Option Explicit Private InternalAccount As AccountInterface Private Function Acct() As AccountInterface If InternalAccount Is...
Implementing an Access architecture for the credit card payoff app
I am currently discussing a credit card payoff application I'm working on in terms of Model-View-Control architecture in a series of messages. In this message, moving back to forms, I have built a form (user interface) which I am going to think of as the user...
Test Driven Development and Tables in Access
As I think about and discuss an architecture for an Access application I was considering the data persistence layer again and thinking about why one might want to test it. For example, what if your application is meant to track historic events throughout the history...
Considering the various user interface functions of a form
Given a table as the persistence layer, we will use that table to save data for re-use. If there is a form bound to this table, what user interface functions does this perform? Controls bound to fields in the table are saved automatically based on various behaviors....
Why, Jon, Why??? For the love of VBA, Why?????
From my message yesterday:Separating business logic, user interface, and data persistence in a real world Access app | Access JumpStartI laid out a potential structure which included a Table which would be a data persistence layer a Form which represents a user...
Separating business logic, user interface, and data persistence in a real world Access app
Considering a simple app to calculate the number of payments it would take to payoff a credit card, how might I architect this in Access to optimize for separation of database, user interface, and business logic layers? Let's consider a simple app with a table like...
You can split a db, but can you split a form?
What would your strategy for splitting a form between logic and database record management? I'm honestly asking, because that's what I'm thinking about today. I'm thinking in terms of creating tests a la TDD style work. Having business logic that you could separate...
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...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994