In this week's Office Challenge, we resolve last week's question and offer a new one: It's common to want to rearrange the data in a table, but how do you move data from one row to another?
Last week we asked..."How do you hide and unhide system and custom objects in Access?" The answer follows:
- To hide an object, right-click it in the Database window or Access 2007's Navigation Pane, choose Properties from the resulting submenu, and check the Hidden option in the Attributes section on the General tab.
- To unhide hidden objects, choose Options from the Tools menu and check the Hidden Objects option in the Show section on the View tab. In Access 2007, right-click the Navigation pane’s menu bar, select Navigation Options, select Show Hidden Objects, and click OK. If hiding the object doesn't work (it's still visible in the Database window or Navigation Pane) most likely, the Hidden Objects option is currently checked. Uncheck it, and the hidden objects should disappear.
- Access hides System objects by default. To unhide them, choose Options from the Tools menu. Then, check the System Objects option in the Show section on the View tab. In Access 2007, right-click the Navigation pane’s menu bar, select Navigation Options, select Show System Objects, and click OK.