Link to home
Create AccountLog in
Avatar of developingprogrammer
developingprogrammer

asked on

Error Handling Best Practices

dear all,

previously Christian and i had a very long discussion on error handling where he taught me many many things = ) he's put in a lot of effort to type some really long posts with fantastic points in there so here is the link, do feel free to check it out if you're a newbie like me to error handling architecture and the best practices  = ))

Guidance on Error Handling by Christian

Christian, i re-read your last post and realised that i can implement these 3 things in my coding methodology:
1) Collecting multiple errors before showing them all to the user for batch correction

2) Maintaining a error log file - i think this is the basic thing any self-respecting programmer MUST do haha (it's funny cause i didn't do it!! i didn't even know about it!! hahaha = PP  ), and i WILL implement it in about 5 minutes time in my database haha = )

3) Custom forms for user input. right now i'm using a modified version of the inputbox. but there are so many fallibilities in the original inputbox that even my "self made in the garage" inputbox can't do too much about it too ha. but i can't say inputbox is bad actually, it was programmed to achieve a certain task and it does it very well = )

here's my database! (if you'd like to have a look, but you don't need to - i know your time i very precious and am thankful for all the coaching you've given me all this while!! = ))    )
DMS-Cerebro---SSB-Recon.mdb
SOLUTION
Avatar of Bitsqueezer
Bitsqueezer
Flag of Germany image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of developingprogrammer
developingprogrammer

ASKER

You're absolutely right about the input box and I need to present a custom form. As a very novice programmer I am struggling with time a lot to either add functionality or improve on existing functionality. And I've got an inhuman timeline haha, because nobody in my organisation believes in IT!! So I have to prove them wrong!! Whilst flying up the learning curve!! Haha, thankfully I have you guys!! = ))

Yup the database is different, the latest, I did see your question and was going to go through it just awhile ago but needed a mind clearing break haha = ) will respond to it soon in half an hour! = )
Hi,

that's why I program such tools as in the attachment above: You can simply insert it into your project and use it like you want so you don't need to invent the wheel again.

Cheers,

Christian
SOLUTION
Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Whao great!! I'll read it right after I finish supper!! = ))
Haha yup yup I got that = ) sorry I replied too fast you couldn't change your comment!! Haha = P
ASKER CERTIFIED SOLUTION
Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
And I was about to post Luke's links, but he beat me to it :-)

mx
mx,

Glad you like them!
guys, thanks for all your help!

ha luke, before i just read your post i went to read through every single article in your Access Developer's webpage and also bought Total Access Ultimate Suite with the 1 year support. it's superbly expensive for me but i have to make the best out of it = )

DatabaseMX thanks for your help and directing me to the right place again!! much appreciated!! = ))

Christian, do you think you could take a look at my question : "the ultimate Access architecture"? it's the brain child of my understanding through your comments' readings = )
developingprogrammer,

Glad you found our articles useful (always nice to know people actually read them!). Thanks also for becoming a customer. I trust your investment will let you be far more productive.

The error handling issue is huge. Once you come up with your standard error handling structure, you can use the Total Visual CodeTools product you purchased to apply it to all your procedures. That should give you an immediate improvement to any application you're supporting. With the line numbering feature, you'll be able to trap for specific errors in a global error handler. By documenting those errors and fixing them one by one, you can continually improve the quality of your solution.

Let me know if there's anything else we can do to help.

Luke