Access JumpStart 2.0 | Email Archive
A Rapid Development Framework for Microsoft Access
Email Archive
Access form starting on a blank record causes problems
My Access adventure today was helping work on a problem for a customer where they were getting errors on a form that was bound, and when opened automatically starts writing a default date and time to a record. The code checks to see if this record becomes valid as the...
When TDD doesn’t work
I had a problem with my Access program where I had separated the database from the business logic in order to test the business logic. My tests ran successfully on the business logic, but I had introduced an error on the db side creating the data in a live environment...
CoPilot’s refactoring abilities
I gave copilot this prompt: Rewrite this VBA function using Uncle Bob's SOLID principles:Function time_() '****************** Dim v_a As Integer Dim v_b As Integer Dim v_c As Integer '- - - - - - - - - v_a = Hour(Now) v_b = Minute(Now) '****************** If Hour(Now)...
How about an Access TDD Bootcamp?
This is an experiment today. I don't think I'll get fully through what I would want to do today, but I want to start a little series on using TDD along with a form in Access. What would the whole process look like from beginning to end? I'm thinking something like...
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...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994