Create a link on a form or report to part of an existing unbound object
You can use this procedure if the application that you're linking to has OLE support for linking to part of an existing document.
- Open the file in the application that you used to create it, and select the information you want to link to. For example, open Microsoft Excel and select a range of cells.
- On the Edit menu, click Copy.
- Leave the application open, and switch to Microsoft Access.
- In form or report Design view, click Paste Special on the Edit menu.
- In the Paste Special dialog box, click Paste Link, and then click the type of object to paste as in the As list. For more information on these options, click .
- Select the Display As Icon check box if you want the object to appear as an icon instead of as the object itself. Displaying an object as an icon can be helpful when an object contains supplementary information that doesn't have to be displayed. Displaying an object as an icon also uses significantly less disk space.
- Click OK.
Microsoft Access creates an unbound object frame and displays the object in the frame. If you want to edit the object, double-click it.
Notes
- You can adjust the size and proportions of the object after you paste it.
How?
- In a form, you can edit an unbound object in Design view. To edit the object in Form view also, open the form in Design view, and set the Enabled property of the unbound object frame to Yes and the Locked property to No.
- When you link an object, the link is automatic by default. This means that if the object is updated outside Microsoft Access, then the changes will automatically appear the next time you open the form or report. If you want to control when the link is updated, you can change the link from automatic to manual.
How?