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!

Register Log in
  • Congratulations Chriss Miller 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: airbus2
  • Content: Threads
  • Order by date
  1. airbus2

    DB Design is a big Brain Twister

    I have a training db desinged to create classes and maintain employee records of classes attended. With the current db design,when a new class is created, a class title is required to be typed in the "class name" field and then any assignments that are required (ie. Quiz, Test, etc.) have to be...
  2. airbus2

    Trying to eliminate double work in tables

    Hello all, At the moment I have two unrelated (atleast within the db) tables. One is "Employees" the second is "Instructors". All of my "instructors" are also employees. Both tables have the same type of info (ie. firstname, lastname, employee-number, etc.) Is there a way to add a field to my...
  3. airbus2

    Merging Last and First names and a Yes/No question..

    My DB has a table that lists our school Instructors. With three of the text fields being "Instructor", "FirstName", "LastName". How can I get the "Instructor" field to show "LastName, FirstName" I can create it using an "unbound" on my "Instructors" Form but I want it in the table if possible...
  4. airbus2

    Side Tab Navigation on DB

    I have seen db's that have tree like sidebar navigation buttons on the left side of page that also displays subnavigation options. The main box to the right shows the results of the sected button. Like what you would find on a web page. I have been searching for info on how to construct this...
  5. airbus2

    Formula to change available seats

    I am creating a event/class scheduler DB. I am wanting to create a formula that takes max available seats for each class (entered by user) minus number of attendees (auto increased every time a person is enrolled to the class) that will auto reduce number of seats available. I also have seen...
  6. airbus2

    Need To Add another Field to this Query string

    Hello, I need help adding another field to this name string. I cant quite figure out where to add the MiddleName field to this: Contact Name: IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name]))...
  7. airbus2

    Updating VB when changing field names

    I have to overhaul a db. When I change a Form or table name or field name, is there a way to auto update VB without going into each statement and updating the code. There are literally 100 of them.
  8. airbus2

    Updating Access 2007 VB

    When I change a Form or table name or field name, is there a way to auto update VB without going into each statement and updating the code. There are literally 100 of them.
  9. airbus2

    Form that shows data from two tables

    I need help walking through the steps of making this form. I have two tables, 1)employees and 2)benchmarks. The benchmark table fields are: benchmarkID (primary), employeeID, date completed, and status. The employees table has all the normal employee fields (Last name, first name, position...
  10. airbus2

    Two tables one form

    I have a simple question to a complex structure. What is the best way to setup this example? I have 10 employees identified by their employee number in one table called "employees". In another table I have 15 courses that they have to take (test 1, test 2, test 3, etc.). I want a form...
  11. airbus2

    Matching one Table to another.

    I have a simple question to a complex structure. What is the best way to setup this example? I have 10 employees identified by their employee number in one table called "employees". In another table I have 15 courses that they have to take (test 1, test 2, test 3, etc.). I want a form...
  12. airbus2

    Subform shows only location ID and not location name

    My employee database is displaying individual info of each employee through subforms because there is so much info. All subforms where info is linked from the employee table is fine. I have one field "Location" displaying where the employee is located. This info is being pulled from the...
  13. airbus2

    Need Code to do Record Search on Form

    Hi guys, I know this is an Access 101 question but her it goes. I have a form called Employees, with a control source of tblEmployees. The form also has numerous subforms attached linked via parent/child and is working fine. All these forms are based on "EmployeeNumber" I want to have a...
  14. airbus2

    Dates! Dates! Dates! Im stressing over Date codes. HELP?

    Hi guys!! I have a real brain teaser with dates on my database. I am trying to place the right codes in the respective fields. OK, here we go. I am keeping track of 6 date fields: 1)WBT_Initial (Web Based Training Date Initially completed) 2)WBT_Recurrent (Date taken aproximatly 1 year after...
  15. airbus2

    Three Tab Subform help

    Hello all. Is there a way to have data from three tables represented on three separate tabs on one subform? If so how do I do this. The main form has basic employee info. The other fields have specific info on the employee that I would like to have populate when the record from the main form is...
  16. airbus2

    Pulling Table Information into a form

    What are the right steps to pull a single employees info (location, e-mail, phone, etc.) into a form thats based on entering an employee number into a currently unbound field. Once I get that down, I then need to pull info into a subform. I read thread702-1459007, but got confused. HELP!
  17. airbus2

    WILL WORK FOR CODE! Need help with date fields

    I have to track when an employee initially recieved their badge, the day it expires, and the day they actually renewed it. The first field is a date field called "Initial", it represents the date they were issued a badge. The second date field called "Recurrent" represents the date the employee...

Part and Inventory Search

Back
Top