MartyConnelly
martyconnelly at shaw.ca
Thu Oct 26 15:46:38 CDT 2006
Actually they look like a VB6 .frm file, if you open it in notepad VERSION 5.00 Object = "{6B7E6392-850A-101B-AFC0-4210102A8DA7}#1.3#0"; "COMCTL32.OCX" Begin VB.Form frmMain AutoRedraw = -1 'True Caption = "AsyncDownload Test" ClientHeight = 7116 ClientLeft = 2568 ClientTop = 2232 ClientWidth = 8664 LinkTopic = "Form1" Gustav Brock wrote: >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 > > > > -- Marty Connelly Victoria, B.C. Canada