1287
Index
copying and pasting, 569–571
dragging and dropping, 572–573
moving, 572–573
data macros, table events
before, 562–566
after, 564–566
AfterChange event, 564–566
AfterDelete event, 564–566
AfterInsert event, 564–566
BeforeChange event, 562–564
BeforeDelete event, 562–564
Data Mode argument, 1061
data object models. See ADO (ActiveX Data Objects); DAO
(Data Access Objects).
Data properties, 283
data sources
for forms, specifying, 309
network applications, 754–756
data sources, binding to. See also connecting.
bound controls, 266, 285
bound forms, 304
in reports, 346–348
data types
Attachment, 49, 54
DLLs, 943–945
Hyperlink, 49, 54
Lookup Wizard, 49, 54
SharePoint, 1127
validation, automatic, 224–225
VBA versus C/C++, 943–945
data types, Access
absolute speed, 862–863
converting to other types, 57–58
converting to SharePoint types, 1127
corresponding VBA types, 429
for fields, 45, 48–50
indexing, 50
list of, 49. See also specific types.
for phone numbers, 50
processing speeds, 862
property procedures, 990–991
for Social Security numbers, 50, 51
sorting, 50–51
versus SQL Server, 1235–1240
storage requirements, 50
for telephone numbers, 51
for zip codes, 51data macros. See also macros; VBA.
Action Catalog, 557–562
adding records to tables, 558–559
adding to tables, 554
back-end execution, 575
calling VBA procedures, 576
canceling record changes, 560
CancelRecordChange action, 560
ClearMacroError action, 562
CreateRecord action, 558–559
data actions, 560–562
Data Blocks actions, 557–560
DeleteRecord action, 560
deleting records, 560
editing records, 559
EditRecord action, 559
error handling, 561
error logging, 560–561
ExitForEachRecord action, 560
ForEachRecord action, 560
limitations of, 575–576
with linked tables, 576
LogEvent action, 560–561
LookupRecord action, 560
looping through recordsets, 560
Macro Designer, 553–562
macro groups, 557
for multi-value or attachment fields, 575
OnError action, 561
overview, 551–553
passing values with local variables, 561
program flow, 557–560
RaiseError action, 562
rasing errors, 562
resetting errors, 562
for returned records, 560
RunDataMacro action, 561
running other data macros, 561
saving as XML, 574–575
SendEmail action, 561
sending email, 561
SetField action, 561
SetLocalVar action, 561
StopMacro action, 561
terminating, 561
updating field values, 561
data macros, macro items
adding, 566–569
collapsing, 573–57452_475348-bindex.indd 128752_475348-bindex.indd 1287 4/1/10 2:01 PM4/1/10 2:01 PM