Tag Archives: MS Access macro

Creating a VBA Access database

You can create powerful Access databases with no programming code at all. There may be a situation though when you do need some specialized functionality and then you will have to create a VBA Access database. The programming language used in all the MS Office products is VBA which stands for Visual Basic for Applications. [...]

Read full storyComments Off

How to use the autoexec macro

The autoexec macro is used to run actions when the database is opening. For example, you may wish to perform a data update before the system becomes active. You can do a similar thing with the start up options, but the autoexec macro will allow you to run more than one action. Lets look at [...]

Read full storyComments Off

Create a PDF file with a Microsoft Access macro

In Microsoft Access 2010 one of the new features is to save data as PDF format files. You can also do┬áthis by using Microsoft Access macros. Click on the ‘Create’ tab. Click on the macro button on the top right hand side. At the right of the screen you will see a window for the [...]

Read full storyComments Off

MS Access Macro – How To Open a Report

An MS Access macro is a great tool for automating our databases. We can use Microsoft Access macro actions for many tasks. In this demonstration I am going to open a report by using a macro. The MS Access macro designer has three main columns 1. Macro Name 2. Action 3. Comment Enter the name [...]

Read full storyComments Off