Search results

  1. A

    Disallowing Edits Not Working

    Thank you @Gasman! I appreciate all the time you put into helping me out.
  2. A

    Disallowing Edits Not Working

    Pat - Thank you! That actually made sense to me and better yet it seems to have worked! I appreciate everyone's help and time. Have a great day! :)
  3. A

    Disallowing Edits Not Working

    So I've been recreating the form as @Gasman suggested and testing step by step. This code suggested by @Pat Hartman yesterday works as expected (saved records can't be accidentally edited but new records can be created).... Private Sub Form_Current() If Me.NewRecord = True Then...
  4. A

    Disallowing Edits Not Working

    Spoke too soon. Now I'm getting this error. I should note that I do have all the various fields set to Required at a table level to ensure my data entry guys can't skip out on adding vital information. Will this interfere with the .Dirty VBA?
  5. A

    Disallowing Edits Not Working

    @Josef P. That seemed to do the trick! Thank you!! If you don't mind - can you tell me why that fixed the problem incase I run into something similar in the future?
  6. A

    Disallowing Edits Not Working

    @Gasman Thanks for your help on this. I tried making just a simple form and it does seem to work. So I'll try remaking the form from the ground up and hope that works. Hopefully I can keep the same type of formatting and functionality as the original. :)
  7. A

    Disallowing Edits Not Working

    I have an admin form (that certain members of my team can access) that will allow edits to fix any mistakes that happen or fix missed types. I wouldn't just leave incorrect data without it being corrected.
  8. A

    Disallowing Edits Not Working

    Do you know if there is a setting I could have accidentally hit that makes alternate odd/even records some how? Or would it have more to do with 1 & 3 being Pass in the Results combobox and 2&4 being Fail?
  9. A

    Disallowing Edits Not Working

    I copied and pasted your original code exactly how you put it in your response. I saved it. Closed the VBA screen. That look me back to my form in Design View. I saved my form for good measure and closed the form. Then I re-opened the form. Clicked on a text box located in the first...
  10. A

    Disallowing Edits Not Working

    My apologies. When I'm looking at the code and such I just right click on the login screen and close it. You can use username: doejane pw: dog The specific form I'm having issues with is "frmRecordKeeping" You can get to it after the login screen Forms > Results Again I apologize for the...
  11. A

    Disallowing Edits Not Working

    @Gasman realized that was a dumb question as soon as I asked it. DB attached.
  12. A

    Disallowing Edits Not Working

    Do you need tables included or just the Forms?
  13. A

    Disallowing Edits Not Working

    I know that I'm doing something wrong. I just don't know what. Below is all the code that is on the Form in question, including the code Pat suggested earlier in this thread. I am very much a novice with VBA so I've been kind of piecing things together through Google and reading threads here...
  14. A

    Disallowing Edits Not Working

    I tried your code and it is still allowing edits on previous records. Any other ideas?
  15. A

    Disallowing Edits Not Working

    I have a Form that my team uses to enter test results. What I would like to have happen is once the results have been entered my team can go back and look at previous records but not be able to change them while still being able to add new records. I've gone into the Form's properties and set...
  16. A

    Query for Pass/Fail/Totals

    Thank you SO much! That's exactly what I needed.
  17. A

    Query for Pass/Fail/Totals

    Thanks for your help however I'm getting the attached Syntax error. Did I type something in wrong?
  18. A

    Query for Pass/Fail/Totals

    My team tests items from several teams for functionality from various teams in my company. We rate them as Pass or Fail after testing is complete. What I'm needing to do is hopefully create a query that will count how many of each Pass and Fail and then a total of Pass+Fail for a total amount...
  19. A

    Hello

    Hi! I'm Ashley and I'm new to the forum and fairly new to Access. I'm at the level where I can figure some things out with YouTube and Google and know that I should be able to do something or that I am doing something wrong but can't quite figure it out. I'm glad I found this forum and I'm...
Back
Top Bottom