Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

"Intellisense" and Active X Controls in VBA

Discussion in 'Information Technology' started by Peter Hibbs, Jul 28, 2006.

  1. Peter Hibbs

    Peter Hibbs
    Expand Collapse
    Guest

    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.

    --
    Peter Hibbs
     
  2. Loading...


  3. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    Peter Hibbs <peter.hibbs@btinternet.com.NO_SPAM> wrote:

    >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
     
  4. Peter Hibbs

    Peter Hibbs
    Expand Collapse
    Guest

    As I suspected. Never mind, we shall just have to wait and see.
    --
    Peter Hibbs
     
  5. James A. Fortune

    James A. Fortune
    Expand Collapse
    Guest

    Peter Hibbs wrote:
    > 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
    MPAPoster@FortuneJames.com
     

Share This Page