Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
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...
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...
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...
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...
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...
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...
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:...
VBA function to de-dupe spaces from a string
I found myself in a position where I needed to be able to take an arbitrary string and remove consecutive spaces in a string, replacing them with one space each. Example:"7122A05 N62A N656"to: "7122A05 N62A N656" This is a pretty simple problem so I didn't really want...
Design Pattern – COMMAND for Access VBA
This is a very simple pattern. It simply is an object that does a command. It is defined by an Interface with a run() method like this: 'Class Module Command ' To be used to Implement as an interface Option Explicit Public Sub run() End Sub An interface doesn't get...
Access function to return SQL Server record set using passthrough query
Enjoy! 'Creating a Passthrough query read only recordset on the fly in VBA 'Put this in a normal module, call it from any other module 'This is requiring DAO.Database and DAO.QueryDef objects so that ' the recordset will survive after the function ends. 'The DAO...
Nested Error Handling – Example code and what happens
So this is my latest nested error test code. You can put it in any public code module and run MainProcedure to see what it will do. The thing to do here is to see how Access will behave in various scenarios and the code paths that execute and the ones that don't. Sub...
VBA Class errors and Break in Class Module option
So the reason I was getting strange behavior in some tests I was running was because there was a third party class which responsibly used an error handling scheme used in it's tests which required an error being raised with Err.Raise to pass up to the calling code. I...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994