VBA error handling tutorial

[Zydeceltico]

Hi all,

I'm not up to snuff with error handling and am wondering if anyone could point me to some tutorials.

I've googled and there are a lot of tuts for Excel VBA error handling and not very much for Access.

I did find Allen Brown's page but am hoping for something that would go in to a little more depth explaining each typical line of code.

I mean, I know what error handling is for but I'm not experienced enough to understand and apply preventive error-handling. I'm sure a lot comes from experience and having some inkling of how a particular block of code might break but I'd very much like to get some more guidance if possible.

Your thoughts are appreciated.

Thanks,

Tim

 

[jdraw]

Tim, Have you tried the links in my signature?

 

[Zydeceltico]

Tim, Have you tried the links in my signature?

Hey jdraw! Glad you responded. No - headed there now. Thanks!

 

[jdraw]

Good luck.

 

[Zydeceltico]

Tim, Have you tried the links in my signature?

That's exactly what I'm looking for. Thx!

 

[MajP]

I've googled and there are a lot of tuts for Excel VBA error handling and not very much for Access.

There should not be any difference. You are not writing in Access or Excel, you are writing code in VBA. Those links provided are generic to VBA, but would not matter if error handling in Access, Excel, Word, Outlook, PowerPoint etc. My error trapping is identical in all of those applications.

 

[Zydeceltico]

There should not be any difference. You are not writing in Access or Excel, you are writing code in VBA. Those links provided are generic to VBA, but would not matter if error handling in Access, Excel, Word, Outlook, PowerPoint etc. My error trapping is identical in all of those applications.

Thank you for the clarification. Got it. Thx!

 

[Uncle Gizmo]

I did some Error Handling video's in 2007 here:-

Error Handling – MS Access - Nifty Access

Error Handling in MS Access My Journey with Camtasia These are some of the first videos I did using a program called Camtasia. I made them in 2007, and I am keeping them for nostalgia. ???? Really, I need to update these and add some more videos because this is a very interesting subject ????

www.niftyaccess.com

They are some of my first attempts at doing videos!

Also if you search my website on the search term "Error" you will be served some links that maybe of interest....