Line numbers

I have a huge amount of code here and I want to know how I can easily add line numbers and trap to line number(s) specifically for errors like “syntax error in FROM clause”?
LVL 1
MarkWAsked:
Who is Participating?
 
corvanderlindenConnect With a Mentor Commented:
To show the line the error occured on use the undocumented Erl variable
0
 
VbmasterCommented:
Since VB code are simple text files it's really easy to add line numbers, and therefore there are loads of sharewares that does that. You'll find a couple on altavista if you search for it, for example

http://bulletsoftsolutions.com/autoerrhandler/
http://www.supershareware.com/Apps/1559.asp
0
 
MarkWAuthor Commented:
Still looking for code the question was "how"...although an add-in I guess is a how its not the one I was looking for.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
cvidlerCommented:
Check out CodeSMART

http://www.aivosto.com/codesmart.html

it will automatically help you insert/remove line numbers and error handlers.
0
 
MarkWAuthor Commented:
This is the same answer that VBMaster gave!
0
 
corvanderlindenCommented:
To show the line the error occured on use the undocumented Erl variable
0
 
MarkWAuthor Commented:
Wow...truly must be undocumented i never herd of it.
0
 
MarkWAuthor Commented:
Yes i can use this ...back to the vb3 days...good job! thanks
0
All Courses

From novice to tech pro — start learning today.