FuneralofSmiles

What I mean is adding all the cells in a field that contain numerical data and stores them in a variable on form load or change. Such as an expenses database that has a 'Deposits' field and an 'expense' field. During formload adding all the cells in each field that actually contain data, storing each in a respective variable and then subtracting expenses from deposits an displaying overall balance in a label. I still can't figure how to do this. Any help would be gratefully appreciated.

Can anyone tell me how I would go about adding together a particular field in a database? Thanks.

I've tried that but my original forms are still visible in the background. This is my code for my mmuNewCourse: Private Sub mmuNewCourse_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles mmuNewCourse.Click Dim frmCourse As New frmCourse frmCourse.ShowDialog() Call mmuFileExit(ByVal sender As System.Object, ByVal e As System.EventArgs) End Sub I tried calling my exit button but when I tried I came up with more errors. I want the new form to open and the old form to close. Thanks.

I am working on a small project that uses multiple forms to display contents of multiple tables within a database. My problem is that when I click FILE > NEW > different form.... I can create a new instance of my other forms that are fully functionable but my previous form stays in the background. How do I close the form from my menu button? I tried calling my mmuFileExit() button but that doesn't work. All help would be greatly appreciated. Thanks. :)

I'm working on a project that displays a datagrid with the table contents and then I am also binding a few textboxes to the fields in the table. I know you can update the database from the datagrid but what I want to do is update from the textboxes as well. But when I try all I get is an error message saying that this field does not allow a Null value. How can I allow a user to update a database from the textboxes instead of the datagrid? Any help will be greatly appreciated. :)

Hello, I am working on a small comic book database for a friend of mine and I built an HTML help file that I want to be able to launch from a menu item. Can anyone help me which how to do so? Also, when I do this, will it use the default browser or am I going to have to specifiy a specific brower? Thanks for all your help and happy holidays, funeralofsmiles

Hello, I am wondering if there is a way in VB .Net to import code from an external file? Such as with HTML when you can store your JavaScript code in an external file and import it into your HTML file for use. :confused: What I want to do is clean up my code by placing all my validation code into an external file so that everything doesn't look so jumbled. And if I can store some code into another file, is there any special rules or a cerain file extension needed? Thanks for the help and forgive a budding programmer. :D

Can anyone help me or give me a few links for sites that help explain arrays. I'm doing some homework with arrays and this textbook doesn't do a very good job of doing so. Thank you.