I am operating a database which tracks maintenance and inspection history for electrical equipment and instruments at a chemical plant. The database includes references to manufacturer's data sheets and test certificates carried out by external agencies. This information is readily available in *.pdf format in other directories on the same server as the database.
It would be useful if these pdf files could be opened, viewed and printed from within Access by for example inserting the file name into a vba dialog box or by clicking a command button on the user switchboard screen.
I've been unable to find anything in the Microsoft help screens or in any of Access text books which I have.
Does anyone know if this is possible and, if it is, where to find some code which will at least get me started.
It would be useful if these pdf files could be opened, viewed and printed from within Access by for example inserting the file name into a vba dialog box or by clicking a command button on the user switchboard screen.
I've been unable to find anything in the Microsoft help screens or in any of Access text books which I have.
Does anyone know if this is possible and, if it is, where to find some code which will at least get me started.
