- Subscribe to this page:
- RSS
- Email Alert
susan harkins
(1359 results)
About Susan Harkins
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.
-
Downloads
How do I... Reject alpha characters in a SQL Server character column?
January 25, 2008 12:00am PST
Enforcing your data's integrity is probably the single most important issue you face when designing a database. Validating user input is one way of keeping bad data from making its way into your...
Provided by: Susan Harkins
-
Downloads
How do I... Add music and narration to a PowerPoint presentation?
March 4, 2008 12:00am PST
Sound effects, such as music and voice recordings, can mean the difference between a good presentation and an outstanding presentation. Luckily, PowerPoint supports media clips, which include...
Provided by: Susan Harkins
-
Downloads
10+ common questions about SQL Server data types
May 15, 2008 12:00am PDT
SQL Server has a variety of data types, and as with most things, the more options you have, the more confusing a choice can be. Susan Harkins offers answers to the questions she hears most often...
Provided by: Susan Harkins
-
Q&A
A simple solution for tracking changes to Access data...Error
September 12, 2007 9:00am PDT
A simple solution for tracking changes to Access data...Error I have searched this forum for some contact info on Susan Harkins who originally posted this download titled "A simple solution for...
3 Started by CEHinman@... | Latest comment by coretek2003@...
-
Downloads
10 ways to screw up your VBA code
November 29, 2010 12:00am PST
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,...
Provided by: Susan Harkins
-
-
Downloads
My 10 favorite Office tips of the year
December 27, 2010 12:00am PST
During 2010, Susan Harkins wrote more than 200 tips to help Office users and the techs who support them. To wrap up the year, she's selected 10 of the ones she (and TR members) liked the most.This...
Provided by: Susan Harkins
-
Downloads
10 Office tips I learned from readers in 2010
January 7, 2011 12:00am PST
Some of the best information on TechRepublic is sparked by discussions that spring up around a particular tip or technique. Susan Harkins shares a selection of the insights, refinements, and...
Provided by: Susan Harkins
-
Downloads
10 tricks for handling null values in Microsoft Access
October 12, 2006 12:00am PDT
Null values indicate that data is missing or unknown, and if you don't take steps to handle them, you could wind up with runtime errors or erroneous data. These Access pointers will help you...
Provided by: Susan Harkins
-
Downloads
10 tips for working with dates in Microsoft Access
November 13, 2006 12:00am PST
Despite the Date/Time data type and a selection of functions for manipulating date values and components, handling dates in Access is often a little tricky and nonintuitive. Database expert Susan...
Provided by: Susan Harkins
-
Downloads
10 tips for customizing menus and toolbars in your Access apps
January 3, 2007 12:00am PST
When you build an Access application, you'll generally want to tailor the menus and toolbars so that users have all the tools they need but won't stumble over the built-in options. Access expert...
Provided by: Susan Harkins
-
Downloads
10+ tips for designing flexible and efficient Access tables
March 8, 2007 12:00am PST
The way you build your Microsoft Access tables makes all the difference in the world in terms of performance and reliability. These concise guidelines explain how to effectively employ Access...
Provided by: Susan Harkins
-
Downloads
How do I... Query for multiple values in Access on the fly?
May 14, 2007 12:00am PDT
When you need a flexible way to filter a form or report on multiple values, a fixed query isn't your best bet. Find out how you can use a VBA function to add a versatile query solution that can...
Provided by: Susan Harkins
-
Downloads
How do I... Add custom error handling to my Access forms and reports?
July 18, 2007 12:00am PDT
Access is designed to handle action errors -- such as those that occur when someone tries to add a record without filling in required fields -- without any help from you. But when you need a...
Provided by: Susan Harkins
-
Downloads
How do I... Export Outlook e-mail messages to Access using VBA?
August 20, 2007 12:00am PDT
Exporting Outlook folders and their contents is a simple enough task most of the time. The Import And Export wizard handles the process nicely. But as easy as it is to use, the wizard is a...
Provided by: Susan Harkins
-
Downloads
How do I... Start an Access label report with any label on the sheet?
September 10, 2007 12:00am PDT
Printing labels is a snap using Microsoft Office Access' Label Wizard. Depending on the criteria, the report prints the most up-to-date data in the order you need. The only problem is wasted...
Provided by: Susan Harkins
-
Downloads
How do I... Print a label for an individual record in Microsoft Access?
September 24, 2007 12:00am PDT
Printing labels using the Microsoft Access Label wizard is straightforward and relatively simple. But printing a label for a single record can be a bit more challenging. In this How do I..., Susan...
Provided by: Susan Harkins
-
Downloads
10 tips to help your Outlook users work more efficiently
September 24, 2007 12:00am PDT
Outlook might be the busiest application in the Office suite because it does so much. But the downside of all that functionality is that easy tasks aren't always intuitive, and some menu commands...
Provided by: Susan Harkins
-
Downloads
10 ways to customize Outlook menus and toolbars
October 4, 2007 12:00am PDT
Outlook comes with two types of built-in command bar objects, the Menu Bar and toolbars. Only one Menu Bar is allowed, but you can customize both it and the built-in toolbars. In addition, you can...
Provided by: Susan Harkins
-
Downloads
How do I... Create custom toolbar buttons in Outlook?
October 8, 2007 12:00am PDT
Running a macro is simple: Select Tools | Macros, choose Macros from the resulting submenu, select the macro you want to run, and click Run. Simple, yes. Efficient, no. You could complete some...
Provided by: Susan Harkins
-
Downloads
How do I... Retrieve a random set of records in Microsoft Access?
October 11, 2007 12:00am PDT
We usually think of data in sets of related values, but not always. Occasionally, you may need to supply someone with a set of unrelated records, retrieved completely at random. In this How do...
Provided by: Susan Harkins
