I appreciate for your info. I'll try Jesse's book. bravo659

Oh no, i know how to calculate fractions without a problem, is that how do you use the textboxes to display fractions. That's the problem. I've seen it done through C#, but I tried to use it in VB.Net, and it doesn't work. So the solution is in progrmming in VB.Net. That's all. I appreciate for your feedback.

It's only an example. In a tape measure would be 3/4 of an inch. And Yes, it would also be 6/8 but reduce it to the LCD would be 3/4. That's the only problem that I am having, using the fractional portion to render an answer in fractions. There is a site called Break Tru, and they are selling a fraction and decimal program, but can't get the code for that program. For what I want it for is for several fraction programs. Does your home have heat oil. Then you would know that the tank only reads in fractions. I created a program that will give you how much oil you have in your tank and the amount you need to refill it, and how much it will cost you, and the amount of tax and a grand total. I also added on the form a fraction to decimal converter, which is the only i can offer under that program because I don't know how to render the fraction resulting in fractions. If you know of anything or a book that I can purchase in algorithm please let me know. I am up to programing almost in calculus. LOL Thanks Bro for your help.

I appreciate for your help, but I already know to convert a fraction to a decimal. The code is related only to fraction conversion to decimal. I would need to know how to render an answer in fraction not decimal. For instance, 5/8 + 1/8 = 6/8 reduces to 3/4. So therefore, the textbox1 will be the numerator and textbox2 will be denominator. The third textbox will return the fractional value. Or textbox3 will be the numerator and textbox4 will be the denominator and this will invoke the answer. I am having the problem of generating a code for the above instance in fractions. bravo659

I appreciate for your time. I am an intermediate programmer, I am not an expert like you. So being trivial I really dont think so in my part. I am trying to learn this solution. I enter a numerator and denominator in the textboxes. There is no text to convert. Trying to figure out how to use the numerator and denominator in a fractional sense in a program. Don't know if i would use the abs or just something else to get the result in the label as a fraction.

I am using visual basic.net only. I need some help in fractions. How can I use the fractions in system.math to create a fraction program? I will use two textboxes and a label for the answer within a form and i will be adding, subtracting, multiplying, and dividing. Can anyone assist with a sample code? :) bravo659

What I am using is a userID and password in the Access DB tables. What I would need to know is when I add a new child form, what would be the code to add and change a password. In the first form for userid and password it has two textoxes, two buttons for login and exit. Now, the child form would be with a three textbox, one for old password, change to new password, and authenticate new password. If i want to change the username then I would create change username button which another form would appear to change the username. I really dont know how to code these changes. Could you help me in this instance. bravo659

What i like to do since i already have the login box that i need to enter a user id and a password, I would need to change the password time to time. How about adding more users with passwords? I am fairly new to this sql server programming, but I am also using the MS Access to make it easier to understand what I am doing. Even though, all I have to do is change the Access to sql, and vice and versa. How can I do that? bravo659

I created an address book with a login dialog box. It works fine. Now I would like to change the password and or user id. How can I do that? bravo659

I finally fixed the problem. But I still need more to learn about programming in vb.net. Thanks for your reply. bravo659

Thanks for your reply. I've been hearing about these issues. But I am still learning, and need to learn about stored procedires. I believe I am not ready for the stored procedures. But I will try to learn it. I like programming, which it is a challenge. Is it possible if you would explain more about stored procedures? I really appreciate it. And what is the best advanced books that I can learn from. By the way who is Colin? bravo659

I didn't even noticed that I opened it twice, thanks for pointing it out to me. So then, it is not the ExecuteReader, is that I used the conn.Open twice that disallow the disconnect from the reader, it just tries to open twice without closing the reader. Thanks for your response. Let me try and will post again whether it works or not. Been working on this for 3 months. LOL. bravo659

I created a user login page associated with an address book. In order to retrieve the address book the user must enter the username and password. How can i code the login button for authentication. Below is the code that i used but there is an error message that points to ExecuteReader. Error: "ExecuteReader requires an open and available connection. The connection current state is closed." I am using the OleDbDataAdapter, OleDbDataReader, OleDbConnection, and the OleDbCommand. What is it that I am doing wrong. I also created a MS Access table. Dim mypath = Application.StartupPath & "\password.mdb" Dim Password = "" Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & mypath & ";Jet OLEDB:Database Password=" & Password) Dim cmd As OleDbCommand Private Sub btnLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLogin.Click Dim sql = "SELECT Username,Password FROM Password WHERE Username = '" & txtUsername.Text & "' AND Password = '" & txtPassword.Text & "'" cmd = New OleDbCommand(sql, conn) Dim dr As OleDbDataReader = cmd.ExecuteReader If conn.State <> ConnectionState.Open Then conn.Open() End If Try conn.Open() Catch ex As InvalidOperationException MsgBox(ex.Message) End Try Try If dr.Read = False Then MessageBox.Show("Authentication Failed...") Else MessageBox.Show("Login Successful...") End If Catch ex As Exception MsgBox(ex.Message) End Try If conn.State <> ConnectionState.Closed Then conn.Close() End If Dim form As New Form2 form.Show() bravo659

What is these that you are referring to? bravo659

I had no problems in accessing information via Access Database using VB.Net. I created several datagrid programs accessing the MS Access database without an exception. I am just having problems in authenticating a login page that I am trying to use to open a secured program, that continues to point to the ExecuteReader being closed. bravo659

I appreciate for your feedback. Yes i heard of the xml it is structure, but not sure how to really use it. It's becoming prevalent, so i better get with program and learn it, before i'm left behind. Hey, thanks again. bravo659

I created a payroll program that will generate hours and tax deductions. I would like to print the results. How can I do that? bravo659

I found the answer, i am using Math.Round to round off the numbers n the BMI project. bravo659

Thannk you for youre reply to my inquiry. I will try it and let you know how it went. bravo659

I created a BMI program. I am having a problem with rounding numbers. I tried the Double, Constant, and Short. But it still results long numbers. Can anyone he:)lp me. bravo659