Search results

  1. N

    Solved Checking value of all controls in a continuous form

    I don't want to save any record at all, since the user will not have access to the tables and won't easily know which employee's record has been updated and which hasn't
  2. N

    Solved Checking value of all controls in a continuous form

    Hi all I have a continuous form which helps me keep track of which employees have passed which course. The way db has been structured, is the data from the continuous form gets saved in a temporary table, and only gets copied to actual table when the data is all OK i.e., all records have...
  3. N

    Solved Issue with checking duplicate values

    Just to update everyone, I figured out the issue. In the multiple DCount criteria, I was checking whether the combination of Position and Course existed in the source form. What needed to be checked is if the combination of PositionID in the source form and the CourseID from "target" form exists...
  4. N

    Solved Issue with checking duplicate values

    Something funny is happening, this code either does not prevent duplicates at all, and at other times triggers the message box every time I try and enter a new course :(
  5. N

    Solved Issue with checking duplicate values

    I understand what you are suggesting but the SQL is beyond my understanding, unfortunately. Is there an alternate (and possibly, simpler) way in vba?
  6. N

    Solved Issue with checking duplicate values

    Hi Solo Apologies for delay in getting back. I have tried the approach you suggested but I still get the msgbox. Any ideas why this might be? Thanks
  7. N

    Solved Issue with checking duplicate values

    Makes sense. Let me give this a go and get back to you. Thanks Solo :)
  8. N

    Solved Issue with checking duplicate values

    I was under the impression that the and condition will look for combinations :oops: this code is under the target form's course combobox, beforeupdate event.
  9. N

    Solved Issue with checking duplicate values

    This question is in continuation to a solved thread: https://www.access-programmers.co.uk/forums/threads/openarge-error-you-cant-assign-a-value-to-this-object.327824/#post-1878884 For the same source and target forms, I am trying to check if the combination of PositionID and CourseID already...
  10. N

    Solved OpenArge error "You can't assign a value to this object"

    That actually resolves my ick as to why .defaultvalue was not working for me. Cheers, bastanu :)
  11. N

    Solved OpenArge error "You can't assign a value to this object"

    Thanks, Pat. I have seen these videos before and they are great help in clearing up quite a few concepts!
  12. N

    Solved Error Handler always triggering

    I stumbled across this forum https://www.access-programmers.co.uk/forums/threads/f5-and-f8-not-working-in-vba.312940/ and it makes sense since almost all of my code are control-based and form-based. Thanks for the tip though!
  13. N

    Solved OpenArge error "You can't assign a value to this object"

    yes you were right about that! thanks, Ive fixed that :)
  14. N

    Solved OpenArge error "You can't assign a value to this object"

    Ahaa! BeforeInsert works perfect! I still got the same error as in the original post whether I tried Open or Load event, nor the default property worked. Thanks as ever, Pat!
  15. N

    Solved OpenArge error "You can't assign a value to this object"

    I get compile error that .DefaultValue method method or data member not found
  16. N

    Solved OpenArge error "You can't assign a value to this object"

    113 is not the PK for the table behind these forms. 113 is rather an FK
  17. N

    Solved Error Handler always triggering

    Thanks. will try it first thing tomorrow morning
  18. N

    Solved OpenArge error "You can't assign a value to this object"

    Yes. Its bound to the table where the record for role vs training will be saved
  19. N

    Solved OpenArge error "You can't assign a value to this object"

    I will have to edit a lot of things to post the db, unfortunately, but here are the images. Source form: Target form: the textbox in the footer showing 103 is the PositionID from source form i.e., First Aider.
  20. N

    Solved OpenArge error "You can't assign a value to this object"

    I have seen another post where deleting the target control fixed the issue, but it hasn't worked for me unfortunately so here goes. I have a combo box with PositionID, PositionName on a form with a listbox below which shows related training record to that PositionID. I have another form, a...
Back
Top Bottom