Microsoft Help Desk for Microsoft Office 2000 : Support Solutions Direct from Microsoft Book

A
Access. See Microsoft Access
AccessError method, 215-16
accounts, Microsoft Outlook
    checking settings, 573-74
    not properly configured message, 573-74
ACT!
    converter for files, 627
    importing Contact or Calendar data to Outlook, 626-27
action queries, setting UseTransaction property, 138
Active Desktop. See Windows Desktop Update
ActiveMovie
    and PowerPoint, 963-64
    removing startup item from Registry, 963-64
ActivePrinter property, 1139
Active Server Pages (ASP)
    and Database Results region, 439
    and FrontPage, 402, 457-58
    installing after creation of database pages, 440
    installing to Internet Information Server (IIS) or Microsoft Personal Web Server, 457-58
    returning query results as hyperlink, 443-44
ActiveX controls
    Calendar control, 414-15
    defined, 414
    and OCX files, 60-61
    Snapshot Viewer, 122-23
    using to customize Outlook forms, 684-86
ActiveX Data Objects 2.1 Library, 358-59
ActiveX Data Objects (ADO), 158-78
    accessing QueryDef stored procedures through, 158-59
    allowing deletions, 172-73
    assigning to forms, 171
    CommandText property, 158-59
    editing recordset data, 167-70
    error message upon opening, 172-73
    finding Jet database records, 163-67
    and increased database size, 159-60
    lock type, 172-73
    mixing with DDL transaction methods, 170-71
    opening recordsets, 172-73
    referencing object properties and methods, 173-77
    trapping Jet database errors, 160-63
    traversing Tables collection, 171-72
adCmdStoredProc constant, CommandText property, 158-59
adCmdTable constant, CommandText property, 158-59
AddFromFile method, 249
AddFromGUID method, 249
AddFromString method, 249
add-ins
    for Access, 4
    COM, 416-17, 602, 603
    for Excel
        creating, 352-54
        installing, 356-57
    EZ-Photo, 1120-22
    for Outlook
        changing security setting, 603-4
        COM add-in, 602, 603
        potential problem with, 804
    Visual SourceSafe, 82, 84, 486-87
    for Word
        EZ-Photo, 1120-22
        turning off, 1152-53
Add method, Nodes collection, 273
Address Book, Microsoft Outlook. See also Windows Address Book
    copying or moving to different computer, 773-74
    importing addresses for, 758
    importing from Mac to Outlook 2000, 767-68
    importing Windows Address Book to, 777-78
    missing, 757-58
    moving Windows Address Book entries to, 779
ADE files, creating, 76
administrative rights, requiring to change or reset someone else’s password, 254
administrator privileges
    and HTML Help problem, 512-13
    and Internet Explorer 5.0, 508
    Setup error, 1047-48
ADODB object, 358-59
ADOX Views collection, 178
ADP files, 144, 299-300
AfterUpdate property, 189-90
aliases, creating, 298
alignment
    for controls on data access pages, 186-87
    in database reports, 122-23
Alignment And Sizing toolbar, 186-87
AllowZeroLength property, 131-32
ALLUSERS property, 1053-55
AllViews collection, CurrentData property, 178
ALTER TABLE command, 142
Alt+Print Screen key combination
    automating using VBScript, 898-900
    using to print screen images of forms, 897-98
Altron 380 Bus Mastering Ethernet Card, 532
Always Install With Elevated Privileges system policy
    HTML Help problem, 512-13
    setting, 1048-49
    Setup error, 1047-48
America Online
    compatibility problem with FrontPage, 447
    problem with version that shipped with Windows 98, 1000
Ami Pro for Windows, converting files to and from Word, 1093-97. See also Lotus Word Pro
Analyze It With Microsoft Excel, 350
animation, custom, in PowerPoint, 954-57
antivirus software
    installing and updating, 1173
    problem with save process in Excel, 351
API calls, 16-bit vs. 32-bit, 190-214
append queries, upsizing, 305-6
applications, Microsoft Office. See programs, Microsoft Office
ApplyFilter macro action, 190
Arial Unicode MS font, 1140
Asian languages, 1140
ASP files, 150-52, 433
attachments, e-mail, 1191
auditing, Microsoft Excel, illegal-operation errors, 347-48
auditing arrows, removing, 347-48
AUTOEXEC.BAT file, 1115
AutoLookup queries, 25, 29-31, 251-53
Automation
    closing instances of applications, 216-17
    early vs. late binding, 693
    failure of objects to exit from memory in Excel, 368
    and multiple Excel versions on same computer, 336
    preventing applications from quitting, 218-19
    setting focus for Access forms, 270-71
    using in Access 2000 to send Outlook messages, 219-22
    using in different Excel versions, 359-61
    using to program Microsoft Outlook, 693-97
AutoNumber data type, 305
AutoText
    adding AutoText entries to lists, 1197-1200
    changing AutoText submenu names, 1200-1202
    creating new AutoText submenus, 1200-1202
    list of AutoText submenus, 1196-97
    restoring default AutoText entries after deleting, 1211-12
    using Page X of Y entry, 1208

B
banner ads, previewing in FrontPage, 392
base replica, 80-81, 90
BeforeUpdate event procedure, 21-22
BeforeUpdate property, 189-90
Beta version, Microsoft Office 2000, 1045-46
Bgmail utility, 1115
BIFF files, 331
binary files, storing in Access table fields, 224-30
Binder
    adding icon to Microsoft Office Tools program group, 502-3
    adding templates to, 506
    illegal-operation message upon closing Print Preview, 503
    installing, 497-98
    limits to functionality, 505, 506
    problem opening documents, 497-98
binding, early, vs. late, 693
BIOS, troubleshooting, 529, 532
BitBlt statement, 192
bitmaps
    controlling pixel dimensions, 944-45
    in database reports, 124-26
BKZip utility, 807
black and white
    PowerPoint view, 975-76
    printing in PowerPoint, 971-72
BMP files, 331
bookmarks, Microsoft Word, 32-35
bound controls, and Access macros, 189-90
browse-time FrontPage components
    error messages, 392-93
    and FrontPage Server Extensions, 465
browsing web pages. See also Internet Explorer; Netscape Navigator
    redirecting browser to specific page based on browser type, 493-94
    browsing web pages using file locations vs. HTTP URLs, 392-93
    using Microsoft Outlook to browse Internet, 873
buttons, toolbar, Microsoft Word
    adding to toolbars, 1086-89
    changing image, 1087-88
    copying, 1088
    creating, 1086-89
    moving, 1088

C
cache. See also DbRefreshCache flag, DBEngine.Idle method
    CD-ROM drive, turning off, 527
    flushing, 232
    Outlook Calendar, disabling, 746-47
    Outlook forms cache file, resetting, 615-16, 861-62
    refreshing, 232-35
Calendar, Microsoft Outlook. See Microsoft Outlook, Calendar
Calendar ActiveX control, 414-15
cascading style sheets (CSS)
    creating, 383-87
    external vs. embedded, 383-87
    in Netscape Navigator, 424
CCD8.DLL file, 908
cc:Mail
    installing Import Lotus cc:Mail Archive folders converter, 628-30
    Outlook support feature, 908-9
    problem after adding, 577, 584
    problem after installing Outlook, 601
CD-ROM drive
    cleaning CDs, 528
    installing Office programs to run from CD, 552-53
    turning off cache, 527
    using real-mode drivers, 527-28
cells, worksheet, copying formulas, 323-24
certificates, digital, 484, 491, 563, 818-28
charts, Microsoft Excel
    changing font size, 314
    data labels too large, 314
    misplaced data label problem, 313-14
    titles too large, 314
check boxes, adding to web page forms, 406-7
CHECK constraint, database field, 131-32
CheckMenuItem statement, 192
ChooseColor statement, 192-94
class modules
    calling procedures from Access objects, 222-24
    for objects, 127
Client For Microsoft Networks, 587
Client Network Utility, 298
clipart, problem inserting using Publisher, 548-49
Clipboard. See Office Clipboard
CloseClipboard statement, 193
CloseHelpContainer() API function, 248
closing
    instances of Applications using Automation, 216-17
    Recordset objects, 179-80
code page settings, 299-300
collapsible outlines, creating in FrontPage, 419-20
collections
    programming with, 697-98
    referencing object properties and methods, 173-77
Column property
    queries referencing combo box, 190
    queries referencing list box, 190
columns, database, transposing with rows, 132-36
COM add-ins, 416-17, 602, 603
combo boxes
    and Access record selection, 25-31
    queries referencing Column property, 190
combo boxes, adding to web page forms, 412-13
Combo Box Wizard, 26-27
CommandBar objects, Visual Basic for Applications (VBA), run-time errors, 368-71, 563-66
command buttons, adding to web page forms, 391-92, 404-5
command-line switches
    for Office 2000 Setup
        creating log file using /l switch, 992
        list of switches, 986-90
        modifying log file options using /l switch, 993-95
        problem using /j switch, 991
        setting to automatically reboot, 990-91
        syntax error message, 986
    for starting Excel, 376-77
    for starting Word, 1194-96
CommandText property
    adCmdStoredProc constant, 158-59
    adCmdTable constant, 158-59
CommDlgExtendedError statement, 194
Common Dialog control, using to display Help files, 245
Common Dialog OLE control, 204
compacting Access databases, 47
compacting databases, 73-74
company name, changing name displayed in Office, 510-11
compatibility. See versions, program
compilation errors message, 6-8
compile errors, 230-32
compression utilities, 807
computer viruses. See also macro viruses
    antivirus software, 351, 1173
    and KERNEL32.DLL errors, 529
    Win95.CIH virus, 1007
connection control feature. See passive shutdowns
constraints, unique, and data access pages, 188-89
CONTAB32.DLL file, 757-58
CONTACTS folder, Microsoft Outlook, 763
controls
    adding to Outlook forms, 687-88
    aligning and resizing on data access pages, 186-87
    binding to Outlook fields, 689
    changing values using VBScript, 689-91
    vs. fields, 686-87
    Hyperlink property, 129-30
Control Wizard, 26-27
Copy command, MS-DOS, 243-44
CopyFile() API function, 242-43
CopyFile statement, 197
copying files, programmatically, 242-44
CopyMemory statement, 194, 208
Corporate Or Workgroup option, Microsoft Outlook. See Microsoft Outlook, Corporate Or Workgroup option
CreateCompatibleBitmap statement, 194-95
CreateCompatibleDC statement, 195
CreateEventProc method, 249
CreateItemFromTemplate method, 722-23
CreateItem method, 704, 721, 756-57
CreateObject function, 368
CreateObject method, in different Excel versions, 359-61
CreateProcess() API function vs. Shell() function, 262-64
CREXT32.DLL file, 925
CSV files, 331, 332, 333
CurrentData property, 178
CurrentDb function, 250-51
CurrentUser() function, 210
Custom Installation Wizard
    customizing Office shortcuts on Windows Programs menu, 542-43
    modifications lost when reinstalling Office 2000, 1060-61
Customizable Alerts file, Microsoft Office 2000, 107
Customize dialog box, Microsoft Excel
    list of potential missing commands, 356
    restoring missing commands, 356-58

D
damaged database files, repairing, 45-46
damaged documents, Microsoft Word
    recovering text, 1108, 1131-32
    troubleshooting, 1103-9
damaged files, Microsoft Word, recovering text, 1131-32
DAO360.DLL file, 54-55
DAO Object Library, 267-68, 358-59, 361-62
Data Access Objects (DAO), 178-85
    creating recordsets, 169-70
    failure to release memory, 178-80
    and increased database size, 180-81
    and linked TableDef objects, 182-85
    and MaxLocksPerFile setting, 137-38
    problem with older versions of object model, 181
    referencing Microsoft DAO Object Library, 231-32
    using to convert Access data into new Outlook contacts, 755-57
data access pages, 186-89
    adding Record Navigation controls, 188-89
    aligning controls on, 186-87
    creating hyperlinks on, 186
    importing, 46, 188
    opening, 46
    and primary keys, 188-89
    problem adding, editing, and deleting records, 188-89
    problem saving, 82-84
    resizing controls on, 186-87
    underlying HTML files, 188
    and unique constraints and indexes, 188-89
database objects, creating using CurrentDb function, 250-51
database reports, 122-30
Database Results region, 286-87, 439
Database Results Wizard, 437-38
databases, Microsoft Access. See also Microsoft Jet database engine
    ADO impact on database size, 159-60
    automating their importation, 59-60
    collating error messages, 43-44
    compacting, 47, 73-74, 152, 160, 180
    converting from Access 2000 to Access 97
        changes in security, 10
    converting to Access 2000
        compilation errors message, 6-8
        failure of Name AutoCorrect to work, 69-70
        NWIND.MDB compilation errors, 10-12
        problem with large size, 10
        switchboard form problem, 5
    creating objects using ADO, 159-60
    creating objects using SQL DDL statements, 160, 180-81
    creating user rosters, 91-92
    DAO impact on database size, 180-81
    determining size, 159-60
    earlier version problem, 12
    exclusively opened, 84-85
    importing objects, 60-61
    loading error while converting, 13-14
    locking, 82-84
    management, 43-80
    no object error after converting, 14
    normalizing, 47-50
    opening on NetWare servers, 85
    preventing user logons during maintenance, 92-96
    problem of deteriorating performance, 73-74
    problem opening, 43-44
    problem opening objects, 51
    protecting Visual Basic projects, 75-76
    reducing data redundancy, 47-50
    reducing inconsistent dependencies, 47-50
    reducing size, 47
    repairing file damage, 45-46
    replicated, 80-90, 287-88
    saving as MDE files, 17
    secured, converting from Access 2000 to Access 97, 10
    secured, converting to Access 2000 from earlier Access versions, 15-17, 18
    secured, permissions error when opening, 15-17
    setting references, 265-69
    unrecognized format error messages, 43-44
    and Visual Basic for Applications, 10, 12, 13-14
    ways to share, 85-86, 145
databases, Microsoft Works, importing into Access 2000, 20-21
databases, role of FrontPage, 433-44
databases, third-party, problem with linked tables, 143-44
databases, Visual FoxPro, using data in Access 2000, 19
database security, 298-99
Data Command Control, 417-18
Data-Definition Language (DDL)
    mixing with ADO transaction methods, 170-71
    using to create database objects, 160, 180-81
data labels, Excel charts
    deleting extras, 313-14
    misplaced, 313-14
data redundancy, reducing, 47-50
data sources, Microsoft Word mail merge
    data records message, 1185-87
    link to main document lost upon closing Word, 1187-89
    problem attaching, 1184-85
    problem with query options, 1185-87
DateDiff() function, 282-83
Date Fix Wizard, 315, 321-22
DATE() function, 322-23
Date Migration Wizard, 314-15, 317, 318-20
Date Range Footer Control, 417-18
Date Range Header Control, 417-18
dates
    differences in Excel versions, 315-18, 322-23
    displaying four-digit years in Access databases, 57-58
    ensuring Y2K compliance, 314-22
    interpreting century in databases, 50-51
    migration add-in tools, 314-22
    in workbooks saved in PRN format, 338-39
Date Watch Wizard, 315, 317, 318
dBASE files, 330
DBEngine.Idle method, 232-35
DBEngine.Workspaces collection, 232-35
DBF files, 330, 333
DbRefreshCache flag, DBEngine.Idle method, 232-35
default printer
    changing, 116
    correcting WIN.INI file information, 522-23
    installing, 521-22
    problem with ActivePrinter property, 1139
    resetting after using different device, 1154-55
    resetting Registry designation, 98
defragmenting hard disks, 73, 1116-17
delegate accounts, 682-83
DeleteDC statement, 195
DeleteLines method, 249
delete queries, running in replicated Access databases, 287-88
deleting files, 545-46
Design-Time Controls (DTC)
    installing, 417-18
Design view modules, Microsoft Access
    problem opening, 82-84
    problem saving, 82-84
developers, Microsoft Office Developer Support, 557-62
Dial-Up Networking
    configuring for Outlook Internet E-Mail Service, 786-88
    downloading upgrade, 786
    and IBM Global Network connections, 580-81
DIF files, 331, 333
digital certificates, 484, 491, 563, 818-28
Direct Mail Manager (DMM)
    defined, 1189
    installing, 1189-90
    uses for, 1189
directory services
    adding to Microsoft Outlook installations, 582-83
    response slow or nonexistent, 581-82
Disable Macros option, 362, 566-67
discussions, web
    in Excel, 378
    in PowerPoint, 951
Disk Defragmenter, 1117
distribution lists, Microsoft Outlook
    creating from Contact List, 762-63
    deleting and re-creating contacts, 794
    loss of member information, 762
DLookup() function, 235-41
    overview, 235-36
    sample expressions, 236-40
    troubleshooting expressions, 240-41
DMM. See Direct Mail Manager (DMM)
DocProperty Characters field, Microsoft Word, 1203
documents, damaged, and Find Fast Indexer, 500-501
documents, Microsoft Word
    changing default properties, 1109-12
    changing template to global, 1104
    comparing versions, 1113
    converting from Word 2000 to earlier version, 1100-1103
    converting fron Lotus Word Pro, 1124-25
    converting to and from Ami Pro, 1093-97
    converting to Lotus Word Pro, 1138-39
    damaged, recovering, 1103-9, 1131-32
    embedding fonts in, 1147-48
    formatting
        features lost when saving in HTML format, 1181-84
        features lost when Word 2000 documents are converted to earlier version, 1101-3
    frames message, 1123-24
    invisible, 1090
    MAPI error message when sending as e-mail attachments from Word, 1193-94
    merged documents message, 1113
    merging Access records into, for printing, 32-35
    multiple, open, Windows NT End Task closes all documents, 1112
    as objects, 1177-78
    opening in earlier versions of Word, 1129-31
    opening Word 2000 documents in Word 97, 1203-4
    problem inserting hyperlinks, 1180-81
    problem inserting objects into e-mail messages, 1192-93
    problem opening, 1106-7, 1114
    problem saving, 1114-17
    problem when saving over networks, 1125-27
    recovering after macro virus infection, 1164
    saving Word 2000 files in Word 97-2000 & 6.0/95 - RTF format, 504
    sending as e-mail attachments, 1191
    updating fields, 1115
Domain Name System (DNS), 487-88
drag-and-drop, using with TreeView control, 273-81
DrawMenuBar statement, 195
drivers
    CD-ROM, real-mode, 527-28
    installing Windows 98 modem driver, 788-90
    ISAM, 61-62, 142-43
Dynamic HTML (DHTML), 394-95

E
East Asian languages, need for, 1140
Edit Conversion Options macro, 1169, 1171
Electronic Forms Designer, 613-14, 863
e-mail transport services, 573-74
embedding fonts in Word documents, 1147-48
EMF files, 331
EmptyClipboard statement, 195-96
Enable Macros option, 362, 566-67
EnableMenuItem statement, 196
encryption
    and FrontPage, 485, 491
    a