Command button to open external application

[stc]

Hi,

My database contains various information about leaflets, with each leaflet a seperate record, with a unique ID number. I want to have a button on the form which will open up Adobe Reader and display the PDF relevant to the record. Each individual PDF is saved as the ID number from the database (so, ID001 is saved as ID001.pdf and so on). Is there a way to do this?

Thanks for any advice.

 

[oharab]

Have a look here:

http://www.mvps.org/access/api/api0018.htm

Here is a function that will open a file in it's associated application, so you could use it like:

fHandleFile(me!txtIDField & ".pdf&quot

and the file will be opened up in Acrobat automatically.

HTH

Ben