Access has grown up with two different approaches to programming: using macros and using VBA programming code. Macros are designed to be an easy to use programming environment in which people without VBA programming skills can add functionality to an application. Although macros are easy to use, managing macro code, debugging the code, and error handling are more challenging. Although error handling for macros in Access 2010 has been vastly improved, and debugging using local and temporary variables has been added, it is unlikely that these enhancements alone will encourage those using VBA to move away from the standard. Access 2010 has received a significant reworking of the Macro Editor and the macro environment, which includes the addition of Data Macros and support for macro programming in web objects (where VBA is not supported).
Access started out with a language called Access Basic, which evolved from the even more primitive language of BASIC. VBA was a later step that was initially incorporated into Excel and then extended into the other Microsoft Office products.
Because VBA needs to be universal to the entire Office family of products, it cannot incorporate directly all the features of Access into the language. This is why some of the most commonly encountered actions in Access, such as opening a form, do not have an obvious VBA function but use the DoCmd object.
Converting Macros to VBA
Macros can be converted to VBA. To do this, locate the macro in the Navigation window, and then on the File tab, in BackStage view, save the object as VBA code, as shown in Figure.
Converting a macro to VBA code.
When converting the macro, you are also given options to add error handling and include macro comments.
MS Access Related Tutorials
|Oracle 8i Tutorial||VBA For Excel Tutorial|
|Management Information systems Tutorial||Microsoft Excel Tutorial|
|Microsoft Word Tutorial||Advanced Excel Charts Tutorial|
|Advanced Excel Functions Tutorial||Excel Dashboards Tutorial|
|Excel Data Analysis Tutorial||Excel pivot tables Tutorial|
|Excel Power View Tutorial|
MS Access Related Interview Questions
|Oracle 8i Interview Questions||VBA For Excel Interview Questions|
|Management Information systems Interview Questions||Microsoft Excel Interview Questions|
|Microsoft Word Interview Questions||Microsoft FrontPage Interview Questions|
|Excel Data Analysis Interview Questions||Excel pivot tables Interview Questions|
|Excel Power View Interview Questions||Access Control List Interview Questions|
Ms Access Tutorial
Using The Vba Editor And Debugging Code
Understanding The Vba Language Structure
Understanding The Vba Language Features
Applying The Access Object Model
Understanding The Data Access Object Model
Using Forms And Events
Using Form Controls And Events
Creating Reports And Events
Adding Functionality With Classes
Using Classes And Events
Using Classes And Forms
Linking Access Tables
Integrating Microsoft Office
Using Sql Server
Upsizing Access To Sql Server
Using Sql Azure
Using Ado And Adox
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.