Don't Delete! Marking Records Inactive. When and When NOT to Hard Delete Data in Microsoft Access

Поделиться
HTML-код
  • Опубликовано: 20 окт 2024

Комментарии • 23

  • @ajc1233
    @ajc1233 3 года назад +2

    My senior project team is making a small database to assist a non-profit organization with scheduling and this is helpful. A lot of your videos were actually.

    • @599CD
      @599CD  3 года назад

      Sweet!

  • @sharongardner9254
    @sharongardner9254 3 года назад +1

    A huge help and a practical solution, thank you

    • @599CD
      @599CD  3 года назад

      Glad you approve. :)

  • @stephenbeswick2163
    @stephenbeswick2163 Год назад

    Hi Richard just watched you deleting video excellent Infomation many thanks steve B

  • @janniazi3061
    @janniazi3061 4 года назад +1

    Love your work sir .....from Pakistan

    • @599CD
      @599CD  3 года назад +1

      Thanks... from Florida.

  • @jasepotts2865
    @jasepotts2865 Год назад

    Good morning, great video. I have just one question. If you use a combo box to select a User on form A and you later inactive that user on Current Users table, how do you stop that user being removed from the previous selection? If I delete the user it says #deleted.

    • @599CD
      @599CD  Год назад

      599cd.com/ask

  • @saberahmed9293
    @saberahmed9293 3 года назад +1

    Very useful video . Thank you

    • @599CD
      @599CD  3 года назад

      You are welcome

  • @hr.sanders
    @hr.sanders 3 года назад +1

    thank you sir. great and useful as always.

    • @599CD
      @599CD  3 года назад +1

      You are very welcome

  • @3sisterscraftspnw
    @3sisterscraftspnw 2 года назад

    I'm a Silver member and using Access 16 (365). This code doesn't work for me. I've tried several times, watching this video over and over. Does this code work for the version of Access I'm using.

    • @599CD
      @599CD  2 года назад

      599cd.com/Ask - I need more specifics. What code exactly? 99% of all the code I post works in every version of Access.

    • @3sisterscraftspnw
      @3sisterscraftspnw 2 года назад

      I was getting the message data mismatch. I figured it out. My form has a combo box that's a number and the other was a text. I was able to fix the code so it would run correctly. Thanks for getting back to me.

  • @yourstrulyAdrija
    @yourstrulyAdrija 2 года назад

    Does this work on views too? I have a view where i need to remove bulk data but not to delete those rows. How shall i modify the query. It uses view by the way

    • @599CD
      @599CD  2 года назад

      You just add the soft delete field to the table. Doesn't matter if you're using an SQL view or an Access query.

  • @citabyrd-reid807
    @citabyrd-reid807 3 года назад

    I am unable to view the video - comes up as squiggly lines. do you have to be a member before you can see it?

    • @599CD
      @599CD  3 года назад

      Nope. That's not a member-only video. It should play fine. Nobody else has complained, so I'm assuming it's a problem on your system.

  • @AlexandruJalea
    @AlexandruJalea 3 года назад

    Thanks.

    • @599CD
      @599CD  3 года назад +1

      Welcome!