FAQ & How To's
Home What's New FAQ & How To's Download Search

 

This page contains answers to common questions handled by our support staff, along with some tips and tricks that we have found useful.

Note: In these answers we will follow a few shorthand conventions for describing user-interface procedures. Key combinations will be presented like this: Ctrl+Alt+Delete, which means that you should press and hold down the Control key, the Alt key, and the Delete key at the same time. Menu selections will be presented like this: File->Open, which means that you should open the File menu, and then make the Open selection.

General Questions

  1. Do I have to switch to Microsoft Word ?
  2. When is the WordPerfect 7 suite no longer supported? When will it be removed from the network ?
  3. What packages are in Corel WordPerfect Suite 7?
  4. What packages are in Microsoft Office 2000 Suite?

Office 2000

  1. How do I convert documents to Microsoft Office applications ?
  2. How can I turn off the Office Assistant ?
  3. I don't like the clip art Microsoft Office gives me.  How can I get more clip art?
  4. I'm getting an error in an MS Office Application or it's telling me a feature isn't installed properly. How can I fix it?
  5. How can I turn on the "personalized" (adaptive) menus feature that is new in Office 2000?
  6. In Microsoft Office 2000, how do I expand my drop-down menus?
  7. Can Microsoft Office 2000 programs read other file formats and is there a conversion between Office 2000 and Office 97 files?
  8. If I add a correction in one package to the autocorrect feature is it available in the other packages?
  9. How do I download clip art from the internet, and create a category for them?

Word 2000

  1. How can I get help with WordPerfect shortcuts and key commands in Word 2000 ?
  2. Where's the Reveal Codes feature in Word?
  3. In Microsoft Word 2000, how do I change the default font?
  4. Why does "delete block" appear when I try to delete selected text in Word? 
  5. In Microsoft Word 2000, what are the different types of main merge documents available?
  6. How can I center the entire text of a document on the vertically on the page?
  7. How do I setup the automatic back up feature in Word?
  8. How do I specify a save location for automatically recovered files?
  9. Why are the Minimize and Restore buttons gone from the top right-hand corner of the Document window?
  10. What shortcut keys are available in Word?
  11. I opened Word and my menu bar and toolbars have disappeared. How do I get them back?
  12. How do I turn off automatic bulleted lists and automatic numbered lists?

Excel 2000

    1.    How do I get Excel to save workbooks automatically?
    2.    How do I get rid of duplicates in Excel?

PowerPoint 2000

    1.    How do I change the AutoRecover save interval in PowerPoint?

FrontPage 2000

  1. Why can't I open the web page I created in Word 2000 with FrontPage 2000?
  2. In FrontPage 2000, why can't I see the bookmarks I have created in another web page in my web? 
  3. After posting a message on a discussion board that is managed by a FrontPage 2000 web, the message subject did not appear on the discussion Table of Contents?
  4. How do I use the Course Web Template in FrontPage?

Access 2000

  1. How do I convert an Access 97 database to Access 2000?
  2. How do I access the Switchboard Manager in Access 2000?
  3. I have converted a database from Access 97 to Access 2000, now some of my buttons will not work on my forms.  How can I correct this?
 

Do I have to switch to Microsoft Word ?

It is highly recommended that you switch to Microsoft Word for the financial, licensing, compatibility and support benefits the Microsoft Office 2000 suite provides. However, you are not bound to use the Microsoft Office products. You may, at your department's discretion, choose to purchase a stand-alone copy of the WordPerfect suite and install it on your computer. (The product currently retails at $299 to $499 per license, depending upon version purchased). 

Note: A license will need to be purchased by your department from Corel for each computer upon which the product is installed. 

Also, Information Technology will provide no support for Word Perfect products after December 22, 2000; you will be responsible for providing your own support for these products or you will need to contact the manufacturer for support.  IT can assist with the installation and removal of such non-supported software only; tasks will not be submitted for non-supported software aside from installation and removal. A written IT service request for software installation will be honored within 3 to 7 business days of receipt.

Back to Top

When is the WordPerfect 7 Suite no longer supported? When will it be removed from the network?

As of August 15, 2000, the Microsoft Office 2000 suite (Word, Excel, PowerPoint, Access, and FrontPage) will become fully supported by Information Technology. Full support means documentation/speedy sheets, Helpdesk response, and training are available for faculty and staff.

In addition, Microsoft Office was purchased under a Select Licensing Agreement with Microsoft so that it is available for faculty and staff to use at home and for students to purchase at a very low price. Additional information on home use of the products is available at the Campus Technology web site and from the Help Desk (x36116)

Following discussions with the Forum Information Technology Committee and the IT department, it was determined that the WordPerfect 7 Suite will be supported until December 22, 2000. After December 22, 2000 the software will remain on the Novell servers through the Spring 2001 semester, but will be removed on July 13, 2001.

Campus computer users are encouraged to begin the conversion from the Word Perfect 7 Suite to the Microsoft Office Suite as soon as possible. Training is provided by Information Technology to help with this transition. Additionally, anyone needing help in converting WordPerfect merges or forms, please contact Anne McCardell or the IT Helpdesk.

After December 22, 2000, the Helpdesk will no longer be able to support the Word Perfect 7 Suite -- Microsoft Office 2000 will become the only supported Office Suite on the SU Campus.

This transition will be of little consequence to many and a trial for some. The IT Department will make every effort to make the move positive and painless.

Back to Top

What packages are in Corel WordPerfect Suite 7?

The software packages in the Corel WordPerfect Suite 7, as provided through the SU Novell network are:

bulletWordPerfect - word processing software
bulletQuattro Pro - spreadsheet software
bulletPresentations - slide show software
Back to Top

What packages are in Microsoft Office 2000 Suite?

The software packages in the Corel WordPerfect Suite 7, as provided through the SU Novell network are:

bulletWord - word processing software
bulletExcel - spreadsheet software
bulletPowerPoint - slide show software
bulletAccess - database software
bulletFrontPage - web page (HTML) editing software
As of August 15, 2000: Information Technology will be installing the complete Microsoft Office 2000 Premium software locally to machines in which meet hardware requirements.  Users who receive the software locally will have access to all of the software above plus:
bulletPublisher - desktop publishing software
bulletPhotoDraw - graphic imaging software
Back to Top

How do I convert documents to Microsoft Office applications ?

In most cases, all that you will need to do is open the document in the appropriate application, be it Word, Excel, PowerPoint or FrontPage. To do this, simply go to File->Open, and change the Files of Type to All Files. Then navigate to the folder where your document is located, and double-click on the file. The Office converters should then convert your document.

Most documents, including documents created originally in WordPerfect, convert seamlessly into Word simply by opening the document in Word.  In some instances, some minor re-formatting may be needed to the converted document. 

The exceptions to this are Forms, Macros and Merges, and Access databases. For Merges, first try to convert the files by following our documentation.  If still unsuccessful, then you may have to recreate the file within Word.  

For Forms and Macros and Merges, it is easier to recreate the file within Word itself rather than trying to convert them. Access 95/97 databases need to be converted to Access 2000 databases, using a conversion utility.  The IT Helpdesk has techs available to assist you in these conversions; please call 3-6116 or e-mail helpdesk@salisbury.edu for assistance.

Back to Top

How can I turn off the Office Assistant ?

To temporarily get rid of the Office Assistant, choose Help->Hide the Office Assistant.

To turn the Office Assistant off permanently, click once on the Office Assistant to bring up the dialog box, and choose Options. Then, under the Options tab, uncheck the box next to Use the Office Assistant and click OK.

You can bring the Office Assistant back up at any time by clicking Help->Show the Office Assistant.

Back to Top

I don't like the clip art Microsoft Office gives me. How can I get more clip art?

Microsoft has a collection of clip art online available for download at their Clip Art Gallery Live. To access this clip art gallery, simply open the Insert Clip Art dialog box by clicking Insert->Picture->Clip Art. Then, click on Clips Online in the toolbar. A dialog box will appear telling you it will connect to the Internet to browse for clip art files. If you don't want this to pop up each time you use this feature, place a checkmark in the box next to "Don't show this message again." Click OK.

Your browser should now open up and take you to the Clip Art Gallery Live page. Click Accept to the Addendum to the License Agreement (MSELA) to enter the Gallery.

Now you may either search for the specific clip art you want using keywords, or browse through the clip art galleries. Check the boxes under the clip art you want, then when you're finished, click Download clips.

Click Download Now to start the download. This will automatically download the clip art you selected and add it to your Clip Art Gallery. It will then be available to you anytime you need Clip Art.

Keep in mind that clip art takes up disk space. Try to only download the clips you need, and deleting downloaded clip art that you no longer need or use, especially if you are short on disk space.

Back to Top

I'm getting an error in an MS Office 2000 application or it's telling me a feature isn't installed properly. How can I fix it?

Microsoft Office 2000 includes a feature that allows it to detect and repair its own problems. This feature can be found by clicking Help->Detect and Repair. Detect and Repair will then attempt to fix any errors in the application from which you are running the program. You may need to close any open applications when running this program, and you may need to reboot your computer after the program finishes. When the dialog box appears, click Start.

If that does not solve the problem which you are experiencing, you can also try to verify the installation of the program by opening the Netware Application Launcher (also known as NAL on the icon on your desktop), right-clicking on the Office 2000 Installation icon and choose Verify. You may need to reboot your computer after verification.

If neither of these methods work, call the IT Helpdesk at 3-6116 or e-mail helpdesk@salisbury.edu.

Back to Top

How can I turn on the "personalized" (adaptive) menus feature that is new in Office 2000?

New to all applications in Office 2000 is the personalized menu feature.  This feature was designed to improve the use of each application by displaying items and commands that you use the most.  At SU, we have changed this default feature and have maintained menus to display the full menu with all commands.

However, if you would like to turn on this feature - which would be applied to Access, Excel, FrontPage, PowerPoint and Word - select Tools->Customize. Click on the Options tab if it is now the active page and the click on the checkbox in front of Menus show recently used commands first.  Once you turn on this feature, you may additionally decide to expand the full menu if there is a pause when using a menu.  To do this click the checkbox in front of Show full menus after a short delay.  When finished, click Close.

Back to Top

In Microsoft Office 2000, how do I expand my drop-down menus?

By default, Microsoft Office 2000 compresses the drop-down menus so that the most common and recently used commands appear first. In order to view the hidden commands and expand the menu, you can click the chevron (double arrows) at the bottom of the menu list. Clicking the chevron will expand the menu temporarily until the next time you use the menu.

In order to permanently, run one of the Microsoft Office 2000 programs and do the following:

  1. Click Tools and then click Customize.
  2. Click the Options tab.
  3. Under "Personalized Menus and Toolbars", Uncheck Menus show recently used commands first, and then click close.

These changes made in one Microsoft Office 2000 program will affect all other Microsoft Office 2000 programs.

Back to Top

Can Microsoft Office 2000 Programs read other file formats and is there a conversion between Office 2000 and Office 97 files?

Microsoft  Word 2000, Excel 2000, and PowerPoint 2000 are totally interchangeable with the Microsoft Office 97 Professional packages. No file formatting is required.   The user can create a file in Word 97 and then edit the file in Word 2000 then open the file in Word 97.

Microsoft Office 2000 can convert many different file formats into its own format, just as it did in previous versions of Microsoft Office. For example, various versions of WordPerfect (versions 5.0 through 9.0) can be imported into a Word document. 

Note: Versions of WordPerfect previous to 5.0 may convert most text, but might need to be edited to be completely legible.

The first time you attempt to open a non-Microsoft Word document that can be converted into Microsoft Word 2000, you may be prompted with a message stating, "Microsoft Word can't import the specified format. The feature is not currently installed. would you like to install it now?" Once you click Yes, follow the directions to install the necessary component to convert that particular type of file into Microsoft Word 2000.

Back to Top

If I add a correction in one package to the auto correct feature is it available in the other packages?

Yes, a change in the auto correct feature of one program will work in the others.

Back to Top

How do I download clip art from the internet, and create a category for them?

In Word, select Insert > Picture > Clip Art....  Click the New Category button. Enter a name ofr your new category such as "My Clip Art", then click OK.  You are now ready to search the web for graphics.

At the top of the Insert Clip Art window, click on the Clips Online button. This will take you to Microsoft's Clip Art Gallery online where you can choose from hundreds of graphics. Once you have downloaded the clips you want, go back to the Insert ClipArt window. Scroll through your categories and select Downloaded Clips.  You should see the graphics you just downloaded from the web.

Click on the first graphic and a bar will pop up on the side with four icons.  Choose the third one from the top. Click the drop down list and select the category you created above.  Continue this until you have moved all of the clips into your folder.

Back to Top

How can I get help with WordPerfect shortcuts and key commands ?

Microsoft Word 2000 includes help for users of WordPerfect to assist in the conversion. Click on Help->Microsoft Word Help. You will find help under the title Switching from WordPerfect in the Contents tab.

You can also turn on a WordPerfect keyboard emulation by clicking on Tools->Options->General tab and placing a checkmark next to both Help for WordPerfect users and Navigation keys for WordPerfect users.

It is recommended, however, that you learn the Microsoft Word's keystrokes and Navigation keys, as the Microsoft Help files and the IT helpdesk will only refer to problems based on the Microsoft Word navigation keys. If you do change the keyboard to the WordPerfect layout, please alert the IT Helpdesk of this change when calling about Microsoft Word problems.

Back to Top

Where is the Reveal Codes feature in Word?

"The main conceptual difference between Word and WordPerfect involves how formatting is applied. Word is a paragraph-oriented system, and it does not use codes in the same way as WordPerfect. You can view the paragraph and character formatting for specific text in Word 2000 by pressing Shift+F1 or Help->What's This? A question mark then attaches itself to your mouse pointer. Click the text you want to inspect to display a bubble that provides information about the paragraph and font formatting for that text. The question mark remains attached to your mouse pointer until you click the Help button again or press Esc.

You can also display various nonprinting characters in your document. Choose Tools->Options, and select the View tab. In the Nonprinting Characters group, click the All check box to display all nonprinting characters or select the check boxes for the specific nonprinting characters you want to view."

--from the Microsoft Word 2000 Bible by Brent Heslop and David Angell, printed by IDG Books.

Back to Top

In Microsoft Word 2000, how do I change the default font?

The default font in Microsoft Word 2000 is 12 point Times New Roman. There are two ways to change the default font size and type in Word 2000.  

bulletModify the default font from a blank document:
  1. Launch Word 2000 and click Format, then Font. 
  2. Choose the font type and size that you want to be the default every time you open Word 2000. 
  3. Click the default button in the bottom left corner of the "font" window. 
 
bulletModify the global template file normal.dot.  You can find this file by doing a search:
  1. Click start, then find, then files or folders. 
  2. In the Named: filed, enter normal.dot. 
  3. When the file is located, double-click the filename to open the file. 
  4. After the file is open, you can change the font size and type.  Then save the file. 
  5. After saving this file, close Word 2000.
  6. Reopen Word 2000 to use the new default font setting. 

After you use either method, Word 2000 will use your font type and size selection as the default every time it starts.

Back to Top

Why does "delete block" appear when I try to delete selected text in Word?

You have Help for WordPerfect Users turned on. To turn off Help for WordPerfect Users, go to Tools-->Options. Click on the General tab and uncheck both Help for WordPerfect users and Navigation keys for WordPerfect users. Click OK.

Back to Top

In Microsoft Word 2000, what are the different types of main merge documents available?

bullet Form Letters – Form letters are the most commonly used main documents in Word mail merges. They are used for both formal and informal letters. They can also be used for faxes, memos, reports, etc.

bullet Mailing Labels – Mailing labels are used for mass mailings or any other labeling   needs with merges. They can also be used in conjunction with form letters to print out letters and corresponding labels from one merged document and data source.  

bullet Envelopes – Envelopes are used when you want to print out envelopes for mass mailings. They can also be used in conjunction with form letters to print out letters and corresponding envelopes from one merged document and data source.  

bullet Catalog - A catalog is a listing of information, similar to a database, but without field names. It is useful for storing information and making printouts of various listings.
Back to Top

How can I center the entire text of a document on the vertically on the page?

To format the entire text of a document, for example a letter to be printed on letterhead paper, vertically on the page, follow these directions:

  1. Open the document in Word
  2. From the menu bar, select File->Page Setup
  3. On the Layout tab, under the Vertical alignment section select Center from the drop down list.
  4. Click OK to return to the document.
Back to Top

How do I setup the automatic back up feature in Word?

If you want to change how often Word saves documents automatically

  1.   On the Tools menu, click Options, and then click the Save tab.
  2.   Select the Save Autorecover info every check box.
  3.   In the minutes box, enter the interval for how often you want Microsoft Word to save
       documents. The more frequently Word saves documents, the more information is 
       recovered if there is a power failure or similar problem while a document is open in Word.

Note  Autorecover is not a replacement for regularly saving your documents.  If you choose not to save the recovery file after Word opens it,   the file is deleted and your unsaved changes are lost. If you save the recovery file, it replaces the original document (unless you specify a new file name).

Back to Top

How do I specify a save location for automatically recovered file?

1.    On the Tools menu, click Options, and then click the File Locations tab.
2.    In the Files types box, click AutoRecover files.
3.    Click Modify.
4.    If you want to store automatically recovered files in a different folder, locate and open
       the folder.

Back to Top

Why are the Minimize and Restore buttons gone from the top right-hand corner of the Document window?

"In previous versions of the Office suite of programs, users were getting confused when they had multiple documents open. If they have a particular document window maximized, they did not see the other documents they had opened.

In response to user feedback and extensive usability testing, the Office team decided on updating the interface to use a "Multiple Document Interface (or MDI for short)". MDI basically means that for each document you have open, you will get an icon on your task bar. That way, you can quickly change between documents, and the user gets a visual indication of how many documents they have open.

Some users have been concerned that this would take up a lot of memory, but it does not because you still only have one instance of Word (or PowerPoint, or Excel, etc.) running, just each document has its own window available.

Because of MDI, there was really no reason to "iconify" the document window, so they removed those buttons. You can still minimize and maximize individual documents by using the minimize and maximize and restore buttons in the upper right most corner of the word apps (or you can "right click" on the icon in the task bar."

--from the Roberto Bamberger, Manager of Faculty and Professional Development Programs for Microsoft Corporation, as posted on the Microsoft Mentor Community on 6/2/2000.

Back to Top

What shortcut keys are available in Word?

Press

To

Press

To

F1

Get online Help/Office Assistant

CTRL + Y

Redo the last action

F5

Choose the Go To command (Edit menu)

CTRL + SHIFT + F

Change the font

F7

Choose the Spelling command (Tools menu)

CTRL + SHIFT + W

Underline words but not spaces

F12

Choose the Save As command (File menu)

CTRL + =

Apply subscript formatting

Shift + F7

Choose the Thesaurus command (Tools menu, Language submenu)

CTRL + 1

Single-space lines

Shift + F9

Switch between field code and its result

CTRL + 2

Double-space lines

CTRL + F2

Choose the Print Preview command (File menu)

CTRL + 5

Set 1.5-line spacing

CTRL + B

Make letters bold

CTRL + 0

Add or remove one line space preceding a paragraph

CTRL + I

Make letters italic

CTRL + E

Center a paragraph

CTRL + U

Make letters underline

CTRL + J

Justify a paragraph

CTRL + C

Copy selected text or object

CTRL + L

Left align a paragraph

CTRL + X

Cut selected text or object

CTRL + R

Right align a paragraph

CTRL + V

Paste text or an object

SHIFT + ENTER

Insert a line break

CTRL + Z

Undo the last action

CTRL + ENTER

Insert a page break

CTRL + N

Create a new document of the same type as the current or most recent document

CTRL + F

Find text, formatting, and special items

CTRL + O

Open a document

CTRL + H

Replace text, specific formatting, and special items

CTRL + W

Close a document

CTRL + G

Go to page, bookmark, footnote, table, comment, graphic, or other location

CTRL + S

Save a document

CTRL + A

Selects entire document (Edit Menu)

I opened Word and my menu bar and toolbars have disappeared. How do I get them back?

You will need to rename your normal.dot template by doing the following:

1.    Open My Computer.
2.    Browse to C:\Windows\Application Data\Microsoft\Templates.
3.    Select the normal.dot template and click File > Rename. Rename the file normal.old.

If you couldn't find the normal.dot template on your computer in the above location, try the following: 

1.    Click on Start > Find > Files or Folders.
2.    In the Named: box, type normal.dot. make sure that your hard drive is selected in the Look in: box and there is a check in the box next to include subfolders.
3.     Click Find Now.
4.    Select the normal.dot template in the results box and click File > Rename. Rename the file normal.old.

The next time you open Word, your menu bar and toolbars will be back but you will have to reset your custom settings.

Back to Top

How do I turn off automatic bulleted lists and automatic numbered lists? 

1. Open Microsoft Word.
2. Click Tools > AutoCorrect and select the AutoFormat As You Type tab (it's the second one from the left).
3. Uncheck both Automatic bulleted lists and Automatic numbered lists.
4. Next, click on the AutoFormat tab (it's the one all the way to the right).
5. Uncheck Automatic bulleted lists.
6. Click OK.

Back to Top

How do I get Excel to save workbooks automatically?

1.    On the Tools menu, click AutoSave.
2.    If the AutoSave command is not on the Tools menu, you must install the AutoSave add-in.
       How?
3.    Select the Automatic save every check box.
4.    In the Minutes box, enter how often you want Microsoft Excel to save workbooks.
5.    Select any other options you want.

Back to Top

How do I get rid of duplicates in Excel?

Excel uses filters to hide duplicate entries.
1.    Select all records including column labels (if you don't have column labels and the first 
       record has a duplicate entry, Excel will not filter the second instance of the record).
2.    On the Data menu, choose Filter then Advanced Filter.... Select the check box for Unique 
       records only
.
3.    Click OK.

Note:  To show the duplicates again, you must choose Data > Filter > Show All. Clicking the undo button will not reverse a filter.

Back to Top

How do I change the AutoRecover save interval in PowerPoint?

1.    On the Tools menu, click Options, and then click the Save tab.
2.    Select the Save AutoRecover info every check box.
3.    In the minutes box, enter the interval for how often you want PowerPoint to save 
       presentations.

Note: When you select the Save AutoRecover info every check box, the changes you make to a presentation are saved in a recovery file until you save or close the presentation. The recovery file is then deleted. If a power failure occurs or you need to restart your computer before you save or close a presentation, the recovery file still exists. When you restart PowerPoint, PowerPoint opens all recovered files so you can save them. If you choose not to save a recovered file, it is deleted.

Back to Top

Why can't I open the web page I created in Word 2000 with FrontPage 2000?

By default, FrontPage 2000 allows you to use the MSOffice 2000 program you used to create your web page to perform edits to the page. If you want to use FrontPage 2000 to edit all web pages you have open in Front Page, you need to turn this feature off. To do this, click Tools->Options and click on the Configure Editors tab. Uncheck the box next to Open web pages in the Office program that created them and click OK. FrontPage 2000 will now open all web pages, even those created in other MS Office applications.

Back to Top

In FrontPage 2000, why can't I see the bookmarks I have created in another web page in my web? 

During the FrontPage 2000 training during Spring Break 2000, fellow faculty and staff were having problems creating a hyperlink to a bookmark in another web page in the current FrontPage web.  It was determined that in the Hyperlink properties window in order to display the bookmarks available in the target web page, the target web page must be open for editing.   Once opened, users could select the web page on the URL: text line and then access the bookmarks through the drop down box.

Back to Top

After posting a message on a discussion board that is managed by a FrontPage 2000 web, the message subject did not appear on the discussion Table of Contents? 

Anyone posting a message to a discussion board should know that if they receive a confirmation screen, then the message was successfully received by the web server.  Then the first solution, which can be used by anyone, is to use the Reload button on the web browser in which you are using.  This will refresh the contents of the page.

However, sometimes after reloading the page, the message is still not there.  The second solution is for the administrator of the discussion board to open up discussion within FrontPage.  Then select Recalculate Hyperlinks from the Tools menu.  This command is used to perform the following actions:

bulletrepair all hyperlinks in the FrontPage web
bulletupdates information for all FrontPage-based components
bulletsynchronizes web data, database information, and categories
 Back to Top

How do I use the Course Web Template in FrontPage?

  1. Open FrontPage
  2. Select File->New->Web
  3. Select the Course Web Template icon on the window and make sure that you specify the path (on the right) on where to create the new web.   IT does not recommend saving the web over top of other existing web page files.
Back to Top

How do I convert an Access 97 database to Access 2000?

In previous versions of Access 2000, the Switchboard Manager was located under the Add-ins option of the Tools menu.  In Access 2000, the online documentation under Help still refers to this location.  However, the Switchboard Manager has moved to:

  1. Open Access 2000
  2. Select Tools, Database Utilities, Convert Database, To Current Access Database Version
  3. In the "Database to Convert From" dialog box,  select the database file you want to convert 
  4. Once you have the file selected, click Convert
  5. In the "Convert Database Into" dialog box, enter a new filename (i.e. original_filename v2)
  6. Once you have typed in the new filename, click Save.

Once the conversion is complete, choose File, Open and select the new database file.

Back to Top

How do I access the Switchboard Manager in Access 2000?

In previous versions of Access 2000, the Switchboard Manager was located under the Add-ins option of the Tools menu.  In Access 2000, the online documentation under Help still refers to this location.  However, the Switchboard Manager has moved to:

  1. Select the Tools menu
  2. Select Database Utilities
  3. Select Switchboard Manager

*This information was obtained from Microsoft's Knowledge Base, Article Q235430.

Back to Top

I have converted a database from Access 97 to Access 2000, now some of my buttons will not work on my forms.  How can I correct this?

To fix this problem in the Access form, follow these instructions:

  1. Open the database in Access
  2. Open the desired form in Design View
  3. Select the button with the problem, Right-click and select Properties
  4. On the Event tab, select the On Click property.  Click the button with the three dots on the side to enter Microsoft Visual Basic to see the code.
  5. Insert the following text after the On Error code and before the Exit_Command code:

    If Me.Dirty Then
    Me.Dirty = False
    End If

  6. After making the changes, exit Visual Basic to return to design form view.
  7. Click Ok to accept the changes to the Button properties.
  8. Test the form as normal.
Back to Top