Access Database Systems

WelcomeBlog

Are your business objectives being met?

Do you need specialised Access database consulting or an Access database solution? Our software is dedicated to providing assistance toward increasing efficiency and productivity of the small or medium sized business.

If you do not have the resources or time to develop software for your business, you may find something of interest here.

Archive for the ‘The MS Access Macro’ Category

How to use the autoexec macro

Monday, February 1st, 2010

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 how we can use the autoexec Access macro to open a form and move to a blank record for entering data.

Load up a database.

Go into the macro designer.

In Access 2007 at the Ribbon you would click on the create tab.

Then click on the macro icon at the far right hand side.

In the action column select the ‘OpenForm’ action.

MS Access Autoexec Macro

At the bottom of the screen you will see an area for action arguments.

Select the name of the form to open

Make sure the view says form.

Now select another action of ‘GoToRecord’.

At the bottom of the screen you will see an area for action arguments.

Select an object type of form.

The object name will be the form you are opening.

Set record to be new.

That’s it…..

Now just save the macro with the name of ‘Autoexec’.

Close the macro designer window.

Exit the database.

Now run the database.

The autoexec Access macro will immediately kick in and you will be taken to a brand new record in the form you specified.

The autoexec macro enables us to control what we want to take place when the database is opening.

Click here MS Access macro if you want to learn more about macros.

Tags: , ,
Posted in The MS Access Macro | 1 Comment »

Create a PDF file with a Microsoft Access macro

Tuesday, January 26th, 2010

In Microsoft Access 2007 one of the new features is to save data as PDF format files. You can also do
this by using Microsoft Access macros.

Load up the macro designer and click on the actions column. Scroll through the list of actions until you find one called ‘OutputTo’. Select this action.

At the bottom of the screen you will see the Microsoft Access macro action arguments.

-The object type will be the object you are using which could be a table, query, form etc.

-The Object name will be the name of the object – for example you may have a table called customers.

-Output format will be the type of format you wish to output the object to. This could be html, excel etc. Select PDF format here.

Output file will be the path of where you want the output to be saved.

The only other setting here which you could use is ‘Output quality’. Set this to be ‘Screen’.

Microsoft Access macro

Now save and run the Microsoft Access macro.

In Windows locate the area where your PDF was saved and open it up.

Click here to get more help with the Microsoft Access macro

Tags: ,
Posted in The MS Access Macro | 1 Comment »

MS Access Macro – How To Open a Report

Wednesday, January 20th, 2010

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 of the new MS Access macro in the ‘Macro Name’ column.
Now move to the ‘Action’ column and select the ‘OpenReport’ action.
Look towards the bottom of the screen and you will see the action arguments section. Enter the name of the report in the report name section. In the view section select the view you wish to see the report in. In this example I want to see it in print preview mode.

Now save the MS Access macro and close the designer window.

Create a brand new form in design view.
Now make sure the wizard button is clicked as you want to use a wizard for the next step.
From the toolbox control area you want to click the command button control.
Drop the button onto the form.
The wizard will now load and you will see two columns – categories and actions.
Select from the categories box the option called miscellaneous.
From the actions box select the run macro action.
Click the ‘Next’ button and on the next screen select the macro that you saved earlier.
Click the ‘Next’ button and on the next screen add text to the button.
Click the finish button.

Now run the form and click your command button.
The Microsoft Access macro will run and your report will open in print preview mode.

The MS Access macro makes our life so much easier. We don’t need to learn complex programming code to add power to the database.

To further your learning of the MS Access macro check out this great new MS Access macro ebook.

Tags: , , ,
Posted in The MS Access Macro | 3 Comments »

Using the MS Access macro

Saturday, January 16th, 2010

When we want to automate certain aspects of our database we can take two routes. The first is to learn how to program or the second to learn how to use MS Access macros

Macros consists of actions which instruct Access to perform tasks. For example we may have a macro to backup our tables,forms etc into another database. We may even create a simple macro to open a form or report.

There are macro actions for practically anything you want to do in Access. You will find that learning how to use the MS Access macro is not as hard as you think.

You may even want to transfer data from your MS Access tables into a Microsoft Excel spreadsheet by clicking one button. Easily done with a macro. Forget about having to click various menu commands. Just create a macro in the designer and you are done.

Why not email that spreadsheet or even output it to Microsoft Word? Again, a macro can take care of this for you.

Forget about complex programming. The MS Access macro makes automating your database a breeze.

Check out this fantastic new resource to help you with MS Access macro learning
http://access-databases.com/ebooks/macros/

Posted in The MS Access Macro | No Comments »