, , . , , , . Visual Basic (VB), , ( ).
, , :
;
, Access ;
■ , , Pig Latin (" ");
■ , .
( ) . , Access. Access. , VB, , . .
Visual Basic, Access Office, VBA (Visual Basic for Applications, Visual Basic ).
Visual Basic
, Visual Basic , - . Visual Basic.
Visual Basic Access, . Visual Basic → → Visual Basic (Database Tools → Macros → Visual Basic). Access . 16.1 , .
Visual Basic . , Access .
. 16.1. Visual Basic . Project ()
Visual Basic . Project () . ( .) Project () , . . 16.1 Project () ( BoutiqueFudge ). .
|
|
Access , Project () acwzrtool. Access, , . , Access .
Project Properties (), Project , . Immediate () , . , , . .
.
1. , , .
2. .
3. , , .
, , , . ( .)
, , (. . " " 15). , .
, . Visual Basic Insert → Module ( → ). . 16.2 .
, Visual Basic , . ( , Project.) , : Option Compare Database
, , Visual Basic . Visual Basic , Access.
Access (, Windows () (U.S. English) (Japanese kanji script)). . , "" "", Access .
, - , . ( ) Option Compare Database :
|
|
Option Explicit
Visual Basic , (. . " " 17).
. 16.2. , Project Modules. Access , , Module1, Module2 . . - , Project Properties, , Name. DataCleanupCode ( )
Visual Basic Option Explicit . Tools → Options ( → ), Require Variable Declarations ( ) . Access .
Access, Visual Basic Access . , File → Save [DatabaseName] ( → [], [DatabaseName] ).
, Access. ,
, , . , Access Visual Basic.