Recent content by airbus2

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

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?

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

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

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

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

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

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

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