Video Requests

I still have quite a few ideas for treeview tutorial videos I wish to create and publish, but at some point I might run out of inspiration. If you have any ideas for a tutorial, or an area of Access that you feel is not covered as well as it might be, leave a post here, and I will consider making a video on that topic (if I know anything about that topic).

30 comments on “Video Requests
  1. George Nelson says:


    Great youtube videos. I just ran across them about an hour ago looking for a treeview example basically for exactly what you show in your example. One of the first search results, by the way.

    Another thing I would like to see that I think would be very helpful is being able to re-sort the treeview by dragging the nodes up and down to different locations.

    I’ll be on the lookout for that. 🙂 But in the mean time keep up the good work!

    • TheSmileyCoder says:

      Hi George, Thank you for your comment.
      I intend to do a drag-n-drop video as well, though at the current speed of production it might still be some time before I get to that. Glad to hear you liked the video, and that it was able to help you.

      Best of luck with your project!

      • Beth H says:

        Hi Smiles (saw someone else call you that! I hope you don’t mind)
        I just posted on your YouTube channel, asking about this same functionality. Do you have any examples that show this (the drag/drop feature or some other means to reorder nodes up, down, inside and outside other nodes?). Even a sample DB that has this functionality would be helpful if you haven’t had time to create a tutorial yet.
        Thank you!!

        • TheSmileyCoder says:

          I’m sorry to say I still haven’t gotten around to making a drag-n-drop tutorial. I will see if I have anything that could work as a sample, however most drag-n-drop are integrated in applications running on sql server, so I don’t have something that can easily be “pulled” out.

  2. DJ says:

    I was researching TreeView when I came across your youtube videos! They were extremely helpful to a novice like me!!

    I would love to see more info on MultiSelect Checkboxes and how to use them to change information in the subforms.

    Great job!

    • TheSmileyCoder says:

      Hi DJ
      I am glad to hear you liked the treeview videos. I don’t quite understand your comment about MultiSelect checkboxes. First off, are you sure you don’t mean multiselect listbox?
      And what information are you trying to change?

  3. Seth Schrock says:

    Can you post the database for your third video on the Treeview control? I’m having trouble with getting it to expand back to where it was.

    • TheSmileyCoder says:

      Hi Seth.
      Thank your for posting. I shall try to get it posted tomorrow.

      • Seth Schrock says:

        I got it to work! Thanks for these tutorials. They are so easy to understand, although having the sample database in front of me helps. I can’t wait until you do the drag-n-drop and the right click menu that you have talked about. I will probably incorporate them into my database.

        • TheSmileyCoder says:

          Excellent. Lovely to hear. The treeview part 5 tutorial has been a bit delayed by me working on the Crash Reporter tool. I really need to get back to finishing part 5.

  4. Joy says:

    You’ve saved my life. I have a database with a series of hierarchical many to many relationships. With the help of your videos and information I’ve found on other blogs about creating treeviews for one to many relationships, I have been able to piece together what I needed. But, I DESPERATELY need to know how to insert new nodes into a treeview parent node, and then, how to save the information in the new node to the underlying table. I know that you said you would cover something like that in episode 6…but I can’t find episode 6. Does it exist yet?

    Thanks for all of your wonderful guidance.


    • TheSmileyCoder says:

      Hi Joy
      Very pleased to hear you liked my treeview series.
      I have not yet finished part 6. I have most of it lined up in my head, I just need a few quiet evenings to record and edit it. I usually record each video 3 or 4 times until I am satisfied with the quality, and then comes some time for editing and dubbing.

  5. Seth Schrock says:

    You mentioned one time on Bytes that you had a solution that automatically updated the database based on a version number that was stored somewhere in the database. Could you post that solution or create an instructional video on it (after part 6 of the treeview is done)?

    • TheSmileyCoder says:

      Hi Seth
      I have intended to share that for a while, but wanted to get my treeview series done first. I still have at least one treeview video I would like to do (Drag and Drop). I will get to the version updater eventually.

  6. James says:

    Anders your treeview tutorials are excellent. I would like to suggest that you do future tutorial demonstrating how to recursively search through a treeview. Three improvements over the example that is on Technet would be to count the total number of matches, highlight the matching nodes, and to expand the branches with matching nodes up to the top level. Just a suggestion.

    • TheSmileyCoder says:

      Thank you James. Sounds like a good idea for a tutorial. I have done all of those in one way or another, of course it would need to be modified some to be boiled down into a tutorial.

  7. Jesko says:

    I would like to thank you for your great treeview tutorials as well, great job!
    I was trying to adapt your demo database into one, that can handle n:n recordsets, but didn’t succeed. Is this possible at all?
    The idea is to get transparency about the depencies of various development projects. One project (i) is enabler for another project (x) and another project (y). Project (i) can have enabler itself. When i create a treeview, only the project (i) with parent (x) shows the node, but not project (i) with parent (y).
    Do you think you can show a tutorial for this?

    • TheSmileyCoder says:

      Hi Jesko
      Glad to hear you liked it. Yea, that should be possible, as long as you
      A) Dont run into recursion (i.e. infinite loop)
      Just to be sure I got the idea correct about what you want to achieve, could you try to sketch it in paint, or excel, and mail it to me?

  8. Frank says:

    Your Treeviews demo’s are an excellent source of information as to how to create and use a treeview which I use as a record selector all the time. I would like to see you put together a video/demo which shows how to drag and drop nodes within a single Treeview and also how to drag and drop nodes (Copy Nodes) from another Treeview located on the same Access form.

    • TheSmileyCoder says:

      Thank you for taking the time to comment, and provide inspiration. I have started work on a drag-n-drop video, but not yet sure when it will be ready for release.

  9. Petrit says:

    Hi TheSimileyCoder,

    1-Can you tell me much more for learning Access by myself?
    2-How can link two of three comboboxes inside a datasheet or continuous subform to filter each other
    Thank you very much for your videos.

    • TheSmileyCoder says:

      Hi Petrit
      Thank you for posting. I don’t personally have any “basic” access learning videos, but you can go to youtube and look at Crystal Longs videos, on her channel:

      I would also strongly recommend looking into finding a local course in Access. A 2 day starter course on access can save you alot of time down the road, and help to avoid some of the more common mistakes.

      As for 2) that does sound like a good topic for a video. I am sorry to say though, that I am not really producing videos at the moment. I am in the process of a major house-renovation that is taking up 99% of my free time.

  10. Andy Wolfenden says:

    Hi Smiles
    I have followed our videos and they are very well done. unfortunalty I am of an age that progarming is very hard to understand. ( ie, not a teenager). your tree works well for me, but is not ideal for the use im using it for.

    My Ideal tree is one for problem solving faulty items,.and would be able to grow as new problems are found with a repair route.

    For instance
    is the toast brown. Y / N
    If yes, say Toaster is working fine.
    if no, then asks the question is the toaster pluged in Y / N
    If No, then links to a page on how to plug toaster in.

    if a new problem is found, like the dial is turned down, then this could be added with a text box.

    it would have to record the repairs and dates and locations.

    could your tree be modified to do this, do you know of an excisting down load that could work neatly,

    or any other help to get me on the right road.

    • TheSmileyCoder says:

      Of the top of my head, I think its doable, though the exact implementation would require some more thought. I mean, probably not all questions will be yes/no questions.

      So its doable, but its also the kind of thing I imagine would take a fair bit of code to get running. Its more like a 2-4 hour project to think it through, and create a sample, then something I can explain in 10 minutes in a post.

  11. Edie says:

    Thank you! Your tutorial really useful.
    I would like to know if there’s any way to create a treeview with columns? (something like a treegridview)

  12. Philipp says:

    Hi SmileyCoder,

    great tutorials and videos you’ve posted already…many thanks.
    I’ve adapted your access-code with my information and it worked very well..great.

    Unfortunately I would need the treeview in Excel, not in Access.

    Do you know any (easy) way to get the code for the treeview (maybe with functions) implemented in excel/adapted to Excel?
    It would be great to have the database in Excel, too (e.g. in a seperate worksheet). I mean if there is a chance to take the “tbl_Reqs”-database and copy/paste it into Excel and use this as the source for the tree, this would be totally fine for me. I like the strucute of it (ID_Type, ID_Parent, dbl_Sort etc.).

    Many thanks for your reply and please let me know your thoughts.
    I’m really looking forward to hearing from you.

    Kind regards from Germany,

    • TheSmileyCoder says:

      Hi Philipp
      Thank you for your comment. All comments undergo moderation before being posted, which is why they take a while to appear. Sadly I get way to many spam posts.

      I’m afraid I don’t know an easy way to adapt it to working in Excel. A big part of the treeview is based on recordsets. That said, you could have the treeview in Excel, but have the data in an access database (or SQL server), its a matter of specifying the data connection from Excel, and of course adapting the code. ”

      So I don’t really have a sample to share. But best of luck with your project.

  13. Daniel Schunk says:

    Hello, Anders,

    at the past Access DevCon in Vienna you showed in your presentation how to filter data with the Access Layout Grid.
    Unfortunately I could not come to Vienna. Can you publish the slides and a sample database on your website or can you create a tutorial video or send me a ZIP file?

    Many thanks in advance!

    Kind regards from German

  14. TheSmileyCoder says:

    Hi Daniel
    I do intend to do that eventually but haven’t found the time and energy yet to get it done.

Leave a Reply

Your email address will not be published. Required fields are marked *


This site uses Akismet to reduce spam. Learn how your comment data is processed.