Create a link on a form or report to part of an existing unbound object

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.

  1. 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.

  2. On the Edit menu, click Copy.

  3. Leave the application open, and switch to Microsoft Access.

  4. In form or report Design view, click Paste Special on the Edit menu.

  5. 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 .

  6. 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.

  7. 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