VBA, Current Line Number in an Access Module

Current Line Number in an Access Module

Author	Message
Terry Thompso #1 / 3	Current Line Number in an Access Module How do you determine the current line number (where the cursor is located) in an Access Module? I have a procedure that inserts a standard documentation header for a sub or function, but don't know how to have it insert at the current cursor position. VBA provides the InsertLines method of the the Module object, but you must provide the line number. I have been unable to find any built-in function or method that provides this info. I also tried using SendKeys, but Sendkeys behavior is flakey. Thanks in advance for your help.
Mon, 23 Jul 2001 03:00:00 GMT

Terry Kref #2 / 3	Current Line Number in an Access Module Hi Terry, Try downloading wzComment.zip from Dev's site ( http://home.att.net/~dashish ), have a look at the code and see if it helps you. Quote: >How do you determine the current line number (where the cursor is located) >in an Access Module? I have a procedure that inserts a standard >documentation header for a sub or function, but don't know how to have it >insert at the current cursor position. VBA provides the InsertLines method >of the the Module object, but you must provide the line number. I have been >unable to find any built-in function or method that provides this info. I >also tried using SendKeys, but Sendkeys behavior is flakey. >Thanks in advance for your help.
Mon, 23 Jul 2001 03:00:00 GMT

Dev Ashis #3 / 3	Current Line Number in an Access Module Hi Terry, Try this link. Perhaps the code samples would be helpful. < http://home.att.net/~dashish/modules/mdl0031.htm > HTH -- Dev Ashish (Just my $.001) --------------- The Access Web ( http://home.att.net/~dashish ) --------------- :How do you determine the current line number (where the cursor is located) :in an Access Module? I have a procedure that inserts a standard :documentation header for a sub or function, but don't know how to have it :insert at the current cursor position. VBA provides the InsertLines method :of the the Module object, but you must provide the line number. I have been :unable to find any built-in function or method that provides this info. I :also tried using SendKeys, but Sendkeys behavior is flakey. : :Thanks in advance for your help. : :
Mon, 23 Jul 2001 03:00:00 GMT

Page 1 of 1

[ 3 post ]