Internet Fixes Weekly Office XP Newsletter!

Sometimes you'll want the AutoShapes and text boxes in a document to use the same formatting. You don t need to apply the same formatting to each object yourself. Instead, you can simply set custom AutoShape defaults. First, insert a text box or any AutoShape in your document, then apply it the desired color, line, margin, 3-D, and shadow formatting. Next, click once on the object to select it, and then choose Draw | Set AutoShape Defaults from the Drawing toolbar. (In Word 2001, click the Set AutoShape Defaults button on the Drawing toolbar.) The next AutoShape or text box you add to your document automatically uses the default formatting specifications you applied to the original. (Note: Word saves custom AutoShape defaults only within the current document.)

Reposition data point labels to make charts easier to read in Excel 97-2000-2001-2002

Although creating charts is a breeze in Excel, sometimes the chart elements aren't as neatly arranged as they could be. For example, if you're showing labels next to the data points, the labels may be difficult to read because they're placed over the actual data point or some other dark-colored chart element. Fortunately, it's easy to change the data label's placement.

You can adjust the label placement to appear in several predefined positions relative to the data points. To do so, select one of the data labels. When you do, all of the related labels are automatically selected. Next, choose Format | Selected Data Labels from the menu bar and then click on the Alignment tab. Select the desired location from the Label Position dropdown list and click OK.

If most of the labels are already in an acceptable position, you can selectively change the Label Position setting for individual labels. To do so, select the labels as previously described. Then, wait a moment and click on the single data label you want to change. Doing so selects the individual label. You can then change Label Position setting as you did before.

If the results after changing the Label Position setting are still undesirable, you can manually drag the data labels to an appropriate place. To do so, follow the previous steps to select an individual label. Then, click and drag the label's border to move it to the desired location.

Use parameter queries to handle dynamic criteria requirements (Access 97-2000-2002)

Some queries are designed to fill a very specific role, and therefore their selection criteria never changes. However, some queries may need to be flexible enough to return records based on criteria that can vary from one instance to the next. For example, you may need to look up records based on a range of dates that change as reporting needs require. Fortunately, it's easy to create a query that accepts dynamic criteria values.

Such a query is called a parameter query. Essentially, you identify which fields in the query need to meet variable criteria conditions, and what the general conditions are. When you view the query, Access automatically prompts you for the variable values and then displays the records that meet the criteria. To create such a query using the query design grid, you set up the criteria for the field or fields that control the record selection and surround the prompt for the variable data with brackets.

To demonstrate, let's say that you're working with a query based on the Orders table in the Northwind sample database that comes with Access. We'll create a query that lets you find orders placed between two variable dates. First, create a new query based on the Orders table. Drag the fields you want to display in the query's datasheet to the design grid and be sure to include the OrderDate field. Then, click in the Criteria cell in the OrderDate column and enter the expression:

Between [Starting Date] And [Ending Date]

Now, run the query. Access displays the Enter Parameter Value prompt for the first variable data item, Starting Date.

Enter the value 08/01/1996 and click OK. You are then prompted for the Ending Date value. Enter a value of 08/15/1996 and click OK.

Access then displays a datasheet containing just the orders that meet the date range you specified. Switch to Design view and run the query again. You can now enter a different set of dates to inspect orders from another time period.

There is no reason that It can’t be used for Home User’s. We can offer PcAnywhere connections right now if you have PcAnywhere Installed.

If you don’t have PcAnywhere don’t buy it because Our Home User’s don’t have that many problems that require Remote Help.

If you are using Windows XP you don’t need any other Software to carry out a remote session. I can teach you how to set up with a Remote Session with us!

If you don’t have Windows XP there is VNC Freeware that you can set up to allow a Remote Session with us.

I will be setting up the Directions for using any of the above software for Remote Sessions with us in the coming Weeks.

E-mail:

info@internetfixes.com

We’re on the Web!

www.internetfixes.com

Other Points Of Interest!

Internet Fixes Customer Support!

Windows Registry Tips!

Learn How To Backup The Registry!

Batch File Tips And Tricks!

DOS Command Index!

When Requesting Help On A Computer Related Problem Add As Much Information As You Can For The Hardware and/orSoftware!

Just Click Here and then Copy and Paste the following text into the Email that Pops Up. After you have pasted the following text into your Email Program try and fill in as much information that you can. Send it off to me and I will get back to you as soon as possible will an answer to your question!! If you like using an Online Form just Click Here

Need Help!

Computer manufacturer ("Custom Built", or brand name: Dell, HP, etc.) :

Computer model (if brand name) :

Operating system (Windows version) : 95__ 98__ 98SE__

ME__ NT__ 2000__ XP Home__ XP Pro__ Other__

(put an X beside the one that applies)

Type of browser (Internet Explorer or similar) and version :

Motherboard if known :

CPU (processor) type and speed :

Amount of memory installed (RAM) :

Hard drive size:

Hard drive free space :

Sound card ("Onboard", or type of card) :

Video adapter ("Onboard", or type of card) :

Anti-virus program :

Firewall program :

Spyware / Adware check program :

Outline your problem :

Exact error message (if applicable) :

What you were doing when the problem first appeared :

Any new software or hardware installed recently :

Any other information that you think might help :

The following is a Quick Index for setting up a Remote Connection with us.

Installing Real VNC Remote Connection Software.
Using Real VNC Remote Connection Software.
Our hours of operation for the remote services.
Viewing the legal.
Our Fees For Remote Help Connections!
Passwords and Logins!!
Send us System Information!
Select a Time in which you want to setup a Remote Connection Using Real VNC Send Your Choice To Us.
Send In Your Payment For a Remote Connection! As soon as we get a confirmation notice from our paypay service I will send out a confirmation letter of payment and the time that you selected for a remote session.
Please send me your system Information at least two hours before your remote session scheduled time.
Here is a brief overview of what we do when connecting to your PC.
Here is What We See When Connecting To Your PC To Repair A Problem!!