SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 8 of 8
  1. #1
    SQA Council
    Join Date
    Mar 2001
    Posts
    14,438
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Tree control for MS Access

    User Paolo Cantoni (paolo.c@rmt.com.au.nospam) posted:

    Hi,

    We've got access (via MS Access) to the Test Manager DB and are
    reporting stuff directly from it. We'd like to be able to select Test
    Folders and Test Cases (and stuff of that ilk) via a Tree control in MS
    Access (2000). Does anyone know a (Free) tree control we could use with
    MS Access to do this? We've currently got access via a multi-level form
    and can navigate the structure with it, it's just cumbersome and an tree
    view would be really nice...

    Paolo

    ---

  2. #2
    SQA Council
    Join Date
    Mar 2001
    Posts
    14,438
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Tree control for MS Access

    User MArk B. (slow_steamer@yahoo.com.nospam) posted:

    Isn't there a tree control add-in that ships MS Access? It's one of those
    things you pick during setup.

    MArk B.

    Paolo Cantoni <paolo.c@rmt.com.au> wrote in message
    news:144414@sqa-suite-users...

    Hi,

    We've got access (via MS Access) to the Test Manager DB and are
    reporting stuff directly from it. We'd like to be able to select Test
    Folders and Test Cases (and stuff of that ilk) via a Tree control in MS
    Access (2000). Does anyone know a (Free) tree control we could use with
    MS Access to do this? We've currently got access via a multi-level form
    and can navigate the structure with it, it's just cumbersome and an tree
    view would be really nice...

    Paolo
    ---

  3. #3
    SQA Council
    Join Date
    Mar 2001
    Posts
    14,438
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Tree control for MS Access

    User Paolo Cantoni (paolo.c@rmt.com.au.nospam) posted:

    Yes, Mark, I though so too. But finding it is another issue. I suspect
    it's something you can get if you have one of the SDKs, but which one?
    It's not on the standard list of controls...


    Paolo Cantoni

  4. #4
    SQA Council
    Join Date
    Mar 2001
    Posts
    14,438
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Tree control for MS Access

    User PHIL BEVAN (PHIL.BEVAN@thales-cs.com.nospam) posted:

    It part of the MS Common Controls the actual file it is in is "mscomctl.ocx"
    located in the C:\WINNT\System32 or C:\WINDOWS\System folder.

    It's a default part of windows, you may get updated versions within the SDKs
    but unlikely, you'd usually only get the updates with the dev tools or
    Windows itself.


  5. #5
    SQA Council
    Join Date
    Mar 2001
    Posts
    14,438
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Tree control for MS Access

    User Paolo Cantoni (paolo.c@rmt.com.au.nospam) posted:

    Thanks Phil,

    But that's not the control I'm talking about (I believe). I think I
    remember a data-bound control. The one you mentioned uses in memory
    trees (I think). The one I'm thinking about used a pointer to a table
    which contained the hierarchy and allowed you to move up and down it.
    It was specifically for MS Access (or at least DAO or ADO).

    Is any body using an MSAccess compatible tree control? I'd like some
    feedback on how they go before we spend money as some of the sites I
    visited said "no refunds".


    Paolo Cantoni

  6. #6
    SQA Council
    Join Date
    Mar 2001
    Posts
    14,438
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Tree control for MS Access

    User PHIL BEVAN (PHIL.BEVAN@thales-cs.com.nospam) posted:

    Check out ComponentSource.com and see if they have what you need. The one
    for access was just for that, only for MSAccess.


  7. #7
    SQA Council
    Join Date
    Mar 2001
    Posts
    14,438
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Tree control for MS Access

    User Tom Roberts (testmachine2k@yahoo.com.nospam) posted:

    Have you tried the Microsoft ADO Data Control
    (msadodc.ocx). We do something similar to what I
    believe you are attemtping to do (although with SQL
    Server). And given that via UDA you can access your
    data, this control can help you. We fill top-level
    nodes with database names, then below each one table
    names, and below table names the records for each
    table.

    --- Paolo Cantoni <paolo.c@rmt.com.au> wrote:
    ************************************************** **********************
    ************************************************** **********************
    ************************************************** **********************
    ************************************************** **********************
    ************************************************** ********************
    === message truncated ===


    __________________________________________________
    Do you Yahoo!?
    Faith Hill - Exclusive Performances, Videos & More http://faith.yahoo.com

    ---

  8. #8
    Member
    Join Date
    May 2002
    Posts
    69
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Tree control for MS Access

    Hey Tom Roberts, how did you define the Node. When I brought the TreeView ADO control in, I can't setup the nodes within VBA. Is this sorta like the other user defined commands or is there another file that's missing? Any help would be appreciated. Thanks!

    ------------------

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 12.50%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 01:48 PM.

Copyright BetaSoft Inc.