Re: Can lines collection be used to assist me in automatically numbering lines?


MLH wrote:

I'll seek psychiatric help, if that's what you think I need. 

Why do you bother typing things that don't answer the question?

I think you would be more successful if you:
1. tried to keep your code as simple as possible;
2. asked clear questions about your problems in simple terms (as opposed to pursuing something you posted three years ago which may or may not be correct);
3. used the help file.

You should use 1,2,3 as your signature on all your posts/replys.
Or, do you think 1,2,3 do not apply to everyone - just to me?
What I think is that you like to rave on and to put your name
in print. Why else would you waste your time commenting on
my posts. 

MLH,

You would do well to listen to Lyle's advice. You seem to be suffering from the newsgroup equivelent of Tourette Syndrome (http://www.tourettes-disorder.com/home.html). You get a question in your mind and you immediately post it. If you were to pause and do a small amount of research in the help file and/or Google Groups you would answer 90% of your questions in less time than it took to post the question and wait for an answer. I don't say this to be mean and nasty, I say this so that you will only post the questions that you can't answer with the easy research. That will get you more meaningful responses and will not get you ignored as background noise.

As for debugging without line numbers; I add a line with just the Resume command on it below the Resume ExitLable line (where it will never execute during regular processing). Then when I get an error, I break into Debug mode and the code window opens with the highlighted line being the Resume ExitLable line. I then click on the Resume line below and hit CTRL-F9 which moves the highlight to that line. Then F8 will execute the Resume which will move you to the line that caused the error.

--
Bri


.

Relevant Pages

  • Re: Duplicate Data
    ... The VBA editor will pop up and you will see a line highlighted ... That is the line that will execute next. ... >> line will execute and the next line will highlight. ... >> Private Sub Form_BeforeUpdate ...
    (microsoft.public.access.forms)
  • Re: SQL 2005 Query Execution for selected text using Right Click
    ... It does not deselect if you right click on the empty window in Query Analyzer as you mentioned. ... execute and then right click in the the Query Editor to Execute the ... it would save the highlight and execute only the text which is highlighted. ...
    (microsoft.public.sqlserver.setup)
  • Re: Duplicate Data
    ... The VBA editor will pop up and you will see a line highlighted ... That is the line that will execute next. ... > line will execute and the next line will highlight. ... > Private Sub Form_BeforeUpdate ...
    (microsoft.public.access.forms)
  • Re: Duplicate Data
    ... That is the line that will execute next. ... line will execute and the next line will highlight. ... Private Sub Form_BeforeUpdate ... >> Have you run it in debug mode and stepped through it to see what it is doing? ...
    (microsoft.public.access.forms)