Learning,use,the,Access,macro, computer Learning to use the MS Access macro
----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc
Normal 0 false false false EN-GB X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:"";mso-padding-alt:0cm 5.4pt 0cm 5.4pt;mso-para-margin:0cm;mso-para-margin-bottom:.0001pt;mso-pagination:widow-orphan;font-size:11.0pt;font-family:"Arial","sans-serif";mso-ascii-font-family:Arial;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:"Times New Roman";mso-fareast-theme-font:minor-fareast;mso-hansi-font-family:Arial;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:"Times New Roman";mso-bidi-theme-font:minor-bidi;}The general features of MS Access allow us tocreate some great systems. However, there will be times when we want to dosomething which goes beyond what can be achieved with the basic functionality. TheMS Access macro will take your database into a new dimension. Some people may find the idea of programmingor learning VBA program code off putting. To some it can be challenging,rewarding even, to others a chore best avoided. There is a way around thisthough. MS Access macros offer a halfway housebetween general functionality and fully blown programming. Essentially, behindthe scenes macros are VBA program code, but to the user they appear as one lineaction statements. For example we could use a macro to open a form. The macroaction would be called OpenForm. We just pass it the name of the form to openin the macro designer and voila, we have just written an automation statementwithout any program code. We could do the same with a report. We would write an MS Access macro to automateroutine tasks that we perform again and again. A good example is importingdata. To save us going up to the menus and selecting the various options, wecould write a macro to take care of it. A macro consists of actions. We can add aseries of actions to a single macro. We can also write a macro condition. Forexample, our macro condition could determine which button was clicked on theform and perform the correct macro action that is needed. Although an MS Access macro has limiteddebugging features, it does allow us to step through each line to pinpoint whatwent wrong. You cannot recover from the error easily as is the case with VBAprogramming. Some people use a macro for practicallyeverything in their applications, although this is not recommended. Whilst theyare very powerful tools it is better to use them sparingly and only for certaintasks. A very well known MS Access macro is calledAutoExec. This is the first thing that gets run when a database is opening.You might add a macro action to open a form and move to a certain record. Youcould then name the whole macro AutoExec and the actions inside it would getrun as soon as the database opens. By using the MS Access macro you will notonly add greater power to your applications, but you will also experience awhole new way of doing things.
Learning,use,the,Access,macro,