John W. Colby
jwcolby at colbyconsulting.com
Tue Mar 23 08:50:23 CST 2004
LOL to the whole message!!! In particular the PS1: I feel for you, but with any luck it will generate prodigious revenue as you clean it up. The error handler wizard is in VB and is under the care of Seth Galitzer. This sounds like a very custom mod which you would probably have to make. John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of S D Sent: Tuesday, March 23, 2004 9:34 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] VBE Error Handler We use a VB function to create a standard message. We use this in all (500+) applications. I don't won't to break the line of work. Problem is we enherited a HUGE Access app (250+ tables, 300+ forms, 7(!?!) modules) So we've got the following line in all our error handling: Call GenErr("Switchdatabase.Form_Startscherm", "Form_Load") TIA Sander PS1: according to the programmer of this beast: - 'normalization'? What's that, a snack? - a function is never used more then once - dim a, b, c as string creates 3 strings.... - dim blnError as String blnError = "0" blnError = "1" blnError = "incorrect" aaahhhhrg..... "John W. Colby" <jwcolby at colbyconsulting.com> wrote: In short, it is not "programmable". The message the user gets is the native Access error plus the function / module name. What did you have in mind? John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of S D Sent: Tuesday, March 23, 2004 8:20 AM To: accessd Subject: [AccessD] VBE Error Handler Hi group, i downloaded the VBE Error Handler dll from www.databaseadvisors written by John Colby. I really love this program....almost. It works great however I want to change the message that the user gets. Is that possible? Thnx in advance. Regards Sander Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com