Rocky Smolin
rockysmolin at bchacc.com
Sun May 12 20:25:02 CDT 2013
Oh maaan. I already customized Colby's to put up a message which can be emailed and some other stuff. MZTools = work. But it'll be my fall back if I can't get this to run. Again, oddly, in another app where I used it, it compiles just fine. I AM missing something but don't know what. R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy Sent: May 12, 2013 11:16 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Error Traps - Question for Colby Rocky, Try the one in MZTools. Works great out of the box and you can customize the template if you want. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Sunday, May 12, 2013 9:03 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Error Traps - Question for Colby P.S. If I comment out all the lines in the Select Case the app compiles OK. R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: May 12, 2013 8:36 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Error Traps - Question for Colby JC: I'm using your error module builder to put error traps into an app for a client. I haven't used it for years but it always worked in the past. Now I'm getting a compile error in this new app Compile error variable not defined. and vbext_pk_Getis highlighted in 'GET THE STRING THAT REPRESENTS THE PROCEDURE TYPE Select Case .lngProcKind Case vbext_pk_Get .strProcKind = "Get" Case vbext_pk_Let .strProcKind = "Let" Case vbext_pk_Set .strProcKind = "Set" Case vbext_pk_Proc If InStr(.strProcDecl, "Sub") = 0 Then .strProcKind = "Function" Else .strProcKind = "Sub" End If Case Else End Select But I can't find any other reference to vbext_pk_Get even in an old app where the code works and compiles correctly. Do yo know what might be the problem? Thanks and regards, Rocky Smolin Beach Access Software 858-259-4334 www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com <http://www.e-z-mrp.com/> Skype: rocky.smolin -- 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com