Troubleshooting Word Documents!
Open the file and hit the show/hide button on your standard
toolbar. With your cursor at the beginning of your document, hit
ctrl-end. Then, hold down the left shift key and use the left
arrow key to deselect any extra paragraph markers at the bottom of
your document. If there is only one, you may want to go ahead and
deselect the last sentence of your document-—you can always
retype it. Hit the copy button or ctrl-c to copy the document.
Paste it into a new, blank document, and save it. Generally, if
the file size has reduced considerably, you’ve probably gotten
rid of the corruption. (You may need to reset certain formatting,
such as landscaped pages.) Hit File-Properties and then the
General tab to view the file size in the original document, and
then in the new document; or just go to Windows Explorer to
compare sizes.
Try saving the file to Rich Text Format (RTF). Close the file.
Reopen it and save it back to a Document (DOC) file again. This
trick is particularly helpful with files that contain tables.
If that doesn’t work, most likely there is a graphic or other
object in the document that is corrupt. You can copy and paste
pieces of your document to a new document, saving the new document
each time, until you get the error. Then you can copy the rest of
the document—all but that portion, into the new document.
Another trick is to open a blank document, hit enter at least
once, then hit Insert-File and insert your "bad" file into the new
file. This method also removes protection from a document that has
been protected using Tools-Protect Document, even if it's got a
password. You will lose tracked changes if there were any in the
document.
If all else fails, you can always try the “Recover text from any
file” option under the file types in Word when you open the
document. You will then have to reformat the document. However, if
the document was primarily text, you may find yourself grateful to
have it.
Printing Formulas In Excel 2000
If your users have invested time in writing numerous formulas,
they may want to print them for safekeeping. Although Excel
doesn't include a simple "Print Formulas" button, functionality is
built in. Here's how to find it:
1. Go to the Tools menu.
2. Click Options.
3. Within the section called Window Options on the View tab,
select Formulas.
4. Click OK.
There is also a keyboard shortcut for this function. Press
[Ctrl][~].
In both cases, the result is that the formulas, rather than their
results, will appear in the worksheet.
Change the color of the highlighted record in a tabular form in
Access 2000!
This can be done with conditional formatting (a feature added to
Access in Office 2000). For each control on the form that you want
to change color (generally, text boxes and combo boxes), select
the control in Design view, select Format|Conditional Formatting
(or select Conditional Formatting from the control's right-click
menu), select Field Has Focus for Condition 1, and select the
highlighting color of your choice. This has to be done separately
for each control – on a tabular (datasheet) form or subform,
this would generally be text boxes and combo boxes. Once you have
set the appropriate conditional formatting for all the necessary
controls, the highlight will display when the form is opened,
either independently, or as a subform on another 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.
|