VBA for Access (but as a larger question for VBA and VB in general.)
The documentation I have access to gives a rather vague explanation of exactly what the property set function in a class module does and how it relates to the set statement in the standard module that calls it. I don't expect a full tutorial here, but perhaps a souce where I could find a (few) very simple example (so I don't have to wade through a lot of difficult code) in order to see how it works.
It seems to set a reference to an object. After that is done, where exactly is the object available? Is it available to the standard module, or available only to the class module? This is one of those questions that you are not even sure what the question shoul be because the info is so scanty.
To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.
I see at least one EE question a week that pertains to using temporary tables in MS Access. But surprisingly, I was unable to find a single article devoted solely to this topic.
I don’t intend to describe all of the uses of temporary tables in t…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another.
Base the dependent combo on a query for its row source:
Add a reference to the first combo on the form as criteria i…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database.
Split up all multi-value fields into single values:
Split up fields that belong to other things into separate tables:
Make sure that all record…