XL7: Error Clicking View Access Form/Report Button

ID: Q137262

7.00 WINDOWS kbusage kberrmsg

The information in this article applies to:

SYMPTOMS

When you click either a View Access Form or a View Access Report button, located on your Microsoft Excel worksheet, you may receive one of the following error messages: 

   Cannot find the Access form for this list, possibly the form has been
   deleted. Create new form?

   -or-

   Cannot find the Access report for this list, possibly the report has
   been deleted. Create new report?

CAUSE

You may receive either of the these error messages if you do the following: 

   Click either Access Form or Access Report on the Data menu.

   -and-

   Click Cancel in either the Microsoft Access Form or Report Wizard dialog
   box.
Even though you canceled the procedure to create either a Microsoft Access form or report, a button for either the form or report (depending upon which one you tried to create) is still created on your Microsoft Excel worksheet.

If you receive the error message, your options are to either click the Yes or the No button in the error dialog box. If you click the Yes button, the Microsoft Access Form or Report Wizard (depending on which one you tried to create) is started and you can try to create another Microsoft Access form or report. If you click the No button, the error dialog box is dismissed.

RESOLUTION

If you cancel either the Microsoft Access Form or Report Wizard, as described in the previous section, you might want to delete the View Access Form or the View Access Report buttons that generate this error. To delete these buttons from your worksheet, do the following:

1. Use the right mouse button to click the button.

2. On the shortcut menu that appears, click Cut.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

When you create an Access form or report from data on your worksheet using the AccessLinks add-in provided with Microsoft Excel, a button is added to the worksheet that contains your data to access the report or form that you created.

This problem occurs when you click the View Access Form or View Access Report button because Microsoft Access attempts to open the form or report associated with your data. However, this form or report was never created because you canceled out of the Microsoft Access Form Wizard.

REFERENCES

For more information about creating Microsoft Access forms and reports in Microsoft Excel, click the Index tab in Microsoft Excel Help, type the following text 

   Access (Microsoft), Acc
and then double-click the selected text to go to the "Use AccessLinks Forms And Reports With Microsoft Excel" topic.

KBCategory: kbusage kberrmsg KBSubcategory:

Additional reference words: 7.00 

Version           : 7.00
Platform          : WINDOWS

Last Reviewed: March 29, 1997