𝗠𝗶𝗰𝗿𝗼𝘀𝗼𝗳𝘁 𝗔𝗰𝗰𝗲𝘀𝘀 |𝗦𝗶𝗺𝗽𝗹𝗲 𝘄𝗮𝘆 𝘁𝗼 𝗽𝗿𝗼𝘁𝗲𝗰𝘁 𝘆𝗼𝘂𝗿 𝗲𝗻𝘁𝗿𝘆 𝗳𝗼𝗿𝗺 𝗳𝗿𝗼𝗺 𝗲𝗱𝗶𝘁𝗶𝗻𝗴

Поделиться
HTML-код
  • Опубликовано: 29 янв 2022
  • This video will show on how to protect entry form from editing.
    #MIcrosoftAccess #ProtectEntryForm #MsAccess
    #VBA Masters
    #Sissoko M. Prodev
    / @sissokom.prodev9979
    #Alessandro Grimaldi
    / papillon0365
    ✅ Recommended playlists:
    Worksheet Basics
    • Worksheet Basics
    Microsoft Excel Essentials
    • Microsoft Excel Essent...
    Ms Access Fundamentals Series
    • Ms Access Fundamentals...
    Microsoft Access Essentials
    • Microsoft Access Essen...

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

  • @piotrpiotrek1341
    @piotrpiotrek1341 3 месяца назад

    Thank you very much for another great tutorial. I have used your method in my database and it works! However I have a continuous form and the data is being locked only on specific line I am currently on. I'm a beginner and don't really understand all that Access VBA codes, macros etc "magic" but what I was hoping for is that with clicking a button I would be able to lock certain columns in the form (not the entire form, just some columns). Is there any easy way to do it? Thank you again!

  • @user-dx7hf2ur4w
    @user-dx7hf2ur4w 7 месяцев назад

    Professor, first of all, I thank you for your good effort with us, but if you provide us with a download link for some of the codes that you use to benefit more, I am following you from Libya and I hope so, and thank you for your effort..

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

    Keep it up very informatve

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

    galing nmn sir 💞💞💞🥰🥰🥰

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

    With a little VBA code, there is a more simpler way to do this. I use it all the time on my forms. On your form load event, put me.allowedits=false. This prevents any editing from being done when the form opens. What I usually do, if a user search for a record and want to view the details of that specific record, it opens that record in another form with allowedits set to false. When they want to edit or update that record, they click the update button and it sets the allowedits to true. Usually I change the caption of my update button when you click update, it changes to Cancel so that it undo any changes made and sets the alllowedits back to false and the caption of the button changes back to Update

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

      Thank you so much sir... Thats great idea...

    • @eduardorosalesjr7225
      @eduardorosalesjr7225 6 месяцев назад

      Sir is there anyway to this in macros since VBA is not allowed in our policy?@@KamayoAko

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

    Keep safe po from dasol