Building a Searchable Document Index in Microsoft Access (Word Docs, PDF Files, Text Files, etc.)
ฝัง
- เผยแพร่เมื่อ 24 ก.ค. 2022
- 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?
Silver Members and up get access to an Extended Cut of this video. Members 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.
MEMBERS VIDEO:
• Document Index EXTENDE...
BECOME A MEMBER:
TH-cam: / @599cd
or My Site: 599cd.com/THMember
LEARN MORE:
Document Index: 599cd.com/DocumentIndex
LINKS:
Blank Template: 599cd.com/Blank
Images: 599cd.com/Image
Query Criteria: 599cd.com/Criteria
Concatenation: 599cd.com/Concat
Wildcard Search and LIKE: 599cd.com/Like
Parameter Query: 599cd.com/Parameter
Value From a Form: 599cd.com/FormName
Intro to VBA: 599cd.com/IntroVBA
Relationships: 599cd.com/Relationships
Invoicing: 599cd.com/Invoicing
RECOMMENDED COURSE:
Access Developer 39: 599cd.com/ACD39
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, 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
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Excellent video!!!
Thank you very much!
It's very useful thank u
Welcome 😊
I have a question: can I search by file name instead of doc, txt or pdf extension file?
Thank you
Sure... you can search by whatever you save in the table.
So I just wrote my code AS explained in the video and then when I checked the button I get an error message. So let me get this straight, on my home screen, I have an access icon for my database and a seperate folder for the documents. Does that sound correct? Or do both of those need to be in a different folder? Just not sure where I'm getting an error
599cd.com/Ask
Hello! I'm writing from Turkey. this is perfect. this is what i need. an alarm program. but the alarm should work when an action occurs on my computer's internet explorer page. can i do this? When I am not at my computer, when an action occurs on the internet explorer page that is always open on my computer screen, I need to be warned audibly.
You could program the WebBrowser control to look for specific keywords and refresh the page every X minutes. I cover something similar in 599cd.com/ACX24
Hi Mr Richard, I am a lecturer and every semester I must prepare a set of test questions, assignments and final exams (with pictures). so I want to save my questions and make it a database in access. Is it possible and how to include these pictures in access?
599cd.com/Images
how would you make a button the same way however documents are separated into folders within the project folder?
You'll have to store the full path
Hello. Thank you for the video. I followed the instruction but i get run-time error 490. My pdfs are in G:\Lib\Ebooks.
I get a ton of questions every day, and I don't have time to answer them all here on TH-cam. Feel free to submit your question on my website at: 599cd.com/AskYT
Did you find a fix?
richard i got runtime error 490
never mind the documents folder must be in the dabase folder
Yep
@@599CD and if the folder is in a network location how is better do this ? thanks richard