What’s the new Macro Features from the release of Access database 2010?

1
A C C E S S
D A T A B A S E
T U T O R I A L
Menu
D E C E M BB EEY RN A 1 D 7 T ,
2 02 10 71 7 Whats the new Macro Features
from the release of Access database 2010?
In previous versions of Access database, many
usually used functions could not be executed
without writing VBA code. With the release of
Access database 2010, new features and macro
actions have been added to help remove the need
for code. This makes it less demanding to add
functionality to your database and helps make it
more secure. Embedded macros You can now embed
macros in any of the events given by a form,
report, or control. An embedded macro is not
displayed in the Navigation Pane it becomes part
of the form, report, or control in which it was
created. If you make a duplicate of a form,
report, or control that has embedded macros, the
macros are also present in the duplicate. Increas
ed security When the Show All Actions button is
not highlighted in the Macro Builder, the only
macro actions and Run Command arguments that are
accessible for usage are those that do not
require trusted status to execute. A macro built
with these actions will execute even when the
database is in disabled mode. Databases that
contain macro actions that are not on the trusted
list need to be explicitly granted trusted status.
Error handling and debugging Access database
2010 provides new macro actions, which include
OnError and ClearMacroError, that enable you to
run certain actions when errors occur while your
macro is running. Moreover, the new SingleStep
macro action lets you enter single-step mode at
any point in your macro, so that you can see how
your macro performs one action at a time.
Temporary variables Three new macro actions
SetTempVar, RemoveTempVar, and RemoveAllTempVars
let you make and use temporary variables in
your macros. You can use these in conditional
expressions to control running macros, or to pass
data to and from reports or forms, or for any
other purpose that needs a temporary storage
place for a value. Create a macro As of Access
database 2010, a macro or macro group can be held
in a macro object, or a
2
macro can be inserted into any event property of
a form, report, or control. Embedded macros
become part of the object or control in which
they are inserted. Standalone macros are viewable
in the Navigation Pane, under Macros, but
embedded macros are not. Macro Designer
features Access database 2010 (including the
later versions too) has a new Macro Designer that
allows effortless creation of complex macros at
the same time decreasing coding errors. The
designer is used to build the list of actions
that you want to execute when the macro runs. To
display the Macro Designer, click Macro on the
Create tab. When you first open the designer,
Access will display a drop-down list from which
you select an action.
The following table shows the commands that are
available on the Design tab of Macro. Group Comma
nd Description
Performs the actions listed in the macro.
Tools Run
Executes the macro one at a time. When you click
the Single Step and then click Run, the Macro
Single Step dialog box displays, and you will see
three command buttons Step, Stop All Macros, and
Continue. Once you click Step command button, the
macro executes
Single Step
3
from one macro to another. To stop all the macro
actions, click Stop All Macros command button. To
continue to run the macro, click Continue command
button.
Convert Macros to Visual Basic
Use this to convert a macro to Visual Basic code.
Click this when you want to display the actions
of a macro.
Collapse/Expand
Expand Actions
This works opposite to the Expand Actions tool.
Collapse Actions
It expands the macro actions and the collapsed
block in the Macro Designer.
Expand All
It collapses the macro actions and expanded block
in the Macro Designer.
Collapse All
Click this if you want to display the Action
Catalog pane.
Show/Hide
Action Catalog
When selected, all the macro actions are
displayed in the drop-down list of the Action
column. If you choose a macro action from this
list, you may need to grant the database explicit
trust status before you can run the action.
Show All Actions
SIGN UP AND GET FREE EBOOK
Enter Your Name
SignUp Now and Get FREE EBOOK in your inboxand
Every Friday, we send out amazing Tips and Tricks
to help you master Microsoft Access.
Enter Your Email
Send Ebook Now!
If youlikethispostthenpleasesharewithotherpeople
? Email
Tweet
Save
Share 4
Share
Likethis Loading...
Related 5 Simple To Use Microsoft Access Macros
4
How to create an embedded macro?
Microsoft Access VBA vs MACRO
M S
A C C E S S A B O U T A, A C C C C E E
S S S S D A T A B A S , AE C 2C 0E 1S 6S
D A T A , BM AA SC ER O H EF LE PA
D D A A, AT T CA A CB B EA A S S SE
E
' A U
TD UA, A T C OA C
RB E IAS ASS LE S D E
T U R E S
Leave a Reply Your email address will not be
published. Required fields are marked Comment
Name
Email
Website
Post Comment Notify me of follow-up comments by
email. Notify me of new posts by email.
P R E V I O U S
5
What is a macro? N E X T Create a standalone
macro Part 2
Search
A C C E S S
2 0 1 6
E B O O K
O F F E R
U N D E R S T A N D I N G
A C C E S S
M A C
R E C E N T P O S T S MS Access Database Images
How To Correctly Handle Them ? Access Queries
Date Criteria May Not Always Work with MS Access
Query How to create an embedded macro? Create a
standalone macro Part 2 Whats the new Macro
Features from the release of Access database 2010?
R E C E N T C O M M E N T S benadt2017 on Access
Tab Control How To Create Multi-Page Forms
Kolade. O on Access Tab Control How To Create
Multi-Page Forms ms access forms on How to Build
Access Database Forms Microsoft Access 2016
Database eBook on Microsoft Access 2016 eBook
Offer MS access query on How to Build Access
Database Queries
6
C O N N E C T U P Microsoft Access Database
4,766 likes
O N
F A C E B O O K
Like Page
Contac
M O R E
S O C I A L
M E D I A
A R C H I V E S Select Month
C A T E Select Category
G O R I E S
M Y
E Z I N E
A R T I C L E S . .
2010-2017 Access Database Tutorial
Terms Of Use
Priv acy Policy
Contact Us


7
Proudly powered by WordPress