I wanted to take a query and format part of its output into English; a list of names separated by commas. The DAO Object Library includes a completely pointless Recordset.GetRows command which returns an unwieldy multi-dimensional array. How pointless and unwieldy? Well, the supplied example to Debug.Print FirstName, LastName and Title from Northwind.mdb’s Employees table [...]

This function allows you to set the opacity for a PopUp form. Normally, forms are fully opaque and you cannot see through the form. When it is partially opaque, you can partially see what is behind the form. I use it for smoothly fading in and out forms in my Microsoft Access application (specifically, a [...]

Frequently in Microsoft Access Visual Basic you will want to programmatically display a different record on a currently open form but this common requirement turns out to be a bit more fiddly than you might expect. Manually setting the Filter and FilterOn form properties or using RecordSetClone and FindFirst are all somewhat less than intuitive. [...]

This function allows you to bring a specific form to the top so that you can be certain that the user can see it.   To use: Save this code into a new module called FormHelper. Call FormHelper.BringToTop with the Form object you wish to bring to the top. The code is fully commented and [...]

Sometimes in Microsoft Access Visual Basic you will want to know whether a form is open or not. This common requirement turns out to be a bit more fiddly than you might expect. My original version of this function also returned True if the form was open but hidden or open in Design View. This [...]