canOpen

Topic group Related topics

Event fired when attempting to open a query or stored procedure; return value determines if object is opened.

Parameters

none

Property of

Query, StoredProc

Description

canOpen fires when a Query or StoredProc object’s active property is set to true.

If an event handler is assigned to the canOpen property, the event handler must return true or false to indicate whether the object is opened and activated.

canOpen may also be used to do something with the query, just before you open it. In this case, the canOpen event handler would always return true.