Microsoft Office Tutorials and References
In Depth Information
Designing Custom Web Apps
Book IX
Chapter 3
Table 3-2
Macros Actions Available in a Custom Web App
Comment
GoToControl
RunMacro
Group
GoToRecord
SaveRecord
If
MessageBox
SetProperty
Change View
NewRecord
SetVariable
ClosePopup
OpenPopup
StopMacro
DeleteRecord
RequeryRecords
UndoRecord
EditRecord
RunDataMacro
Customizing the mini toolbar
When Access creates the views, it adds a mini toolbar with Add, Delete, Edit,
Save, and Cancel buttons. To customize the toolbar, you simply open the
view in Design view and customize the buttons:
To remove one of the buttons that Access added, click once to select the
button and then press the Delete key.
To change the order of the buttons, click and drag them to new locations.
To add a new button, click the plus sign to the right of all the buttons;
click the new button; and then click the Data Properties icon to
customize the button (Control Name, Tooltip, Icon, or On Click macro).
For information about the properties of a control, see “Editing views,” earlier
in this chapter.
Creating a data macro
A data macro doesn’t run when a user does something. Instead, the data
macro runs when something happens at the table level. Just as you can in a
desktop database — but with fewer options available — you can add macros
to the events listed in Table 3-3.
Table 3-3
Data Macro Events
Event
Description
On Insert
After a new record has been added to this table
On Update
After any field in a record in this table has been updated
On Delete
After a record in this table has been deleted
Search JabSto ::




Custom Search