Search results for query: *

I have a switchboard with 10 option buttons. On the switchboard I have a list box that give a snapshot of classes enrolled in our academy. I want the instructor to be able to double click on his class in the list box and be taken to his class on the form [classinformation]. The switchboard form...

I have read two seperate FAQ's on this subject (faq702-4851 and faq181-261). Neither one seems to fit what I want to do and if they do, I don't know how to apply them. We have a 64-day course that is broken into six blocks of instruction. What I want to do is enter the start date of Block I and...

I want to create a custom date that is displayed "YYYYMMDD" for example: November 10, 1775 would be 17751110 and August 7, 1942 would be 19420807. I have tried using the input mask as "99990000,0,_" but the text box and table will not accept input as properly formatted. The date and month must...

Anyhting that is in quotes ("") is the control source for the specified text box or the name of a form or table. We are using Microsoft Access to calculate teaching hours for instructors at our academy. For each class taught, there are two instructors assigned. These instructors are titled...

Let me apologize in advance for the long code but I always see posts that ask for it so I decided to include it from the jump. Here is my vision: We have 2 tests that are administered to students at our fire academy, the midblock exam and the end-of-block exam. Each exam has 2 versions to...

I have a table titled TestAnalysis This table stores information on the number of students in a class who missed questions on two seperate exams. The exams are administered to the students on two seperate dates. Each quarter we analyze the number of missed questions to validate our tests. What...

Here is my dilemma: I am creating a database to replace an old Excel program. The database will be used to track students attending a firefighting academy. We have pre-designed forms that must be used to track student progress through 23 different learning objectives. These objectives are listed...

I have a form with three tab controls. I want the third tab to be visible only if a box is checked on the first tab. The check box is checked if a student is assigned to a physical fitness program. The third tab contains the information on the fitness program. If the student is not on the...

I have two tables I use to store information on new classes. The one table titled “Class Info” stores the class number, instructor names, and class start and graduation dates. The onther table, titled “Student Information” stores information on students in the class such as name, social security...

I’ve posted questions here before with success so I am going to try again. I am creating class rosters for a fire academy. I have three tables titled “Class Info”, “Student Information”, and “instructors” I want to create a class roster that uses information from the Class Info table and the...

I am trying to build a database that will allow me to track students and instructors at a Department of Defense formal training academy. I have seen this repeatedly on this site but am not grasping the concept. I have a basic knowledge of how to put together a database but all my knowledge...