Mike Wolfe - No Longer Set (Page 39)

Making Sense of SQLOUT.TXT

You've enabled ODBC Trace SQL Mode and created a sqlout.txt file. But do you know what to do with it now? Let's explore.

COM

The IUnknown Interface

All COM objects are required to support at least one interface: the IUnknown interface. In this short article, we explore the three methods of IUnknown.

twinBASIC Weekly Update

twinBASIC Update: March 6, 2022

Highlights include a sneak peek at the new twinBASIC IDE (currently under development) and a brief comparison between RAD Basic and twinBASIC.

Under 100

What is COM?

The concept of COM explained in under 100 words. #Under100

SQL Server

Editing Data Directly in SSMS

Query results in SQL Server Management Studio are read-only by default. Follow these steps to edit SQL Server table data directly inside SSMS.

Debugging

Find the Yellow Highlighted Line When Debugging in VBA

Did you ever lose your place while debugging in VBA? Here's an easy way to find it.

Tools

3 Ways to Find sqlout.txt

Finding ODBC TraceSQLMode's sqlout.txt file can be deceptively difficult. Here are three approaches to make it easy. At least one is guaranteed to work.

Quick Tip

Preventing Line Break After Debug.Print Statement

Every time you call Debug.Print in VBA it outputs to a new line in the Immediate Window. ... But what if it didn't?!?!

Debugging

Troubleshooting SQL Server Connection Errors

"SQL Server does not exist or access denied." One error. Dozens of possible causes. Read on for a bunch of practical troubleshooting tips.

twinBASIC Weekly Update

twinBASIC Update: February 27, 2022

Highlights include multiple form designer improvements and a *BIG* announcement about the future of the twinBASIC IDE.

Defensive Programming

A Safe Way to Add Temporary Code

A quick tip to ensure your temporary code disappears when the sun sets.

Commentary

Expect the Unexpected

Getting ready to start a complex project? Stressing about what might go wrong? Here's some advice to help lower that stress level.

Hidden Features

Declaring and Initializing Variables in the Same Line in VBA

You can't declare and initialize a variable in a single code *statement* in VBA, but you can do it in a single *line* of code with this handy trick.

Hidden Features

Inspecting the End of a Long Variable Value in VBA

You know how VBA cuts off the right side of a really long variable when inspecting its value via mouse hover? Did you know you can show the right side instead?

Code Library

How to Return the Precision and Scale of a Decimal Field in Access

There's no way to use DAO to return the scale and precision of a Decimal field in Access. Luckily, there's an easy workaround using ADO.

Hidden Features

Quick and Dirty For Loops in the Immediate Window

Did you know that you can write and execute entire For Loops in the VBA Immediate Window?

twinBASIC Weekly Update

twinBASIC Update: February 20, 2022

Highlights include checkbox-style list boxes, native Winforms progress bar and image controls, and an option to align controls to grid in the form designer.

SQL Server

SQL Server Connectors in 2022

To get access to the latest features--especially security features--be sure you're using the latest ADO provider and ODBC driver for SQL Server.

Quick Tip

Quick Tip: Force IntelliSense to Appear When Writing VBA

Does the IntelliSense dropdown ever disappear when you're writing VBA? Do you backspace and re-type the dot to get it back? There's a better way.

Commentary

Yes, VBA-Enabled Office Docs are a Significant Threat

VBA-enabled documents are commonly used to open the door for more virulent malware.

SQL Server

How Access Reads Data From SQL Server

How does Microsoft Access pull data from SQL Server? You'll be amazed when we pull back the curtain to expose how Access interacts with SQL Server.

Combo Boxes

Dealing with Inactive Items in a Combo Box Row Source

There are many ways to deal with inactive RowSource items in combo boxes. Here's a no-code technique that I find myself coming back to time and again.

Deployment

Adding a Machine-Wide Trusted Location in MS Access

Let me show you how to add a Trusted Location for every user on a device even if that device doesn't have a full copy of Microsoft Access.

twinBASIC Weekly Update

twinBASIC Update: February 13, 2022

Highlights include a new Settings filter bar and WinForms Controls Package updates included by default with future twinBASIC extension updates.

Announcement

Office to Disable All VBA Code in Files from the Internet

Beginning in April 2022, users will no longer have the option to manually enable VBA code in Office files downloaded from the internet.