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


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.


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


Get started with Access programming
When you create a new database, you typically begin by creating a few database objects such as tables, forms, and reports. Eventually, you reach a point where you need to add some programming to automate certain processes and tie your database objects together. This article helps orient you to the programming tools in Microsoft Office Access 2007 and points you to some resources where you can learn more about programming.
In this article: What is programming? Should I use macros or should I use VBA code? Use the Command Button Wizard to perform common programming tasks, Understand macros, Understand VBA code, Convert macros to VBA code, Learn how to use the Help system.


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


Convert Macros to VBA
I have a database that is highly driven by macros. I have been working on rewriting the VBA where I know how. I ran the performance analyzer on a few macros and it said to use the convertto VB tool and I did that and it converted it to VB and I am not sure how to use the VB code for example where do I put it now or does it automatically use it?

For example I have a macro that is run as autoexec when the database opens, and others that run after a button on a form is clicked.

Should I just be copying the code into the correct object event like the click event, etc?


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.


replicate this vba command using the macros
Is there a way to replicate this vba command using the macros? If Me.Filter = "" Then
MsgBox "Apply a filter to the form first."
Else
DoCmd.OpenReport "r_PullPkgCkOffSheet", acViewPreview, , Me.Filter End If End Sub
The reason why I'm asking is, when I make my dbase to ACCDE the vba code does not work while macros do.