Recent content by Loony064

  1. L

    Problem with rounding off values

    Hey everyone! I'm almost finished this payroll system that automatically calculates employee's wages, gross wages, total income, deductions and nett wages, etc based on the info provided (i.e. hours worked and rate/hour). For the most part everything works, except for the total income, total...
  2. L

    Save Record - keeps updating with 1st records data

    Hey guys! I figured it might be easier to have my various questions in seperate posts, to avoid confusion. My next problem is that with two of my tables (Hours Worked and Occupations) when i want to save the records, it places the correct values (taken from text boxes on the form) and sets...
  3. L

    Problems with saving 1st record

    Hey guys I'm pretty close to finishing this payroll program, but i've run in to yet some more problems and i can't figure out how to fix them. So, i have various forms representing different tables of my database (Access - the database is connected to my vb application as a data source)...
  4. L

    Adding new record to database - overwriting first record

    Solved After a much time spent messing around, i managed to figure out a way to get it to work. I placed text boxes on my form over the text boxes used to display the record, and set them to not be visible. then, when users clear the record to input new values for a new record, i make the new...
  5. L

    Poll: How long would it take you to execute a project like this?

    Hey all! I have sort of a random poll for everyone. I’ve been working on a payroll project and as I’m a student and most of the things I had to accomplish for this project I’d never seen before, its’ taken me hours upon hours to code it, but I was curious as to how long (an estimation)...
  6. L

    Adding new record to database - overwriting first record

    Hey all! On my form, there aretextboxes for all the various fields. the user must enter data into the boxes and then click on the "Add Record" button. This will then create a new record with the data the user has entered. It works mostly ok, as it adds the new record onto the end of the...
  7. L

    Sum of fields in report

    Hey all I've created a report to calculate the coinage to give employee's for their weekly wages. In the detail section of the report, i have the employee's name and nett wages, and then text boxes to store how many of each value of money he/she recieves (i.e. R200, R100, R50... - R = RSA...
  8. L

    Insert Into and Delete SQL functions in VBA

    Twoplustwo, YOU ARE AWESOME! I wish i knew to do that before i spent 4 hours trying to do it other ways! thanks a million!
  9. L

    Insert Into and Delete SQL functions in VBA

    Thanks for the help. I'll try that. originally when i tried to delete the record, it wouldn't let me because there were related records in other tables. I have normalised all my tables. If i did it right, it should be in 3NF, but this is the first time i'm doing such a huge project. I'm still...
  10. L

    Insert Into and Delete SQL functions in VBA

    Hey all! I'm currently working on a database for a payroll system. I've created all the tables and the queries to calculate wages, etc, as well as forms so that the user can add/delete/edit/view records. There is an employee table containing details about an employee (employee id - primary...
Back
Top Bottom