How to Open Report with Specific Record in Ms Access.

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

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

  • @milfredalcalde7336
    @milfredalcalde7336 Год назад +2

    Thank You Sir I learn a lot

  • @tariqal-mudris7877
    @tariqal-mudris7877 Год назад +2

    Always special. I like your videos.
    I need to know if you have used a vba code to hide the boarder. ?!This design is amazing.!

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

      Thanks for watching my videos.
      I set the border to NONE and I added this VBA CODE.
      ruclips.net/video/KaRFkGjLV_g/видео.html

  • @الحمدلله-ن6غ9ب
    @الحمدلله-ن6غ9ب Год назад

    You are excellent and your explanation is clear and sequential
    Please, I want to create an html and css page and put it in an Access form. The page has a button that, when clicked, opens a specific form in the current database.
    I hope you will answer me with a video - and you are excellent at that - thank you

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

    ❤❤❤

  • @arbygh
    @arbygh 11 дней назад

    Thank you for great video,
    This doesn't work when you enter the record for first time and you click to show one report, but it works when you navigate to previous record and come back.
    What to do so the data entery person to print the report right after entering the data?

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  10 дней назад +1

      Refresh the current record before you execute the command.
      Sample:
      ME.REFRESH
      Docmd.openForm "NameOfForm"

    • @arbygh
      @arbygh 6 дней назад

      @@EdcelleJohnGulfan thanks so much it worked

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

    I'm looking for help to create a template. I have 5 different Word files that I'd like to be accessible through buttons in an Access database. The buttons should open specific pages in the Word files for editing and printing. Additionally, I'd like to keep a record of all my prints in a database. Is there anyone who can assist me with this?"

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

    Hello Sir Edcelle, I am trying to filter my report by following your demo, but I got "Data Type Mismatch" of my criteria.. I think because my criteria is numeric and your demo is text.. what should be the syntax if my criteria is numeric.. am trying to learn access through your demos..can you please help me to get my print button work..many thanks.

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  6 месяцев назад +1

      Hi, do not put single quote in your criteria.
      Sample :
      "IDNumber=" & me.ID

  • @Yaseen176
    @Yaseen176 9 месяцев назад

    Its Good But With Itemcode and Data Range multiple parameter possible?

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  9 месяцев назад

      Data range is possible if you are in Continuous Form

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

    Hello can you teach how to use Access file on networking or with internet for more users who access on their laptop or pc. thanks in advance

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

    Helo
    is there a way of sending a report to specific records using email address in the table

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

      Yes there is.
      Watch this video first.
      ruclips.net/video/WCqHahZA_Bc/видео.html

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

    Sir @edcelle question. Meron ako code na timestamp and username capture after ticking checkbox sa ms access. Naganda sya sakin. Pero pag colleagues ko ang mag ccheck ng checkbox di nalabas sa kanila yung timestamp and username. Bat po kaya? Hope you can help

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

      Try to follow this video.
      Timestamp: ruclips.net/video/fiS6uzM-NMw/видео.html

  • @satarsacur6477
    @satarsacur6477 7 месяцев назад

    I ask for support to resolve an issue that constitutes a doubt in the process of creating an access program:
    - I have a database with several items, with their respective values.
    - I want to list items with values greater than a certain defined value (click on the button)
    - I want to print items with values greater than a certain defined value (click on the button)
    Best regards

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  7 месяцев назад

      Create a query and make it a source of your list box.
      In the criteria of your query, write this..sample greater than or = 100...
      Code: >=100

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  7 месяцев назад

      Then in your button for On click event, write this...
      Me.NameOfListbox.Requery

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  7 месяцев назад

      For more idea, click this link.
      ruclips.net/video/APQVs3FpebY/видео.htmlsi=kFSe8ywAkdi22AUL

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

    HELLO SIR!
    SIR HOW TO PRINT DUPLICATED RECORD THROUGH BUTTON PLEASE ONE TUTORIAL PLEASE.
    AND THROUGH REPORT AS WELL.

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

      I just wanna clarify, your purpose is to generate duplicate records?

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

      @@EdcelleJohnGulfan SIR I WANT TO PRINT DUPLICATED SINGLE AND SPECIFIC RECORD THROUGH REPORT

  • @00darkmist
    @00darkmist Год назад

    Thank you very much
    I had a problem Run time error "3464" Data type in criteria expression ! how to fix this issue

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

      Is this in report or in query? always cause by using auto number as criteria. And joining both auto numbers in criteria

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

    How to open a parameter report based on a columnar form having multiple pages.

  • @frenzy_7975
    @frenzy_7975 День назад

    tutorial po sa report, pano niyo po nagawa?