Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/169411

From BetaArchive Wiki

Article ID: 169411

Article Last Modified on 10/20/2003



APPLIES TO

  • Microsoft Access 95 Standard Edition
  • Microsoft Office Small Business Pack for Windows 95



This article was previously published under Q169411

Moderate: Requires basic macro, coding, and interoperability skills.


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:

139721 What Is the Small Business Pack for Microsoft Office 95


Keywords: kbinterop kbui kbprb KB169411