Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Microsoft Access 2010 VBA Macro Programming

Buy

Database macro programming has changed enormously over the last 15 years, having gone from Access Basic macros to VBA. Another major change occurred with Office 95, when macros went to VBA modules in a separate environment accessed via the Visual Basic Editor. It used to be fairly basic: code was entered into a special design window. Although the language was rather powerful in its own right, it was not a structured language and could certainly not be described as object-oriented. The number of commands was limited, and a fair amount of ingenuity was required to do certain tasks. The main advantage was that it was fairly easy to learn and understand; many programmers cut their teeth by initially writing database macros.

If anyone other than the original author examined the code, it could take days to find out exactly how it worked and what it was doing. Commercial companies frequently found that when the author of a complicated macro left the company, that macro had to be rewritten from scratch because of the time involved in assessing what it was doing.

Microsoft has introduced a new programming language called Visual Basic for Applications (VBA). VBA is a more intuitive and robust programming language, using an object-oriented design. It has many similarities with its older and larger cousin, Visual Basic (VB). Once you learn VBA, you will have a fair understanding of how Visual Basic itself operates.

VBA is extremely different from the old macro language, and if the older language is what you are used to, it will mean totally rethinking how you write and structure your code. The concepts of object-oriented programming (OOP) are as different as chalk and cheese to the old macro language, but there is a huge advantage in terms of what you can achieve on a spreadsheet. With object-oriented programming, you are dealing with the concept of objects. To use an example, the database you load is an object. The tables and queries where you access your data are other objects, and so are the printer and the screen. They have properties, events, and methods (discussed later in the book). You will start to see object-oriented programming in more detail when you reach Chapter 14.

VBA does allow a more structured and object-oriented approach to writing your macros. If this is your first foray into the world of Access macro programming, you may well find the concepts easier to grasp, since you have no knowledge of the technologies used in the past within Excel. The Access Basic macros were a completely different language in terms of how and where you entered it. The concept of VBA is unique and cannot be compared to the old Access Basic macros. Unfortunately, knowledge of the old system of writing macros can add to confusion with the new method of VBA and extend the learning curve.

(HTML tags aren't allowed.)

What's Your Future Worth?: Using Present Value to Make Better Decisions
What's Your Future Worth?: Using Present Value to Make Better Decisions

We weigh every significant decision based on how it will affect our future. But when it comes to figuring that out, we mostly make the process up as we go along. While financial professional Peter Neuwirth can't help you actually predict the future, he can offer...

Programming Cookbook
Programming Cookbook

This book brings together many of my routines that have been programmed over the years. Routines range from fading a screen up and down and moving tiles around in Mappy, the tile map editor which can be found at www.tilemap.co.uk The code in this book have been written using GLBasic, C, Javascript, PureBasic, DarkBasic Professional and...

XML for ASP.NET Developers (Kaleidoscope)
XML for ASP.NET Developers (Kaleidoscope)
XML for ASP.NET Developers first gives a solid foundation in the basics of MSXML including XML Syntax, XML Schemas, Xpath, Xlink, Xpointer, and other concepts necessary to leverage the power of XML. After the building blocks of XML are thoroughly covered, Dan guides readers through manipulating XML documents using the Document Object Model (DOM)...

Identity Theft Handbook: Detection, Prevention, and Security
Identity Theft Handbook: Detection, Prevention, and Security
The magnitude of the identity theft and fraud problem is enormous. Identity fraud was identified as one of the top priorities of the Department of Justice, just prior to the terrorist attacks of 9/11. Naturally, everyone’s priorities changed after 9/11. The impact of identity theft and identity fraud is reaching a proportion and a level of...
Cognitive Penetrability and the Epistemic Role of Perception (Palgrave Innovations in Philosophy)
Cognitive Penetrability and the Epistemic Role of Perception (Palgrave Innovations in Philosophy)
This book is about the interweaving between cognitive penetrability and the epistemic role of the two stages of perception, namely early and late vision, in justifying perceptual beliefs. It examines the impact of the epistemic role of perception in defining cognitive penetrability and the relation between the epistemic role of...
Handbook of Politics: State and Society in Global Perspective (Handbooks of Sociology and Social Research)
Handbook of Politics: State and Society in Global Perspective (Handbooks of Sociology and Social Research)

Political sociology is the interdisciplinary study of power and the intersection of personality, society and politics. The field also examines how the political process is affected by major social trends as well as exploring how social policies are altered by various social forces.

Political sociologists increasingly use a wide variety...

©2020 LearnIT (support@pdfchm.net) - Privacy Policy