Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
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...
Calculating the height of a sub-report
First of all, it's good to know that you can add a report to a sub-report control on a form. If you need to display multiple groups of data for informational purposes on the form, this can be a real game changer! I have a routine I use that's in my library to...
MS Office Dev Team is not perfect and neither are we!
Had an interesting little bug in Office today in which a solid 2px black (#000000) border does not appear around a subform control (and this ends up applying to many other controls and shapes as well) I was really scratching my head, until I went online to find out if...
What’s Your Work Flow?
When working with a particular customer, it is very beneficial to have a plan on working on their database and being able to implement your new database changes effectively. Ideally, you might have a fully automated pipeline that would allow you to test and deploy a...
Quick tip: DAO.Database AffectedRecords property
If you've ever wondered whether a SQL statement you executed actually modified any records, there is a property of the DAO database object that can help you. You can get the number of affected records of a DELETE, UPDATE, or INSERT type query immediately after you've...
TDD – one small change at a time
Back 6 months ago I was asked to add new fields to check for the validity of a line item on an order. This caused me to go through a rather extensive process to break dependencies on an Access form so that I could test it without having to launch the form and build an...
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...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994