Search results

  1. P

    Subform Field

    Ok, I've uploaded a screenshot of the form (and translated all the relevant fields). The field "Topic(s)" is the one on the subform. The idea is to use this form as a means of registering the quality of the answers given to emails which are sent to a (small) Contact Center. Most of the...
  2. P

    Subform Field

    The subform was created in order to capture (and save on a table) more than one topic for a certain subject on a list (multiselection)... I'm using access 2003, by the way.
  3. P

    Subform Field

    Hi I'm working on a form with a subform. The (required) fields are suposed to be filled in a certain order and the fields in the subform are somewhere in the middle. The problem is that Access is making me fill all the fields in the main form first. Is it possibble to solve this issue without...
  4. P

    How to validate sum of fields

    Hello? I still need help with this Thanks
  5. P

    How to validate sum of fields

    Ok, I've done that :o, but the error continues to be ignored. The code works (without stopping the query updating however) when I put it in the after update event of a field (for instance, "Id_Of", or "ScoreMin"), but not on the form's properties, where I need it...
  6. P

    How to validate sum of fields

    Re: How to validate sum of fields (access 2003) I'm sorry, I meant "so that the sum always equals 1" (already corrected in the original message). Anyway, I tried your solution (put the code in the subform's before update event), but it's still not working... Please, check the enclosed file...
  7. P

    How to validate sum of fields

    Hi, I'm running a query in order to find records that have at least one match, based on a form - where I select a certain record - and a subform -where the matching records are displayed. The search is based on four parameters (located in the main form), which are scored from 0 to 1 (passing...
  8. P

    How to score matching results

    Ok, no one replied so far :( but I've found this fairly simple (too simple) solution, in a microsoft forum...
  9. P

    How to score matching results

    Hi, everyone I'm running a qbf based on two main tables (CVs, Ofertas), in order to find records that have at least one match (see enclosed file), and I would like to include in the underlying query (Consulta_CVs) a field containing the percentage of matching criteria, amongst the parameters...
Back
Top Bottom