susan harkins

Downloads

How do I... Populate an Access list control with the results of a dynamic search?

July 30, 2007 12:00am PDT

This tutorial and sample Access database will guide you through the process of setting up fixed queries to populate a list control with the query results. Using a list control provides events that...

Provided by: Susan Harkins

Blog Post

Print a logo in an Excel header

July 25, 2007 10:06am PDT

Excel isn’t a word processor, nor does it generate reports the way Access does. But that doesn’t mean you can’t improvise. For instance, you can display a graphic, such as a company logo, at...

1

Blog Post

Hide duplicate values in an Access report

July 23, 2007 5:45am PDT

When pulling Access data together into a meaningful format, you may find that reports repeat data. Depending on how you're using the data, you may or may not want to display those duplicate...

Blog Post

Tip: Print e-mail addresses

July 19, 2007 5:29am PDT

Printing a phone list of your Outlook contacts is simple. Click Contacts and then choose Arrange By from the View menu. Next, select Current View and finally, choose Phone List. To customize the...

Blog Post

How do I... Add custom error handling to my Access forms and reports?

July 18, 2007 1:11pm PDT

This information is also available as a PDF download. When capturing and handling errors, you probably think of the Err object, which stores information about the current run-time error. If a...

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

Blog Post

Tip: Quick access to Word codes and formatting

July 16, 2007 5:41am PDT

By default, Word’s formatting codes aren’t visible while you work, and most of us like it that way. When you need to see the codes, choose Options from the Tools menu and click the View tab...

1

Blog Post

Grab user attention with blinking text in an Access form

July 13, 2007 3:05pm PDT

A virus scan I use blows what sounds like a foghorn when it's done. I try to be out of the room because it's so loud and annoying. I prefer a gentler approach. Blinking signs are a good...

5 Latest comment by mnmcollector@...

Blog Post

Tip: Customize Windows Regional settings

July 9, 2007 11:03am PDT

Dr. Keith Rowlings of South Africa recently asked an Outlook question. He wanted calendar view to display the day's name, along with date, as in Monday, July 9, 2002. That's how Outlook displays...

Blog Post

Tip: Avoid trouble with Word tables

July 6, 2007 11:03am PDT

Word's table feature is easy to use and intuitive enough that most of us can insert a table without too much going wrong. The quickest way to create a table in Word is to enter the table's...

2 Latest comment by augustine70_2000@...

Blog Post

How to reference an Access subform

July 5, 2007 3:05pm PDT

Referencing subform controls always throws Access users for a loop while they're new to using Visual Basic for Applications (VBA). That's because Access views the subform as just another one of...

5 Latest comment by askolits

Blog Post

Access 2007 bug list

July 4, 2007 6:30am PDT

Thanks to Marty Connelly, one of Microsoft's newest MVPs, for this link to a list of Access 2007 bugs and other good stuff, by Allen Browne.

Blog Post

How do I... Query foreign data using SQL Server's linked servers?

July 2, 2007 12:47pm PDT

This information is also available as a PDF download. If you have a magic wand or a special relationship with some data fairy, all of your data is in the same database on the same server. Most of...

Downloads

How do I... Query foreign data using SQL Server's linked servers?

July 2, 2007 12:00am PDT

Sometimes, the data you need is in a non-database format or resides on a different server. Fortunately, SQL Server is flexible enough to offer a number of ways to get it. One of the easiest...

Provided by: Susan Harkins

Blog Post

Download: Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats

June 25, 2007 6:37am PDT

Generally, it takes people a while to upgrade. For what it’s worth, I've heard from users who have Office 2007, but they're not using it. While the ribbons wow users who are new to Office, they...

16 Latest comment by ERISAgeek

Downloads

How do I... fill Word form fields with Access data?

June 25, 2007 12:00am PDT

Filling a Word form with Access data can be useful when you need to use Word's formatting features to present that data in just the right way. Fortunately, the process is simple, whether sharing...

Provided by: Susan Harkins

Blog Post

2007 viewer and pdf downloads available

June 24, 2007 8:09am PDT

In previous discussions, I’ve posted links to viewers and a download for saving documents to PDF format. If you’re using Office 2007, there are two downloads you might be interested in....

9 Latest comment by kethy123456

Blog Post

How do I... remove the built-in icons from the Office My Places bar?

June 18, 2007 9:15am PDT

This information is also available as a PDF download. As I discussed in a previous entry, the My Places bar was introduced in Office 2000. It appears on the left side of the File Open and File...

Downloads

How do I... remove the built-in icons from the Office My Places bar?

June 18, 2007 12:00am PDT

Office 2003's My Places bar makes it easy to add or remove custom icons. But getting rid of seldom-used built-in icons requires a trip to the registry. Here's a rundown of the steps you can follow...

Provided by: Susan Harkins

Blog Post

How-to change perspective in an Excel chart

June 14, 2007 5:49am PDT

Oh my, I had no idea you could do this with an Excel chart! What am I raving about? You can reverse the order of the axis values. You have to see this in action to appreciate it. First, look at a...

2 Latest comment by ssharkins@...