ACC97: Unbound OLE Object Frame on Report Not Updated Properly

• Microsoft Access 97

SYMPTOMS

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

When a linked unbound object frame exists in a report, changes in the data or content of its source document are not displayed correctly on the report. However, if after each change in the source document, you open the report in Design view first and then switch to Print Preview, the data or content of the source document is displayed correctly.

RESOLUTION

If you add the linked unbound object frame to a form first, set its Enabled property to Yes and its Locked property to No, and then embed that form on the report, changes to the control's source document do appear as expected in the report.

The following steps demonstrate how to implement this workaround.

1. Start Microsoft Excel and open a new workbook.



2. In cells A1:A3, enter the numbers 1, 2 and 3, respectively.



3. Save and close the workbook, but leave Microsoft Excel open.



4. Open a new database in Microsoft Access.



5. Create a form in Design View and do not base it on any table or query.



6. Add an unbound object frame to the detail section of the form.



7. In the Insert Object dialog box, click Create From File and select the Link check box; then click Browse.



8. In the Browse dialog box, select the file that you saved in step 3. Click Open.



9. In the Insert Object dialog box, click OK.



10. On the View menu, click Properties to open the property sheet of the unbound object frame; click the Data tab.



11. Change the Enabled property to Yes and the Locked property to No.



12. Save the form as frmLinkFix and close it.



13. Create a new report in Design View and don't base it on any table or query.



14. Press F11 and position the windows so that both the Database window and the report are visible.



15. Click the Forms tab in the Database window. Select the frmLinkFix form but do not open it.



16. Drag the frmLinkFix form to the report. Note that it is now a subform on the report.



17. Save the report as rptLinkFix and close it.



18. In Microsoft Excel, open the file you created in step 3 and change the values of cells A1:A3.



19. Close the workbook, but leave Microsoft Excel open.



20. Open the rptLinkFix report in Print Preview. Note that the three values in the object frame match those currently in the workbook.



21. Close the rptLinkFix report.



22. Repeat steps 18 through 21 several times. Note that the values in the object frame always match the current values in the workbook.

MORE INFORMATION

Steps to Reproduce Behavior

1. Follow steps 1 through 4 in the "Resolution" section earlier in this article.



2. Create a report in Design View and do not base it on any table or query.



3. Add an unbound object frame to the report.



4. In the Insert Object dialog box, click Create From File and select the Link check box; then click Browse.



5. In the Browse dialog box, select the file that you saved in Microsoft Excel. Click Open.



6. In the Insert Object dialog box, click OK.



7. Switch to Print Preview and note that the three values in the object frame match the data that you entered in the workbook in step 2 of the "Resolution" section.



8. Save and close the report as rptLinkTest.



9. Open the workbook in Microsoft Excel and change the values in cells A1:A3.



10. Save and close the workbook, but leave Microsoft Excel open.



11. Open the rptLinkTest report in Print Preview. Note that the three values in the object frame do not match those that currently exist in the workbook.



12. Switch to Design View and immediately back to Print Preview. Note that the values in the unbound object frame now match those in the workbook.



13. Repeat steps 9 through 11. Note that the values in the object frame match the values that currently exist in the workbook.



14. Close the rptLinkTest report and reopen it in Print Preview. Note that the values in the object frame do not match those in the workbook.

Additional query words: different not the same

Keywords : kbdta IntpOle
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbprb