Code Library Looping by Month: Loop Until with DateAdd Reader Francesco Foti writes in with his own solution to the Looping by Month challenge.
Code Library Looping by Month: Lookup Table Have I ever used this method? No. Can I imagine a situation where it could be useful? Maybe. Should I write an article about it? Sure, why not.
Code Library Creating a Monthly Lookup Table Having a table where each record represents a single month can come in quite handy. Let's create such a table.
Code Library Looping by Month: Custom Functions By using a couple of custom functions, we can write very readable loops that iterate one month at a time.
Code Library Looping by Month: DateSerial The first approach to looping by month uses only the builtin VBA functions DateSerial() and DateDiff().
Code Library Sticky Wicket: Looping by Month Some programming problems are difficult to solve. Others are difficult to solve clearly.
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.
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!
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 FedHolidays() 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 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.
Basic The Global Form Storing global variables on a hidden form has some distinct advantages over storing them in VBA.
Code Library Setting MultiSelect At Runtime You can't actually set a list box's MultiSelect property at runtime. But there are a few ways to work around the limitation. Let's explore them.
Code Library Get a Handle on Window State Using the IsZoomed and IsIconic API calls to return the window state (minimized, maximized, or restored) of a form, report, or Access itself.
Basic Unicode-Friendly MsgBox There's a great big world outside of the ANSI bubble. Make every MsgBox in your program Unicode-safe in no time at all with this drop-in replacement.
Code Library Unicode-Safe Filtered Filename Lookups Need a Unicode-safe way to retrieve a list of filenames from a folder? And its subfolders? And filtered by filename? It's all here!
Code Library Clearing a List Box in Access Sometimes you need to wipe the slate clean and start fresh. Here's a simple function to do just that for an Access list box.
Advanced "Complex" DTOs in VBA Can you use the OpenArgs parameter to pass multiple values to forms and reports with compile-time checking? You can if you use DTOs.
Code Library Writing Code with Code in VBA Can you write code with code in VBA? Yes. Should you write code wit--OH, BE QUIET YOU!!! Where's your sense of adventure? ;-)
Code Library Text Files: Read, Write, Append There is beauty in simplicity. These three functions for reading, writing, and appending text files are simple, but effective.
Code Library Kill Failed? Let User Try Again My Access applications regularly need to overwrite existing files. A common example is exporting data to a text file, such as a .csv. Sometimes the user chooses to overwrite the
