Access JumpStart 2.0 | Email Archive
A Rapid Development Framework for Microsoft Access
Email Archive
Count Distinct in SQL Server and Access
In SQL Server you can count up the distinct values in a column of a query using syntax like: SELECT SalesPersonID, COUNT(DISTINCT CustomerID) As NumberOfDistinctCustomersServed FROM ClosedSales GROUP BY SalesPersonID This will give you the number of unique customers...
When to quit
First of all I am notoriously bad at knowing when to quit. I keep trying things thinking I'm almost there and that I'll get that code working in the next 5 minutes. Then 3 hours later I have a huge mess and it's not done yet with me scratching my head. So when should...
End to end problem solving
Today's adventure in Access was a problem my customer was having with an imported file. Their shipment requests were being supplied via electronic delivery and then they send a confirmation via the same electronic delivery system. The recipient of the shipments asked...
Upgrading our AJS template
In today's adventure, I have a complex application I am updating from an older version of our Access Jump Start application template from when we were calling it RDF (Rapid Development Framework). I am doing this so I will have access to some of the newer features as...
Test Driven Development and Changing Code
I've been a relatively recent newcomer into Test Driven Development, only starting to implement it into my projects and been working on learning it since 2023 or so. Today, my Access adventuring leads me to work on changing the behavior of custom rule of the system....
Be careful! Don’t fall down the rabbit hole.
Today's adventure in Access involved discovering I'd been working on behavior in an application that although is recognized that it needs fixing, was not what my customer wanted me focusing on. You fall down the rabbit hole (as I did) when you become singularly...
Unintended Changes Deployed in an Access program
Today I got an email from a customer that they couldn't enter information into a certain form and asked me if I had it locked. Immediately, I knew I had messed up because I had made a change in my development database in which I changed that's form recordset to...
Dragging and dropping between Access Files
Did you know that you can drag and drop items from the navigation pane in one Access database to another Access database? I used this feature today as I needed to copy a somewhat complex form to display a series of entries in a linked table in both databases filtered...
Lazy Loading Class Instances on a form
One of my recent adventures in Access was to fix an issue where occasionally a class instance setup by the Form Open event was somehow getting blown away. I'm frankly not sure why. As far as I know the global variables on the form only get reset if you close and...
Ahh! Egg on my Face! (Or: Input mask and value options)
So I was wrong yesterday about phone number input masks and input values. An input mask value specifies a format, whether the mask is stored in the value, and the placeholder for users to enter data into the mask. This Microsoft web site discusses the pros and cons of...
Reformatting simple text based phone number strings in VBA
Today, for my customer's app, I wrote some VBA code in an after update routine of a textbox to strip out non-numeric characters and reformat them into a phone number format the customer wanted. Private Sub employee_phone_number_AfterUpdate() If IsPhoneNumberThere Then...
ADO and DAO recordset Filter property
Today, my customer for whom I had enabled transactions was having problems with the update routine. Ultimately, it stemmed from the fact that the Filter property is treated differently between the ADO recordset object and the DAO recordset object. I had originally...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994