Mike Wolfe - No Longer Set (Page 57)

Code Library

Sticky Wicket: Looping by Month

Some programming problems are difficult to solve. Others are difficult to solve clearly.

Commentary

You're Not an Impostor

You're good enough, you're smart enough, and doggone it, people like you.

Code Library

RegOp Quick Tip

Be respectful of your user's registry. Store all your applications' settings in a dedicated publisher subkey.

Code Library

RegOp Class for 64-bit VBA

Updating a classic VBA registry reading and writing class module for 64-bit compatibility.

Tools

Hiding Shortcuts in Everything

Here's a quick tip from Tom Wickerath for hiding shortcut files from your Everything file search results.

Risk Management

The Allegory Explained

What does delivering mail have to do with writing software applications? I'm glad you asked.

Risk Management

Mail: An Allegory

Behold, the world's greatest literary allegory since George Orwell penned "Animal Farm."

Professional Development

Growing a Business

I used to think owning a business was scary. And then I decided to start growing it.

Tools

Everything You Need to Find Files

Or, should I say, You Need *Everything* to Find Files.

Code Library

Joining Paths in VBA

How many times have you gotten a runtime error because you had duplicate or missing backslashes in your file paths? Never again!

Tools

vbWatchdog Webinar

Peter Cole of ThemeMyDatabase.co.uk presents a demonstration of vbWatchdog in action. Come for the info, stay for the discount code.

SQL Server

Securing Access and SQL Server

Wherein Anders Ebro demonstrates how easy it is to circumvent application-level security in an Access program.

Risk Management

Securing Your Data

Relying on application-level security to protect your data would be like using guard rails to keep out your enemies.

Conventions

Googleable Field Names

Using globally unique field and table names will make it easier to identify where such fields and tables are used throughout your application.

Code Library

Using TDD to Calculate Holidays in VBA

This article takes you step-by-step through the Test Driven Design process, unencumbered by the complexity of any sort of testing framework.

Code Library

Counting Business Days in VBA

Counting business days is easy with the WeekDayCount() and FederalHolidays() functions. What's interesting is how we test the WorkingDayCount() function.

Code Library

Counting Weekdays in VBA

This otherwise mundane function is made a bit more interesting through its use of the little-known VBA backslash operator, which performs integer division.

Code Library

IsLastBusinessDayOfMonth() Function

I bet you can't guess what this function does.

Code Library

VBA IsBusinessDay() Function

A simple function that returns True except for weekends and US federal holidays.

Code Library

Federal Holidays in VBA

How do you calculate US federal holiday observances in VBA? One option is to use brute force and skip the calculation altogether.

Tools

Bad Words in Access

Note, Caption, Format, Pages, Sequence. All reasonable-sounding field names, but all should be avoided.

SQL Server

Role-based SQL Server Security

There are many reasons to implement SQL Server roles even if you use Windows Authentication with Active Directory security groups.

Professional Development

One Step at a Time

To reach great heights, take small steps.

Version Control

Tracking Schema Changes

If it can cause a bug in your software, you should be tracking it in version control. Database schema changes absolutely fall into that category.

SQL Server

Playing Telephone with SQL Server

You won't believe how Access and SQL Server actually talk to each other. You're going to need to see this for yourself.