O'Reilly logo

Access™ 2007 VBA Programmer's Reference by Armen Stein, Geoffrey Griffith, Rob Cooper, Teresa Hennig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

G.5. AccessObject

The AccessObject object refers to a particular object within any of the following collections: AllDatabaseDiagrams, AllForms, AllFunctions, AllMacros, AllModules, AllQueries, AllReports, AllStoredProcedures, AllTables, and AllViews. This is an all-purpose object that can be used to determine whether an object is dependent upon another object or whether an object is open in the database.

It has its own properties, described in the following table, that you can implement within your code.

PropertyData TypeDescription
CurrentViewAcCurrentView EnumReturns the current view for the specified Access object.
DateCreatedDateReturns the date the AccessObject was created.
DateModifiedDateReturns the date the AccessObject was modified.
FullNameStringSets or returns the full path of the object.
IsLoadedBooleanDetermines whether the object is currently loaded.
NameStringReturns the name of the object.
ParentObjectReturns the collection of which the object is a member.
PropertiesAccessObjectProperties collectionReturns the AccessObjectProperties collection for the object.
TypeAcObjectType EnumReturns the type of the AccessObject.

AccessObject has two methods you can use:

MethodArgumentsDescription
GetDependencyInfoNoneReturns a DependencyInfo object that represents the database objects that are dependent upon the specified object.
IsDependentUponObjectType, ObjectNameReturns a Boolean value that indicates whether the specified object is dependent upon the database object specified in ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required