ObjectFrame.OLEType property (Access)
Use the OLEType property to determine if a control contains an OLE object, and if so, whether the object is linked or embedded. Read/write Byte.
Syntax
expression.OLEType
expression A variable that represents an ObjectFrame object.
Remarks
The OLEType property uses the following settings.
Setting | Constant | Description |
---|---|---|
Linked | acOLELinked | The control contains a linked object. All the object's data is managed by the application that created it. |
Embedded | acOLEEmbedded | The control contains an embedded object. All the object's data is managed by Microsoft Access. |
None | acOLENone | The control doesn't contain an OLE object. |
When creating an OLE object, use the OLETypeAllowed property to determine what type of object a control can contain.
Example
The following example illustrates how to display the Insert Object dialog box and how to display an error message if the Cancel button in the Insert Object dialog box is chosen.
Sub InsertObject_Click()
Dim conUserCancelled As Integer
' Error message returned when user cancels.
conUserCancelled = 2001
On Error GoTo ButtonErr
If OLE1.OLEType = acOLENone Then
' No OLE object created.
' Display Insert Object dialog box.
OLE1.Action = acOLEInsertObjDlg
End If
Exit Sub
ButtonErr:
If Err = conUserCancelled Then ' Display message.
MsgBox "You clicked the Cancel button; " _
& "no object was created."
End If
Resume Next
End Sub
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for