Visual Basic

im new to programming... but couldn't you use the IsNumeric() function, if u get true back, just convert it to whichever type u need? CInt, CSng, CDec...etc. Sorry if i don't know what i'm talking about ______________________________________________ "I'm not me when I dream...anymore." -TRUSTcompany

Thank you all! What i did was: I edited the c++ code to write the hard drive serial number to a file, that is imediatilly read and erased from the vb code, its not the best solution but i guess it shall work... Thank you once more

What are you working with, could you be a little more explicit? Nick Parker The only man who never makes a mistake is the man who never does anything. - Theodore Roosevelt

Simple. You have two tables (Table1 and Table2). Table2 has records that relate to records in Table1. The only thing holding the relationship is the fact that the two tables share a common field: Table1: Table2: recID ID# of record recID ID# of record in table 1 Name Some name Info1 Some information related to table1 Address Some address Info2 Some information related to table1 Both tables share a recID field. But, Table2 can have multiple records with the the same recID from Table1, this is a 1-to-many relationship. One record in Table1 is related to Many records in Table2. The problem your running into is there is a recID in Table2 that doesn't exist in Table1. It's a record that doesn't have a relationship to any record in Table1. You can probably code a SELECT statement to find the 'orphaned' records in Table2 for you, but I don't know exactly how to do it.

You don't need the comma after the txtDesc.text. So the correct SQL command should work with: updateSQL = "UPDATE Product SET Description = '" & txtDesc.text & "'" & _ "WHERE Code = '" & txtCode.text & "'" Set RS = Conn.Execute(updateSQL) HTH:cool:

Ok, here you go… http://samples.gotdotnet.com/quickstart/[^] http://www.vb-helper.com/tutorial.htm[^] http://www.vbwm.com/resources/default.asp?page=TutorialsVBNET[^] http://www.troobloo.com/tech/vbdotnet.shtml[^] Paul Watson wrote: "At the end of the day it is what you produce that counts, not how many doctorates you have on the wall." George Carlin wrote: "Don't sweat the petty things, and don't pet the sweaty things."

Don't worry, someone posted the following code sample which solved my problem: Dim current As Process = Process.GetCurrentProcess() Dim processes As Process() = Process.GetProcesses Dim ThisProcess As Process For Each ThisProcess In processes '-- Ignore the current process If ThisProcess.Id <> current.Id Then '-- Only list processes that have a Main Window Title If ThisProcess.MainWindowTitle <> "" Then ListBox1.Items.Add(ThisProcess.ProcessName) End If End If Next

I want to thank both of you for your comments on this… After taking a long hard look at the architecture I had originally selected I finally decided to refactor things a bit and moved away from the inheritance aspect since there were some apparent, albeit subtle, differences in the implementation between what each child class needed. I ended up using an interface style and backed it up by using come common helper functions behind the scenes. I even ended up lowering my LOC count by about 30% and dropping the complexity of the design a significant amount because of it. I also noticed that the problem with my chosen implementation seemed to become apparent when I started the steps of documenting the class with XML docs. There were things showing up in the docs (I am using Ndoc) and things exposed to the outside world that I did not want exposed. The process of building the documentation for the library pointed that out very quickly. Thanks again… Paul Watson wrote: "At the end of the day it is what you produce that counts, not how many doctorates you have on the wall." George Carlin wrote: "Don't sweat the petty things, and don't pet the sweaty things."

See my replies (with more info) to myself. I have discovered over the last few days how to browse to the folder, select files, copy them to a listbox, and then process the files from the listbox. When I have time this weekend, I will post the project on http://files.danen.org/h/prg\_vbnet.shtml for everyone's benefit. Thanks for your response. :-) Gerry

Not sure, Bijju. "Imports system.io" for example imports (includes) a namespace that you can then refer to in your code, like additional classes. system.io comes from system.dll (I believe) so you could create a DLL and then make a reference to it in your project, or you can copy a source file to your project. I used to keep a number of "global" .h files in a special directory that I made known to the compiler, so it would know where to find it. You can probably do the same thing in vb .net, but I've only been using vb .net a month, so I'm learning as I go along. :-) Good luck, Gerry

I got it ... it is X| AppExcel.DisplayAlerts = False Thanx for all But there is one more problem i am facing and this is when EXCEL.EXE is still in running condition, even i close the Application. I check it through Task Manager. For closing the Excel Application I use following code. AppExcel.DisplayAlerts = False wBook.SaveAs FileName:=strFileName, FileFormat:=xlNormal, ConflictResolution:=False Set wSheet = Nothing Set wBook = Nothing AppExcel.Quit Set AppExcel = Nothing After last line i check the Task Manager ... their is still a EXCEL.EXE running .... How i resolve this ... Again thanx in advance