Skip to content

Files

Latest commit

ccf5c4c · Apr 2, 2020

History

History
50 lines (31 loc) · 1.79 KB

Access.AccessObject.IsDependentUpon.md

File metadata and controls

50 lines (31 loc) · 1.79 KB
title keywords f1_keywords ms.prod api_name ms.assetid ms.date localization_priority
AccessObject.IsDependentUpon method (Access)
vbaac10.chm12755
vbaac10.chm12755
access
Access.AccessObject.IsDependentUpon
aba465c5-4176-c69a-8eb8-1a6737b6d8cf
02/01/2019
Normal

AccessObject.IsDependentUpon method (Access)

Returns a Boolean value that indicates whether the specified object is dependent upon the database object specified in the ObjectName argument.

Syntax

expression.IsDependentUpon (ObjectType, ObjectName)

expression A variable that represents an AccessObject object.

Parameters

Name Required/Optional Data type Description
ObjectType Required AcObjectType An AcObjectType constant that represents the type of database object to check for dependency.
ObjectName Required String The name of the database object to check for dependency.

Return value

Boolean

Remarks

This method will return a run-time error if any of the following conditions are true:

  • The Track name AutoCorrect info setting (Tools menu > Options dialog box > General tab) is disabled. You can use the following code to enable the Track name AutoCorrect info setting and update the dependency information for all of the objects in the database: Application.SetOption "Track Name AutoCorrect Info", 1

  • You have insufficient permissions to check the dependency information for the specified AccessObject object.

  • This method is being called from an Access project (.adp).

Access does not search Visual Basic for Applications (VBA) code, macros, or data access pages for dependencies.

[!includeSupport and feedback]