Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
CustomTags – changing to utilize RubberDuckVBA testing
Ok, so to use test driven development here, I will start writing tests to describe the behaviors of the control I want and then code to make the tests pass. I copied the code from the module from last time with the TestCustomTags Sub to a new Test module I created...
Custom tags for form controls – further refining a desired syntax
So far my idea just kind of sucks. It's ok, sometimes one just has a sucky idea. I think what I'd really like to be able to do is something like this: ' In a form object, wouldn't it be nice to be able to do this? Private Sub Form_Load() ' Ideal custom tags...
The Proxy Design Pattern in Access VBA
I've been reading a book about Design Patterns. This particular book has Java sample code. It is written by Robert C Martin and is called Agile Software Development Principles, Patterns, and Practices. I had been trying to wrap my brain around separating database...
Using Passthrough Queries for Reports in Microsoft Access
There is no way to directly place Passthrough SQL into a Report RecordSource property. Reports want DAO recordsources and in some cases, need a table object to work off of. However, if you are using SQL server and want to utilize a SQL view, you can link it as a table...
How not to generate unique numbers from existing ones
Today one of my customers ran into a problem with my coding of a system meant to group related lines together on a purchase order. There are estimating details that contain an affiliation number for grouping lines together. They are unique per phase number. These need...
Custom Tags For Custom tags for form controls – reimagined code
I'm imagining what the new code might look like based on the last message I wrote on this topic. Here is the URL to the previous article: https://www.accessjumpstart.com/custom-tags-for-form-controls-the-case-to-use-them-for/ So given this kind of syntax: Dim...
Just show the city from the address we chose. Simple.
In today's adventure, I discovered what I thought was a simple change was not so simple. The system I'm working on has jobs and each job has POs written as part of doing the job. Each PO is delivered to an address which is USUALLY the job address, but not always, so...
Tabbed view – tabs vanish in Access
Ok, should have done a screen shot, and I could go back and recreate it and get one, but not in the time I have right now... 😀 I was working in an app and had a Class outside of a form that had a function to get a reference to the form by name if it had been lost. A...
Custom tags for form controls – Beginning to code the solution
So I'm doing some proof of concept here. I want to use a starting syntax like the following in the Debug.Print line: Public Sub TestCustomTags() Dim testCT As CustomTags Set testCT = New CustomTags Dim ctl As Access.Control Set ctl = Form_TestForm.TestControl...
Using RecordsetClone to modify other records on a subform
Today I wrote up a quick proof of concept for a task to propagate changes to other records that matched a key of a cost reference number and a phase number. In this case, I wrote a before update event routine to check to see if there were other records that met the...
My musings on the phenomenon that is “Microsoft Access”
Access is an interesting animal. It's a Windows desktop app included in the Microsoft Office family originally touted as a low-code no-code relational database management tool. It received decent attention for a while, getting relatively serious new features through...
De-duping characters from strings in VBA again!
Thanks to Cristian Buse a list subscriber and amazing VBA programmer. He replied to the message yesterday about duplicates and pointed me to this StackOverflow question and answer:...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994
info@halderconsulting.com