[AccessD] MS Access 2007 - where may one have a look at the full list of the new objects, proper

Gustav Brock Gustav at cactus.dk
Thu Oct 26 10:50:44 CDT 2006


Hi Shamil

Great work, but those "embedded macros" - whatever that is - sure look ugly.

/gustav

>>> shamil at users.mns.ru 25-10-2006 23:21 >>>

Hi All,

As far as I see there are ~300+ new properties for MS Access 2007 objects.
153 of these properties are to set/get embedded macros' to process
forms'/reports'/controls' events - like in this sample to set embedded macro
for command button's Click event:

Dim strMacro As String
strMacro = _
"Version = 196611" & vbCrLf & _
"ColumnsShown = 8" & vbCrLf & _
"Begin" & vbCrLf & _
"    Action = ""OpenForm""" & vbCrLf & _
"    Argument = ""frmTest""" & vbCrLf & _
"    Argument = ""0""" & vbCrLf & _
"    Argument = """"" & vbCrLf & _
"    Argument = """"" & vbCrLf & _
"    Argument = ""-1""" & vbCrLf & _
"    Argument = ""0""" & vbCrLf & _
"End"
Me.cmdTest.Properties("OnClickEmMacro").Value = strMacro

These new [{EventName}EmMacro] properties seems to be available only via
.Properties collection.

Another interesting new feature is that Report object has now additionally
all the events of the Form object and reports' controls have now all the
events of the corresponding form controls...

Here is the list of unique new properties' names ([{EventName}EmMacro]
properties are not listed):

AggregateType
AllowLayoutView
AllowReportView
AllowValueListEdits
AlternateBackColor
AppendOnly
AutoHeight
BottomPadding
CursorOnHover
CustomRibbonID
DatasheetAlternateBackColor
DatasheetCaption
DisplayAsHyperlink
DisplayOnSharePointSite
FilterOnEmptyMaster
FilterOnLoad
FitToPage
GridlineColor
GridlineStyleBottom
GridlineStyleLeft
GridlineStyleRight
GridlineStyleTop
GridlineWidthBottom
GridlineWidthLeft
GridlineWidthRight
GridlineWidthTop
HorizontalAnchor
ImageData
InheritValueList
Layout
LayoutID
LeftPadding
ListItemsEditForm
NavigationCaption
NavPane Category
NavPane Closed
NavPane Sort By
NavPane View By
NavPane Width
OnPaint
OrderByOnLoad
RightPadding
SaveSplitterBarPosition
SeparatorCharacters
ShowDatePicker
ShowOnlyRowSourceValues
ShowPageMargins
SplitFormDatasheet
SplitFormOrientation
SplitFormPrinting
SplitFormSize
SplitFormSplitterBar
TextFormat
TopPadding
UseDefaultPaperSize
VerticalAnchor

If that is interesting I can publish complete list of 300+ new properties
somewhere on my site....

--
Shamil
 
-----Original Message-----
From: Shamil Salakhetdinov [mailto:shamil at users.mns.ru] 
Sent: Tuesday, October 24, 2006 11:32 PM
To: 'Access-D'
Subject: MS Access 2007 - where may on have a look at the full list of the
new objects, properties, methods,...

Hi All,

As far as I see there are useful new properties of MS Access 2007 controls,
e.g. ComboBox has got 'List Items Edit Form' property. 

Is there anywhere a full list of new objects, properties, methods? (MS
Access 2007 online help doesn't have it. Or I'm missing it?).

Thank you.

--
Shamil





More information about the AccessD mailing list