Troubleshooting Files in Word 2000 and other Office 2000 Programs!
Office and other files can become corrupt for any number of
reasons. Some can be explained and some cannot.
General Tricks for Many/Any File Types
One trick that might work with any type of Office file is to hold
down the left shift key while you double-click to open the file.
Why? This keeps automatic Visual Basic code from running and
certain other auto-commands, which may be causing the error.
(Similarly, this sometimes works if you're getting an error
starting a program; hold the shift key down while you launch the
program.)
Another trick that works is to open them from a higher version of
a SIMILAR program. You might not always get the results you want,
but you'll be able to edit it and save it back. Sometimes, a
different program doesn't interpret the corrupt portion of the
document. For instance, try opening a Word 97 file with
Wordperfect 8; try opening an Excel 97 file with Lotus 1-2-3
Millenium. Both Office 2000 and Office XP have improved
performance working with troubled files, and can often repair the
files.
If you're at work, and store your files on a network drive, you
can always retrieve a copy of your file from the previous network
backup. Depending on the size of your company and the response
time of your helpdesk, this can take anywhere from 10 minutes to
twenty-four hours or even longer.
If your file resides on a floppy, always try the following, no
matter how ridiculous it sounds: take the floppy out and blow on
the areas (don't spit on it!). If that does not work, try copying
the file from the floppy to a location on the hard drive. If that
does not work, try running scandisk and defrag on the floppy
drive. Lastly, take it to another PC and attempt to open it. If
the latter works, you might want to have your floppy drive checked
out.
Copying Styles Between Workbooks in Excel 2000!
Creating formatting styles is a real timesaving trick for users.
So why should they waste time recreating these styles in multiple
workbooks? If they have formatted a workbook in a particularly
useful way and want to continue to use the format in other
workbooks, teach them how to copy the style from one workbook to
another.
1. Open the source workbook and the destination workbook.
2. Making sure that the destination workbook is active, go to the
Format menu and choose Style.
3. Click the Merge button.
4. Within the Merge Styles dialog box, select the source workbook
from the Merge Styles From list box.
Click OK.
Adding a list box to a form in Access 2000!
Lookup lists can come in handy when using forms in Access 97,
2000, or 2002. However, when designing a form, you don't have
access to the Lookup Wizard as you do in tables. Forms have a list
box and combo box wizard that can help you create a list. A list
box is a box that lists the values and is open at all times. A
combo box is a drop-down list. The procedure to create either a
list box or combo box is basically the same as creating a lookup
list in tables.
Although list boxes and combo boxes function in much the same way,
there's a major difference between the two: A combo box allows a
user to enter new values that aren't currently contained in the
list while a list box allows a user to choose only values that are
in the list.
In this tip I will briefly step you through the process of adding
a list box to a form.
1. Open your form in Design view and display the Toolbox if
necessary by choosing View | Toolbars | Toolbox from the menu bar
or by clicking the Toolbox button on the Form Design toolbar.
2. Make sure that the Control Wizards button is selected in the
Toolbox, and then click the List Box button.
3. Click and drag to place the list box on the form and to launch
the List Box Wizard.
Follow the instructions in the List Box Wizard in accordance with
the knowledge you've gained from dealing with the Lookup Wizard.
If you choose the I Will Type In The Values That I Want option,
the values you enter become a value list.
The third option available in the List Box Wizard, Find A Record
On My Form Based On The Value I Selected In My List Box, creates a
list box on your form that's used to find records. When a value is
selected in this type of list box, the data for that record
appears in the form
|
Things to Note
Many Folks ask us how we cover so many topics. Most of our answers
come from a Database with 42 Topics and over 8000 entries. This
came from over 8 years of online help. Couple that with over 5000
documents on various subjects we have the ability to answer most
of your questions.
|