Introduction to the IDE

1
Introduction to the IDE

• Integrated Development Environment

2
A Look at the IDEPopular buttons
Change Properties of selected object
Use Project Explorer to locate Modules
Save your work
Run a proc in a Standard Module
3
A Look at the IDEGet Set Up Properly
Customize your buttonbar
Bookmarks help finding code
Indents help code appearance
Comments help remembering code
4
Essential IDE SkillsForm Class Object Modules

• These modules are created for you
• They are containers for Form-based procedures
• Procs in one Form Module are invisible to another
  form
• Event procedures in a Form Class Module can be
  edited
• Cannot test these procs in the IDE
• Run the Form in Access to test procs in a Form
  Class Module

5
A Look at the IDEForm Class Module
(Form_frmContribution)
The Button Wizard wrote this code when we pasted
the Next button on frmContribution back in Access
6
Essential IDE SkillsStandard Modules

• Create Standard Modules in the IDE
• These are containers for general procedures
• Created using Menu Insert, Procedure
• Rename modules modUtilities, modGlobals
• Create and test general procedures here
• Procs are functions and subprograms
• All forms can use these procedures
• Delcare Option Explicit in modGlobals

7
Creating code in the IDEEditing a Function
Typing MID( is enough to activate Auto Quick with
handy argument reminders
8
Testing code in the IDEStandard Module
(modUtilities)
Test single statements
Test procedures