okay thanks

I want to show some information to the user in a nonmodal form. Basically just like a message box (doesn't even need buttons) except nonmodal (and doesn't beep). I could probably create a form from...

Okay thanks for the advice... sounds like I need to learn a little bit more about datasets.

I think I understand.

One thing is that I was never actually loading the database into the dataset, only vice versa. This is because my program only adds to the database, and never needs to read...

I'm not sure I understand the response, but I don't think I explained my problem very clearly, so I'll start over:

I am trying to add new entries to the SQL Server database from a dataset. The...

I'm new to datasets, and trying to update a SQL Server database with one. I'm having trouble understanding how to correctly write the dataset info to the server db and preserve the relationship...

Thanks. I took a look and it would probably do the trick (and then some). Depending on whether I can find an available tool in Visual Studio (which is looking unlikely) and, of course, if my boss...

I need to display a DAG (directed acyclic graph), which is basically a Treeview, except children can have multiple parents. Any clue on a control or method to implement this in Visual Basic 2008?

Okay, thanks.

I'm not quite sure how to tackle this problem. I have a form that displays the properties of a class. I have events for all the properties so the form gets updated automatically when the properties...

I'm trying to write a program in VB2008 that uses a 2003 Excel spreadsheet as the interface. To help with this I am trying to pass data to and from macros inside the spreadsheet. I call a macro...

Upon further searching, I guess the "real" solution is to upgrade to VB .NET and use LINQ.

Okay, one example was I had a long array of numbers, and I wanted to do a tally, where I calculated the frequency of each number occuring in the array. I also wanted the tally to be sorted with the...

There a lot of times in my program where I have large arrays of data and I would like to use the power of SQL commands (SUM, GROUP BY, INNER JOIN, ORDER BY) on this information. It is a great tool...

Disregard the extra 'Integer' declaration in my first post ... not sure how that got in there.

(I'm using VBA with Excel 2003, have references to OLE Automation and Microsoft Common Controls 6.0). The Hittest with my Treeview control does not seem to be working. I'm using it in a MouseDown...

I suppose that makes sense.

I suppose there are easy ways around it, as you mentioned. Even so, I find it surprising that VBA has this convenient feature, while full VB6 does not.

Most of my Visual Basic 6 experience comes from VBA with Excel. With VBExcel, you can run any procedure (if it does not require input parameters) by simply putting your cursor in the sub and...

Okay, thanks.

I guess then my question is what exactly constitutes "closing the form". I thought unloading meant clearing from memory, but as my above code demonstrated, my user-created properties of the form...

Thanks, I can see how it works now.

Is unloading a form variable in the code the same thing as setting it to Nothing?

Okay, I found something that works but I am still just as confused. In my parent sub I have a variable to the form. I also have given the form a public boolean variable, ConnSuccess, so it goes...

I have a routine that, at one step, calls a form and shows it modal. When the user closes the form the routine continues. However, upon closing the form I want to know if it performed its assigned...

Very interesting, I look forward to trying that out. It looks straightforward, but as it is all completely new terrain for me, might have to to wait for the next project to learn it. Deadline in...

Unfortunately the data is not in a UDT, but still another slick idea, thanks again. After this project is finished I am done with VB6 and moving to .NET or some other language, as the many gaps in...

Actually, now that I've read some stuff, I'm not sure this would fix my problem. It's my fault for not being more clear. Basically, at certain points in the code I need to create a copy of my...

Thanks so much for the suggestion. This could certainly help get me out of a jam. I have never serialized an object before though. I'm starting a web search but so far haven't found much (for...

I have created a class module, and my program creates many instances of the class. Each object has a lot of data, and I want to be able to create a new instance that is a copy of an existing...

That's exactly the type of issue that I'm worried about. I'm guessing there are lots of little limitations that could show up at the most inopportune moments.

I'm about to write a new program in Visual Basic. I have Visual Studio 6.0, but it's limitations are starting to become a problem and I'm wondering about trying Visual Studio 2008 Express...

And now I've learned that Visual Basic cannot do WithEvents for arrays of objects. Sometimes I really dislike this language.

That might solve that particular problem, but I was only using the deck of cards situation as an example of a general problem, not just unique names/keys. It is hard to think of commonplace...

That would work, but here is where I get some issues. Number 1, as you say, this checking routine is in the Parent Class. But, when you give a card a name, since that is a specific property of a...

As I learn class modules, one issue that seems to come up repeatedly involves class modules inside class modules - how the "child" class module can never see anything inside the "parent".

Say, for...

This involves an Excel file that is being controlled by another program. I have written my own excel file with vba that works with this Excel file. So basically, the program opens up an excel file,...

Anybody??

I'm actually having this problem with the Deactivate and QueryUnload events as well.

From my reading I think the Unload event is supposed to fire when you close a form with the close button or...

Thanks for the responses. I guess I understand that the Get and Let procedures serve specific purposes, and aren't supposed to be substitutes for procedures in general. I had already started making...

I'm new to class modules, and the compiler seems to be enforcing a correlation of the number of input vars for a Get and Let procedure of the same property. The Let property must always have exactly...