Test for existence of database objects

Public Function DbFormExists(FormName As String, Optional dbs As DAO.Database = Nothing) As Boolean

Does the Form exist in the database ?

Public Function DbMacroExists(MacroName As String, Optional dbs As DAO.Database = Nothing) As Boolean

Does the Macro exist in the database ?

Public Function DbModuleExists(ModuleName As String, Optional dbs As DAO.Database = Nothing) As Boolean

Does the Module exist in the database ?

Public Function DbObjectExists(ObjectType As AcObjectType, ObjectName As String, Optional dbs As DAO.Database = Nothing) As Boolean

Does the object exist in the database ?

Public Function DbObjectIsActive(ObjectType As AcObjectType, ObjectName As String) As Boolean

Is the object loaded (open) in the database and not in design mode ?

Public Function DbObjectIsLoaded(ObjectType As AcObjectType, ObjectName As String) As Boolean

Is the object loaded (open) in the database ?

Public Function DbQueryExists(QueryName As String, Optional dbs As DAO.Database = Nothing) As Boolean

Does the Query exist in the database ?

Public Function DbReportExists(ReportName As String, Optional dbs As DAO.Database = Nothing) As Boolean

Does the Report exist in the database ?

Public Function DbTableColumnExists(TableName As String, ColumnName As String, Optional dbs As DAO.Database = Nothing) As Boolean

Does the column of the table exist in the database ?

Public Function DbTableExists(TableName As String, Optional dbs As DAO.Database = Nothing) As Boolean

Does the table exist in the database ?

Public Function DbTableIndexExists(IndexName As String, TableName As String, Optional dbs As DAO.Database = Nothing) As Boolean

Does the index of the table exist in the database ?