Found it ... Dim objUP As Outlook.UserProperty objUP = objTask.UserProperties.Item("CC Ref")

oDS.ReadXml(sfilename) Never underestimate the power of human stupidity RAH

By the look of things, the table Value is already linked to Product, the problem is just that this example only contains data (price, currency, etc) for Product 2. My advice is free, and you may get what you paid for.

Have you solved this? "The clue train passed his station without stopping." - John Simmons / outlaw programmer

Have a look at this article You always pass failure on the way to success.

Thanks for your thoughts. I managed to fix it. The problem was that I had created a sorted DataView, and populated the DataGridView with it - which had the effect of sorting one of the columns, which seemed to have messed up the indexing. One thing I can't get my head around is that the grid was bound to the dataview, so the indices should, I think, have worked - irrespective of the sort.

The TreeNodesCollection class has an indexer so you can access each Node by trvDbNameNormal(0) or trvDbNameNormal(strTable) . The TreeNode class has a Text property which will return strTable name in the case of your code. Then simply write a recursive algorithm to walk the tree. something like: Private Sub walkTree(t as TreeNode) For i as Integer = 0 To T.Nodes.Count -1 ' Do something usefull here walkTree(T.Nodes(i)) Next End Sub I'm largely language agnostic After a while they all bug me :doh:

Oddly, you can prevent the dragDrop in the DragEnter handler by just changing the visual effect: e.Effect = DragDropEffects.None You'd think this would just change the cursor, but it does actually prevent the _DragDrop from firing. This has the advantage of showing the 'not allowed' cursor if they drag a file type you don't want to accept.

Resolved it ... Private Sub DataGridView1_DragDrop(ByVal sender As Object, ByVal e As System.Windows.Forms.DragEventArgs) Handles DataGridView1.DragDrop Dim strFilePathAndName As String() = DirectCast(e.Data.GetData(DataFormats.FileDrop), String()) Dim zip As ZipFile zip = ZipFile.Read(strFilePathAndName(0))

What specific error are you getting when the app falls over? "Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

penguin5000 wrote: I had already tried adding the column to my table, but it just didn't seem to work, which is why I assumed there was some sort of binding problem going on. If you want to see this change, then you either have to manually add the new column to the DGV, or just rebind the DGV to your datasource so it can regenerate the columns it needs to display the data. penguin5000 wrote: Am I right in thinking that if I read the XML file in, I've automatically got my dataset and tables to work with, and if I update my table in any way I choose (i.e. adding/deleting rows/columns), it is the same table in the exact same dataset that I write back to XML? Yes. This will overwrite the existing XML file with the new data and schema. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

What about cascading menus? item1 item2->item1 item2 item3 item4 He was a snowflake, like other "unique" snowflakes, falling down, getting stepped on, and pushed aside to disappear.

Yes, You have to define a new MenuItem object and then add it to another MenuItems items collection. You then also have to enable the required event handlers. My Blog[^] FFRF[^]

If you have XML, you can use SelectSingleNode on an Xmldocument to see if you r node existss. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Thanks for your replies. I did a message box for objDsExistingXRatesFile.Tables(0).TableName. I assumed I was assigning the table name when I did the line objDsExistingXRatesFile = New DataSet("StoredRates"). .... obviously not ;)