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

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

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

  • @iammai5404
    @iammai5404 Год назад +3

    That's great! You're a genius

  • @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.

  • @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.

  • @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

  • @alimoradi6664
    @alimoradi6664 Год назад +1

    thank U Mr Gulfan

  • @santrehNgoding
    @santrehNgoding Год назад +1

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

  • @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...

  • @Abdullah_Alhathloul
    @Abdullah_Alhathloul 8 месяцев назад

    Nice , thank you

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

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

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

      Maybe this is what you mean.
      ruclips.net/video/e1Yg4VqiZrw/видео.html
      ruclips.net/video/Uo5pV_wQ4sc/видео.html