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

Thank you for your replies. The problem I am having is figuring out how to get the date entered to pass through this module. Could you give me an exapmle of an AfterUpdate event for my field? It is a txtbox named:BlockIStartDate Thanks again. ARFF Marine

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

Nikita6003, You get a star for the Exit Sub post. I was pulling my hair out over a blank error message. ARFFMarine

Of course....Thanks for your help AceMan1

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

I think I got too involved with not making one of those posts that makes no sense due to lack of infomation. What is happeining is the total missed will total, the total students tested, and the total of each version administered will sum without the date field. Once you add the date field...

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

Thank you for your replies. dhookum in reply to your response: The string you posted was right on the money. The problem was the text fields in my form were not named properly. I did not post the full SQL because the problem was fixed. The form will remain open until close by the user...

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

I finally got this working but had to rebuild the database. I can send anyone who is interested the VB Script I used. Thank you for your help FormerTexan. I had to tweak what you posted but was able to get there.

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 read up on the Microsoft website about the OLE problems. I tried disabling script blocking and disableing the Norton Office Plugin but to no avail. i think te best thing to do is abandon the idea.

Error Message: The expression On Click you entered as the event property settin produced the following error: A problem occured while Microsoft Access was communicating with the OLE server or ActiveX Control. *The expression may not result in the name of a macro, the name of a user-defined...

PH, I have a form, "Student Information", with three tab controls titled "Student Information", "Failures", and "Firefighter PT Program". The "Firefighter PT Program" tab is the one i want to not be visible unless the "Assigned to Firefighter PT Program" check box is checked. The tab # for the...

I tried but i keep getting an error message. If it helps, the form name is "Student Information" and the tab is named "Firefighter PT Program". By the way, where in TX are you from? I live in San Angelo.

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