Search results

  1. M

    Events - What is evaluated first.

    In what order, are events processed ? I have an event on a field that must check the following. 1. Is there data in the field (I have placed this in the "Lost Focus" event) 2. If there is data, then generate an account code. (This has been placed in the "After_Update" event. 3. I also want to...
  2. M

    Further Summary details

    Hi All I have a database that records the Maintenance & Repair costs for vehicles, per Department. I have got the report to give me the usual summary details as follows. Department 1 Vehicle Name1 Repair Item 1 Cost1 Labour1 Repair Item 2 Cost2 Labour2 Total...
  3. M

    Add to NotInList - Possible solution & questions

    Not in List I have a form that is based on a single table. On this form I have 2 combo boxes where the recordsource = CollegeCode (A field in the table) Combo36 is set to Limit to list = Yes Visible = Yes Tab Order = 0 (First field on the form) CollegeCode is set to Limit to list = No...
  4. M

    Simple "Month End"

    I am constructing a database that keeps a records of the hours worked as well as the repair & maintenance costs for forklift vehicles in the company. The idea being that at the end of each month the system generates a report that will identify the running cost per hour for each vehicle. I am...
  5. M

    Add to combo box

    I have a form which shows all the details about a college. Each college has a code (string) to identify it. This code is displayed in a combo box that is limited to list of valid codes. If the user types in a value that is not in the list, a message asks the user if they want to add the new...
  6. M

    Using code to validate existing data

    I am an extremely frustrated (And/Or slow) learner who has been trying to learn how to use code in "M.S.Access" (On and off for about a year now) but without much success. I have embarked on what should be a VERY simple "Timesheet" project. Its easy to add and edit records using the Switchboard...
  7. M

    Access keeps adding a blank record on subform

    In trying to learn how access (And VBA) works, I am writting a "contact management" application whereby users need to make telephonic contact with someone and then record what was discussed. The parent form contains data about the contact. The subform records the "DATE" and the topic of what was...
Top Bottom