The workbook object has a close method that has save changes parameter and a filename paramater. Suspect you need to use that somehow. Dave Who am I?: http://www.bebo.com/daveauld/

When it comes to advice, the old adage 'garbage in, garbage out' applies :). Anyway, well done with solving the problem yourself. Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

Partition Magic[^]

manni_n wrote: i made a c++ project long back. now i am learning dot net.. i want to add an interface now on vb.net.. but i dont know how to add .cpp file in vb.net can anybody help.? What you can do is to either compile the C++ project into a DLL and add a reference to it in VB.NET, or you can convert your C++ project to VC++ .NET project and add a reference to the whole project. Pete Soheil DigiOz Multimedia http://www.digioz.com

Ok, U can get PartitionMagic Software to get this done.. The software allows you to create or merge partitions. Gud luck Try this. SAJAN A PILLAI C#.NET Programmer TELESOFT INDIA PVT LTD... BANGALORE "Winners don't do different things. They do things differently. ...

thanks dave, now it makes sense to me. as forms are classes so encapsulation concept will be voilated... i'll try this way and come back to you.. thanks..

You are right, I misread your post and thought Form2 was an MdiChild of Form1 as well. I don't understand why you would ever use the scenario in your post. Generally, with Mdi applications you don't create forms that are not MdiChildren or Dialog forms (dialog forms must be closed before you can do anything else in the application, like the MessageBox). The reason for this is all your forms are neatly contained in the main application instead of spread out across your machine. But you know what you are trying to do better than me, just hope I was able to offer something helpful. Mike Lasseter

I had this problem once and beleive it or not a simple disk cleanup and defrag did the trick:) ---Although I think i also had spyware, but symantec no detect "Shorter of breath, and one day closer to death." ~Pink Floyd

manni_n wrote: its giving error that invalid object ' authors'. how this error can be resolved??? If you are just learning a better question would be "What does the error mean?" so you can understand what it means in the future. SQL Server has a number of database objects. These include tables, views, stored procedures, functions and so on. You can get a list of all object in the database by typing SELECT * FROM sysobjects The message "invalid object" indicates that the object either does not exist, or it is the wrong type of object for the context in which you are trying to use it. In this case you refer to a table object in the SELECT statement that does not exist (there may be another object in the system called authors, but that will be a different type of object, or be used in a different context. Upcoming events: * Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ... * Reading: Developer Day 5 Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton My website

okkk, i think it will do. but wat abt the conectivity with database..?? like how the connectivities with backend will be established automatically with the textboxes created dinamically. can u tell me any article or any code for such logic...?

You could use the same code I posted earlier. However, instead of closing form1 when the child is closed you would just show it. Form2 doesn't need to worry about form1 at all in this case. When the back button is clicked just call me.close. Form1's method will then get called because you registered that method with form2's closed event.

You don't do anything with it. Read up on the OleDbCommandBuilder class here[^]. Dave Kreskowiak Microsoft MVP - Visual Basic

The events fire in this order: LostFocus Validating Validated 'Cancel' is not a property of the system.eventarg object which is the object the Validated event recieves. 'Cancel' IS a property of the System.ComponentModel.CancelEventArgs which is the object the Validating event recieves. I don't understand why you think the validation should occur in the validated event. There is no reason the validation shouldn't be done in the validating event and one very good reason why it should be. This reason would be that you can prevent other controls from responding to the user before they have inserted valid data. I'm glad you've got it working though. As long as it works the way you want I see no reason to change it.

thanks man.. its working perfectly... and reduced mah problem alot.. regards.. manni

You should NEVER pass a reference to a control between forms. You can pass the string to form2, via a property, store the value in a common property in a static class, or use a delegate to inform form2 when it changes in form1, if form2 is modeless. 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 people... for sending me solutions... regards.. manni