Using VBE object in Access 97

[johngo]

I want to use the VBE object in Access 97. In 2000 and later you
access it through the Application object.

Is it possible? If so does anyone know how?

 

[Douglas J. Steele]

It doesn't exist in Access 97. What are you trying to do? (We can probably
suggest an alternative)

 

[johngo]

It doesn't exist in Access 97. What are you trying to do? (We can probably
suggest an alternative)

I want to get the current edit line. So what you can get using
VBE.ActiveCodePane.GetSelection in 2000 and later.

 

[Douglas J. Steele]

I don't believe it's possible in Access 97. Why do you need it? What are you
trying to do?

 

[johngo]

I don't believe it's possible in Access 97. Why do you need it? What are you
trying to do?

I have a procedure that runs from the module toolbar. The procedure
needs to know the current procedure so it can put things like the
procedure name in the error trap message and other procedure sensitive
info elsewhere in the current procedure. It also needs the line
location of the procedure for inserting text.

 

[Douglas J. Steele]

I don't know for certain, but go to The Access Web at
http://www.mvps.org/access/resources/downloads.htm and download the Code
Comment Builder Wizard sample. I believe it's Access 97, so it should help
you.

 

[johngo]

I don't know for certain, but go to The Access Web at
http://www.mvps.org/access/resources/downloads.htm and download the Code
Comment Builder Wizard sample. I believe it's Access 97, so it should help
you.

Doug,

Thanks for your reply. I downloaded and checked out wzComment.zip. It
is a 97 add-in. It creates a builder which you can get to through the
module shortcut menu. His builder functions get the module and
procedure names through the builder passed arguments.