Microsoft KB Archive/117549

{|
 * width="100%"|

Issues Using the Office Assistant Access Database OAFORMS.MDB

 * }

Q117549

-

The information in this article applies to:


 * Microsoft Office Assistant for Windows, version 1.0

-

SUMMARY
The following information describes issues that you may encounter, and how to get the best results when you use the Office Assistant database for Microsoft Access version 2.0, OAFORMS.MDB.

MORE INFORMATION
The Microsoft Office Assistant database contains 27 online forms, many of which also produce printed reports. when you work with this database, you may encounter the issues listed below.

Symptom
When you use a jump to the database from the Office Assistant, the jump may not work with the first click. In addition, jumps might not work if you are sharing OAFORMS.MDB across a network.

Workaround
Click again to activate the jump.

Symptom
When you use the Microsoft Office Assistant database, and you press F1 or choose the Office Assistant Help button from the Microsoft Office Assistant toolbar, you receive the following error message:

Cannot open Help file

Cause
You receive this error message if the current field is part of a subform (a form within a form). For example, you receive this error message when you choose the Microsoft Office Help button while the current field is the Product No field in the Purchase Orders form. When the current field is part of a subform, the database cannot locate the Office Assistant Help file.

Workarounds
To open the Office Assistant Help, select a field in the main form before you press F1, or choose the Microsoft Office Help button from the Microsoft Office Assistant toolbar. For more information about subforms, see your Microsoft Access documentation.

If you receive this error message, choose the OK button, and then choose Exit from the File menu in Windows Help. Then select a field in the main form, and choose the Microsoft Office Help button again.

Symptom
If you choose Exit from the File menu or double-click the Control menu to exit the Microsoft Office Assistant database, the database does not update your last transaction.

Workaround
To exit the database while updating your last transaction, choose the Exit button on the Microsoft Office Assistant database toolbar.

Symptom
If you open multiple forms from the Forms window in Microsoft Access, your system resources are depleted, resulting in degraded performance or error messages.

Workaround
To avoid losing system resources, open the Office Assistant forms and reports from either the Microsoft Office Assistant or the Microsoft Office Assistant database menus.

Symptom
You receive a compile Error when open OAFORMS.MDB.

Cause
If you install the Upsizing Wizard, it loads the file WZCS.MDA in the MSACC20.INI file. This library defines a GLOBAL API constant HELP_CONTEXT which is also defined in the OAFORMS.MDB database in the Help module. The same GLOBAL constant can't be defined in more then one database.

Workaround 1
Edit the MSACC20.INI file and remove the WZCS.MDA from the Libraries section.

Workaround 2
Comment out the constant declaration in the AOFORMS.MDB Help module.

Symptom
When you print a form or report, the information printed on the form may not match the current information in the database.

Workaround
To make sure that the printed form matches the current information in the database, complete all fields on the form before printing the form or report.