Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
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:...
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...
More VBA Error handling scenarios using Err.Raise
I am running into a situation in someone else's code where an Err.Raise call is not getting handled by any of the upstream calling functions and ends up calling the main VBA system debugger displaying the VBA error dialog. I was trying to recreate the problem but so...
SQL Server query to check for normalization in row columns
If you have a table with duplicated rows, a common requirement is to try to normalize those rows by extracting distinct information from each row, placing it into another table, and relating them with an ID. But how do you find if there are any differences between...
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...
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...
Drop in Native VBA (No references needed) Scripting.Dictionary replacement
As I was working on some code to store custom tags related to controls, I thought it would be nice to use a dictionary object. Dictionary objects work by storing a value of some kind along with a key to find it. The Scripting.Dictionary object uses the VBScript...
SQL field value swapping
I'll get back to working on the custom tags class tomorrow. Today I want to share a solution I worked out in order to swap numeric values in an Access DAO SQL statement. So, I had a need to import records into a table where there may be existing records of the same...
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...
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...
Custom tags for form controls – the case to use them for
I wrote a couple of times last week about custom tags and creating a class that could store custom tag information. I am further refining the requirements of the class using a real world example of something I will be using it for. I'm bringing in an enum here that is...
Custom tags for form controls – considering usage options
Yesterday, I talked about creating a class for custom tags for form controls. In particular, I have a class I'll call FormResizer. I want FormResizer to be able to set and read top, left, width, and height properties for the original attributes of the control so that...
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