473,326 Members | 2,732 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Hyperlinking to external word and excel files from within access

hey all,
I would very much appreciate any help or ideas on how to do this as I am stumped.
I need to develop an access database to track documents but also link to them.
I’ll explain what it needs to do;

Every day there is a numbered (and titled) Word format document that is sent.
Most, but not all of the time an accompanying excel file is also sent. The excel file is used for updates to the word document of the same name.
Lets say the word document is titled DW101.1.doc and the Excel file is called DE101.1.xls
The first would signify it is a Word document by D (being short for Document) and W for Word.
The 2nd would be D for document and E for Excel, and then a number which is 101.1.

They are saved in a folder on the hard drive.
Each time these documents are recd then the Access Database is opened and info about those documents is entered. The document name, date, subject, number etc.
There will also be 3-4 fields that are also filled out with terms from the content of the document that could be searched by those 3-4 fields.
So as each document is recd, it’s opened and ‘scanned’ for relevant terms and or content.
That content is what will be filled in the search fields and then the subject will be the ‘main’ searchable item.

All this so far I can do with no problem.
It’s this part that’s making me crazy.
What I would really like to do is when the document(s) come in and are saved in the folder, from access you can open a dialog box, browse to that folder, and click in the file to associate it with the entry you are making for it in the database.
That way when a search is done with terms or words or subjects that match that document it will bring up the results of the search as a hyperlink that will open that document.

The people that will be using this are not very computer literate to say the least.
I could create a link to the document but I would have to be in design mode and it won’t show up as a record in a table.
Any ideas would be very much appreciated……………..

reb0101
Oct 29 '06 #1
2 2449
NeoPa
32,556 Expert Mod 16PB
You can insert links to documents in an OLE field but to search through a document would be more complicated and would involve writing code to process the Word & Excel documents from within your Form or whatever.

Check out this other thread - particularly with regards to the 'blobs'.
http://www.thescripts.com/forum/thread554620.html
Oct 29 '06 #2
pks00
280 Expert 100+
Regarding this table that has scanned "relevant terms"

Im assuming there is a link to the documents table and with this u can get to the document
e.g.
tblDocument
DocumentID
DocumentName
etc

tblTerms
TermID
DocumentID (link to tblDocument)
Term


ok, so u have a form based on this (can be continuous or subform)
Im assuming here the files are held on a directory somewhere and its just the docname u store in the db.

SELECT DocumentID, DocumentName, Term
FROM tblDocument, tblTerms
WHERE tblDocument.DocumentID = tblTerms.DocumentID

You have a textbox (txtSearch) and a search button (cmdSearch)
on the click event, u can display the results

private sub cmdSearch_Click()

Me.Filter = "Term Like '*" & Me.txtSearch & "*'"
Me.FilterOn = True

end sub


Now the results displayed, ensure the DocumentName has a click event, one which opens the document using FollowHyperlink
e.g.

private sub DocumentName_Click()
Dim sParent as String 'Here I am defining it locally, ideally u want it held in a table as a config value or constant

sParent = "C:\mydocs\"
if dir$(sParent & me.DocumentName) = "" Then
msgbox "Cannot find document " & Me.DocumentName
else
FollowHyperlink sParent & Me.DocumentName
end if
end sub
Oct 30 '06 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

41
by: Ruby Tuesday | last post by:
Hi, I was wondering if expert can give me some lite to convert my word table into access database. Note: within each cell of my word table(s), some has multi-line data in it. In addition, there...
1
by: Aged | last post by:
Hi I have asked several groups now for advise but I feel I must be confusing either them or myself, but anyway here goes! Below is code taken from the "OnClick" function of a command button...
0
by: Jack | last post by:
Windows 2K Pro Access/Excel 2003 Hi there, I have a large number of password protected Excel Workbooks. The files are protected by code that runs when the workbook opens. The code asks the...
5
by: Daniel Walzenbach | last post by:
Hi, I need to know how I could populate a word file from within ASP.NET and stream it out to some user (I can rely on all users have at least Word XP installed). The preferable solution would be...
3
by: herman404 | last post by:
Hi everyone, I have data coming to me in the form of Word and Excel files, and I need to place this data into a SQL Server database. The Word file will be coming in text which is similiar to an...
2
by: anguraj | last post by:
Hi My requirement is this...... I need to have a hypherlink option from the test box to be more clear. i need the have hypherlink option which we normally have in word/excel document........
12
by: Steve | last post by:
I've been building an application that will merge fields in a text file with a word template, save the resulting word file out to the user's hard drive, and then email the file as an attachment. ...
6
by: rlntemp-gng | last post by:
I need to extract information from some Excel files but am stuck with part of it: As an example, I have the following Excel File that has 3 tabbed sheets: FileName: ...
3
by: Papo76522 | last post by:
Hi, I'm creating a Configuration Management database, and my idea is to have data entered in a continuous form like I currently have in Excel. The issue is that in Excel, I can hyperlink the title...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.