How to Create MENU using NAVIGATION form in Microsoft Access | Edcelle John Gulfan

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

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

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

    thumb up as always for the best instructor ! thank you very much for your great tutorial as always

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

    I was just working on this type yesterday
    Thanks this gives me more knowledge

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

      Thanks for watching Alieu.

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

      @@EdcelleJohnGulfan
      How can I get in touch with you... I have a project am working on i use this nagivation you show us here but I have reach a point I need a guild . Can you have me I will like to send screenshots to you

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

      Email me eduardogulfan@gmail.com or in WhatsApp +63 933 655 6846

  • @Don-28
    @Don-28 6 หลายเดือนก่อน

    yo wtf, this is much quicker than it should! This man of God needs a blessing!

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

      Thank you for watching. Im glad it helps.

  • @Vando.Santos
    @Vando.Santos ปีที่แล้ว +2

    Bro! your content it's awesome! Keep it up!!!

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

    Thanks for this one! Cheers!

  • @mauriciobolivar7088
    @mauriciobolivar7088 3 หลายเดือนก่อน

    Excelente trabajo, bonito, resumido. Muy buena estética

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

    WoW - Excellent Work!

  • @Brand.ooo7
    @Brand.ooo7 10 หลายเดือนก่อน +2

    So nice biutefoll pick ❤
    Oaliz detail

  • @macariojrbelza2730
    @macariojrbelza2730 3 หลายเดือนก่อน

    Hi Sir Edcelle, first of all your videos are extremely informative and with your expertise perhaps you can give some hint regarding my my navigation form which overlapping my taskbar?

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

    Hello, could you show us how you create the buttons (left pane) on timestamp 00:06 ?
    They look really good !

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

      That's a Navigation form.
      Check this Link for the tutorial.
      th-cam.com/video/rV1hgP3qBZM/w-d-xo.html

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

      thank you for this @@EdcelleJohnGulfan
      Actually, I meant the buttons merged with a picture in the "Invoice Tracking Database" tool menu: "Invoice entry", "Printing", "Picking", etc... as seen at timestamp 00:06

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

      @@nicor1501 check this tutorial for inserting icon in command buttons.
      1. th-cam.com/video/EXN5clRzbXs/w-d-xo.html
      2. th-cam.com/video/UTMlQQJ5R0Y/w-d-xo.html

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

      Excellent ! Exactly what I was looking for 👍
      Your videos are really inspiring.
      Thank you again and keep up the good job.

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

      You're welcome. Thanks for watching

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

    I'm just starting to learn some basics of Microsoft access and wonder if it is possible to share a similar form you created by creating a QR-Code so they can get access to it. I look forward to hearing from you. Thanks :)

  • @terakuma1977
    @terakuma1977 5 หลายเดือนก่อน

    I needed this for work, I've never used access before and never created a database, I need to make a whole FAQ for the call centre. Any other of your videos would you recommend that would help?

  • @gabrielenicolo1680
    @gabrielenicolo1680 2 หลายเดือนก่อน

    hi sir, i meant to ask u when at the end u add the form to the button, how u do that, on mine it only makes me link the tables, but since i have already forms with builded layout i wanted to link them to the navigation buttons.

  • @irperera
    @irperera 9 หลายเดือนก่อน

    which video did you create the Report Master in? Like your tutorials by the way.

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

    Hi, I really likes the idea. But how can put command button for export excel with between two date parameters? Can you help? Thanks

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

    Great Job and very useful Thank you Sir. Could you please upload an another video as a follow-up video to this as when I trying to make a navigation form by following your video in my case when I trying to open the form through the navigation form, it's asking to put some parameter value. Kindly help. Thank you Sir.

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

      To fix, try this video. th-cam.com/video/LA7Fntikys0/w-d-xo.html

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

      @@EdcelleJohnGulfan - Thank you Sir. I will try now.

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

    Hello, my Navigation command in the Create menu is dimmed or not active! Can you please tell me how to get it back? thank you

  • @sunilnr6936
    @sunilnr6936 2 หลายเดือนก่อน +1

    Boss, If I want to exit from a current subform on button click and go to welcome page, what code I have to use as my code is not responding in side the subform?

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  2 หลายเดือนก่อน +1

      Warch this video.
      th-cam.com/video/_Uw28n_dMyI/w-d-xo.html

    • @sunilnr6936
      @sunilnr6936 2 หลายเดือนก่อน +1

      @@EdcelleJohnGulfan Thank you so much !

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

    Hello there, thanks a lot for these wonderful video tutorials on database building. I have followed you well with this particular tutorial on creating menus using navigation form. Just one extra thing I want to know how to do is the hiding or removing of the title bar when the form opens up. How did you do it. Thanks and I hope to see your response regarding this.

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

      First of all, thanks for watching.
      For the Title bar, open the property sheet, go to format, and set the Border Style to NONE.

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

      Thanks so much for your response.@@EdcelleJohnGulfan

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

    Hello Edcelle, your video is very informative and interesting. I'm watching most of your videos to get some tips for the Database that I'm developing right now. After watching this video, I made a Navigation Form Menu using Horizontal Tab. I created a Tab called Evaluation. When I click the Tab it will Open the Main Form called Manpower Evaluation. Inside the Manpower Evaluation form I created a Button that will open another Form or Query of a specific record. For example, I select Employee No. 1, when I click the button it should open the form or query that displays Employee No. 1. It works well when I run the Manpower Evaluation form outside the Navigation Form menu, but I'm when I Open the Manpower Evaluation Form inside the Navigation Form Menu then and click the button it is asking me to enter a parameter. I would appreciate if you can help me solve that issue. Thanks & more power!

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

      Thanks for asking.
      Here is what you need.
      th-cam.com/video/LA7Fntikys0/w-d-xo.html

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

    Hello Edcelle, You are extraordinary in MS Access.
    Can you please upload a video on How to use MS Access Application for Multi-user.
    Thanks in Advance.
    John

  • @Rojin.Marzooki
    @Rojin.Marzooki 10 หลายเดือนก่อน

    I tried now making the navigation and it looks beautiful. But unfortunately I have a form which I use in it search query in one of fields. But when i add this form to the navigation menu it doesn’t work and says please enter a parameter id .The form works well alone but not with the navigation menu. Help pzl.
    The build event for the field which is in the form is Form![profile]![ID]. What can i write to make this form work when I add it to the navigation menu form

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  10 หลายเดือนก่อน +1

      This video is what you need.
      th-cam.com/video/LA7Fntikys0/w-d-xo.html

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

    You'are really good. Thank you

  • @saeedbaryal8723
    @saeedbaryal8723 8 หลายเดือนก่อน

    Hello sir, I hope you are fine. I have created a form with option group to apply filter. The filter is working perfectly, but when I add this form to navigation control then the filter doesn't work, hope you will help me.

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  8 หลายเดือนก่อน

      Hi thanks for watching.
      To solve, just change the parameters. You need to add the name of your navigation form.
      For tutorial, follow the link below.

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  8 หลายเดือนก่อน

      th-cam.com/video/LA7Fntikys0/w-d-xo.html

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

    Hi Edcelle, was watching your videos and they are very informative. I just have some questions about relationships? I am doing a Project and maybe you can give some insights on how the relationships is created. By the way i am a newbie. Thank you

  • @yubautube
    @yubautube 10 หลายเดือนก่อน +1

    excellent , thanks

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  10 หลายเดือนก่อน

      Welcome and thanks for watching.

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

    Bro. Your content is awesome..A big fan of you!
    Tuning you for a long time and learning alot.. Could you please share this project file with me?

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

    Good afternoon, I have being watching your videos and it has being helpful.
    Can you please help me with a video on how to sends bulk sms with access database?

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

    Please Create & share File MS Access Inventory Material In-Out open source.....
    Thank you🙏🙏🙏

  • @GALLERY-96
    @GALLERY-96 3 หลายเดือนก่อน

    can you tell me how can i find those emoji letters?

    • @EdcelleJohnGulfan
      @EdcelleJohnGulfan  3 หลายเดือนก่อน

      It's not an emoji letters. It's a picture from the internet and converted into icons.
      th-cam.com/video/EXN5clRzbXs/w-d-xo.htmlsi=Z0LAWLIMO5-vVJFu

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

    are you using navigation form for main menu? or you create your own menu?

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

      I'm creating my own menu using the navigation form.

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

      @@EdcelleJohnGulfan If possible, can i have your database. I need it for my reference. Thank you

  • @alfredallen6113
    @alfredallen6113 9 หลายเดือนก่อน

    Hi. Nice one. May I know how I could reach you. I kindly need advice on a project.
    Thank you.

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

    Boss pano po mag auto adjust yung size ng forms mga textbox based sa monitor size

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

      pwede gamitin ang Anchoring. Click mo lang ang fields or textbox then right-click then select Anchoring.

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

    Nice one sir. Possible po ba sya na pag e click un mazimize button, gagalaw dn un naka anchor? Thanks

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

      Yes po sir. Automatic na yan pag naka-anchoring.

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

    pano mawala yung mismong application after mag load Nung navigation form

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

      hindi ko gets sir. Application Icon ba ibig sabihin mo sir?

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

    sir accordion menu po meron po kau link?

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

      Meron akong nagawa kaso lang sa client ko. Di pwede ma share. Gagawa nalang ako ng tutorial. Nakakaantok kasi magcoding yan😀😀😀 more on numbers

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

      @@EdcelleJohnGulfan cge sir asahan q po my ginagawa kc aq system pra sa office nmin.

  • @scubaguy1989
    @scubaguy1989 ปีที่แล้ว +6

    You’re going way too fast to follow easily 😊

  • @RashidJaved
    @RashidJaved 5 หลายเดือนก่อน +1

    Hello sir

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

    Ng eeror ung akin sir hys sana matulungan

  • @DawnByte.gaming
    @DawnByte.gaming 2 ปีที่แล้ว

    save... ( how can image-line call their software a professional DAW... when the programming belongs to kindergarden... ) Last ti I ever

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

      I remember my teacher in kindergarten once said " If you don't like my flowers then stay out from my Garden"

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

    Hi this is brilliant and I have followed your tutorial perfectly. I have an issue though , hope you can help.
    In the navigation form I have a form with my clients invoices, next to the name of the idclient I have a button to open the detail of that client, stored in another form that is also in the navigation . The button works perfect but only it opens the form outside the navigation form, how I do make it to open inside the navigation.
    For the button I have used the following code
    docmd.openform "nameform",,, "IDClient = " & me.IDClient
    how to adjust the code?
    Thanks a lot

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

      That code still work inside the navigation form.
      But if you have criteria inside the navigation, then you have to indicate that in your vba.

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

      Try this video.
      th-cam.com/video/LA7Fntikys0/w-d-xo.html

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

      @@EdcelleJohnGulfan Thanks for your reply but if I design a button on a form to open another form, it will open ouside the navigation form. Anyway I solved the problem with this vba code
      Forms!NavigationForm!Namenewform!.setfocus
      but I don't know how to continue to get the specific record

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

      @@EdcelleJohnGulfan thanks that video helped to solve other problems, not this one

  • @baba-e-computer
    @baba-e-computer 2 ปีที่แล้ว

    need help
    what is wrong in this code
    Dim rs As Object
    DoCmd.SelectObject acForm, [main form]![NavigationSubform]
    Set rs = Forms![main form]![NavigationSubform].Recordset.Clone
    rs.FindFirst "Wcode = " & Me.List30
    [main form]![NavigationSubform].Bookmark = rs.Bookmark