01. Document Index 1 (33:06)
Searchable Document Index
Create Document Index Table
FollowHyperlink to Open Files
Copy/Paste Document Text to Index Table
Search Text Box
Assign Documents to Customers
Open a Customer's Documents

02. Document Index 2 (25:11)
Browse and Pick a File
Automatically Load Document
Microsoft Word Automation
Convert PDF to Text
Convert DOCX to Text
VBA to Copy Text to Database

03. Document Index 3 (26:13)
Reasons to Index Keywords
Limitations of Long Text Fields
Save Documents as Text Files
Overcome 64k Limitation
Read in Text Files with File I/O
WordDoc.SaveAs2
wdFormatText
Bypass Word for Text Files

04. Document Index 4 (24:36)
Build Index Tables
IndexT: IndexID, Keyword
DocIndexT: DocIndexID, DocID, IndexID
Composite Key
AddToIndex Subroutine

05. Document Index 5 (23:00)
DocIndexQ, DocIndexF Subform
Exception Table
Different Query for Searching
Change RecordSource for All Records

06. Document Index 6 (33:32)
Display Percent Completed
Abort Checkbox
Adding Word Count to Index
Finding Records in a Recordset
rs.FindFirst
rs.NoMatch
dbOpenDynaset
Optimize AddToIndex for Speed