Latest from Susan Harkins
-
10 things you should have in your presentation kit
Preparing for a presentation means rehearsing your material -- but it also means making sure you have all the items you need for a glitch-free delivery.
-
5 rules for embedding strings in VBA code
Don't struggle to pass strings. Instead, apply these five simple rules when working with embedded strings in VBA.
-
10 ways to screw up your VBA code
It's easy to get enticed into cutting corners when you write VBA code -- but that's likely to create problems down the road. Susan Harkins looks at some misconceptions that lead to bad practices, fl...
-
Five tips for writing better VBA code
You can produce efficient, reliable, and easy-to-maintain code by following a few best practices. Susan Harkins reviews some essential aspects of good VBA code writing.
-
Five tips for debugging a routine in the Visual Basic Editor
The VBE provides tools to help you debug your code, but you need to know a few tricks to use them effectively. Susan Harkins suggests a few ways to streamline your debugging tasks.
-
Use VBA to return the next Saturday
Let VBA schedule your next weekend off. Just use this simple VBA function to return the date of the next Saturday.
-
Let VBA identify mistakes when you're entering code
This simple tip for entering VBA code can help you quickly discern mistakes.
-
Can a small IT consultancy benefit from a Web site?
For many businesses, the Internet is the land of opportunity, but is it the right frontier for a small IT consultancy? Susan Harkins ponders whether a Web site will pay off for her business.
-
Don't let disappearing error handling send you into a panic
It's hard to remember tools and options you seldom use. If Access' error trapping suddenly stops performing as usual, don't fret. Most likely, someone has set the VBE to break at all errors.
-
Pass optional objects to VBA functions
Not every argument has a value every single time you call it. When you need a function that's flexible enough to handle an empty argument, use VBA's Optional keyword.