Mike Wolfe - No Longer Set (Page 33)

Business

Sole Proprietorship vs. Partnership vs. LLC vs. S Corp. vs. C Corp.

What's the best type of business for you? It depends on where you're at on your journey.

Business

The Most Important Rule in Client Contracts

This rule can be the difference between project success and project failure; joy and misery; profit and loss.

Advanced

HRESULT: Use "Long" and Not "LongPtr"

If the return type of an API function call is an HRESULT in the C++ header file, it should be declared as a Long in VBA (and not a LongPtr).

Hidden Features

AccHitTest: Returns the Form Control the Mouse Clicked On

This undocumented form function can help you write a generic click event for label controls.

twinBASIC Weekly Update

twinBASIC Update: July 31, 2022

Highlights include improved support for building device drivers, initial support for keyboard menu navigation, and a milestone for the twinBASIC project.

Week in Review

Week in Review: July 30, 2022

Highlights include tips for designing Access apps for tablet use, sorting forms by combo box columns, and CUPID--an alternative to SOLID principles.

Announcement

vbWatchdog v4 Released

Version 4 of vbWatchdog just got released. If you don't already own a license for it, you should. And if you do, you should upgrade before August 31, 2022.

Professional Development

The Robot, the Technician, and the Fixer

What type of Microsoft Access developer are you? Being a robot is easy, being a technician is fun, but being a fixer is valuable.

Video

VIDEO: Modern On Off Buttons in Access

I recorded a YouTube video that demonstrates how to implement the Modern On/Off button feature that I wrote about yesterday.

Form Design

Modern On/Off Button in Access

Leave those boring checkboxes behind and move into the 21st century with these modern on-off switches for Microsoft Access. Very little code required!

Tools

Access Database Right-Click Context Menu Creator

Wouldn't it be great to right-click an Access file to compact or decompile it? With Daniel Pineault's awesome tool, you can!

twinBASIC Weekly Update

twinBASIC Update: July 24, 2022

Highlights include implementation of the form Controls collection, initial publication of the twinBASIC Guiding Principles, and the potential to write device drivers with tB.

Week in Review

Week in Review: July 23, 2022

Highlights include the latest edition of Karl Donaubauer's Access News, creating a custom splash form, and the public release of the SSMS-style "Access Studio" tool.

Commentary

The Curse of Knowledge

Even the world's worst programmer knows more about programming than most small business owners or department managers.

Deployment

Creating Pre-packaged Software with Microsoft Access

Microsoft Access is a poor choice for creating pre-packaged software applications. But does it really have to be that way?

Professional Development

$5,999: Microsoft's Insane Price for Access 2013

Microsoft does not make it easy to buy old versions of Access, even though you need them to distribute compiled .accde files for *still-supported* runtimes.

Tools

Changing Internet Explorer Options in IE Mode of Microsoft Edge

Did you try to change Internet Explorer options from IE Mode in Edge only to realize that you can't get to them? Luckily, there's an easy workaround.

twinBASIC

twinBASIC Weekly Updates

The twinBASIC weekly updates now have their own dedicated tag on nolongerset.com, making it easier to find the other twinBASIC articles.

twinBASIC Weekly Update

twinBASIC Update: July 17, 2022

Highlights include double-click to change form/control properties in the IDE, support for the Form.Show Modal argument, and a discussion about On Error Resume Next.

Week in Review

Week in Review: July 16, 2022

Highlights include 5 things NOT to do when writing code, embedding videos on Access forms, and--of course--more bugs. :-(

Code Library

IMPROVED: SelectedListBoxItems() Function

A clearer and (very slightly) more performant version of my SelectedListBoxItems function.

Code Library

SelectedListBoxItems() Function

It's not difficult to get the selected items from a multi-select list box, but it is tedious. This function makes it simple and easy.

Bug Alert

WARNING: Do NOT Declare DAO Fields As Field2, Field3, etc.

While declaring DAO Field objects as Field2 will get you additional IntelliSense, it comes at the risk of breaking working code when MS releases a new Field type.

Code Library

3 Ways to Get and Set the TitleBar Text for an MS Access Application

Here are three ways to set the Application Title for an MS Access application. My preferred method allows getting and setting with a single line of code.

Code Library

clsApp: My Application-Wide MS Access Singleton Class Module

I use many class modules in my applications, but this is the one I cannot live without.