In addition to the main switchboard number, each office or room within the company may have its
own extension number that is private within the company. A large office building will have a public
street address that is known by anyone passing by the building. Each office or suite within the
building will have a number that is private within that building.
400
Programming Microsoft Access Part II
Variables declared within a procedure are local to that procedure and cannot be used or referenced
outside of that procedure. Most of the listings in this chapter have included a number of variables
declared within the procedures in the listings. In each case, the Dim keyword was used to define
the variable. Dim is shorthand for dimension and is a rather archaic expression that is an instruction
to VBA to allocate enough memory to contain the variable that follows the Dim keyword.
Therefore, Dim intMyInt As Integer allocates less memory (2 bytes) than Dim dblMyDouble
As Double (8 bytes). There is no way to make a variable declared within a procedure visible outside
of that procedure.
Pages:
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880