4 out of 6 rated this helpful - Rate this topic

Access 2010 Object Model Changes Since Earlier Versions

Office 2010

The tables in this topic provide a summary of the changes in the Microsoft Access 2010 object model as compared to earlier versions of Microsoft Office.

Note
In these tables, the status value for a given object model member may be any of the following: Changed—The syntax for the member has changed. Hidden—The member has been deprecated. Removed—The member has been removed from the object model.

Note

In these tables, the status value for a given object model member may be any of the following:

Changed—The syntax for the member has changed.
Hidden—The member has been deprecated.
Removed—The member has been removed from the object model.

Contents

Object Model Changes Since Microsoft Office 2007
Object Model Changes Since Microsoft Office 2003
Object Model Changes Since Microsoft Office XP (2002)
Object Model Changes Since Microsoft Office 2000

Object Model Changes Since Microsoft Office 2007

AcCommand

Constants	Status
acCmdExportLotus	Hidden
acCmdExportParadox	Hidden
acCmdFieldTemplates	Hidden
acCmdImportAttachLotus	Hidden
acCmdImportAttachParadox	Hidden
acCmdMacroArguments	Hidden
acCmdMacroConditions	Hidden
acCmdMacroNames	Hidden

AcSpreadSheetType

Constants	Status
acSpreadsheetTypeLotusWJ2	Hidden
acSpreadsheetTypeLotusWK1	Hidden
acSpreadsheetTypeLotusWK3	Hidden
acSpreadsheetTypeLotusWK4	Hidden

Application

Properties	Status
AnswerWizard	Hidden
Assistant	Hidden

BoundObjectFrame

Properties	Status
LpOleObject	Hidden

CustomControl

Properties	Status
LpOleObject	Hidden

DoCmd

Methods	Status
AddMenu	Changed Previous syntax VOID AddMenu (VARIANT MenuName, VARIANT MenuMacroName, VARIANT StatusBarText) New syntax VOID AddMenu (VARIANT MenuName, VARIANT MenuMacroName, OPTIONAL VARIANT StatusBarText)
SelectObject	Changed Previous syntax VOID SelectObject (ACOBJECTTYPE ObjectType, OPTIONAL VARIANT ObjectName, OPTIONAL VARIANT InNavigationPane) New syntax VOID SelectObject (ACOBJECTTYPE ObjectType, OPTIONAL VARIANT ObjectName, OPTIONAL VARIANT InDatabaseWindow)
SetProperty	Changed Previous syntax VOID SetProperty (VARIANT ControlName, OPTIONAL ACPROPERTY Property = 0, OPTIONAL VARIANT Value) New syntax VOID SetProperty (OPTIONAL VARIANT ControlName, OPTIONAL ACPROPERTY Property = 0, OPTIONAL VARIANT Value)

Form

Properties	Status
OnMenu	Hidden

Image

Properties	Status
TabIndex	Removed
TabStop	Removed

ObjectFrame

Properties	Status
LpOleObject	Hidden

Report

Properties	Status
OnMenu	Hidden

Object Model Changes Since Microsoft Office 2003

AcCommand

Constants	Status
acCmdDataAccessPageAddToPage	Hidden
acCmdDataAccessPageBrowse	Hidden
acCmdDataAccessPageDesignView	Hidden
acCmdDataAccessPageFieldListRefresh	Hidden
acCmdDemote	Hidden
acCmdExport	Hidden
acCmdImport	Hidden
acCmdMacroConditions	Hidden
acCmdMacroNames	Hidden
acCmdMicrosoftScriptEditor	Hidden
acCmdNewObjectDataAccessPage	Hidden
acCmdPromote	Hidden
acCmdSaveAsASP	Hidden
acCmdSaveAsDataAccessPage	Hidden
acCmdSaveAsIDC	Hidden
acCmdSelectDataAccessPage	Hidden
acCmdShowOnlyWebToolbar	Hidden
acCmdStopLoadingPage	Hidden
acCmdViewDataAccessPages	Hidden
acCmdWebPagePreview	Hidden
acCmdWebPageProperties	Hidden
acCmdWebTheme	Hidden

AcDataAccessPageView

Constants	Status
acDataAccessPageBrowse	Hidden
acDataAccessPageDesign	Hidden

AcObjectType

Constants	Status
acDataAccessPage	Hidden

AcOutputObjectType

Constants	Status
acOutputDataAccessPage	Hidden

AcSendObjectType

Constants	Status
acSendDataAccessPage	Hidden

AcSpreadSheetType

Constants	Status
acSpreadsheetTypeLotusWJ2	Hidden
acSpreadsheetTypeLotusWK1	Hidden
acSpreadsheetTypeLotusWK3	Hidden
acSpreadsheetTypeLotusWK4	Hidden

AllDataAccessPages

Properties	Status
Application	Hidden
Count	Hidden
Item	Hidden
Parent	Hidden

Application

Properties	Status
AnswerWizard	Hidden
Assistant	Hidden
DataAccessPages	Hidden
DefaultWebOptions	Hidden
FileSearch	Hidden

Methods	Status
CreateControl	Changed Previous syntax CONTROL CreateControl (STRING FormName, ACCONTROLTYPE ControlType, OPTIONAL ACSECTION Section = 0, OPTIONAL VARIANT Parent, OPTIONAL VARIANT ColumnName, OPTIONAL VARIANT Left, OPTIONAL VARIANT Top, OPTIONAL VARIANT Width, OPTIONAL VARIANT Height) New syntax _CONTROL CreateControl (STRING FormName, ACCONTROLTYPE ControlType, OPTIONAL ACSECTION Section = 0, OPTIONAL VARIANT Parent, OPTIONAL VARIANT ColumnName, OPTIONAL VARIANT Left, OPTIONAL VARIANT Top, OPTIONAL VARIANT Width, OPTIONAL VARIANT Height)
CreateNewWorkgroupFile	Hidden
CreateReportControl	Changed Previous syntax CONTROL CreateReportControl (STRING ReportName, ACCONTROLTYPE ControlType, OPTIONAL ACSECTION Section = 0, OPTIONAL VARIANT Parent, OPTIONAL VARIANT ColumnName, OPTIONAL VARIANT Left, OPTIONAL VARIANT Top, OPTIONAL VARIANT Width, OPTIONAL VARIANT Height) New syntax _CONTROL CreateReportControl (STRING ReportName, ACCONTROLTYPE ControlType, OPTIONAL ACSECTION Section = 0, OPTIONAL VARIANT Parent, OPTIONAL VARIANT ColumnName, OPTIONAL VARIANT Left, OPTIONAL VARIANT Top, OPTIONAL VARIANT Width, OPTIONAL VARIANT Height)
NewCurrentDatabase	Changed Previous syntax VOID NewCurrentDatabase (STRING filepath) New syntax VOID NewCurrentDatabase (STRING filepath, OPTIONAL ACNEWDATABASEFORMAT FileFormat = 0, OPTIONAL VARIANT Template, OPTIONAL STRING SiteAddress = "", OPTIONAL STRING ListID = "")

BoundObjectFrame

Properties	Status
LpOleObject	Hidden

CodeProject

Properties	Status
AllDataAccessPages	Hidden

Constants

Constants	Status
acFormatASP	Hidden
acFormatDAP	Hidden
acFormatIIS	Hidden

CurrentProject

Properties	Status
AllDataAccessPages	Hidden

CustomControl

Properties	Status
LpOleObject	Hidden

DataAccessPage

Properties	Status
Application	Hidden
ConnectionString	Hidden
CurrentView	Hidden
Document	Hidden
MailEnvelope	Hidden
MSODSC	Hidden
Name	Hidden
Parent	Hidden
RemovePersonalInformation	Hidden
Visible	Hidden
WebOptions	Hidden
WindowHeight	Hidden
WindowWidth	Hidden

Methods	Status
ApplyTheme	Hidden

DataAccessPages

Properties	Status
Application	Hidden
Count	Hidden
Item	Hidden
Parent	Hidden

DefaultWebOptions

Properties	Status
AlwaysSaveInDefaultEncoding	Hidden
Application	Hidden
CheckIfOfficeIsHTMLEditor	Hidden
DownloadComponents	Hidden
Encoding	Hidden
FolderSuffix	Hidden
FollowedHyperlinkColor	Hidden
HyperlinkColor	Hidden
LocationOfComponents	Hidden
OrganizeInFolder	Hidden
Parent	Hidden
TargetBrowser	Hidden
UnderlineHyperlinks	Hidden
UseLongFileNames	Hidden

DoCmd

Methods	Status
AddMenu	Changed Previous syntax VOID AddMenu (VARIANT MenuName, VARIANT MenuMacroName, VARIANT StatusBarText) New syntax VOID AddMenu (VARIANT MenuName, VARIANT MenuMacroName, OPTIONAL VARIANT StatusBarText)
ApplyFilter	Changed Previous syntax VOID ApplyFilter (OPTIONAL VARIANT FilterName, OPTIONAL VARIANT WhereCondition) New syntax VOID ApplyFilter (OPTIONAL VARIANT FilterName, OPTIONAL VARIANT WhereCondition, OPTIONAL VARIANT ControlName)
OutputTo	Changed Previous syntax VOID OutputTo (ACOUTPUTOBJECTTYPE ObjectType, OPTIONAL VARIANT ObjectName, OPTIONAL VARIANT OutputFormat, OPTIONAL VARIANT OutputFile, OPTIONAL VARIANT AutoStart, OPTIONAL VARIANT TemplateFile, OPTIONAL VARIANT Encoding) New syntax VOID OutputTo (ACOUTPUTOBJECTTYPE ObjectType, OPTIONAL VARIANT ObjectName, OPTIONAL VARIANT OutputFormat, OPTIONAL VARIANT OutputFile, OPTIONAL VARIANT AutoStart, OPTIONAL VARIANT TemplateFile, OPTIONAL VARIANT Encoding, OPTIONAL ACEXPORTQUALITY OutputQuality = 0)
SelectObject	Changed Previous syntax VOID SelectObject (ACOBJECTTYPE ObjectType, OPTIONAL VARIANT ObjectName, OPTIONAL VARIANT InDatabaseWindow) New syntax VOID SelectObject (ACOBJECTTYPE ObjectType, OPTIONAL VARIANT ObjectName, OPTIONAL VARIANT InDatabaseWindow)
TransferSpreadsheet	Changed Previous syntax VOID TransferSpreadsheet (OPTIONAL ACDATATRANSFERTYPE TransferType = 0, OPTIONAL ACSPREADSHEETTYPE SpreadsheetType = 8, OPTIONAL VARIANT TableName, OPTIONAL VARIANT FileName, OPTIONAL VARIANT HasFieldNames, OPTIONAL VARIANT Range, OPTIONAL VARIANT UseOA) New syntax VOID TransferSpreadsheet (OPTIONAL ACDATATRANSFERTYPE TransferType = 0, OPTIONAL ACSPREADSHEETTYPE SpreadsheetType = 10, OPTIONAL VARIANT TableName, OPTIONAL VARIANT FileName, OPTIONAL VARIANT HasFieldNames, OPTIONAL VARIANT Range, OPTIONAL VARIANT UseOA)

Form

Properties	Status
AllowDesignChanges	Hidden
OnMenu	Hidden
Section	Changed Previous syntax READ-ONLY Section [SECTION] (VARIANT Index) New syntax READ-ONLY Section [_SECTION] (VARIANT Index)
WhatsThisButton	Hidden

ObjectFrame

Properties	Status
LpOleObject	Hidden

Report

Properties	Status
OnMenu	Hidden
Section	Changed Previous syntax READ-ONLY Section [SECTION] (VARIANT Index) New syntax READ-ONLY Section [_SECTION] (VARIANT Index)

Screen

Properties	Status
ActiveDataAccessPage	Hidden

SubReport

Properties	Status
Application	Hidden
Form	Hidden
Parent	Hidden
Report	Hidden

Events	Status
Enter	Hidden
Exit	Hidden

WebOptions

Properties	Status
Application	Hidden
DownloadComponents	Hidden
Encoding	Hidden
FolderSuffix	Hidden
LocationOfComponents	Hidden
OrganizeInFolder	Hidden
Parent	Hidden
TargetBrowser	Hidden
UseLongFileNames	Hidden

Methods	Status
UseDefaultFolderSuffix	Hidden

Object Model Changes Since Microsoft Office XP (2002)

AcCommand

Constants	Status
acCmdDataAccessPageAddToPage	Hidden
acCmdDataAccessPageBrowse	Hidden
acCmdDataAccessPageDesignView	Hidden
acCmdDataAccessPageFieldListRefresh	Hidden
acCmdDemote	Hidden
acCmdExport	Hidden
acCmdImport	Hidden
acCmdMacroConditions	Hidden
acCmdMacroNames	Hidden
acCmdMicrosoftScriptEditor	Hidden
acCmdNewObjectDataAccessPage	Hidden
acCmdPromote	Hidden
acCmdPublish	Removed
acCmdSaveAsASP	Hidden
acCmdSaveAsDataAccessPage	Hidden
acCmdSaveAsIDC	Hidden
acCmdSelectDataAccessPage	Hidden
acCmdShowOnlyWebToolbar	Hidden
acCmdStopLoadingPage	Hidden
acCmdViewDataAccessPages	Hidden
acCmdWebPagePreview	Hidden
acCmdWebPageProperties	Hidden
acCmdWebTheme	Hidden

AcDataAccessPageView

Constants	Status
acDataAccessPageBrowse	Hidden
acDataAccessPageDesign	Hidden

AcObjectType

Constants	Status
acDataAccessPage	Hidden

AcOutputObjectType

Constants	Status
acOutputDataAccessPage	Hidden

AcSendObjectType

Constants	Status
acSendDataAccessPage	Hidden

AcSpreadSheetType

Constants	Status
acSpreadsheetTypeLotusWJ2	Hidden
acSpreadsheetTypeLotusWK1	Hidden
acSpreadsheetTypeLotusWK3	Hidden
acSpreadsheetTypeLotusWK4	Hidden

AllDataAccessPages

Properties	Status
Application	Hidden
Count	Hidden
Item	Hidden
Parent	Hidden

Application

Properties	Status
AnswerWizard	Hidden
Assistant	Hidden
DataAccessPages	Hidden
DefaultWebOptions	Hidden
FileSearch	Hidden

Methods	Status
CreateControl	Changed Previous syntax CONTROL CreateControl (STRING FormName, ACCONTROLTYPE ControlType, OPTIONAL ACSECTION Section = 0, OPTIONAL VARIANT Parent, OPTIONAL VARIANT ColumnName, OPTIONAL VARIANT Left, OPTIONAL VARIANT Top, OPTIONAL VARIANT Width, OPTIONAL VARIANT Height) New syntax _CONTROL CreateControl (STRING FormName, ACCONTROLTYPE ControlType, OPTIONAL ACSECTION Section = 0, OPTIONAL VARIANT Parent, OPTIONAL VARIANT ColumnName, OPTIONAL VARIANT Left, OPTIONAL VARIANT Top, OPTIONAL VARIANT Width, OPTIONAL VARIANT Height)
CreateNewWorkgroupFile	Hidden
CreateReportControl	Changed Previous syntax CONTROL CreateReportControl (STRING ReportName, ACCONTROLTYPE ControlType, OPTIONAL ACSECTION Section = 0, OPTIONAL VARIANT Parent, OPTIONAL VARIANT ColumnName, OPTIONAL VARIANT Left, OPTIONAL VARIANT Top, OPTIONAL VARIANT Width, OPTIONAL VARIANT Height) New syntax _CONTROL CreateReportControl (STRING ReportName, ACCONTROLTYPE ControlType, OPTIONAL ACSECTION Section = 0, OPTIONAL VARIANT Parent, OPTIONAL VARIANT ColumnName, OPTIONAL VARIANT Left, OPTIONAL VARIANT Top, OPTIONAL VARIANT Width, OPTIONAL VARIANT Height)
ExportXML	Changed Previous syntax VOID ExportXML (ACEXPORTXMLOBJECTTYPE ObjectType, STRING DataSource, OPTIONAL STRING DataTarget = "", OPTIONAL STRING SchemaTarget = "", OPTIONAL STRING PresentationTarget = "", OPTIONAL STRING ImageTarget = "", OPTIONAL ACEXPORTXMLENCODING Encoding = 0, OPTIONAL INT32 OtherFlags = 0) New syntax VOID ExportXML (ACEXPORTXMLOBJECTTYPE ObjectType, STRING DataSource, OPTIONAL STRING DataTarget = "", OPTIONAL STRING SchemaTarget = "", OPTIONAL STRING PresentationTarget = "", OPTIONAL STRING ImageTarget = "", OPTIONAL ACEXPORTXMLENCODING Encoding = 0, OPTIONAL ACEXPORTXMLOTHERFLAGS OtherFlags = 0, OPTIONAL STRING WhereCondition = "", OPTIONAL VARIANT AdditionalData)
NewCurrentDatabase	Changed Previous syntax VOID NewCurrentDatabase (STRING filepath) New syntax VOID NewCurrentDatabase (STRING filepath, OPTIONAL ACNEWDATABASEFORMAT FileFormat = 0, OPTIONAL VARIANT Template, OPTIONAL STRING SiteAddress = "", OPTIONAL STRING ListID = "")

BoundObjectFrame

Properties	Status
LpOleObject	Hidden

CodeProject

Properties	Status
AllDataAccessPages	Hidden

Constants

Constants	Status
acFormatASP	Hidden
acFormatDAP	Hidden
acFormatIIS	Hidden

CurrentProject

Properties	Status
AllDataAccessPages	Hidden

CustomControl

Properties	Status
LpOleObject	Hidden

DataAccessPage

Properties	Status
Application	Hidden
ConnectionString	Hidden
CurrentView	Hidden
Document	Hidden
MailEnvelope	Hidden
MSODSC	Hidden
Name	Hidden
Parent	Hidden
RemovePersonalInformation	Hidden
Visible	Hidden
WebOptions	Hidden
WindowHeight	Hidden
WindowWidth	Hidden

Methods	Status
ApplyTheme	Hidden

DataAccessPages

Properties	Status
Application	Hidden
Count	Hidden
Item	Hidden
Parent	Hidden

DefaultWebOptions

Properties	Status
AlwaysSaveInDefaultEncoding	Hidden
Application	Hidden
CheckIfOfficeIsHTMLEditor	Hidden
DownloadComponents	Hidden
Encoding	Hidden
FolderSuffix	Hidden
FollowedHyperlinkColor	Hidden
HyperlinkColor	Hidden
LocationOfComponents	Hidden
OrganizeInFolder	Hidden
Parent	Hidden
TargetBrowser	Hidden
UnderlineHyperlinks	Hidden
UseLongFileNames	Hidden

DoCmd

Methods	Status
AddMenu	Changed Previous syntax VOID AddMenu (VARIANT MenuName, VARIANT MenuMacroName, VARIANT StatusBarText) New syntax VOID AddMenu (VARIANT MenuName, VARIANT MenuMacroName, OPTIONAL VARIANT StatusBarText)
ApplyFilter	Changed Previous syntax VOID ApplyFilter (OPTIONAL VARIANT FilterName, OPTIONAL VARIANT WhereCondition) New syntax VOID ApplyFilter (OPTIONAL VARIANT FilterName, OPTIONAL VARIANT WhereCondition, OPTIONAL VARIANT ControlName)
OutputTo	Changed Previous syntax VOID OutputTo (ACOUTPUTOBJECTTYPE ObjectType, OPTIONAL VARIANT ObjectName, OPTIONAL VARIANT OutputFormat, OPTIONAL VARIANT OutputFile, OPTIONAL VARIANT AutoStart, OPTIONAL VARIANT TemplateFile, OPTIONAL VARIANT Encoding) New syntax VOID OutputTo (ACOUTPUTOBJECTTYPE ObjectType, OPTIONAL VARIANT ObjectName, OPTIONAL VARIANT OutputFormat, OPTIONAL VARIANT OutputFile, OPTIONAL VARIANT AutoStart, OPTIONAL VARIANT TemplateFile, OPTIONAL VARIANT Encoding, OPTIONAL ACEXPORTQUALITY OutputQuality = 0)
SelectObject	Changed Previous syntax VOID SelectObject (ACOBJECTTYPE ObjectType, OPTIONAL VARIANT ObjectName, OPTIONAL VARIANT InDatabaseWindow) New syntax VOID SelectObject (ACOBJECTTYPE ObjectType, OPTIONAL VARIANT ObjectName, OPTIONAL VARIANT InDatabaseWindow)
TransferSpreadsheet	Changed Previous syntax VOID TransferSpreadsheet (OPTIONAL ACDATATRANSFERTYPE TransferType = 0, OPTIONAL ACSPREADSHEETTYPE SpreadsheetType = 8, OPTIONAL VARIANT TableName, OPTIONAL VARIANT FileName, OPTIONAL VARIANT HasFieldNames, OPTIONAL VARIANT Range, OPTIONAL VARIANT UseOA) New syntax VOID TransferSpreadsheet (OPTIONAL ACDATATRANSFERTYPE TransferType = 0, OPTIONAL ACSPREADSHEETTYPE SpreadsheetType = 10, OPTIONAL VARIANT TableName, OPTIONAL VARIANT FileName, OPTIONAL VARIANT HasFieldNames, OPTIONAL VARIANT Range, OPTIONAL VARIANT UseOA)

Form

Properties	Status
AllowDesignChanges	Hidden
ChartSpace	Changed Previous syntax READ-ONLY ChartSpace [CHARTSPACE] New syntax READ-ONLY ChartSpace [OBJECT]
OnMenu	Hidden
PivotTable	Changed Previous syntax READ-ONLY PivotTable [PIVOTTABLE] New syntax READ-ONLY PivotTable [OBJECT]
Section	Changed Previous syntax READ-ONLY Section [SECTION] (VARIANT Index) New syntax READ-ONLY Section [_SECTION] (VARIANT Index)
WhatsThisButton	Hidden

ObjectFrame

Properties	Status
LpOleObject	Hidden

Report

Properties	Status
OnMenu	Hidden
Section	Changed Previous syntax READ-ONLY Section [SECTION] (VARIANT Index) New syntax READ-ONLY Section [_SECTION] (VARIANT Index)

Screen

Properties	Status
ActiveDataAccessPage	Hidden

SubReport

Properties	Status
Application	Hidden
Form	Hidden
Parent	Hidden
Report	Hidden

Events	Status
Enter	Hidden
Exit	Hidden

WebOptions

Properties	Status
Application	Hidden
DownloadComponents	Hidden
Encoding	Hidden
FolderSuffix	Hidden
LocationOfComponents	Hidden
OrganizeInFolder	Hidden
Parent	Hidden
TargetBrowser	Hidden
UseLongFileNames	Hidden

Methods	Status
UseDefaultFolderSuffix	Hidden

Object Model Changes Since Microsoft Office 2000

AccessObject

Properties	Status
FullName	Changed Previous syntax READ-ONLY FullName [STRING] New syntax READ-WRITE FullName [STRING]
Type	Changed Previous syntax READ-ONLY Type [INT32] New syntax READ-ONLY Type [ACOBJECTTYPE]

AcCommand

Constants	Status
acCmdDataAccessPageBrowse	Hidden
acCmdDataAccessPageDesignView	Hidden
acCmdDemote	Hidden
acCmdImport	Hidden
acCmdMacroConditions	Hidden
acCmdMacroNames	Hidden
acCmdMicrosoftScriptEditor	Hidden
acCmdNewObjectDataAccessPage	Hidden
acCmdPromote	Hidden
acCmdPublish	Removed
acCmdSaveAsASP	Hidden
acCmdSaveAsDataAccessPage	Hidden
acCmdSaveAsIDC	Hidden
acCmdSelectDataAccessPage	Hidden
acCmdShowOnlyWebToolbar	Hidden
acCmdStopLoadingPage	Hidden
acCmdViewDataAccessPages	Hidden

AcDataAccessPageView

Constants	Status
acDataAccessPageBrowse	Hidden
acDataAccessPageDesign	Hidden

AcObjectType

Constants	Status
acDataAccessPage	Hidden

AcOutputObjectType

Constants	Status
acOutputDataAccessPage	Hidden

AcSendObjectType

Constants	Status
acSendDataAccessPage	Hidden

AcSpreadSheetType

Constants	Status
acSpreadsheetTypeLotusWJ2	Hidden
acSpreadsheetTypeLotusWK1	Hidden
acSpreadsheetTypeLotusWK3	Hidden
acSpreadsheetTypeLotusWK4	Hidden

AllDataAccessPages

Properties	Status
Application	Hidden
Count	Hidden
Item	Hidden
Parent	Hidden

Application

Properties	Status
AnswerWizard	Hidden
Assistant	Hidden
CurrentObjectType	Changed Previous syntax READ-ONLY CurrentObjectType [INT32] New syntax READ-ONLY CurrentObjectType [ACOBJECTTYPE]
DataAccessPages	Hidden
DefaultWebOptions	Hidden
FileSearch	Hidden

Methods	Status
CreateControl	Changed Previous syntax CONTROL CreateControl (STRING FormName, ACCONTROLTYPE ControlType, OPTIONAL ACSECTION Section = 0, OPTIONAL VARIANT Parent, OPTIONAL VARIANT ColumnName, OPTIONAL VARIANT Left, OPTIONAL VARIANT Top, OPTIONAL VARIANT Width, OPTIONAL VARIANT Height) New syntax _CONTROL CreateControl (STRING FormName, ACCONTROLTYPE ControlType, OPTIONAL ACSECTION Section = 0, OPTIONAL VARIANT Parent, OPTIONAL VARIANT ColumnName, OPTIONAL VARIANT Left, OPTIONAL VARIANT Top, OPTIONAL VARIANT Width, OPTIONAL VARIANT Height)
CreateDataAccessPage	Hidden
CreateReportControl	Changed Previous syntax CONTROL CreateReportControl (STRING ReportName, ACCONTROLTYPE ControlType, OPTIONAL ACSECTION Section = 0, OPTIONAL VARIANT Parent, OPTIONAL VARIANT ColumnName, OPTIONAL VARIANT Left, OPTIONAL VARIANT Top, OPTIONAL VARIANT Width, OPTIONAL VARIANT Height) New syntax _CONTROL CreateReportControl (STRING ReportName, ACCONTROLTYPE ControlType, OPTIONAL ACSECTION Section = 0, OPTIONAL VARIANT Parent, OPTIONAL VARIANT ColumnName, OPTIONAL VARIANT Left, OPTIONAL VARIANT Top, OPTIONAL VARIANT Width, OPTIONAL VARIANT Height)
NewCurrentDatabase	Changed Previous syntax VOID NewCurrentDatabase (STRING filepath) New syntax VOID NewCurrentDatabase (STRING filepath, OPTIONAL ACNEWDATABASEFORMAT FileFormat = 0, OPTIONAL VARIANT Template, OPTIONAL STRING SiteAddress = "", OPTIONAL STRING ListID = "")
OpenCurrentDatabase	Changed Previous syntax VOID OpenCurrentDatabase (STRING filepath, OPTIONAL BOOL Exclusive = 0) New syntax VOID OpenCurrentDatabase (STRING filepath, OPTIONAL BOOL Exclusive = 0, OPTIONAL STRING bstrPassword = "")

BoundObjectFrame

Properties	Status
LpOleObject	Hidden

CodeProject

Properties	Status
AllDataAccessPages	Hidden

ComboBox

Properties	Status
AllowedText	Hidden

Constants

Constants	Status
acFormatASP	Hidden
acFormatDAP	Hidden
acFormatIIS	Hidden

CurrentProject

Properties	Status
AllDataAccessPages	Hidden

CustomControl

Properties	Status
LpOleObject	Hidden

DataAccessPage

Properties	Status
Application	Hidden
ConnectionString	Hidden
CurrentView	Hidden
Document	Hidden
Name	Hidden
Parent	Hidden
Tag	Hidden
Visible	Hidden
WebOptions	Hidden
WindowHeight	Hidden
WindowWidth	Hidden

Methods	Status
ApplyTheme	Hidden

DataAccessPages

Properties	Status
Application	Hidden
Count	Hidden
Item	Hidden
Parent	Hidden

DefaultWebOptions

Properties	Status
AlwaysSaveInDefaultEncoding	Hidden
Application	Hidden
CheckIfOfficeIsHTMLEditor	Hidden
DownloadComponents	Hidden
Encoding	Hidden
FolderSuffix	Hidden
FollowedHyperlinkColor	Hidden
HyperlinkColor	Hidden
LocationOfComponents	Hidden
OrganizeInFolder	Hidden
Parent	Hidden
UnderlineHyperlinks	Hidden
UseLongFileNames	Hidden

DoCmd

Methods	Status
AddMenu	Changed Previous syntax VOID AddMenu (VARIANT MenuName, VARIANT MenuMacroName, VARIANT StatusBarText) New syntax VOID AddMenu (VARIANT MenuName, VARIANT MenuMacroName, OPTIONAL VARIANT StatusBarText)
ApplyFilter	Changed Previous syntax VOID ApplyFilter (OPTIONAL VARIANT FilterName, OPTIONAL VARIANT WhereCondition) New syntax VOID ApplyFilter (OPTIONAL VARIANT FilterName, OPTIONAL VARIANT WhereCondition, OPTIONAL VARIANT ControlName)
OpenReport	Changed Previous syntax VOID OpenReport (VARIANT ReportName, OPTIONAL ACVIEW View = 0, OPTIONAL VARIANT FilterName, OPTIONAL VARIANT WhereCondition) New syntax VOID OpenReport (VARIANT ReportName, OPTIONAL ACVIEW View = 0, OPTIONAL VARIANT FilterName, OPTIONAL VARIANT WhereCondition, OPTIONAL ACWINDOWMODE WindowMode = 0, OPTIONAL VARIANT OpenArgs)
OutputTo	Changed Previous syntax VOID OutputTo (ACOUTPUTOBJECTTYPE ObjectType, OPTIONAL VARIANT ObjectName, OPTIONAL VARIANT OutputFormat, OPTIONAL VARIANT OutputFile, OPTIONAL VARIANT AutoStart, OPTIONAL VARIANT TemplateFile) New syntax VOID OutputTo (ACOUTPUTOBJECTTYPE ObjectType, OPTIONAL VARIANT ObjectName, OPTIONAL VARIANT OutputFormat, OPTIONAL VARIANT OutputFile, OPTIONAL VARIANT AutoStart, OPTIONAL VARIANT TemplateFile, OPTIONAL VARIANT Encoding, OPTIONAL ACEXPORTQUALITY OutputQuality = 0)
SelectObject	Changed Previous syntax VOID SelectObject (ACOBJECTTYPE ObjectType, OPTIONAL VARIANT ObjectName, OPTIONAL VARIANT InDatabaseWindow) New syntax VOID SelectObject (ACOBJECTTYPE ObjectType, OPTIONAL VARIANT ObjectName, OPTIONAL VARIANT InDatabaseWindow)
TransferSpreadsheet	Changed Previous syntax VOID TransferSpreadsheet (OPTIONAL ACDATATRANSFERTYPE TransferType = 0, OPTIONAL ACSPREADSHEETTYPE SpreadsheetType = 8, OPTIONAL VARIANT TableName, OPTIONAL VARIANT FileName, OPTIONAL VARIANT HasFieldNames, OPTIONAL VARIANT Range, OPTIONAL VARIANT UseOA) New syntax VOID TransferSpreadsheet (OPTIONAL ACDATATRANSFERTYPE TransferType = 0, OPTIONAL ACSPREADSHEETTYPE SpreadsheetType = 10, OPTIONAL VARIANT TableName, OPTIONAL VARIANT FileName, OPTIONAL VARIANT HasFieldNames, OPTIONAL VARIANT Range, OPTIONAL VARIANT UseOA)

Form

Properties	Status
AllowDesignChanges	Hidden
OnMenu	Hidden
Section	Changed Previous syntax READ-ONLY Section [SECTION] (VARIANT Index) New syntax READ-ONLY Section [_SECTION] (VARIANT Index)
WhatsThisButton	Hidden

ListBox

Properties	Status
TextAlign	Hidden

ObjectFrame

Properties	Status
LpOleObject	Hidden

Report

Properties	Status
OnMenu	Hidden
Section	Changed Previous syntax READ-ONLY Section [SECTION] (VARIANT Index) New syntax READ-ONLY Section [_SECTION] (VARIANT Index)

Screen

Properties	Status
ActiveDataAccessPage	Hidden

SubReport

Properties	Status
Application	Hidden
Form	Hidden
Parent	Hidden
Report	Hidden

Events	Status
Enter	Hidden
Exit	Hidden

TextBox

Properties	Status
AllowedText	Hidden
FELineBreak	Hidden

WebOptions

Properties	Status
Application	Hidden
DownloadComponents	Hidden
Encoding	Hidden
FolderSuffix	Hidden
LocationOfComponents	Hidden
OrganizeInFolder	Hidden
Parent	Hidden
UseLongFileNames	Hidden

Methods	Status
UseDefaultFolderSuffix	Hidden

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD