Topics Search

Microsoft Access Macros vs. VBA - Why Use Macros?

Microsoft Access Macros vs. VBA - Why Use Macros?
Views: 111
Macros have been used as development tool since the early days of the Microsoft Office product line. Microsoft Access macros incorporate generalized database functions using existing Microsoft Access capabilities. Errors in a macro can be easily resolved by using the Microsoft supplied Help function. The ease with which you can generate Macros makes Macro development seem easier to accomplish...
Sponsored Links:

More topics

 

Microsoft Access Macros

Preview
The following articles contain useful information about using macros in Microsoft Access 97 and converting macros to Visual Basic for Applications code.
Macros are very useful for automating simple tasks, such as carrying out an action when the user clicks a command button. You don't need to know how to program to use macros. Macros can perform a number of the common tasks that you can also use Visual Basic code to perform. However, using Visual Basic code instead of macros gives you much more flexibility and power, and there are many things you can only do in code, such as returning values or iterating through recordsets.
 

vba vs macros

Preview
if the majority of my code is in vba, does it hurt to have some simple stuff in macros.like a close form button or whatever

I was reading that macros are amateurish, and you should make your whole program in vba.but I copied a couple of buttons or what not from templates or examples, and I absolutely do not understand macros at all.i understand vba A LOT better.but im scared to change it because I need it to still work.
 

VBA or Macros

Preview
I am building my database base on a template I got off of the Microsoft Access Website and it includes a combination of embedded macros and event procedures, VBA.

At this point I am not having too much problem editing either to get what I need to done, but that does not mean that I understand either very well at this time. However I am really trying to think about this database from a macro point of view and do things the right way the first time and not just what works just for the moment. I want to plan for this database to be upscaleable and to probably work on a network which may mean that the backend will reside on an SQL server. I am trying to learn and understand VBA, which I will take any reference recommendations on, but at this point both VBA & Macros are just greek to me.

So the question is should I be trying to convert all of the embedded macros to VBA or visa versa? Or is everything OK the way it is and if it ain't broke don't fix? What are your
 

Create a macro

Preview
In Microsoft Office Access 2007, macros can be contained in macro objects (sometimes called standalone macros), or they can be embedded into the event properties of forms, reports, or controls. Embedded macros become part of the object or control in which they are embedded. Macro objects are visible in the Navigation Pane, under Macros; embedded macros are not.
 

Automate applications with macros in Access 2007

Preview
If you have been using Access in the past, the easiest way to automate the tasks would have been by using the macros. On the other hand, programmers might have realized that writing VBA (visual basic for applications) modules is the best way to automate things in any Access database.
Access 2007 makes it very easy to create macros. In previous versions, many macros could not have been created without using VBA code but in Access 2007 new features have been added to eliminate the need of using VBA code.
 

Introduction to macros

Preview
This article explains what macros are and how they can save you time by automating tasks that you perform often. It explores the fundamentals behind creating and using macros and also touches on improvements to macros in Microsoft Office Access 2007.
In this article: What is a macro? Understand macros; New macro features in Office Access 2007; Create a macro; Run a macro.
 

Macros

Preview
This week we'll discuss, for those of you unfamiliar with programming, one of the more conceptually complex aspects of Microsoft Access. We'll start with a discussion of events: what they are and how Access uses them. Then, we'll move on to a lengthy discussion of macros, including what they do and how you design and use them. TOC: Macros; Debugging;
Getting Fancy with Macros.
 

Macros vs. VBA?

Preview
I think I read somewhere that whenever possible I should use Macros over VBA because they are faster to run. Is this true? plus what are some other benefits to running Macros over VBA
 

Types of Macros in Microsoft Access

Preview
A macro is an object like other objects available in Microsoft Access (tables, queries, reports etc.), except that you create the macro to automate a particular task or series of tasks.
Typically, macros on Microsoft Access forms can be grouped into categories depending on the function that they perform; the macros in each category contain unique instructions that enable them to perform the indicated tasks.
 

Introduction to macros: Automate tasks

Preview
This article explains what macros are and how they can save you time by automating tasks that you perform often. It explores the fundamentals behind creating and using macros and also touches on improvements to macros in Microsoft Office Access 2007.
In this article you'll learn: What is a macro? Understand macros, New macro features in Office Access 2007, Create a macro, Run a macro.