Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: TigerNoire
  • Content: Threads
  • Order by date
  1. TigerNoire

    Subform within subform dilemma

    Hi, I have a database that I am trying to generate a work call form in which all data regarding hours worked is saved to a show. The basic idea: Show and Call - Main Form Job - Subform 1 Employee - Subform 2 The design is supposed to allow easier viewing. The main form is unbound...
  2. TigerNoire

    Report layout issues

    I'm trying to generate a report that will bring out information like the following: Team 1 Team 2 Team 3 Show 1 Date Time In Date Time In Date Time In Show 2 Date Time In Date Time In Date Time In Team names are a list box that I would need...
  3. TigerNoire

    Help - Creating Archive DB and Linking to Current DB

    Hi, I currently administer a massive database to calculate payroll. As of June 30, all wage rates are changing for the new fiscal year. What I need to do is preserve all historical data, hopefully in an archive db,(wage rates, dates worked, hours worked, etc.) and allow for the new rates and...
  4. TigerNoire

    Linking database possibility?

    Hi, My question is kind of vague but here's my situation... I have two databases, one to track payroll and one to track vacation/sick time. Some, but not all, vacation/sick time info comes from the payroll database but is manually entered into the vacation/sick time db. Is it possible to get...
  5. TigerNoire

    Nested IIf Dilemma

    Happy Almost New Year! What I have: tblVacation Hours Granted VacPurchased VacCarryOver VacMarch VacJune Case 24 120 40 40 1 12 60 30 30 2 0 80 20 20 3...
  6. TigerNoire

    Use a Value Based on Date

    I'm currently building a vacation/sick time database with the intention of tracking an employee's time that is granted, used, and when. I've completed this part of it. After showing this to my supervisor, he added the fact that vacation time can be used after two specific dates if the current...
  7. TigerNoire

    Doulbe IIF statement possibility?

    I've built a timesheet/payroll database and I have one part left to complete in it. What I have (a sample): ProjID RegHours OTHours RHours D04Beer 3.5 0 3.5 M04Rats 4 0 4 Pfront 6.5 0 6 Pbox 4 0 4 Pbox 7...
  8. TigerNoire

    How do I deduct for lunch time?

    Hello, I've built a database to keep track of payroll information and I need to have it automatically deduct a half an hour if the person works more than six hours. The complicating factor is that I only need the deduction if the person is in a certain department and worked a certain project...
  9. TigerNoire

    Security - too much info to decifer

    Hi, I've come across so much information on Microsoft Access and how to implement security, I'm all sorts of confused on where to even start with my problem. The general idea: I have built a database that I need to define user-level security for. The database will be located on a network...

Part and Inventory Search

Back
Top