Microsoft Access Macros vs. VBA - Why Use Macros?

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:

Related Topics

Microsoft Access Macros
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
if the majority of my code is in vba, does it hurt to have some simple stuff in 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
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
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
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
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.

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?
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
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
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.

Access 2007: Enable Macros on Startup
Has anyone figured out if it's possible to enable vba macros on startup using a script? In Access 2003 I used application.setoption to tweak a number of application parameters though I'mnot sure if I can use this to enable macros in 2007.

I know that I can manually enable macros through the trust center and I could also add a trusted location (could prob. also automate a registry update to do same). My preference though isto enable macros using a script as over 600 users will, on occasion, use these databases and I don't want to spend my days telling people how to enable macros.

Run Excel Macros in Access
I coded a project using VBA in Excel. Now they want me to create a form in Access to do the exact same thing. Instead of converting the code to functions etc etc. Can I just call the macros from Excel within Access? The macros are saved in my personal.xls file

Delete macros after conversion to VBA?
I have a slooow Database. Everytime I go from one form to another (through buttons) it takes longer and longer as time goes (still developing database). So I tried converting my macros ( only bout 10 or so) into VBA through the setup they have on the wizard. My question is, now that I converted to VBA, can I delete the macros? If not then what is the point of converting to VBA other than more flexibility of programming.

Using macros to speed up your work - Office 2007
You can create macros in any Microsoft Office program to automatically perform a lengthy series of commands that you use often. After the macro is programmed, pressing a single button or combination of designated keys performs the series of tasks for you. Macros are frequently utilized in Microsoft Word.

How to Convert a Macro to VBA Code?
Although Microsoft has made great strides in improving the capabilities of macros in Access, most experienced developers agree that Visual Basic for Applications (VBA) code is still far superior to using macros in Access client apps. (Web apps, of course, cannot use VBA, so the following is only pertinent to applications that run in the Access Client.)
So suppose you have a completed macro that you want to convert to VBA? Fortunately, Access makes it easy.

VBA vs Macros
Just a general question. what is the best way to handle operations in DB, VBA or Macros? I seem to enjoy VBA more as it gives me more room for functionality and experiments

Jump Start VBA Skills with MS Access Macros
Macros help to speed up the performance of certain repetitive tasks when using an application. They are used extensively in all office-related software. As a programmer, you can leverage the built-in macro object in MS Access to get a head start in understanding VBA. This article explains how. TOC: Jump Start VBA Skills with MS Access Macros; Creating and running a macro in MS Access: opening the macro designer; Creating the first macro; Converting this macro to VBA code; Creating the second macro.

How to remove MACROS message in word. it comes at opening & closing of Microsoft word
The Message is like:
"The Macros in this project are disabled. Pls. refer to the online help or documentation of the host application to determine how to enable macros

How to display message if macros are disabled?
I would like to know how I can make Access 2007 display a message if I open a database that contains macros but in the Trust Center macros are disabled

I know that Access automatically displays a warning bar when doing so, but that is no good to me, I would need a msgbox that appears if macros are disabled (so that other parts (forms, etc) don't get displayed

What Are Macros and Why Would You Use Them in a Microsoft Access Database?
Macros are basically Microsoft Access' way of telling the application what it needs to do. It's essentially a small program (or a piece of script) that can tell the application a whole range of things it can do and how to go about doing them. They can sometimes be useful when performing certain tasks during the initial creation of applications.