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

[@Jojosmith342]

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

[@EdcelleJohnGulfan]

Thanks for watching!

[@Excelandaccessusefultips]

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

[@EdcelleJohnGulfan]

Thanks for watching Alieu.

[@Excelandaccessusefultips]

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

Email me [e-mail] or in WhatsApp [phone]

[@Vando.Santos]

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

[@EdcelleJohnGulfan]

Thanks

[@Don-28]

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

[@EdcelleJohnGulfan]

Thank you for watching. Im glad it helps.

[@boyk9683]

Thanks for this one! Cheers!

[@EdcelleJohnGulfan]

Welcome

[@mauriciobolivar7088]

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

[@Brand.ooo7]

So nice biutefoll pick ❤ Oaliz detail

[@EdcelleJohnGulfan]

Thank you.

[@AsadShaheenAkram]

WoW - Excellent Work!

[@EdcelleJohnGulfan]

Thanks for watching Asad

[@sebastianpetrescu382]

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 :)

[@macariojrbelza2730]

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?

[@terakuma1977]

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?

[@Missingtailpipesby]

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]

To fix, try this video. kzbin.info/www/bejne/gnKad6GqntCsqZI

[@Missingtailpipesby]

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

[@gabrielenicolo1680]

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]

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

[@nicor1501]

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

[@EdcelleJohnGulfan]

That's a Navigation form. Check this Link for the tutorial. kzbin.info/www/bejne/qIeUmZqGaNZ1kK8

[@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]

@@nicor1501 check this tutorial for inserting icon in command buttons. 1. kzbin.info/www/bejne/e4mxZpaih9-VjtU 2. kzbin.info/www/bejne/i4WwnYSHf5qFZrs

[@nicor1501]

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

[@EdcelleJohnGulfan]

You're welcome. Thanks for watching

[@ronmargate3327]

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]

Thanks for asking. Here is what you need. kzbin.info/www/bejne/gnKad6GqntCsqZI

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

[@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?

[@kemalayaz6459]

You'are really good. Thank you

[@EdcelleJohnGulfan]

Thank you for watching

[@johnhenryjoseph1323]

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

[@EdcelleJohnGulfan]

Ok sure soon. Thanks for watching John.

[@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]

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]

Thanks so much for your response.@@EdcelleJohnGulfan

[@sunilnr6936]

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]

Warch this video. kzbin.info/www/bejne/lYbaY2uklMmAr6s

[@sunilnr6936]

@@EdcelleJohnGulfan Thank you so much !

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

[@EdcelleJohnGulfan]

I'll create a video about this.

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

[@EdcelleJohnGulfan]

So what's your question?

[@tuamaleos4519]

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

[@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?

[@amirulramli_]

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

[@EdcelleJohnGulfan]

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

[@amirulramli_]

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

[@yubautube]

excellent , thanks

[@EdcelleJohnGulfan]

Welcome and thanks for watching.

[@Rojin.Marzooki]

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]

This video is what you need. kzbin.info/www/bejne/gnKad6GqntCsqZI

[@saeedbaryal8723]

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]

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]

kzbin.info/www/bejne/gnKad6GqntCsqZI

[@alfredallen6113]

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

[@EdcelleJohnGulfan]

[e-mail]

[@GALLERY-96]

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

[@EdcelleJohnGulfan]

It's not an emoji letters. It's a picture from the internet and converted into icons. kzbin.info/www/bejne/e4mxZpaih9-VjtUsi=Z0LAWLIMO5-vVJFu

[@babyboss6047]

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

[@EdcelleJohnGulfan]

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

[@ninoeimred6276]

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

[@EdcelleJohnGulfan]

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

[@scubaguy1989]

You’re going way too fast to follow easily 😊

[@ninoeimred6276]

pano mawala yung mismong application after mag load Nung navigation form

[@EdcelleJohnGulfan]

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

[@RHUDelfinAlbano]

sir accordion menu po meron po kau link?

[@EdcelleJohnGulfan]

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]

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

[@RashidJaved]

Hello sir

[@EdcelleJohnGulfan]

Hi Sir.

[@kunakunachannel3346]

Ng eeror ung akin sir hys sana matulungan

[@EdcelleJohnGulfan]

Ano ang error?

[@kunakunachannel3346]

@@EdcelleJohnGulfan may pm po ako sa messager nyo po

[@DawnByte.gaming]

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

[@EdcelleJohnGulfan]

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

[@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]

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]

Try this video. kzbin.info/www/bejne/gnKad6GqntCsqZI

[@LecceGiallorossaNews]

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

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

[@baba-e-computer]

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