Issues Using the Office Assistant Access Database OAFORMS.MDB

ID: Q117549

The information in this article applies to:

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.

GETTING HELP WHILE USING OAFORMS.MDB

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.

EXITING OAFORMS.MDB

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.

OPENING AND PRINTING FORMS IN OAFORMS.MDB

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.


REFERENCES

For more information about the Access Database, choose the Search button in Help and type:

Access database, about
The OAREADME.TXT readme file (dated 4/19/94), that shipped with Microsoft Office Assistant version 1.0.

Additional query words: offasst winppt macppt 


Keywords          : 
Version           : 1.00
Platform          : WINDOWS 
Issue type        :

Last Reviewed: June 9, 1999