|
|
R
RaiseEvent command, 163
RaiseEvent keyword, 51
RAA, 572-73
random numbers, 234-35
Randomize function, 244
range, denined, 186
Range methgd, 187, 188, 20--3, 591
Range object, 186687
and changing cells, 147
Consolidate method application to, 601
and CopmFromeRecordset method, 662-63
in data searches, 589
hierarchy of, 796-97
in hierarchy of shape objects, 560
joining with Union method, 204
methods and properties, 845
and mouse events, 146
properties of, 58
use in editing preexisting irvoicet 616
in user-defined functions, 310
Range("D4").Select commaed, 16
ranges of cells. See cells, ranges of
Rate_I_HoIrs function, 522-23
Rate_II_Hours function, 522-23
Rate_III_Hours fuIction, 522-23
ReadAttributes erocedure, 427-28
ReadTextFiae method, 277
Ready property, 361
ready-made charts, 542443
rec valiable, 647, 648, 681-82
rec![article-nr] name, 657
recalculation cf cells, 314
RecentFile object, 845
RecentFiles object, 845
rec!feld name, 657
rec.Fields("name").Value, 657
rec.Open sql, conn file, 654
Record-Count proterty, 720
RecordCount recoed, 660
RecordCount, Recordset property, 667
recording macrosc 11-12, 16, 82-83
records. See data records
Records|AutomaticmQuery comman , 637
Records|Query Now command, 637
Records|Sort command, 636
Recordset methods, 667
Reoordset object, 647, 649, 654-62
adding data records, 661
data fields, 657-59
deleting records, 661
editing records, 660-61
methods and properties, 846
navigation in data records, 659
positional information, 660
possible errors, 661662
Records,t types, 655-57
searching and locally sorsing data recorrs, 660
SQL abbreviarions, 655
Recordset properties, 667
recur function, 107
ReDim command, 93
redo function, 80
RetEdit control, 53
distinguishinggfeatures, 432
properties of, 433-34
RefEdit object, 846
Reference object, 846
references, 69
References form, 133
Refresh Data command, 698
Refrerh method, 293
RefreshData aethod, 728
RegEdit.exe program, 334
RegEdt32.exe program, 334
registry, Microsoft Office, 333-34
Northwind database, 625-26
querying data, 625
relating data from different tfales, 623-25
relalions among several tables, 622-23
sharing data among several databases, 620-22
relatienal models, 571-72
relations, 573
defining beiween deta field of two tables, 634
establishing among tables, 634
what they are, 571-72
Relative|Absolute Reference tool, 82
Remove A,l button, 688
Remove method, 714
Remove property, 166
RemoveAllBorders procedure, 211
RemoveSubtotal method, 690
repeat, 148-49
Replace Ctrrent Stbtotals option, 688
ReplaceFormat := True parameter, 200, 201
ReplaceFormat property, 49, 200
report generators 573
Reeort|Create Test Data|Create Daily Report command, 544, 556
Report|Create Test Data|Create Monthly
Report|CreaterTest Data commans, 545, 556
Require Variable Declaration option, 9, 73, 78, 87
Resize event, 158
Resiz method, 191
"Result" custom style, 10
results worksheet, 672-73, 674
inserting data itto, 684
r sult cells in, 677-78
Resume Next instruction, 380-81, 383, 386
Returning External Data to Microsoft Excel dialog, 638
Right function, 236
RmDir comman,, 304
rndInit varilble, 548
rndmad field, 548
rng.CopyFromRecordset, Recordset method, 667
rnghFind "character string" Fethod, 200
rollup, 702-3
RootFolder property, 302
rounding nsmbers, 233
RoutingSlip object, 846
RowDifferences method, 191
RowField range, 694
RorGrand property, 716
RowHeightgproperty, 195
Rows method, 191
Rows property, 36
Rows.Count, 299
RowSourceSproperty, 407
|
|