Internet Fixes Weekly Office XP Newsletter

April 09, 2004Keeping you up-to-date every week!
If you drag a table to the bottom of the page and then try to click above it you get an error message and Word XP closes!
If you turn on Track Changes before you insert the table, or not turn on Track Changes at all, then you will not have this trouble anymore.

You can turn on and off Track Changes from the Tools menu in Word. Microsoft says they acknowledge this as a problem but they don't say when they intend to fix it. My best advice for you is if you don't need to track the changes you make to the document, then just don't turn on Track Changes.

  Visit Our Windows XP Database Full Of Tips!

Prevent error values from printing in Excel 2002!
In previous versions of Excel, you were forced to create custom formatting or
formula solutions to avoid displaying worksheet errors like #DIV/0! or #VALUE!
when you printed a worksheet. Excel 2002 simplifies things by letting you
control how these errors are handled when it comes time to print. You can
simply have the offending cells appear blank, or display a substitute string in
place of the error.

To take advantage of this feature, select File | Page Setup from the menu bar.
Then, click on the Sheet tab. Finally, select one of these choices from the
Cell Errors As dropdown list:

Displayed
<blank>
--
#N/A

Click OK when you've finished. Choosing Displayed prints the original error
value, while the other choices replace the errors with blanks, dashes, or #N/A
placeholders.

Adding a group filter control to a data access page (Access 2002)!
Data access pages allow you to view and edit data stored in Access tables via an HTML page. The page can be viewed in Internet Explorer, eliminating the need to use Access as the front end to the data. Although they were fairly limited when originally introduced in Access 2000, data access pages are worth investigating in Access 2002, as they have been significantly improved. 

As you work with pages, you may find that you want to limit the information shown on a page. For instance, if your page lists products, you may want to only show one particular category of products at a time. 

Data access pages let you limit the items displayed on a page using a group filter control. It's easy to add a group filter control to a page, but the easiest technique to do so is far from obvious. 

To add the control, open your page in Design view. Then, using your right mouse button, drag the field containing the data you want to use as the basis for your filter from the field list to the appropriate section of the page. When you release the mouse button, select Group Filter Control from the shortcut menu. 

By default, Access adds a combobox control to the page. When you view data with the page, the control contains a list of the items stored in that field. Choose the item you're interested in, and the page displays only those records that meet the filter value.
Interesting Facts
Things to Note
Your hard disk will crash. Count on it. 

It happens to everyone eventually. And when it does you will be glad you have a backup copy of all your data. 

You do have an up-to-date backup, don't you? 

You don't? Never fear. Here are the simple ways you can use one of our Batch files to backup your data for you. Just Click Here!

 

WE DEPEND ON YOUR DONATIONS

 

 

Hit Counter

  
http://www.internetfixes.com/question.htm