Button
|
Shortcut Key
|
Action
|

|
Cntrl+N
|
New. Add new record at the bottom of the grid. Cntrl+Add is also another shortcut key for adding new record.
|

|
Cntrl+O
|
Open current cell DBLink, if any
|

|
Cntrl+S
|
Save or persist changes to the database
|

|
|
Print. This prints directly the currently selected report catalog on the Preview combobox without showing the Report Catalog.
|

|
Cntrl+P
|
Shows report catalog that the user can choose which report to be printed.
|

|
|
Data Transfer Service (DTS). This shows the DTS catalog that the user can choose from.
|

|
|
Command prompt: This shows the Command Line Interface where the user can choose which external application to run.
|

|
F5
|
Refresh dataset and reset layout
|

|
Cntrl+Z
|
Undo cell changes. To undo all changes click the icon.
|
.png)
|
Cntrl+F
|
Find and Replace
|

|
Cntrl+C
|
Copy. This key combination copies the selected content to the Clipboard
|
.png)
|
|
Cancel sorting of column
|

|
Cntrl+X
|
Cut. This key combination cuts the selected content and copies it to the Clipboard
|

|
Cntrl+V
|
Paste. This key combination pastes the contents of the Clipboard to the selected location.
Copy/Paste To/Trom Excel is supported.
|

|
F9
|
Recalculate column formula
|

|
F1
|
View User's Manual
|

|
Cntrl+F1
|
Setup for customizing and adding applicaiton module. Available in build 598 and above only.
|

|
|
File Manager. This shows the file manager module where the user can choose to view files
|

|
F10
|
View Central Menu. This shows all the modules that the user can access
|
.png)
|
|
User's default settings
|

|
|
Add current module to Favourite
|

|
|
View Where Clause Builder
|

|
|
View global settings
|
.png)
|
|
View global variables.
|

|
|
Theme Roller. Shows all available themes that the user can choose from. These themes affect the overal display settings such as font, colors, backgrounds, etc.
|

|
|
Export to Excel
|

|
|
View Import/Export services
|

|
|
Export grid to flex-pivot
|

|
|
Open dropdown DBLink, if any. This is now hidden starting build 512
|

|
Cntrl+Shift+K
|
Open file stream based on current cell, if any
|

|
|
Attach file stream to datarow. Need to click Save to persit to database file.
|
.png)
|
|
Overides constraints and restrictions. Needs password to gain access.
|

|
|
Lock/Unlock current column. Lock columns have image before the column caption to indicate that the column is non-editable.
|
 .png)
|
|
Lock/Unlock saved records. This is usually used to lock saved records to avoid accidental editing. When lock, user can still edit the cell using F2 key.
|

|
Cntrl+Shift+Down
|
Zoom out makes grid smaller
|

|
Cntrl+Shift+Up
|
Zoom in makes grid larger.
|

|
|
Change celll horizontal alignment
|

|
|
Change cell vertical alignment
|

|
|
Wrap Text
|
.png)
|
|
Set direction after ENTER
|

|
Cntrl+Shift+L
|
Show/Hide filter bar
|
.png)
|
|
Show/hide conditional filtering
|
.png)
|
|
Clear Filter
|

|
|
Show/Hide column footer
|

|
|
Freeze left column(s)
|

|
Cntrl+M
|
Maximize/minimize splitter panels. This is useful when the user wants to view the current grid in full screen within the MDI parent screen.
|

|
|
Show Table Relations. You can disable or change the table relations of the curretnly open app to have a different master-detail view of the tables.
|

|
|
Show Parser Expression. If you want to try to generate parser expression for the currently open app.
|