Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
Access as a low cost option
Is Microsoft Access really a low cost option? It certainly can be if you are a DIY person who already owns Microsoft Office and think of low cost as "not spending lots of cash". There is always a learning curve which takes time to work through, as well as the time it...
Writing tests for legacy code – Part 5
Yesterday's message: Writing tests for legacy code – Part 4 | Access JumpStart Here is the full code I am discussing: '@TestMethod("DeleteAction") Private Sub GivenConcreteGroupDeleteTriggered_WhenReadOnlyStatusType_RequirePassword() On Error GoTo TestFail 'Arrange:...
Writing tests for legacy code – Part 4
Yesterday's message: Writing tests for legacy code – Part 3 | Access JumpStart Before diving into the next piece of the function, the Act, here is the full code: '@TestMethod("DeleteAction") Private Sub...
Writing tests for legacy code – Part 3
See yesterday's message in the archive here: Writing tests for legacy code – Part 2 | Access JumpStart For reference, here is the full function I am discussing. '@TestMethod("DeleteAction") Private Sub...
Writing tests for legacy code – Part 2
See yesterday's message in the archive here: Writing tests for legacy code – Part 1 | Access JumpStart I'm going to start breaking down the test I wrote and what I'm doing and why. Here is the whole test: '@TestMethod("DeleteAction") Private Sub...
Writing tests for legacy code – Part 1
As I am continuing on my Test Driven Development journey, I am starting to learn how to write tests as I add new features to my code. A recent example would be a requirement to ask for a password if the user was trying to delete a line in an order. There are...
Tree View Control
I watched half of a new Access Users Group video on the tree view control by Pete Poppe which I link to at the bottom of this message. I learned something new. The last time I used the Treeview control I never ended up implementing it in a customer's project because...
Cost and Price for custom written software
In the consideration of charging customers for custom software you are writing for them there are different terms here that sometimes get used interchangeably. I'm going to define them for this article as two very distinct and separate things and will do so in terms...
Can you make a living with Microsoft Access?
The resounding answer to this is "Yes". BUT - what if you can't seem to make it work? There are actually a number of ways to monetize your Access skills: Offering your services as an Access Application developer to create, modify, and/or maintain Access databases.Many...
Simple Active / Inactive Access Combo Box Dropdown List
I was working with a friend yesterday and he was showing me how he was showing a bound dropdown list on a combo box on a bound form. He was using a UNION query and VBA to update the combo box RowSource value each time to include another row in the dropdown if the...
Access VBA isn’t always the quickest thing out there…
Don't get me wrong. Access VBA can perform very well in most situations. There have been a few times where I've needed to improve the speed of some function I was using and Access just took too long. One of those is hashing values for files. There is a hashing...
Troubleshooting an ODBC error in Access
Access Error (3155) ODBC: "Query timeout expired". It happened when trying to insert a new record into a linked table called "order" I'm using ODBC driver 17 in this case and it happened twice. Not sure if the user tried to do it twice or if my code kept going and...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994