Export (0) Print
Expand All
7 out of 9 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 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.

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

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

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

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?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.