Links to Documents

[demax182]

It's been awhile since I've visited this board since lately I've been running pretty smooth with my database thanks to this forum. I've come up with new problems however, somebody in my office asked if there's a way I can link a document to my form.

Here's what I want to do,
1) Have a command button that will open up the document/file in a separate window.

2) Some how create a combo box that the user can use to specify which document the command button should open.

I know this is probably really hard to do, but any help would be greatly appreciated. As always, thanks in advance.

 

[KenReay]

Hi

You could use a hyperlink to do this quite easily, say a simple three column table

Id
DocumentName
DocumentPath (as a hyperlink)

The document name gives you a human readable name

You can have variations on the idea

If the documents are all in onefolder you could use Dir() to make a list of Paths, but unless the document names are really meaningful, this may be a bit non user friendly

If the documents have a common format and are in word, you could even scan through the folder opening each document and reading the title for display purposes

Personally I think the first method is the most simple, as you may have deduced by now the work is in populationg the list of documents

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK