OK, that makes sense. I can see that now.
And thank you to wrmosca for the MZTools tip. I am finding them very useful!
---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :
David-
After looking at the code again, I remembered that I do that because I'm about to call some code that sets its own error trap. Doing that will reset Err and Error, so I stuff the original error values in variables.
By the way, I'm not the one who recommended MZTools to you - but it was a good suggestion from another poster.
John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
(Paris, France)
On Apr 9, 2017, at 11:01 PM, david.pratt@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
John, in your error handling you create variables lngErr and strErr and then assign them the values of Err and Error. You then call the ErrorLog function and pass it the parameters Me.Name, lngErr and strErr.
I am sure there is a reason for doing this substitution, but I cannot figure it out.
Why not just call ErrorLog and pass it the parameters Me.name, Err, Error?
I am using the MZTools error handler tool and it is great! So thank you again. I don't want to insert a lot of these until I understand whether I need the variables and substitutions.
__._,_.___
Posted by: david.pratt@outlook.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (10) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar