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: *

  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

    Thanks Golom, Being the novice that I am, I did not quite understand what I am to do with this information. Where am I placing this code?
  3. 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...
  4. airbus2

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

    One record has the five certification date fields. Thank you sooooooo much. It worked! Imagine that? lol. Im slowly getting there, be patient with me. How do I get the [Valid Through Date] field to not show error when there is no date in the CertifiedDate field? Im using this formula...
  5. airbus2

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

    Excuse me for not explaining this is a cohesive way. Each instructor has five (one year) certifications that they need to maintain. I have three fields for each certification 1) [Certified Date] (Date they took their certification class. 2) [Valid Through Date] using this formula...
  6. airbus2

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

    No reason. Not sure what part of my request for help you are refering to though. The first section as it relates to the name; I was just wanting to know if there is a way to store it in a table. If not, thats cool. The second part of my question; I have attempted numerious calculations to no...
  7. 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...
  8. 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...
  9. 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...
  10. 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]))...
  11. 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.
  12. 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.
  13. 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...
  14. airbus2

    Two tables one form

    So, what would be the better way to go? 1) Creeat a table called "Tests" and have each individual test be identified as a "field" with the controling ID being the Employee Number. Or 2) that same tables "fields" represent specifics about each teat (score, passed, time, etc), and the actual test...
  15. 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...
  16. 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...
  17. 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...
  18. airbus2

    Need Code to do Record Search on Form

    THANKS GUYS!!! IT WORKS GREAT!!!! One questions though. Actually 2 questions. First, Building on what we have, how do I make the entire EmployeeInfo form blank when a user initally selects it? Currently it goes to the first record in the database. Also, when a user enters the employee number...
  19. airbus2

    Need Code to do Record Search on Form

    Hey guys, in adding rs.FindFirst "EmployeeNumber=" & Me!EmployeeFind I am getting error message 3464.
  20. airbus2

    Need Code to do Record Search on Form

    I created a new db with one tbl & one form. Here are the parameters Table Name: Employees Form Name: EmployeesInfo Field Name: EmployeeNumber Unbound Field Name: EmployeeFind (This is where the employee number is entered.) The code was placed in After_Update on the EmployeeFind field. When...

Part and Inventory Search

Back
Top