Search results

  1. R

    If record exist

    Hello All, I'm trying to find out if a record exists in a table. I have searched and found several methods, but I have not been successfull in making any of them work. Here is how I want to implement it; I want to check in a log table to see if an archive has been made for a paticular month...
  2. R

    TransferDatabase problems

    Hello All, I am trying to export a table from one database to another, to be used as an archive. I have tried to use the TransferDatabase method but keep coming up with an error: runtime error '2006' The object name 'C:\Program Files\Commission_Database\Backup\Backup.mdb"you entered does not...
  3. R

    Adding sequential dates via an append query

    Hello Everyone, I'm trying to append a weekly set of records to a table. The current append query adds one record, the StartDate, which works outstanding (Many thanks to DavidR for the help on that). Here is the SQL for that: INSERT INTO tblWeeklyInput ( EmployeeID, StartDate ) SELECT...
    • RickR
    • Thread
    • Replies: 2
    • Forum: Forms
  4. R

    Validation on a form

    Hello All, I have a database where the user enters the hours an employee had worked that week. The number is later used to figure if an employee gets an overtime commission and if so how much. ( a bunch of Chinese arithmetic the IRS dreamed up). Commission changes every quarter hour, so at...
    • RickR
    • Thread
    • Replies: 4
    • Forum: Forms
  5. R

    automaticly adding a set of records to a form

    Hello Everyone, I have a time sheet DB that adds up daily totals for a weekly commission. To do this I have set up three tables to handle this: EmploeeTable: EmployeeID Lname Fname Payrate CommTable: HoursWorked CommissionRate WeeklyInput: WeeklyInputID EmployeeID StartDate Mon Tue Wed Thu...
    • RickR
    • Thread
    • Replies: 8
    • Forum: Forms
  6. R

    Getting extra copies of my report

    Hello All, I've done up a report, and when I go to preview it, there are 3 pages, exact copies of my one report (I have only made one in the report design). I have checked to make sure my page set up is not extended past the 8.5 X 11 standard (and its not white space I get), searched every...
  7. R

    Comparing data in another table

    I have an Excel spread sheet that does calculations for commision. I use a look up table to compare how many hours of overtime a person works and gives me back a value. For example, a person works 41 hours, the multipler for that is 0.012. I am moving this and other calculations to Access. I...
Back
Top Bottom