Access JumpStart 2.0 | Blog
A Rapid Development Framework for Microsoft Access
Recent Articles
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...
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...
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...
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...
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...
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...
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...
Custom tags for form controls – the idea
Every Access control has a tag property which stores a string. I've used this property before to store information about a control I'll need later. Kind of a poor man's custom property. Let's say you want to store something in that tag property, but then someone...
VBA Class initialization Options
In other languages, when you build a class, there are things called constructors which can take parameters when you instantiate the class as an object in order to initiate it. This is very handy, as you can abbreviate what you need to do into a much smaller number of...
Creating libraries for Access
We all re-use code in one form or another. Perhaps it begins by copying and pasting routines into a text file. Perhaps you've used people's online repositories of code that they place online, or you share your code in forum posts and search there for code help. Maybe...
Quick Links
About
Our goal is to help people simplify their business by providing software products to streamline their work.
Contact
(630) 423-4994