Search results for query: *

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...

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...

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...

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...

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...

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]))...

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.

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.

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...

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...

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...

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...

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...

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...

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...

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!

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...