Windows
Nifty tricks with the windows keyWhy not use the extra key? Our favorites: Windows-M (Minimize all) to return to the windows desktop and Windows-Shift M to restore your windows. Windows-F (Find) find files and folders and Windows-L (Lock) oto lck your computer.
MS Office
Fast zoom in and zoom outWant to look at your Word document as a whole? Zoom out from that Excel table? Try the mouse scroll wheel! Keep the CRL key pressed. Works in several other applications such as Microsoft Internet Explorer, FileMaker
Word: the trick is to double-click!
In MS Word you can double-click almost everywhere and then something happens. An overview:
- Double-click before a paragraph to select it
- Double-click in the space next to the text ruler and to open the Page setup dialog window
- Double-click on the 'hourglass' or the grey triangles to open the the Paragraph dialog window
- Double-click in the header or footer area to edit header or footer text. Click in the body text to return.
- Double-click in the various parts of the status area to activate windows such as language options and spelling check.
Excel: outline rows and columns
In Excel you can resize columns and rows by dragging the lines between columns and rows. If you select multiple columns or rows they all get the same site. If you double-click between two columns, Excel automatically adjust column size based on largest content. This also works with multiple columns selected. Extreme fun if you select the worksheet as a whole!
Excel: fill multiple cells at once
Select multiple cells. Enter some value in the active cell and then press CTRL + Enter. The same value gets entered in all selected cells.
Dragging fun in Excel!
In MS Excel there is more than one way to drag a selected area of cells:
- First select an area of adjacent cells. Grab the selection on one of the sides (not a corner).
- Now you can move the selection. It is the same as cut and paste.
- While dragging keep the CTRL-key pressed. It is the same as copy and paste.
- While dragging keep the SHIFT-ley pressed. Now you can insert the selection into rows or columns.
- While dragging keep the ALT-ley pressed to move the selection to antoher worksheet
- Try the combinations of the above mentioned keys and you'll be amazed!
FileMaker Pro
Duplicate Scripts without the 'Copy' extension in the script nameIf you duplicate a script in the ScriptMaker window with the 'Duplicate', FileMaker addes the extension 'Copy' in the script name. To prevent htis, keep the SHIFT-key pressed while clicking the 'Duplicate' button. Note: this doesn't work with the copy/paste features added since FileMaker Pro 7.
Layouts: de magie van het dupliceren...
In Layout mode you can use the 'duplicate' feature to copy and outline one or more objects:
- Select an object
- Press CTRL-D on Windows or APPLE-D on Mac to duplicate the object
- Place the duplicated object somewehere on the layout. It is important that the object stays selected.
- With the new object in position and still selected, press CTRL-D/APPLE-D again.
- The new object places itself in the same relative position as the position between the original and the first copy. This way you can create groups of outlined objects.
Create your own custom layout theme
Layout themes are layout templates that the FileMaker New layout wizard shows when creating new layouts. You can create your own and display them in that list!
The layout elements - color, position, font - of layout themes are described in XML files. You can find these files on the following paths from withing your FileMaker application folder: 'Extensions\English\Themes\' (Windows) or 'FileMaker Pro 8.app/Contents/Resources/English.lproj/Themes/' (MacOS). The files have the '.fth' file extension.
The best way to create your own layout theme is to copy an existing theme file, and to open it in a text editor(e.g. Notepad on Windows, or TextEdit on MacOS). Now you can modify all style elements in plain text. You can amongst others redefine default font, font size, font weight, color and backgroundcolorn. Warning: it is recommended to be familiar with XML at some level before experimenting with custom layout themes.
The downloads page contains a theme in ClickWorks style!
Quick debugging in FileMaker Pro Advanced
Start a script in the Script debugger by keeping the SHIFT-key pressed while clicking the 'Perform' button in the ScriptMaker window.
Access
Use the mouse wheel to scoll through your VBA codeIt is a shame that the development team at MS could has forgotten this! Fortunately there is Joe Bott to fill this black hole:
Scroll Wheel Fix!