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,
Microsoft Office Pro Plus 2007 Activation cl��, you can use the following VBA command to expand all of them: Forms,
Office Standard 2007 Serial Key![FormName],
Microsoft Office Professional Plus 2007 Product Key![SubFormName].Form.SubdatasheetExpanded = True However,
Office Enterprise 2007, we often want only some of the subdatasheets to be expanded,
Microsoft Office 2007 Professional Product 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