ACC95: Company Name Not Visible in Small Business Pack Locations

ID: Q169411

The information in this article applies to:

Microsoft Access 7.0
Microsoft Office Small Business Pack for Windows 95, version 1.0

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

If you supply a company name in the Company Information form of the Small Business Pack, that name may not appear in certain places within the Small Business Pack. For example, the name may not appear on any of the menu form headers. Also, when you preview or print the Time Billing report from the Small Business Pack, the Company Name field is not visible.

CAUSE

The Visible property of the Company Name field is set to No in different locations, such as the Company Logo form or the Company Header report of the Small Business Pack. The Company Name field may also be hidden behind the Company Logo field.

RESOLUTION

To change a menu form so that the Company Name is visible in the header, follow these steps:

 1. Open any one of the Small Business Pack databases.

 2. On the View menu, click Form Design.

 3. Double-click the Company Logo subform to open it in Design view.

 4. Using the right mouse button (right-click), click the Company Name
    field, and then click Properties.

 5. Click the Format tab. Change the Visible property from No to Yes, and
    change the BackStyle property from Normal to Transparent.

 6. Right-click the label field Text11, which is behind the Company Name
    field.

 7. Click Properties and select the Format tab. Delete the Caption property
    "Company Name," and change the BackStyle property to Transparent.

 8. Close and save the Company Logo subform.

 9. Quit Microsoft Access.

10. Reopen any one of the Small Business Pack databases. Notice that the

    Company Name field now appears in the menu form headers, along with the
    Company logo.

To change the Time Billing Invoices report so that the Company Name is visible, follow these steps:

 1. Open the Time Billing database.

 2. On the Window menu, click Unhide. Select sbpForms: Database, and then
    click OK.

 3. Click the Reports tab, and open the TBInvoice report in Design view.

 4. Double-click the Company Header subreport to open it in Design view.

 5. Right-click the Company Name field, and then click Properties. Click
    the Format tab.

 6. Change the Visible property from No to Yes. Change the BackStyle
    property from Normal to Transparent.

 7. Close and save the Company Header subreport. Close the TBInvoice
    report.

 8. Quit Microsoft Access.

 9. Reopen the Time Billing Database.

10. Click Invoices.

11. Select Send To Screen, and then click Send.

12. Notice that the Company Name field appears in the resulting report.

MORE INFORMATION

Steps to Reproduce Behavior

Attach to Sample Data

1. Click the Operations button on the Small Business Pack shortcut bar.

2. Open the Time Billing database.

3. Click the Previous Menu button on the toolbar to go to the Main Menu

   form.

4. Click Setup, and then click Attach To Database. If you are not currently

   sharing the database with other users, click Yes.

5. Select SBPSAMPL.MDB, and click Open. This will attach the front end of

   the application to sample data.

Make a Backup of the Company Table

1. On the Window menu, click Unhide. Select sbpForms: Database, and then

   click OK. Click the Tables tab, and select the Company table.

2. On the Edit menu, click Rename, and rename the table CompanyBackup.

3. On the Edit menu, click Copy. The CompanyBackup table should still be

   selected.

4. On the Edit menu, click Paste.

5. Under Table Name, type "Company" (without the quotation marks). This

   preserves the original Company table as CompanyBackup and leaves it
   attached to the sample data.

Enter a New Company Name

1. On the Window menu, click Setup Menu. Click the Company Information

   button on the Setup Menu form.

2. Change Company Name to "Test" (without the quotation marks).

3. Select the Logo field.

4. On the Insert menu, click Object. Select Microsoft ClipArt Gallery, and

   then click OK.

5. Select any picture and click Insert.

6. Click the Previous Menu toolbar button. Notice that the logo appears on

   the header of the Setup Menu, but the company name does not appear.

7. Click the Previous Menu toolbar button to go to the Main Menu form.

   Click Time Billing.

8. Click Invoices. Under Send To, select Screen.

9. Click Send. Notice that in the resulting report the logo is visible, but

   the Company Name field does not appear.

REFERENCES

For more information about the Visible property, search the Help Index for "Visible property."

For more information about the BackStyle property, search the Help Index for "BackStyle property."

For more information about the Small Business Pack, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q139721
   TITLE     : What Is the Small Business Pack for Microsoft Office 95

Keywords          : kbinterop kbui RptLayou 
Version           : 7.0
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbprb

Last Reviewed: June 3, 1997