?
Solved

Access Errhandler

Posted on 2002-04-29
8
Medium Priority
?
416 Views
Last Modified: 2008-02-01
Hey i want to know more about the Access Errhandler (included with the Office XP Developers' edition)

For example, when I run the errhandler, i get this:

________________________________________________-
Private Sub Command521_Click()

On Error GoTo ErrHandler
Call EnterProc("Form_projects.Command521_Click")

    OpenAccessReport "rptPhoneList"

Cleanexit:
  Exit Sub


ErrHandler:
Call ErrHandler(Err.Number, Err.Description, Form_projects.Command521_Click)
If boolResume = True Then Resume
If boolResumeNext = True Then Resume Next
GoTo Cleanexit

End Sub

_______________________________________

All I _really_ want to do is to get this line:

Call ErrHandler(Err.Number, Err.Description, Form_projects.Command521_Click)

To read like this:

Call ErrHandler(Err.Number, Err.Description, "Form_projects.Command521_Click")

Ive tried the "" $$CURRENTPROCEDURENAME ""

I haven't had enough time to try the

"" & $$CURRENTPROCEDURENAME & ""

_________________________

has anyone else seen this problem??

0
Comment
Question by:aaronkempf
  • 4
  • 3
8 Comments
 
LVL 2

Expert Comment

by:Syed Irtaza Ali
ID: 6979547
ill try to check this one out. I think i might find a generic one.
0
 
LVL 7

Expert Comment

by:Nosterdamus
ID: 6979675
Hi aaronkempf,

I assume that EnterProc is a global function/sub.

In the module where you defined EnterProc, define a Global parameter (ProcName?) like in the following example:

'Begining of the Module
Option explicite....

Public ProcName As String

Public Sub ProcEnter(ProcedureName as String)
    ProcName = ProcedureName
    .
    .
    ' Put here what ever else you need/want to do
    .
    .
End Sub

and now you can execute:
Call ErrHandler(Err.Number,Err.Description,ProcName)

HTH,

Nosterdamus
0
 
LVL 1

Author Comment

by:aaronkempf
ID: 6979682
the issue here is that i am using the auto-errhandler component that comes with Microsoft Office Developer..

and the very end of this-  I am trying to pass this phrase '$$CURRENTPROCEDURENAME ' and i need to include CHR(34) before and after the phrase $$CURRENTPROCEDURENAME

and i cant get either the CHR(34) or the "" to work correctly..

aaron
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
LVL 7

Expert Comment

by:Nosterdamus
ID: 6980179
Try:

"""" & $$CURRENTPROCEDURENAME & """"

HTH,

Nosterdamus
0
 
LVL 7

Accepted Solution

by:
Nosterdamus earned 400 total points
ID: 6980181
It's four (4) double-quote (") characters from each side!
0
 
LVL 1

Author Comment

by:aaronkempf
ID: 6980828
thanks man ill give that a shot...

0
 
LVL 1

Author Comment

by:aaronkempf
ID: 6999549
i didnt think that worked..

ill try again (different project now)
0
 
LVL 7

Expert Comment

by:Nosterdamus
ID: 7026394
Hi aaronkempf,

Glad I could help

;-)

Nosterdamus
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Usually, rounding is performed by some power of 10 - to thousands, hundreds, tens, or integer - or to one, two, or more decimals. But rounding can also be done to a power of two, say, 16 or 64, or 1/32 or 1/1024, even for extreme values.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

590 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question