|
||||||
Document Index By Richard Rost ![]() ![]() Build a Searchable Document Index in Access In this Microsoft Access tutorial, I'm going to teach you how to build a document index in Microsoft Access. We will store the names of our files in a table, along with a link to each file. We will then copy the text of that file to Access so that we can search the full contents of each document from inside our database. I'll also show you how to make a button to open each file using the FollowHyperlink command. Then, I'll show you how to make a simple form to search for keywords in the text of each document. Catherine from Provo, Utah (a Platinum Member) asks: I have to keep track of hundreds of different documents for each client. Is there a simple way I could put these all in a database and possibly search within the text of each document using Access? MembersMembers will learn how to use Microsoft Word Automation to automatically open each document and copy the text directly into the database. We will also see how to browse and pick a file with the FilePicker function.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today! Recommended Course
Links
|
Age | Subject | From | |
12 months | Index Outlook Email | Shelton Burch | |
13 months | Automate with Excel | Gary Marks | |
14 months | Document Index video | Thomas Martin | |
14 months | Load Text | Sandra Truax | |
| |||
Keywords: TechHelp Access Searchable Document Index, FollowHyperlink, Search Text Box, Assign Documents to Customers, Browse and Pick a File, Microsoft Word Automation, Convert PDF to Text, Convert DOCX to Text, VBA to Copy Text to Database PermaLink Searchable Document Index in Microsoft Access |