00. Intro (5:01)
01. Universal Dialog Box 2
(21:28)
OK, Cancel, Yes, No Buttons
Turn Sub into Function
Global Variables
While Loops
While Wend
DoEvents
Return Function
Value
02. Custom Form Positioning (23:49)
Height and
Width of Forms
Twips = Inches * 1440
Twentieth of an Inch Point
Design
Time Width of Form
Me.Width
Runtime Width of Form
Me.InsideWidth
OnResize Event
WindowHeight, WindowWidth - Read Only
Me.Detail.Height
Me.InsideHeight
There is no OnMoved event
You can use a timer event
OnTimer
Twips Round to 15
Me.Move
Docmd.MoveSize
Center Form On
Screen
AutoCenter
03. Universal Dialog Box 3 (35:14)
AutoCenter
Not exactly in the center of the screen
uDialog Left,
Top, Height, Width
Size of Controls in Form
Resize Prompt Label on Form
Resize
Border Style Sizable, Dialog
Move Buttons as Form is Resized
Button Top, Left
One or Two Buttons Visible
04. External
String Manager (21:59)
Multi-Language Database
Don't Design
Multiple Forms or Databases
Different Prompts on Forms and Reports
Create
User Settings Table
For Multiple Users See Security Seminar
Create String
Table
Dynamic Labels on Customer Form
Label Caption Property
Dynamic
Labels on Customer Report
Create External Module GetString Function
Use
GetString as a MsgBox String
05. Review (2:31)