record linking to a document

[kfenner]

Is there a way to put a button on a form (or something that operates like one) which will open up the document which a particular record describes?

Example:

Record describes a letter which exists on your system - you want to click on something to automatically open this document for you, without having to close your database and go find it yourself.

Any help would be appreciated! Thanks!

 

[footpad]

kfenner,

Sure, though it depends on how you've recorded the location of the letter in your database. Assuming you've saved the letter's filename in your table, here's one way to open the letter (using it's registered application) from a pushButton() event:

execute( "start " + LetterFilename.Value )

For best results, be sure to save the full path to the letter in your table.

Hope this helps...

-- Lance