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:

Similar posts...

 

vba vs macros

vba vs macros Icon
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.
 

Microsoft Access Macros

Microsoft Access Macros Icon
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.
 

Automate applications with macros in Access 2007

Automate applications with macros in Access 2007 Icon
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.
 

VBA or Macros

VBA or Macros Icon
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
 

Macros vs. VBA?

Macros vs. VBA? Icon
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
 

Create a macro

Create a macro Icon
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.
 

Introduction to macros

Introduction to macros Icon
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.
 

Introduction to macros: Automate tasks

Introduction to macros: Automate tasks Icon
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

Access 2007: Enable Macros on Startup Icon
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.
 

What are Macros and how you design and use them

What are Macros and how you design and use them Icon
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.