In Datasheet view

When you're working in Datasheet View, you can easily hide columns containing data that you don't need to immediately work with.

To do so, select any field in the column and choose Format >Hide Columns from the menu bar.

As an alternative, right- click on the column's field name and select Hide Columns from the shortcut menu.

To redisplay hidden columns, select Format>Unhide Columns from the menu bar.
Then, select the check boxes next to the field names of any columns you want displayed and click OK.

You can select the Unhide Columns command even if no columns are hidden, allowing you to easily hide multiple columns by clearing the appropriate check boxes.




See all Topics access

Labels: Customize, General, Tables, Tips

Writ on tables

"And it came to pass that the cries and lamentations of the Access newbies were heard on high by the gods of the Database, and their hearts were moved to pity for their followers. And they opened their mouths and spake, saying: "Nevermore shall the young and innocent wander witless on their journeys!

1. Thou shalt design normalized tables and understand thy fields and relationships before thou dost begin.
   
2. Thou shalt never allow thy users to see or edit tables directly, but only through forms and thou shalt abhor the use of "Lookup Fields" which art the creation of the Evil One.
   
3. Thou shalt choose a naming convention and abide by its wisdom and never allow spaces in thy names.
   
4. Thou shalt write comments in your procedures and explain each variable.
   
5. Thou shalt understand error handling and use it faithfully in all thy procedures.
   
6. . . .
   

Thus spake the gods of the Database, and blessed be their names!"

The full list can be found on the Access Web

See all Topics access

Labels: General, Tips

Cardinal numbers

Labels: Functions, Macros, Tips, Tutorials, VBA

Run code at timed intervals

You may occasionally want to run a procedure associated with a form at set intervals. To do so, add the code to the form's Timer event procedure. Then, set the form's TimerInterval property to the number of milliseconds that should elapse between each time the code is run. The maximum you can set is 65,535.
(in Access 2007, the TimerInterval property setting is a Long Integer value between 0 and 2,147,483,647.)

Keep in mind that you shouldn't use a very small TimerInterval, otherwise your application will likely suffer a performance hit. To prevent the Timer event from firing, set the TimerInterval to 0.

Also see:
HOW TO: Create a Stopwatch Form in Access

See all Topics access

Labels: Forms, General, Macros, Properties, Tips