SECTION 1
Lesson 1.5: Advanced Macro Uses

   

 

 

If you frequently use a particular macro, you may find it cumbersome to use the Tools menu. After all, the main advantage of a macro is to save time!

 

If you would like, you can assign a macro to a keystroke. First, we’ll open the macro we created in our last lesson. Then, we’ll enable the Macro Names field. This is where we’ll type in the keystrokes we want to use. Here’s how the syntax works:

 

Macro Name

Key Combination

^Q or ^1

CTRL+Q or CTRL+1

{F1}

F1

^{F1}

CTRL+F1

+{F1}

SHIFT+F1

{INSERT}

INS

^{INSERT}

CTRL+INS

+{INSERT}

SHIFT+INS

{DELETE} or {DEL}

DEL

 

Let’s look at an example.

 

 

Our FindRecord macro will run when we press Ctrl and Q, and our OpenForm macro will run when we press Ctrl and 4.

 

Now, we need to save the macro with the name AutoKeys. We’ll use the File – Save As command to give it a different name.

 

 

Now, when we go into any data view and press Ctrl + Q, our macro will be run.