Code Examples

Show/Hide Design Tools

acCmdViewToolbox, acCmdFieldList, acCmdProperties, acCmdSortingAndGrouping, acCmdViewRuler

Another piece of code that is probably not very useful.

Displays the various dialogs that can be used in the design of a report. If any are already in view then it hides them. The select object line is necessary as the Properties box rather than the report has the focus.

'***************** Code Start *******************
'Code by Terry Wickenden

Sub ShowDesignTools(strReport as String)

  DoCmd.OpenReport strReport, acViewDesign
  DoCmd.RunCommand acCmdViewToolbox
  DoCmd.RunCommand acCmdFieldList
  DoCmd.RunCommand acCmdProperties
  DoCmd.SelectObject acReport, strReport, False
  DoCmd.RunCommand acCmdViewRuler
  DoCmd.RunCommand acCmdSortingAndGrouping

End Sub

'****************** Code End ********************

© 1998 - 2011 Terry Wickenden TKW Design Site developed maintained and hosted by TKW Design. This site is best viewed at 1024 x 768. Optimised for Firefox.