Shamil Salakhetdinov
shamil at users.mns.ru
Wed Oct 25 16:21:23 CDT 2006
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