Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
Test Driven Development – splitting logic from DB
In a message I sent a few days ago: Test Driven Development Fakes Are Faking me out! I was lamenting that some tests I was trying to write using a fake testing object, simply were returning the values that I needed to pass the test. I'll use a small bit of my objects...
Access development buyer profiles
When I was younger, I was a staunch DIYer (Do-it-yourself) programmer. Granted, this was a great advantage in many ways in those days. I didn't have to spend money on add-ins or have to spend time to learn how to use them. I also didn't have to spend money on software...
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...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994