No Longer Set (Page 33)

Week in Review: October 8, 2022

Highlights include using Base64 encoding to embed images in Thunderbird, seven(!) IslaDogs articles, and episode 4 of Karl Donaubauer's Access NewsCast.

Announcement

Access NewsCast with Karl Donaubauer: Episode 4

Catch up on the latest news and updates from the Access world in episode 4 of Karl's webcast, with guests Colin Riddington, Wayne Phillips, and, of course, Viktoria.

Bug Alert

BUG ALERT: CurrentDb and DAO.OpenDatabase

If you are getting intermittent error messages saying you don't have exclusive access to your database, then this workaround may help.

Code Library

SetPredeclaredId(): Change the Hidden PredeclaredId Attribute of a VBA Class Module

This simple function overcomes the lack of a hidden attribute editor for PredeclaredId values in the VBA development environment.

VBA

3 Ways to Generate Temporary File Names in VBA

Here are three options for generating temporary file names in VBA. Which is best? As with many programming questions, the answer is, "It depends."

Code Library

A GUID-Based Temporary File Name Generator

If you need a reliable and fast way to create lots of temporary file paths, a GUID-based filename generator has some compelling benefits.

twinBASIC Weekly Update

twinBASIC Update: October 2, 2022

Highlights include a pile of new form and control properties, a form menu designer, visual tab stop indicators in design view, and a new twinBASIC LinkedIn group.

Week in Review

Week in Review: October 1, 2022

Highlights include Pivot Tables and Pivot Charts, exporting all Access tables into Excel, and many changes to future Access User Group presentations.

Code Library

Getting the Temp Folder in VBA

There are many ways to get the temporary folder in VBA. But if you look behind the curtain, there's really only one...

Video

VIDEO: Design Patterns with Access

"I fear not the man who has practiced 10,000 kicks once, but I fear the man who has practiced one kick 10,000 times." How Bruce Lee's advice applies to MS Access.

TempVars

tblTempVar: Creating and Populating a Table of TempVars

These three simple procedures: (1) create, (2) populate, and (3) create/delete + populate a local table with the contents of the TempVars collection.

TempVars

Populating a List Box with the TempVars Collection

If you use TempVars in your Microsoft Access applications, this handy function will bring visibility to the contents of that collection.

Announcement

Timeline for VBA Macros Blocked by Default in Microsoft Office

Enterprise customers are next in line to have macros blocked by default in Office files from the web. The policy addresses a real problem, but does it actually help?

twinBASIC Weekly Update

twinBASIC Update: September 25, 2022

Highlights include long-awaited VB6 form import support (experimental) and a community-led GitHub project to provide official documentation for twinBASIC.

Week in Review

Week in Review: September 24, 2022

Highlights include bug fixes in Access v2208, Microsoft's new Office update strategy, creating ACCDB/ACCDE files using code, and a series on TempVars.

TempVars

Safely Using TempVars in Queries

Calling TempVars directly from a query can cause issues. Instead, use this simple wrapper function to save yourself some potential headaches.

TempVars

Beware TempVars in Queries

Many Access users rave about using TempVars with queries. I decided to see what the hype was about. What I found shocked me.

TempVars

TV: The TempVars Class Module

A TempVars class module that provides visibility, type safety, IntelliSense, and compile-time typo checks.

TempVars

A Safer Way to Use TempVars

The TempVars object is an intriguing alternative to traditional global variables, but it has some shortcomings. Here's one way to work around them.

VBA

Namespaces in VBA

VBA may not have the same level of formal support for namespaces as VB.NET, but with a little creativity, we can realize the same benefits in other ways.