|
Auto order tabs |
 |
 |
|
Wednesday, 24 May 2006 14:24 |
|
Go to View > Tab Order, select the section you wish to order and then click Auto Order.
|
|
Create inaccessible fields on a form |
|
|
|
Wednesday, 24 May 2006 14:35 |
|
To make a field look like a standard field, but be inaccessible to the user, set the Enabled property to No, and the Locked property to Yes.
|
|
Exit a code loop |
|
|
|
Wednesday, 24 May 2006 14:39 |
|
If you're stuck in an infinate code loop, press Ctrl + Break to end it.
|
|
Keyboard shortcut: Adding a new record |
|
|
|
Thursday, 18 May 2006 08:16 |
To add a new record
press CTRL + PLUS SIGN (+)
|
|
Keyboard shortcut: Bringing a hidden database windows to the front |
|
|
|
Tuesday, 07 March 2006 14:31 |
You need to see the database windows, but it has dissapeared?
Press F11 to bring the Database window to the front.
|
|
Keyboard shortcut: Deleting the current record |
|
|
|
Thursday, 18 May 2006 08:17 |
|
To delete the current
record press CTRL + MINUS SIGN (-)
|
|
Keyboard shortcut: Insert value from same field in previous record |
|
|
|
Wednesday, 24 May 2006 14:44 |
|
Press Ctrl + ' (apostrophe) to insert the value from the same field in the previous record.
|
|
Keyboard shortcut: Inserting the current time |
|
|
|
Thursday, 18 May 2006 08:13 |
To insert the current time
CTRL + COLON (:)
|
|
Keyboard shortcut: Inserting the default value for a field |
|
|
|
Thursday, 18 May 2006 08:14 |
To insert the default value
for a field CTRL + ALT + SPACEBAR
|
|
Keyboard shortcut: Inserting the same value from the previous record |
|
|
|
Thursday, 18 May 2006 08:15 |
|
To insert the value from
the same field in the previous record
press CTRL + APOSTROPHE (')
|
|
Keyboard shortcut: Open a combo box |
|
|
|
Wednesday, 24 May 2006 14:43 |
|
Press Alt + Down arrow to open a combo box.
|
|
Keyboard shortcut: Recalculating the fields within a window |
|
|
|
Thursday, 18 May 2006 08:18 |
To recalculate the fields
in the window press the F9 key.
|
|
Keyboard shortcut: Show the result of your Debug.Print statements |
|
|
|
Tuesday, 07 March 2006 14:37 |
If you're code isnt working as expected, you can quickly see the result of your Debug.Statements by holding CTRL+G.
|
|
Keyboard shortcut: Undo changes |
|
|
|
Thursday, 18 May 2006 08:10 |
To Undo changes Hit ESC once for current field, ESC twice
for current record.
|
|
Keyboard shortcut: Undo typing |
|
|
|
Thursday, 18 May 2006 08:09 |
To undo typing press CTRL + Z or
ALT + BACKSPACE
|
|
Remove tables from the relationships window |
|
|
|
Wednesday, 24 May 2006 14:20 |
|
Select the table, right click and click on Remove table.
|
|
Stop a control from receiving the focus when tabbing through a form |
|
|
|
Wednesday, 24 May 2006 14:26 |
|
Simply set the TabStop property to No.
|
|
Use 4 digit year format |
|
|
|
Wednesday, 24 May 2006 15:03 |
|
Tools > Options > General and go to use four-digit year formatting and select the appropriate option.
|
|
Use contats from Outlook in Access |
|
|
|
Wednesday, 24 May 2006 14:56 |
Go to File > Get External Data > Import, click Outlook in the Files of Type list and select the folder or address book you wish to use.
Note: Any data which is updated in Outlook will be updated in Access.
|
|
Using the '&' sign in a label |
|
|
|
Wednesday, 24 May 2006 14:42 |
|
To use the & sign in a label, you must enter it twice. So for example, Food & Drink would be Food && Drink.
|
|
|
|
|
