DLOOKUP: If Search Id is not found, then add it as a new record.

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

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

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

    all thumbs up for allowing us to download the program. Great help with the code. Thanks a lot Edcelle for your valuable knowledge.

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

      You are welcome. Thanks for watching. Your comments are highly appreciated.

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

    That's great! You're a genius

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

    Hello Mr John, I hope you be fine
    I'm thankfull of your great tutorials,
    I faced to a problem, my access database project hide or remove all forms, quires, reports after somedays automaticaly , just all the tables are remane with all records in !!
    how can i solve this problem?
    thank you

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

      Maybe you have split the database.
      The table Will be separated from other objects.

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

      good idea, but I don't mind that I splited before!!
      it made me in troble!
      @@EdcelleJohnGulfan

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

    Great

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

    Hi Gulfan. I repeated your step by step tutorial in a new db in Access 2007. Everything works except the last statement, " Else Me.txtResult = StrResult ".
    In the txtResult textbox, it does not return me the EmployeeName field present in the Employee table. Where is the problem? Thank you.

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

    sir, how do you make a search report with multisearch and the results can be previewed and printed out?

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

      Sample
      th-cam.com/video/APQVs3FpebY/w-d-xo.html

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

    thank U Mr Gulfan

  • @Abdullah_Alhathloul
    @Abdullah_Alhathloul 6 หลายเดือนก่อน

    Nice , thank you

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

    Hi asked you you could do a video on access when you complete o from it will change colour say light blue to Green to state this form all fields have been completed could you please do a video on this for me I have users with poor eye sight this will help them when filling data in a form many thanks steve.

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

      Sorry for late reply. I will create a video regarding this one. It's all about AFTER UPDATE FUNCTION.

  • @archiligogilashvili1739
    @archiligogilashvili1739 ปีที่แล้ว +2

    please show how to protect the program from distribution...

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

    can you do dlookup to show the specific record, not just the name ? thanks

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

      Maybe this is what you mean.
      th-cam.com/video/e1Yg4VqiZrw/w-d-xo.html
      th-cam.com/video/Uo5pV_wQ4sc/w-d-xo.html