Ms Access Database - vb6

Microsoft Access Database - Microsoft Visual Basic 6

VB6 With Access
http://www.vb6.us/tutorials/vb6-access

Tutorial 4: Accessing databases using the DataEnvironment Controll
http://pages.cpsc.ucalgary.ca/~saul/vb_examples/tutorial4/

visual basic 6.0 to ms access
http://www.dreamincode.net/forums/topic/185023-visual-basic-60-to-ms-access/

LESSON 9 - Working with a database
http://www.profsr.com/vb/vbless09.htm

Compact Ms Access Database

Compact Ms Access Database / Compress Ms Access Database

CompactDatabase Method (JRO)
https://msdn.microsoft.com/en-us/library/bb237197.aspx

Access Database Engine
http://techieyogi.blogspot.co.id/2009/11/installing-access-database-engine-with.html

Access 2007
http://www.vbforums.com/showthread.php?607895-RESOLVED-How-to-compact-Access-2007-data-base
https://social.msdn.microsoft.com/Forums/en-US/ddf4519f-b69f-4d40-b2f4-fe4987305b0f/compact-access-2007-database?forum=adodotnetdataproviders
http://techieyogi.blogspot.co.id/2009/11/how-to-compact-access-2007-database.html
http://www.vbforums.com/showthread.php?43900-Compact-Access-DB-with-VB6-code

Access 2003
http://www.vbforums.com/showthread.php?661787-RESOLVED-Access-database-compact-repair
https://support.microsoft.com/en-us/kb/230501
http://www.freevbcode.com/ShowCode.asp?ID=1162
http://vbadud.blogspot.com/2007/09/reducing-size-of-microsoft-access.html

All Version
http://stackoverflow.com/questions/156331/wouldnt-ms-access-mdb-file-size-reduce-after-deleting-the-content-of-database

DOS Command Prompt
http://www.vbforums.com/showthread.php?364654-Classic-VB-API-How-Do-I-Run-DOS-Commands-From-VB

Delphi 7 vs Visual Basic 6 - part 1

Delphi 7 = Visual Basic 6
Component Palette toolbar = Toolbox window
Form Designer window ( Shift + F12 ) = Object / Form Designer window ( Shift + F7 )
Project Manager window ( Ctrl + Alt + F11 ) = Project Explorer window ( Ctrl + R )
Object Tree View window ( Shift + Alt + F11 ) = Object Browser window ( F2 )
Object Inspector window ( F11 ) = Properties window ( F4 )

Code Explorer window ( F12 ) = Code Editor window ( F7 )
Code Explorer ( Ctrl + Shift + E ) = Object list box ( Ctrl + F2 ) and Procedure list box ( Ctrl + F2, then Tab)

Microsoft Configuration - tools list

Group Policy Management Console/Group Policy Object Editor:
gpedit.msc

Control Panel
ex: Network Connections control panel = ncpa.cpl

Registry Editor:
regedit
regedt32

Local Security Policy
secpol.msc

Windows Services
services.msc

Microsoft Configuration:
msconfig

Command Prompt / Batch Script
VBScript
JScript

Power Shell
*.ps1

Photoshop Drawing & Painting 1

B : Brush, Pencil Tool, Color Replacement Tool, Mixer Brush (CS6)
E : Eraser tools
J : Spot Healing Brush, Healing Brush, Patch, Red Eye (CS2)
S : Clone Stamp Tool, Pattern Stamp Tool
X : Switch Foreground/Background Colours
Y : History Brush Tool, Art History Brush Tool.

Hold Down Shift + Brush (Works with nearly every drawing tool) : Draw Straight LinesDraw Straight Lines
- Using Brush (Works with nearly every drawing tool)
- Click on the start spot then hold Shift and click on the finish/last/target spot.

]/[	Increase / Decrease brush size (Brush, Stamp tools)
Shift+]/Shift+[	Increase / Decrease brush hardness (Brush, Stamp tools)

Photoshop Text Shortcut 1

Ctrl (Windows) , Command (Macintosh).
Alt (Windows), Option (Macintosh).

T : Activate Text Tool.
Shift + T : Switch to other text tool (Vertical Type Tool, Horizontal Type Mask, Vertical Type Mask).
CTRL+Enter : will commit text changes after you have finished typing.
Enter (on the numeric keypad) : will commit text changes after you have finished typing.
Single click on layer in Layers Panel : will commit text changes after you have finished typing.
click checkmark in (Tool) Options Bar / (Tool) Preferences Bar : will commit text changes after you have finished typing.
Double Click on the "T" icon of a text layer in the layers panel : will select all text in that layer.

Ctrl + Shift + . : Enlarge text size by 2 points.
Ctrl + Shift + , : Smaller text size by 2 points.
Ctrl + Shift + Alt + . : Enlarge text size by 10 points.
Ctrl + Shift + Alt + , : Smaller text size by 10 points.

Ctrl + Shift + K : Quick way to switch between lowercase and uppercase text.
Ctrl + Shift + H - small caps.

Alt + Left and Right Arrow Keys : extend / reduce distance between word, a line or a whole paragraph (Tracking). If you block between two characters (you change the Kerning) by 20.
Ctrl + Alt + Left and Right Arrow Keys : extend / reduce distance between word, a line or a whole paragraph (Tracking). If you block between two characters (you change the Kerning) by 100.

Alt + Up and Down Arrow Keys : Quickly change the distance between selected lines (leading) 20.
Ctrl + Alt + Up and Down Arrow Keys : Quickly change the distance between selected lines (leading) 100.

Alt + Shift + Up and Down Arrow Keys : Easy way to use one text layer but have different positions for the text (Baseline Shift) 2. Generally use for ordinal number in date, equation, chemical, math.
Ctrl + Alt + Shift + Up and Down Arrow Keys : Easy way to use one text layer but have different positions for the text (Baseline Shift) 10. Generally use for ordinal number in date, equation, chemical, math.

Ctrl +Shift+L : will align the selected paragraph text justify/align left.
Ctrl +Shift+R : will align the selected paragraph text justify/align right.
Ctrl +Shift+C : will align the selected paragraph text justify center.
Ctrl + Shift + J : justify with last line left aligned
Ctrl + Shift + F : justify all lines
Ctrl + Shift + U : underline
Ctrl + Shift + I : italic
Ctrl + Shift + B : bold
Ctrl + Shift + Y : not sure what to call it, but it resets everything except justification

Photoshop Layer Shortcut 2

Double Click the lock on Background Layer : Change background layer to layer.
Alt + Double Click the lock on Background Layer : Change background layer to layer with default name.
Alt+Delete/Alt+Backspace (Photoshop CS 2 and earlier) : fill empty layer with foreground color.
Ctrl+Delete/Ctrl+Backspace (Photoshop CS 2 and earlier) : fill empty layer with background color.