Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
Access Programming – What I do and Why (source control)
So in terms of Access Programming, I have over the years, built up tools and practices I use which help me develop better, faster, and more efficiently. Many of these tools and practices were developed specifically in order to solve recurring problems. Ok, so let's...
TDD – 004 – Passing a form to our listener part 1
Ok, so now we have just created a test for creating an instance of a FormListener class, but there's nothing in the class yet. What do we want to test next? I need to think about the next bit of functionality I will want in this class in a way that I can test it. So I...
TDD – 003 – Getting our first test to pass
So we have created our first test and it is failing. Opening up the RubberDuckVBA Test Explorer and running all the tests shows us our failing test: Now it's time to make it pass. To do this I'm going to Create a new Class Module using the Insert -> Class Module menu...
TDD – 002 – initial design and first test
Design for a form auditing object Ok, so before I can write any tests, I have to think just a little bit about what I want to create so that I can start writing meaningful failing tests that will move me toward where I want this to go. Whew! Sounds kind of confusing,...
TDD – 001 – the beginning
Why do we want to use Test Driven Development? It is less error prone, producing better code which is more reliable and able to be verified from multiple paths. It allows us to express our intent in the form of a test. This forces us to create a better design. It...
VBA Compiler Constants are handy… beware of the details
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
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
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...
MS Access Runtime Error (2176): “The setting for this property is too long.”
This error occurs because, drum-roll please.... The setting for this property is too long. So in this particular case, the developer was trying to create a long SQL string using multiple UNIONs with a complex query and trying to set this string to the RowSource...
What do those error codes mean?
So you're updating some VBA code you wrote a while back... Now what is the Error Processing section doing? What do those Error Numbers mean? I shoulda' written some comments! Well you can just look up each of those error descriptions quickly by using the AccessError()...
Your Access Application has Crashed! What to do?
So your Access application crashed and user feedback is not specific enough to diagnose the problem? It sure would be nice if your application VBA code could send you an email with all the error details! Well, The Smiley Coder has written and published just such a...
Gotcha! You thought you deleted a subform record but…
I recently experienced a frustrating issue that had me scratching my head for a while. I had a PO form with a Line Item subform and I could edit lines and when I tried to delete a line it was removed from the subform. BUT... If I closed and reopened the same PO...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994