Table of contents
TOC
折叠目录
展开目录

ObjectFrame.UpdateOptions 属性 (访问)ObjectFrame.UpdateOptions Property (Access)

office 365 dev account|上次更新日期: 2018/3/13
|
2 参与人员

UpdateOptions属性用于指定一个 linkedOLE 对象的更新方式。读取/写入的整数You can use the UpdateOptions property to specify how a linkedOLE object is updated. Read/write Integer.

语法Syntax

表达式UpdateOptionsexpression. UpdateOptions

表达式_一个表示ObjectFrame对象的变量。_expression A variable that represents an ObjectFrame object.

注解Remarks

UpdateOptions属性使用以下设置。The UpdateOptions property uses the following settings.

设置SettingVisual BasicVisual Basic说明Description
自动AutomaticacOLEUpdateAutomaticacOLEUpdateAutomatic(默认值)每当链接数据更改时即自动对对象进行更新。(Default) Updates the object each time the linked data changes.
手动ManualacOLEUpdateManualacOLEUpdateManual只有在操作该控件的属性设置为acOLEUpdate编辑菜单上的OLE/DDE 链接命令来更新链接时,才更新的对象。Updates the object only when the control's Action property is set to acOLEUpdate or the link is updated with the OLE/DDE Links command on the Edit menu.

一般情况下,链接数据发生更改时对象就会自动更新,不过也可以设置 Microsoft Access 在接收到特定的更新指令时才对数据进行更新。例如,假设其他用户或者其他应用程序可以访问或更改窗体上的链接电子表格数据,则可以对该属性进行设置,指定只有在数据库以单用户模式打开的情况下才对链接数据进行更新。Normally, the object is updated automatically whenever the linked data changes, but you can tell Microsoft Access to update the data only when it receives a specific instruction to do so. For example, if other users or applications can access or change linked spreadsheet data on a form, you can use this property to specify that the linked data only be updated when the database is opened in single-user mode.

UpdateOptions属性设置为手动时,更新不会发生的可通过单击选项卡上的工具选项对话框中的高级选项卡上刷新间隔框的设置菜单。When the UpdateOptions property is set to Manual, updates don't occur based on the setting of the Refresh interval box on the Advanced tab of the Options dialog box, available by clicking Options on the Tools menu.

请注意 对象的数据更改时,更新事件发生。Note When an object's data is changed, the Updated event occurs.

示例Example

下面的示例设置名为 OLE1 若要手动更新,未绑定的对象框的UpdateOptions属性,然后使用操作属性强制更新控件中的 OLE 对象。The following example sets the UpdateOptions property for an unbound object frame named OLE1 to update manually, and then uses the Action property to force an update of the OLE object in the control.

OLE1.UpdateOptions = acOLEUpdateManual 
OLE1.Action = acOLEUpdate

另请参阅See also

概念Concepts

ObjectFrame 对象ObjectFrame Object

© 2018 Microsoft