Hi,
I have been learning how to Add, Save, Delete, and Update a database table. I created my Database named Employees and a Table named Workers. The Table has the following fields or columns: ID, FirstName, LastName and JobTitle. I made the ID field the primary key. My goal is to be able to add, Delete, cancel new record and to be able to edit existing records. Below is the code for each:
[code=java]
private void btnUpdateRecord ActionPerformed (ActionEvent...
Akinyemi
Last Activity: Oct 13 '10, 07:26 AM
Joined: Sep 16 '06
Location: Jos, Plateau State, Nigeria
-
How to Add, Update, Delete Save and Cancel New a Record
-
How to connect to Database Table in the Embedded JavaDB in NetBeans
Connecting to Database Table in the Embedded JavaDB in NetBeans
Hi,
I am trying to see if I can be using the Embedded Database that is, JavaDB in NetBeans to develop my Java Desktop Applications.
I can create my database and tables in the embedded JavaDB. I can even write my codes for the Program Application. The Problem I face is when I run the Application I receive this message: "Schema ROOT does not exist".... -
My COCINStudent Refused to Compile
Hi,
I used to program in Vb 6 before I migrated to Java a year ago.
I wrote a program for keeping student information. I now decided to write the same program in Java. I designed two classes: Person class and COCINStudent class. The Person class compiled, and ran well, but the COCINStudent class compiled without the main class. With the main class, the compiler complained that it cannot see me COCINStudent class. I have tried all I... -
How to convert user input to Date
Hi,
I started learning Java a year ago. Before then I had written a Visual Basic Program that maintains student information.
I now want to write the same program in Java. But I do not know how to convert user input to Date. For example the user will have to type in the student's birthDate, yearOfGraduatio n, etc?
I have read some tutorials but couldn't figure out anything as there were no relevant examples.
Suppose a... -
How do I connect MYSQL to Eclipse?
Hi,
Please, how do I connect MYSQL to Eclipse?
I have made several attempts but fialed.
Thank you
Akinyemi -
How to Calculate Year To Date Values
I am still on the Payroll Program I have been developing. I want the Program to compute Year to Date (YTD) values for Basic Salary, Allowances, Deductions, Net Pay and Tax.
I have tried and tried but have not been able to write the codes.
Kindly help me.
Thank you.
Akinyemi -
How to Compute Year to Date (Values)
I am devloping developing a payroll program.
I want the program to compute Year to Date (YTD) values for Salary, Allowances, Dedections, Tax, Net Pay. I have tried very many times to write the code but could not succeed.
Below is what I did but it is not working:
Option Explicit
Dim ConSalary As Currency
Dim RentAllow As Currency
Dim GrossPay As Currency
Dim YTDConSalary As Currency
... -
Honesty I dont know how to save the pictures with the proper names of the employees and how to save the filename in a master table as a field.
Kindly assist me on how to do exactly that.
Thanks
Akinyemi. -
How to set different periods for a Payroll Program
I have almost finished writing my Payroll Program. But I am wondering how the program can be used for different months. For example, after, say January 2007 Payroll, the user would want to prepare February 2007 Payroll.
How will the user close January payroll and then start that of February?
I cannot figure out how to write the Program for that.
Please kindly help me.
Thank you.
Akinyem... -
Loading a Combo Box with Employee Names
I am developing a Payroll Program. I have created a Database Table in Ms Access 2000. I have placed Text Box controls on my Vb 6 Form including a Combo box.
I want to fill the combo box with employee names when the Form loads. I have tried to write codes that will do this, but can't get it done.
Please kindly assist me. What is wrong with the following codes?:
Private Sub Form_Load()
With adoSubjects.Rec ordset... -
Akinyemi started a topic Postioning Name and Image of Employee in MS Access 2000 Database on VB Formin Visual BasicPostioning Name and Image of Employee in MS Access 2000 Database on VB Form
I am creating a database in MSAccess 2000 for my Payroll Program I am writing. I want to save an image representing an employee in the record of each employee. I then want to post the name of each employee and the image I have save in each record of each employee on Visual Basic Form.
How do I do this?
I need your help.
Akinyemi -
Thanks for your interest in helping me.
In Nigerian tax system, Assessment is based on Calender year: 2005 Assessment Year; 2006 Assessment Year etc.
The user of my tax software is expected to enter in the Assessment Year Textbox "2005" or "2006" . In 2007 the user will be expected to enter 2007 in the Assessment year textbox. That is how our tax system is.
I used Integer. It didn't work....Leave a comment:
-
Using codes to create Database Table
I use Ms Access 2000 for my Database Tables.
I tried to use code to create a Database Table for the Tax Software I am developing instead of creating it manually.
Initially I wrote each field on a separate line. But when I wrote above 10 lines VB complained that the statement should not exceed 10 lines so, I then wrote this statement :
Dim conPaye As ADODB.Connectio n
Set conPaye = New ADODB.Connectio n... -
Run-Time Error -2147217904(80040e10)
I created a Database which I named "Address".
I went through the Control Panel and created a DSN to enable me connect to the Database through ODBC.
I then created a Form with the same fields as that of the Database. I wrote the necessary codes and ran the Program. Below are my codes and the runtime error I received:
Run-Time Error -2147217904(8004 0e10):
[Microsoft] [ODBC Microsoft Access Driver]... -
Formating Inputes
I am currently puting finishing touches to a Tax Computin Software. But I am worried about the number of decimal place the program displays - Four decimal place. And some of the fields display only one decimal place while some do not at all!
The program has Basic Salary, Housing Allowance ..., Gross Pay , Reliefs, Taxable Pay, Annual Tax payable, and Monthly Tax Payable fields. I declared all the variables As Currency.
... -
How to Create A file to save data in Database Program
I am a newbie in programing. My Tax Project is nearing completion. I have started to think about deployment. But I dont know how to make the user create a file to save his work when he runs the program.
I know that of Text Files. But when it involves a database like my Tax software or Payroll, I can't just figure out how to go about it.
Please, I need your assistance.
Thank you.
Akinyemi. -
Pringting Payslips
I am very grateful for the help I get from this Forum. I pray God will continue to bless all of you.
As I have earlier told the Forum, I am developing a payroll program. I have been trying to figure out how the program can print out payslips for about 1000 or more employees. I have no idea about the code for that.
I can create the fields needed for the payslip in the Data Report that ships with Visual Basic 6, but have... -
Validation of Inputs to Text Boxes
In the Tax computation Software I am developing, I want only numeric characters to be accepted by the Text Boxes. Bellow is my sample code that refuses to work:
Private Sub txtBasicSalary_ KeyPress(keyAsc ii As Integer)
If IsNumeric(txtBa sicSalary.Text) = True Then
txtBasicSalary. Locked = False
Else
txtBasicsalary. Locked = True
End If
End Sub
Thank You.
Akinyemi -
Re: Using Sql to Delete a Record in Vb 6 Ms Access Database Table
Thank you for your interest in helping out. Here is my code that refuse to work:
Private Sub cmdDelete_Click ()
Dim Sql As String
Dim intResponse As Integer
intResponse = MsgBox("Are you sure?", vbYesNo, "Delete query")
If intResponse = 6 Then
Sql = "Delete * From PAYE Where [Tax Payer ID]"...Leave a comment:
-
Using SQL in to Delete a Record in Database Table
I am currently using Visual Basic 6 to write a Payroll Program.
I created a Database with one Table in Microsoft Access that ships with Office 2000. The name of the Database is "Payroll", and the name of the Table is "Emoluments ".
I then usedcActiveX Data Control (ADO) to connect the Text Box controls on the Form to the Table. I have the following fields in the Table and the Form: Assessment Year,...
No activity results to display
Leave a comment: