[AccessD] Show of hands

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Wed Jan 16 11:09:02 CST 2008


Yeah A97 -  I just changed one like that it generates:

    Case Else   '.All other errors will trap
        Beep
        DoCmd.OpenForm "frmErrorMessage ", , , , , , "Error: " & Err.Number
& " - " & Err.Description & vbCrLf & "In: rsubBuyReport.Detail_Format"
        Resume Exit_Detail_Format
    End Select

the DoCmd.OpenForm.  frmErrorMessage shows the message and give the user
some instructions.  There's a button in frmErrorMessage that says email and
if they click it it send the error message to me.  

So, minimal mods.

Rocky



 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Wednesday, January 16, 2008 8:45 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Show of hands

Hmmm... how did you modify it?  Is this the widget I created in A97? 


John W. Colby
Colby Consulting
www.ColbyConsulting.com
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Wednesday, January 16, 2008 11:32 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Show of hands

I'm using it.  I modified it to pop up a form with the error message which
the user can then email to me.

Rocky
 




 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Wednesday, January 16, 2008 7:50 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Show of hands

Would everyone who uses my error handler insertion wizard please respond so
that I can get a feel for whether anyone but me uses it?

That is the vbErrorHandler that can be found on DatabaseAdvisors web site.

Thanks.

John W. Colby
Colby Consulting
www.ColbyConsulting.com 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.516 / Virus Database: 269.19.4/1226 - Release Date: 1/15/2008
6:19 PM
 

--
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

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.516 / Virus Database: 269.19.4/1226 - Release Date: 1/15/2008
6:19 PM
 




More information about the AccessD mailing list