Free E-Books

n Display a progress meter on the status bar. If you need to display a progress meter to
communicate progress to the user, VBA code is the answer.
Converting existing macros to VBA
After you become comfortable with writing VBA code, you may want to rewrite some of your
application macros as VBA procedures. As you begin this process, you quickly realize how mentally
challenging the effort can be as you review every macro in your various macro libraries. You cannot
merely cut the macro from the macro window and paste it into a module window. For each condition,
action, and action argument for a macro, you must analyze the task it accomplishes and then
write the equivalent statements of VBA code in your procedure.
Fortunately, Access provides a feature that converts macros to VBA code automatically. One of the
options in the Save As dialog box is Save As Module. You can use this option when a macro file is
highlighted in the Macros object window of the Database window. This option enables you to convert
an entire macro group to a module in seconds.


Pages:
2145 2146 2147 2148 2149 2150 2151 2152 2153 2154 2155 2156 2157 2158 2159 2160 2161 2162 2163 2164 2165 2166 2167 2168 2169