@@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
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.
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
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?
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.
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?
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 :)
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.
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?
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!
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
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
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.
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?
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
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
@@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
thumb up as always for the best instructor ! thank you very much for your great tutorial as always
Thanks for watching!
yo wtf, this is much quicker than it should! This man of God needs a blessing!
Thank you for watching. Im glad it helps.
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
Bro! your content it's awesome! Keep it up!!!
Thanks
So nice biutefoll pick ❤
Oaliz detail
Thank you.
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
Thanks for this one! Cheers!
Welcome
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.
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
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.
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
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?
Warch this video.
th-cam.com/video/_Uw28n_dMyI/w-d-xo.html
@@EdcelleJohnGulfan Thank you so much !
Excelente trabajo, bonito, resumido. Muy buena estética
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.
which video did you create the Report Master in? Like your tutorials by the way.
WoW - Excellent Work!
Thanks for watching Asad
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?
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 :)
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
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?
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
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.
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
can you tell me how can i find those emoji letters?
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
Hi. Nice one. May I know how I could reach you. I kindly need advice on a project.
Thank you.
ecgsoftwaresolution@gmail.com
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
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?
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?
You'are really good. Thank you
Thank you for watching
Please Create & share File MS Access Inventory Material In-Out open source.....
Thank you🙏🙏🙏
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?
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.
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.
excellent , thanks
Welcome and thanks for watching.
pano mawala yung mismong application after mag load Nung navigation form
hindi ko gets sir. Application Icon ba ibig sabihin mo sir?
You’re going way too fast to follow easily 😊
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.
Hello sir
Hi Sir.
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