Treeview in MS Access Part 2, Navigation by Treeview

[@greghalliday4226]

Awesome guide, very clear and easy to follow. The best approach I have seen to setting up the treeview.

[@DolittleZoo]

This is the best video of its kind on the net. Thanks for sharing!

[@davidhendrix4909]

Dude, I know it is VERY late, but when looking for this info for a refresh (for a VERY old-time coder) it was EXTREMELY helpful. Part 1 and 2 were exactly what I was looking for with no extra fluff.

[@TheSmileyCoder]

I am glad to hear that these videos are still usefull. :)

[@TheSmileyCoder]

Thank you for that comment. I am working on the third part, and hope to have it ready soon.

[@jamest1973]

your domain is down. Can you please post the code google drive?

[@johnbort2]

Awesome Demo on the treeview. I have been a .net programmer since .net beta, but had to do a project in Access. This was VERY helpful in getting up to speed on the tree view and other things needed to do some access programming. Thanks!

[@Krahkenx]

Clear, efficient, well-explained!

[@TheSmileyCoder]

I shall try to take that into consideration for the next part. The original plan was to post the sample mdb as an attachment. I will try to get that done.

[@amysarkar]

Part 2 added instrumentally to the understanding of possible Treeview applications.

[@dollysjoseph]

These videos are so helpful to a Treeview newbie such as myself!! Can you post this database?

[@artemmateyko9472]

Hi from 2022 and thankx, very usefull)

[@TheSmileyCoder]

Hi M. MAK You can find all the code available on my blog in a Access 2003 and Access 2007 file format samples The link is in the video description.

[@KSAnomad]

can you provide the code for getxml, I am new to XML, and I can not read your youtube screen too well. apart from that, the treeview is working well. regards PRE

[@ife602]

Hi Thanks for this video, but the download link on your blog is not available.

[@TheSmileyCoder]

Hi. Yea, my blog was down for a while due to a bad plugin. I'm in the process of restoring it, and the treeview posts are up and running again, with the downloads.

[@ife602]

@@TheSmileyCoder Nice... thanks a lot

[@jamest1973]

@TheSmileyCoder your domain is down. Can you please post the code google drive?

[@geolmust]

Thanks a lot for your help

[@DiegoEzequieMartinez]

Hi, thanks for sharing this tutorial. I would appreciate if you could put the entire code in some txt or bottom of the video in order to study better. From already thank you very much Diego (Argentina)

[@louisvanderwalt334]

This video is great! Still using it in 2022 (10 years later). I have used it successful in a few applications, but now when I built by latest application it kept giving me an error message "Run-time error 35602 Key is not unique in collection" Advice would be appreciated.

[@mafgeology]

Yes, so I am going to add "key" field in the table includes certain letter in addition to the PK of the record For ex. A1 A2 A.. A667 etc And deal with it while running the code by eliminating the letter at the beginning..

[@waleedsalah6887]

where is the XML code pls ?

[@geolmust]

the function is not clearly stated within the form. Thanks

[@BaubetriebBoettcher]

Hi, unfortunately the link no longer works and the html text has to be copied. Can you create a new link :-) Thank you

[@shehadahyousef405]

Many thank for help. but the getHML is not clear in this video , could you please but the code for getID and Gethml code, many thank again.

[@TheSmileyCoder]

Public Function getXML(strxml As String, strElement As String) As String On Error GoTo errHandler If InStr(1, strxml, "", vbTextCompare) > 0 And InStr(1, strxml, "", vbTextCompare) > 0 Then 'Found it Dim intLeft As Integer Dim intRight As Integer intLeft = InStr(1, strxml, "", vbTextCompare) + Len(strElement) + 2 intRight = InStr(1, strxml, "", vbTextCompare) getXML = Mid(strxml, intLeft, intRight - intLeft) Else GoTo badXML End If Exit Function badXML: MsgBox "An error occured while trying to retrieve XML information,probably due to bad tags", vbOKOnly + vbCritical, "Error reading Node information" Exit Function errHandler: MsgBox "An error occured while trying to retrieve XML information from a node" & vbOKOnly + vbCritical, "Error reading Node information" Err.Clear Exit Function End Function

[@TheSmileyCoder]

Public Function getID(nodX As MSComctlLib.Node) As Long On Error GoTo err_Handler getID = getXML(nodX.Key, "ID") exit_Function: Exit Function err_Handler: doStdErrMsg ("getID Function") GoTo exit_Function End Function

[@geolmust]

Hi and thanks for your effort Please may you paste the getxml function thanks

[@lewiswa02]

I"m not able to just drag a table to create a subform as you did in the demo. What settings did you have to adjust in order to be able to do that?

[@andersebro6690]

Hi William I didn't change any settings. If memory serves I was already using Access 2010 at the time. Maybe you are using an earlier version?

[@lewiswa02]

Anders Ebro I'm using 2010 as well. No worries, I just made the form and drug it over as a subform. I was just curious. Thanks for your videos, they're well done and I've learned a lot from them. Keep it up.

[@TheSmileyCoder]

I have uploaded samples in Ac2003 and Ac2007 format at my blog. You can take a look at them there for the full code used. I will edit the video description to include a link to my blog.

[@dbdata9836]

well

[@TheSmileyCoder]

You can find all the code available on my blog in a Access 2003 and Access 2007 file format samples The link is in the video description.

[@TheSmileyCoder]

You can find all the code available on my blog in a Access 2003 and Access 2007 file format samples The link is in the video description

[@TheSmileyCoder]

You can find all the code available on my blog in a Access 2003 and Access 2007 file format samples The link is in the video description

[@TheSmileyCoder]

You can find all the code available on my blog in a Access 2003 and Access 2007 file format samples The link is in the video description