S D
accessd667 at yahoo.com
Wed Mar 24 00:33:26 CST 2004
grmbl. A pitty. I think I'm going to try using you're error handler and some copy/paste/replace stuff...or copy it into a textfile and write a litte prog to do the replacing. Thanks anyway. Sander PS: A couple of weeks back I saw my first MS-Access 2.0 app from 1995 or so....oi, PS1 was not completely applicable but....although normalization was correct and it still works like a charm :-) "John W. Colby" <jwcolby at colbyconsulting.com> wrote: 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" 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 -- _______________________________________________ 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.