"Intellisense" and Active X Controls in VBA

[Peter Hibbs]

Hi All

In Access VBA the 'Intellisense' facility is very useful when writing and
debugging code, i.e. being able to hover the mouse over a variable and
display the contents. However, when using VB Active X Controls in Access such
as Flex Grid, Tree View, Calendar, etc this facility does not work (although
it does in VB6). Is there any way of activating this option and if not, are
Microsoft likely to implement this feature in the next version of Access.

 

[Tony Toews]

In Access VBA the 'Intellisense' facility is very useful when writing and
debugging code, i.e. being able to hover the mouse over a variable and
display the contents. However, when using VB Active X Controls in Access such
as Flex Grid, Tree View, Calendar, etc this facility does not work (although
it does in VB6). Is there any way of activating this option

Not to my knowledge. And yes that behavior is irritating.

and if not, are
Microsoft likely to implement this feature in the next version of Access.

No idea.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Peter Hibbs]

As I suspected. Never mind, we shall just have to wait and see.

 

[James A. Fortune]

Hi All

In Access VBA the 'Intellisense' facility is very useful when writing and
debugging code, i.e. being able to hover the mouse over a variable and
display the contents. However, when using VB Active X Controls in Access such
as Flex Grid, Tree View, Calendar, etc this facility does not work (although
it does in VB6). Is there any way of activating this option and if not, are
Microsoft likely to implement this feature in the next version of Access.

I can't speak for VB controls, but one interesting thing to check out is
the LINQ project at Microsoft. It attempts to integrate SQL keywords
into the language itself (such as C# or VB.NET) so that 'Intellisense'
will also work on SQL expressions.

"And then we have DLinq, which is the code name for a future version of
ADO.NET that supports mapping of your relational databases to objects
and Language Integrated Query on top of that." --Anders Hejlsberg

I am looking forward to using these features, especially mapping data to
objects.

James A. Fortune
(e-mail address removed)