@@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 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?
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
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 :)
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?
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.
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.
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?
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.
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.
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
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 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
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
thumb up as always for the best instructor ! thank you very much for your great tutorial as always
Thanks for watching!
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
yo wtf, this is much quicker than it should! This man of God needs a blessing!
Thank you for watching. Im glad it helps.
Bro! your content it's awesome! Keep it up!!!
Thanks
Thanks for this one! Cheers!
Welcome
Excelente trabajo, bonito, resumido. Muy buena estética
WoW - Excellent Work!
Thanks for watching Asad
So nice biutefoll pick ❤
Oaliz detail
Thank you.
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?
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
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 :)
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?
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.
which video did you create the Report Master in? Like your tutorials by the way.
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.
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.
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
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 !
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 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
You'are really good. Thank you
Thank you for watching
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
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?
excellent , thanks
Welcome and thanks 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?
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?
Please Create & share File MS Access Inventory Material In-Out open source.....
Thank you🙏🙏🙏
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
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. Nice one. May I know how I could reach you. I kindly need advice on a project.
Thank you.
ecgsoftwaresolution@gmail.com
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.
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.
You’re going way too fast to follow easily 😊
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"
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
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