Search:

Well a GREAT BIG thank you to both jmcilhinney and si_the_geek for all your help in solving this issue. Your responses and code work perfectly! I am now going to set this thread to resolved

Thanks...

Fantastic jmcilhinney! Too late tonight but will have a look at it tomorrow.

Richard

Thank you very much for the detailed explanation. Looks Like I have a lot of reading to do. I Added the System.Data.DataSetExtensions.dll to my project references and the Field errors are gone.
...

Well that got rid of the HasValue error but still have the row.Field error.

Great work............ Getting closer!

Richard

I used your second choice as it made a little more sense to me but still getting the error HasValue is not a member of Integer in the If statement.
Also row.Field is still giving me the same error...

Thanks for the corrections but I am still getting errors.

In Dim Rows line exParentUID.HasValue is giving this error HasValue is not a member of integer
row.Field is still giving me the same...

Well I have searched for an hour plus and cannot find out how to include code snippets like you did so will just have to copy and paste my code as text.

Here is what I have:
NOTE: I have used...

Thanks for that code jmcilhinney. I'm not sure I understand exactly what is happening but once I add that code to my program and run it line by line I'm sure it will become clear. I am assuming each...

Thanks for the suggestion si_the_geek. That is very similar to my first attempts where I ran into the exact issue that you mention where nodes were out of order so to speak.

Thanks jmcilhinney for your response. I "think" I was doing what you suggested before I started keeping track of the node levels. What was happening then was when I read the database records into a...

Greetings all. I have spent hours trying to figure out how to update a MySQL database when I want to move a treeview node to a different existing node.

My Treeview is populated from a MySQL...

Yes I agree there is something wrong here and I'm guessing it is in the registry somewhere. I want to get this updated version to my client as I have added a number of new features. Once it is...

Thanks for the links. I read all the posts in the first link but the last post confirmed my suspicions. The thread starter in that series ended up doing a complete fresh install of Windows 10 Pro,...

Yes your eyes are 20-20 There is an underscore but knowing if that is normal or not is WAY beyond my knowledge. I admit I had not noticed that, but even if I had, it would not have rung any bells.

I can't say whether everything matched the "dead" machine which by the way was originally a Win7pro machine then upgraded to win10 pro with the free upgrade. But yes they do match what was on this...

I have these two references in My Project
Microsoft Excel 12.0 Object Library (Type = COM, Version = 1.6.0.0, Copy Local = False, Path =...

Well I tried your code but did not like the message popup because I am sure my program users would be confused to say the least! My app is on a server and many users have a copy running during the...

Thanks for that Wes4dbt I'll try it tomorrow. I'm in Ontario Canada so time to quit and go shovel snow before dinner.

Thanks for trying. I do appreciate it.
I have been working with late binding excel today which creates an excel object and it seems to work fine BUT I cannot figure out how to tell when the user...

Thanks very much for the suggested code but as you can see in the attached image I get the same error. I think it must have something to do with the warnings that I attached in my previous reply but...

Yes I thought of that just after I made the post.

I am going to try to attach some screen grabs that will show my code as well as the errors. What I did not grab was the Imports...

I purchased a new computer with Windows 10 home. I installed Microsoft Office 2007 and Visual Studio 2010 Pro. Luckily I had all my apps on a USB drive so I plugged that into my new computer and all...

Thanks for your input techgnome. I had thought of creating a multi-member variable or other method of sending my data in the arg field but I guess I was a little lazy and simply put the two strings...

Well I used the BackgroundWorker and that solved my problems. Thanks jmcilhinney!

I'm sure I have not done it correctly though. Here is what I had to do.

Firstly I have 4 database functions to...

Sounds wonderful! Thanks for all your help. Not only in this instance but on all the others issues I have posted.

I'll do my homework.... Give it a try and let you know how I make out.

Once...

OK I'll do some research on the Backgroundworker. As I said in my first post I have never used any kind of threading so all this will be new to me. The functions in the module all return either True...

Yes the database functions are in a module and are called from the main UI.

Putting the database functions in a separate thread is something I can look at in the future but since this program will...

It looks like you are trying to delete a text file on the E: drive but why would you us a shell command to do that instead of doing it within your VB code?

What are the actual commands you want to...

I have a small application that does the following:
Connects to a MySQL database
Deletes rows in a table based on a field value
Inserts new rows from another table (in another MySQL database)...

Thanks for that link pdubee777. I'm away until nearly the end of February but will have a look when I get back.

Hello group. I need to connect to several unix boxes one at a time using a loop but once I connect to the first one then disconnect from it I cannot connect to any of the others. I have to close my...

OF COURSE!!! How could I have been so blind? I have actually forgotten to clear a dataset when I should have and wondered why I was getting more data than I wanted until I realized that I had not...

Thanks for all the input. I'm not sure about the "fill" that you are talking about dunfiddlin. I suspect there is something very basic here that I am missing.

Richard

I was afraid you were going to say that!
The report that will be generated could have hundreds of items when the quantities and sales are required so if I am hearing you correctly I need to get the...

I am dealing with basically four tables in two different databases or Catalogs as they are called in MySQL

Catalog 1 has a table called InvoiceHeader and a table called InvoiceDetail
Catalog 2...

The Tags idea solved my problems. Thanks again!

I'll try the Tags idea and see if I can make that work. Thanks for both replies.

Richard

After searching most of the treeview node posts I have not been able to find the answer I am looking for.

I have a treeview loaded like the following example:
Parent1
Child1
...

Guess I should have given a little more thought to the issue before I sent the last post! In the second code snippet I added "Changed = true" after the dim statement and it works like a charm....

Squiggly is gone. I had not entered the second code snippet. Where do I enter the code to change my variable "Changed" from = false to = True when text is changed?