Office Enterprise 2007 Key Expand only the subdata

Today's guest blogger is Pavlo Pedan of ARGO Business Corp. He has 15 years of experience with Access and has a great site of tips  at If you have a form that contains subdatasheets,Office 2007 Professional Plus Product Key, you can use the following VBA command to expand all of them: Forms,Microsoft Office 2007 Pro Plus Aktivierung Key![FormName],Microsoft Office Professional Plus 2007![SubFormName].Form.SubdatasheetExpanded = True However,Office Enterprise 2007 Key, we often want only some of the subdatasheets to be expanded,Office 2007 Activation Key, based on
some criteria (for example - expand only if subdatasheets contain data.) Watch a short video demo and download a demo database from this page. Make sure you have added a reference to the "Accessibility" library (%windir%\system32\oleacc.dll). This has been tested on Access 2007. Send your Power Tips to Mike and Chris at accpower@microsoft.com. <div