Alison Balteramp;#039;s Mastering Microsoft Office Access 1002003 [Electronic resources] نسخه متنی

اینجــــا یک کتابخانه دیجیتالی است

با بیش از 100000 منبع الکترونیکی رایگان به زبان فارسی ، عربی و انگلیسی

Alison Balteramp;#039;s Mastering Microsoft Office Access 1002003 [Electronic resources] - نسخه متنی

Alison Balter

| نمايش فراداده ، افزودن یک نقد و بررسی
افزودن به کتابخانه شخصی
ارسال به دوستان
جستجو در متن کتاب
بیشتر
تنظیمات قلم

فونت

اندازه قلم

+ - پیش فرض

حالت نمایش

روز نیمروز شب
جستجو در لغت نامه
بیشتر
لیست موضوعات
توضیحات
افزودن یادداشت جدید



Including Objects from Other Applications: Linking Versus Embedding


Microsoft Access is an ActiveX client application, meaning that it can contain objects from other applications. Access 97, and all subsequent versions of Access, are also ActiveX server applications. Using Access as an ActiveX server is covered in Chapter 22, "Automation: Communicating with Other Applications." Access's ability to control other applications with programming code is also covered in Chapter 22. In the following sections, you learn how to link to and embed objects in your Access forms.

Bound OLE Objects


Bound OLE objects are tied to the data in an OLE field within a table in your database. An example is the Picture field that's part of the Categories table in the Northwind database. The field type of the Categories table that supports multimedia data is of the OLE object field type. This means that each record in the table can contain a unique OLE object. The Categories form contains a bound OLE control, whose control source is the Picture field from the Categories table.

If you double-click the picture associated with a category, you can edit the OLE object in-place. The picture associated with the category is actually embedded in the Categories table. This means that the data associated with the OLE object is stored as part of the Access database (MDB) file, within the Categories table. Embedded objects, if they support the OLE 2.0 standard, can be modified in-place. This Microsoft feature is called

In-Place activation .

To insert a new object, take the following steps:


  • Move to the record that will contain the OLE object.

  • Right-click the OLE Object control and select Insert Object to open the Insert Object dialog box.

  • Select an object type. Select Create New if you want to create an embedded object, or select Create from File if you want to link to or embed an existing file.

  • If you select Create from File, the Insert Object dialog box changes to look like the one shown in Figure 9.18.

    Figure 9.18. The Insert Object dialog box as it appears when you select Create from File.

  • Select Link if you want to link to the existing file. Don't check Link if you want to embed the existing file. If you link to the file, the Access table will have a reference to the file as well as to the presentation data (a bitmap) for the object. If you embed the file, Access copies the original file, placing the copy in the Access table.

  • Click Browse and select the file you want to link to or embed.

  • Click OK.


  • Access returns you to the record that you were working with, and you can continue working with that record or move to another record.

    If you double-click a linked object, you launch its source application; you don't get In-Place activation (see Figure 9.19).

    Figure 9.19. Editing a linked object.


    Unbound OLE Objects


    Unbound OLE objects aren't stored in your database. Instead, they are part of the form they were created in. Like bound OLE objects, unbound OLE objects can be linked or embedded. You create an unbound OLE object by adding an unbound object frame to the form.


    / 544