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

  • Users: ArffMarine
  • Order by date
  1. ArffMarine

    List box on Switchboard

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

    A DateAdd Function that adds (x) amount of Working days

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

    A DateAdd Function that adds (x) amount of Working days

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

    Blank Error Message

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

    Custom Date Format

    Of course....Thanks for your help AceMan1
  6. ArffMarine

    Custom Date Format

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

    Remove #Error when calculating FROM a subform

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

    Aggregate Queries and date ranges

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

    Aggregate Queries and date ranges

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

    Query date range from unbound form

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

    Query date range from unbound form

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

    Tab contorls visible based on checkbox

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

    Same 24 pieces of information on 7 different pages

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

    Tab contorls visible based on checkbox

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

    Tab contorls visible based on checkbox

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

    Tab contorls visible based on checkbox

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

    Tab contorls visible based on checkbox

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

    Tab contorls visible based on checkbox

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

    Copy value of text box on from form to a subform

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

    Forms and Subforms related to combobox query

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

Part and Inventory Search

Back
Top