How to Create MENU using NAVIGATION form in Microsoft Access | Edcelle John Gulfan
ฝัง
- เผยแพร่เมื่อ 27 ก.ย. 2022
- This video will show you on how to level up your Microsoft access database design.
RELATED VIDEOS
Inserting round pictures: • How to create Round Fo...
Inserting a username in main menu: • How to create Multi Us...
Insert Professional Icons : • Professional Icons for...
Downloadable Templates:
• Free Download Template
A cup of coffee is always welcome : www.paypal.com/paypalme/eduar...
TIMESTAMP:
03:45 Inserting Username and picture
07:34 Apply back color and hover color
08:58 Apply pressed color
12:10 Insert welcome page
KEYWORDS:
ms access main menu form, Microsoft access 365 tutoring,
ms access dynamic menu
access navigation form examples
access switchboard vs navigation form
ms access menu examples
how to create a navigation form in access
how to create a main menu in access
how to add navigation buttons in access forms
navigation form in access database
how to create a navigation form in access
what is a navigation form, How to Create a Navigation Form in Microsoft Access
Navigation form in Ms Access Database
Navigation form in Microsoft Access Database
How to create switchboard in Microsoft Access, How to create Menu in Microsoft Access
#microsoftaccess
#microsoftaccesstutorial
#mstutorial
yo wtf, this is much quicker than it should! This man of God needs a blessing!
Thank you for watching. Im glad it helps.
thumb up as always for the best instructor ! thank you very much for your great tutorial as always
Thanks for watching!
WoW - Excellent Work!
Thanks for watching Asad
Thanks for this one! Cheers!
Welcome
Bro! your content it's awesome! Keep it up!!!
Thanks
I was just working on this type yesterday
Thanks this gives me more knowledge
Thanks for watching Alieu.
@@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
Email me eduardogulfan@gmail.com or in WhatsApp +63 933 655 6846
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?
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 :)
So nice biutefoll pick ❤
Oaliz detail
Thank you.
You'are really good. Thank you
Thank you for watching
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?
excellent , thanks
Welcome and thanks for watching.
which video did you create the Report Master in? Like your tutorials by the way.
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!
Thanks for asking.
Here is what you need.
th-cam.com/video/LA7Fntikys0/w-d-xo.html
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?
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
Ok sure soon. Thanks for watching John.
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
So what's your question?
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.
To fix, try this video. th-cam.com/video/LA7Fntikys0/w-d-xo.html
@@EdcelleJohnGulfan - Thank you Sir. I will try now.
are you using navigation form for main menu? or you create your own menu?
I'm creating my own menu using the navigation form.
@@EdcelleJohnGulfan If possible, can i have your database. I need it for my reference. Thank you
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.
First of all, thanks for watching.
For the Title bar, open the property sheet, go to format, and set the Border Style to NONE.
Thanks so much for your response.@@EdcelleJohnGulfan
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
Please Create & share File MS Access Inventory Material In-Out open source.....
Thank you🙏🙏🙏
Hi, I really likes the idea. But how can put command button for export excel with between two date parameters? Can you help? Thanks
I'll create a video about this.
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
This video is what you need.
th-cam.com/video/LA7Fntikys0/w-d-xo.html
Hello, could you show us how you create the buttons (left pane) on timestamp 00:06 ?
They look really good !
That's a Navigation form.
Check this Link for the tutorial.
th-cam.com/video/rV1hgP3qBZM/w-d-xo.html
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
@@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
Excellent ! Exactly what I was looking for 👍
Your videos are really inspiring.
Thank you again and keep up the good job.
You're welcome. Thanks for watching
Nice one sir. Possible po ba sya na pag e click un mazimize button, gagalaw dn un naka anchor? Thanks
Yes po sir. Automatic na yan pag naka-anchoring.
Boss pano po mag auto adjust yung size ng forms mga textbox based sa monitor size
pwede gamitin ang Anchoring. Click mo lang ang fields or textbox then right-click then select Anchoring.
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.
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.
th-cam.com/video/LA7Fntikys0/w-d-xo.html
You’re going way too fast to follow easily 😊
Hi. Nice one. May I know how I could reach you. I kindly need advice on a project.
Thank you.
ecgsoftwaresolution@gmail.com
pano mawala yung mismong application after mag load Nung navigation form
hindi ko gets sir. Application Icon ba ibig sabihin mo sir?
sir accordion menu po meron po kau link?
Meron akong nagawa kaso lang sa client ko. Di pwede ma share. Gagawa nalang ako ng tutorial. Nakakaantok kasi magcoding yan😀😀😀 more on numbers
@@EdcelleJohnGulfan cge sir asahan q po my ginagawa kc aq system pra sa office nmin.
Ng eeror ung akin sir hys sana matulungan
Ano ang error?
@@EdcelleJohnGulfan may pm po ako sa messager nyo po
save... ( how can image-line call their software a professional DAW... when the programming belongs to kindergarden... ) Last ti I ever
I remember my teacher in kindergarten once said " If you don't like my flowers then stay out from my Garden"
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
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
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.
Try this video.
th-cam.com/video/LA7Fntikys0/w-d-xo.html
@@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
@@EdcelleJohnGulfan thanks that video helped to solve other problems, not this one