susan harkins

Blog Post

How to check for open Access objects

December 24, 2007 12:00am PST

VBA code that refers to an open Access object will fail if the object isn't open. With good error handling you can capture the error and work around it. A better solution is to make sure the...

5 Latest comment by TKnyte

Blog Post

A SpellCheck limitation in OneNote

December 21, 2007 12:00am PST

I don't know how many of you actually use OneNote, but it's a handy enough application that first appeared with Office 2003. In a nutshell, it offers an easy way to enter class or meeting notes, a...

Blog Post

Online Help a blessing and a curse

December 19, 2007 8:31am PST

Beginning with Office 2003, Help is online. When you access Help, Office automatically searches the Help files on your local system and on Microsoft's Web site. (Of course, you need an active...

9 Latest comment by ssharkins@...

Blog Post

How to generate a cover sheet for your Access report

December 14, 2007 11:49am PST

I'm always surprised when someone complains about having to use Word to print a stack of cover sheets and then manually collating the sheets with the reports. You don't have to work that hard!...

Blog Post

The latest from the knowledge base on Office problems

December 14, 2007 11:24am PST

MS's Knowledgebase is reporting a few more problems with Office 2007's first service pack: You receive an error message when you try to apply any of the 2007 Office Service Pack 1 packages on a...

4 Latest comment by kinniburgh@...

Blog Post

New government report on Access security vulnerability

December 14, 2007 11:04am PST

A new government report is warning about a security vulnerability in MS Access. The report was posted December 10 and is just beginning to hit major blogs. I won't repeat the information here,...

Blog Post

How do I... Base a control's default value on data input?

December 13, 2007 12:33pm PST

One of the most common ways to reduce data input is to provide a default value -- the most common value --for input controls. Occasionally, however, the default value becomes irrelevant as data...

3 Latest comment by ssharkins@...

Downloads

How do I... Base a control's default value on data input?

December 13, 2007 12:00am PST

One of the most common ways to reduce data input is to provide a default value -- the most common value --for input controls. That way, when the value equals the default value, the user simply...

Provided by: Susan Harkins

Blog Post

How to get that phishy smell out of Outlook

December 10, 2007 11:01am PST

I can't think of any industry that sucks up as much creative energy as online scams. Perhaps if evildoers put their creative efforts to good, we might all be living in a golden age of technology....

20 Latest comment by ssharkins@...

Blog Post

How do I... Transfer Access data to an Outlook contact?

December 10, 2007 9:29am PST

How you use data often determines where you store it, which can create a bit of trouble down the line. For instance, you might store contact information in an Access database. If you want the same...

4 Latest comment by fabio.fantuzzi

Downloads

How do I... Transfer Access data to an Outlook contact?

December 10, 2007 12:00am PST

How you use data often determines where you store it, which can create a bit of trouble down the line. For instance, you might store contact information in an Access database. If you want the same...

Provided by: Susan Harkins

Blog Post

More trouble with Office 2003 SP 3

December 7, 2007 11:36am PST

Combo box controls and list box controls display no value or incorrect values in Access 2003 after you install Office 2003 Service Pack 3: http://support.microsoft.com/kb/945280/en-us?spid=2488

4 Latest comment by ssharkins@...

Blog Post

How to guarantee color consistency

December 7, 2007 12:00am PST

In Monday's entry, I showed you how to match a control's background color to the form's by using the same color for both. It's a simple cure for a larger problem -- keeping colors consistent from...

Blog Post

How to help a disabled Access control disappear into the background

December 3, 2007 11:32am PST

It's common to display data that you don't want users to change. I've seen developers deal with primary key values this way, although some developers argue that users shouldn't even see primary...

Blog Post

Tip: Quickly select Excel sheets in a busy workbook

November 19, 2007 8:30am PST

Excel workbooks have supported multiple sheets for a long time. I'm  probably showing my age when I admit that I remember when an Excel file came with only one sheet! I see many workbooks...

Blog Post

Office 2007 stops responding with online requests

November 15, 2007 11:24am PST

A new knowledge base article warns that Excel 2007, PowerPoint 2007, and Word 2007 may stop responding if you use online features.

Blog Post

10 tricks for working more effectively in PowerPoint

November 13, 2007 9:39am PST

PowerPoint is a powerful presentation package, but most of us don't use it often enough to learn its many timesaving tricks. The good news is that you don't have to be an expert to get more...

8 Latest comment by jlqbee@...

Blog Post

How do I... Group an Access report by the results of an expression?

November 13, 2007 7:25am PST

Basing a report's group on natural data is simple, and most of the time it's adequate. For instance, you might group customers by their names or ZIP codes. Or you could group orders by their order...

4 Latest comment by Tony Hopkinson

Downloads

How do I... Group an Access report by the results of an expression?

November 13, 2007 12:00am PST

Grouped reports are easy to create, but sometimes you need more than the built-in settings. Grouping by an expression that references the report's data does more than group the data in a unique...

Provided by: Susan Harkins

Downloads

10 tricks for working more effectively in PowerPoint

November 13, 2007 12:00am PST

PowerPoint is a powerful presentation package, but most of us don't use it often enough to learn its many timesaving tricks. The good news is that you don't have to be an expert to get more...

Provided by: Susan Harkins