gnarpeggio
Registered User.
- Local time
- Today, 15:41
- Joined
- Jun 22, 2010
- Messages
- 74
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!
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!