Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
Sometimes you should just ask the customer
When the customer is having a problem with the output of the system, my first reaction is to check the logs and try to recreate the problem. In this case, the customer has a number of employees who use the system. He didn't know why something wasn't working and didn't...
Debugging in databases with complex code
Despite my best efforts, sometimes I end up with complicated code. The logic snakes and wraps around like crazy river rapids. Today, I had such a part of my customer's database that I was working in and it was not easy. Most of the time this problem occurs because...
Copying Access Tables / Data using VBA Real World Case – Part 3
You can find the previous parts of this message here: Copying Access Tables / Data using VBA Real World Case – Part 1 | Access JumpStart Copying Access Tables / Data using VBA Real World Case – Part 2 | Access JumpStart In Part 3 I discovered that the copied tables...
Some things to log in an Access Application
When implementing logging in your Access app, some of the things you might want to log are: Opening and closing of objects which have VBA associated with them. Typically Forms and Reports. Try to add a log message which includes the primary key when you edit or add a...
Agile Access Programming
If you haven't had the pleasure of Uncle Bob Martin books or videos, you're missing out. I'd recommend a search on YouTube for Uncle Bob's Clean Code. I watched a lot of his videos when I had an O'Reilly subscription and that led me to start learning how to do Test...
Complex Queries – Is there a way to simplify?
This morning I was working on a query for a customer report that took me longer than I expected and produced more problems than I expected. I actually had 3 tables named customers, orders, and payments. Customers can have multiple orders, and have a one to many...
Scrambling data to share a database
The Access 97 database I was trying to get working on my 365 Access was written to scramble data in existing tables in a destructive way so that users of a forum or other developers could look at code without seeing sensitive data. I copied some large tables I had...
Access 97 database converted, how do you test with multiple versions of Access?
Thanks to a reader of Jon's Access List, Xevi from Girona in Spain, I received a converted version of the Access 97 Data Scrambler database. The reader used Access 2010 to update the database to a format that could be read by the most recent versions of Access, which...
Help, I have an Access 97 database!
I didn't think this would be a showstopper, but guess what, it is! If you have a version of Access later than 2010, you cannot open an Access 95 or Access 97 database at all. You get a fun error message: And it won't do anything with the database at all. I need not...
Improving, Planning, and Reviewing your own work
I have been following a system for several years now called EOS or Entrepreneurial Operating System: EOS - Entrepreneurial Operating System for Businesses, home of Traction tools & library (eosworldwide.com) It has helped me create a rythym to my work life,...
Access JumpStart and vbWatchdog
Our Access application framework that Steve and I developed and use to build our apps is called Access JumpStart. It does not include vbWatchdog by default for those who buy our framework, but it contains code to work with vbWatchdog if the developer of the app has...
vbWatchdog Call Stack strategy
After my message yesterday, I updated my strategy a little bit. Yesterday, I added the code to my global error handler that is always called by vbWatchdog. I created a Call Stack string variable every time there was an error regardless of how it was going to get...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994