Custom Error-Handling (Run-Time Error '490')

[gnarpeggio]

Hello,

I have a command button that opens PDF files stored in multiple folders, but I'm trying to create a customized error-handling message to replace the "Run-Time Error '490'" error that is displayed when the database cannot find the specified file.

Since I'm pretty sure that this procedure needs to be coded with the OnClick event, I'd like to create a vbOKonly message that tells users the PDF file does not exist because the criteria on the FollowHyperlink string is not met.

I have a small grasp of error-handling, but I can't seem to complete the full procedure and resume normal functions (due to the VBA syntax errors I keep stumbling on).

Any help on this is appreciated!

 

[pbaldy]

Here are the basics of error handling:

http://www.baldyweb.com/ErrorTrap.htm

Sounds like you'd want to add a Case to handle 490.

 

[gnarpeggio]

This is a great example of Error-Handling. Thank you!

 

[pbaldy]

Thanks! Hope it helped.