Why Does My Form or Query Say "This Recordset is not updateable" in Microsoft Access?

แชร์
ฝัง
  • เผยแพร่เมื่อ 3 ต.ค. 2024

ความคิดเห็น • 19

  • @RichBx
    @RichBx 3 ปีที่แล้ว +1

    Richard, you are great to watch on TH-cam to learn some of the Access principles! You e taught me a huge amount!! Thanks, and keep 'em coming!! "There is a way out of every box, a solution to every puzzle; it's just a matter of finding it." (ST)

    • @599CD
      @599CD  3 ปีที่แล้ว

      Thank you for the kind words. Glad you enjoy!

  • @foxbox7929
    @foxbox7929 3 ปีที่แล้ว

    Thank you for your wisdom sir!
    Ran into someone complaining about a "non-updateable" issue on one query but not another-- now I have something to look for on someone else's database XD

    • @599CD
      @599CD  3 ปีที่แล้ว

      Glad to help

  • @anybody007_who
    @anybody007_who 2 ปีที่แล้ว

    very important topic. Such a simple thing can mess things up; hard to find by any novice like me.

    • @599CD
      @599CD  2 ปีที่แล้ว

      Yep

  • @wumniam
    @wumniam 2 ปีที่แล้ว

    Thank you!

    • @599CD
      @599CD  2 ปีที่แล้ว

      Welcome

  • @isaacjoma6312
    @isaacjoma6312 ปีที่แล้ว

    Hi Richard B. Why my text box does not shows calcs automatically, until I chose and open the form... tahnks

    • @599CD
      @599CD  ปีที่แล้ว

      No idea. Not enough info.

  • @deondraedwards3880
    @deondraedwards3880 3 ปีที่แล้ว

    Hi great video! But what do I do if it is not allowing me to even access design view so that I can input the primary key?

    • @599CD
      @599CD  3 ปีที่แล้ว

      Sounds like you've got a bigger problem with your database. 599cd.com/Trouble

  • @mohamedelghareb4755
    @mohamedelghareb4755 3 ปีที่แล้ว

    Thank you
    I have a query
    If I have a report and a group operator in the name of the company, and I want to make a different arrangement for the names of these companies
    So how is it possible since the available arrangement is alphabetical and I want it to be custom arrangement

    • @599CD
      @599CD  3 ปีที่แล้ว

      Add a custom sort field. 599cd.com/CustomSortOrder

  • @dougandchelle
    @dougandchelle 2 ปีที่แล้ว

    Hi, I have this problem on all fields in my database. Was working fine last week but today I cannot add or edit any information on my database. I get the error This Recordset is not updateable". I checked and the database does have Primary Keys. Any ideas please? Thanks in advance.

    • @599CD
      @599CD  2 ปีที่แล้ว

      599cd.com/NotUpdateable

    • @599CD
      @599CD  2 ปีที่แล้ว

      599cd.com/Trouble

  • @theresiakanva4138
    @theresiakanva4138 2 ปีที่แล้ว

    Hi, i have a problem. I making a simple form and the result will showed on query transaction. But, after i fill the form, the query doesn't showed all my field. Any solution? If u need my video about my problem, i can send through ur email, lemme know your email!🙏

    • @599CD
      @599CD  2 ปีที่แล้ว

      I'd need to see it to help you, but I don't accept files via email. Post in my Forum: 599cd.com/AF