23. (Advanced Programming In Access 2013) Navigation Control Layouts

[@mohamediflah3591]

extraordinary I don't know how to thank you for these videos which allowed me to move on to another dimension in the knowledge of access. Thank you so much

[@fahengraphic7743]

Perfect, simply perfect at all

[@romanteliszczuk8368]

Thanks...You Cleared That up a lot. I like and appreciate all your videos!

[@richardmoumakwe5890]

Beautiful! Thanks for sharing

[@LindaLooUK]

Thanks Steve, always enjoy your videos. :)

[@swapnilwankhede3440]

Hi Steve Excellent Tutorials, Thanks a lot Steve for uploading this videos, it’s really helpful, never found such good videos.

[@jooryalhamed938]

amazing videos and amazing teacher >>> thank you

[@DhammaTravelVlog]

Hi Steve - great tutorial - thanks. how would you set a value from one navigation form to another form?

[@danielking2709]

Thank You for all your content. I have created a Navigation form with two levels of tabs. I would like to hide this second level when the other top level tabs are selected. I want this second level to behave like a drop down list in a combo box. Thank You, Daniel King

[@synergybydesign6783]

great video.....clear and exact. 5 starsout of 5

[@kadnacer7571]

Hi Steve and many thanks I have really enjoyed this video. My question is : when programming with VBA we need constantly to reference a field or subforms or any other control included in navigation form to use it in another form or code, what is the best way to write the correct reference. Your help Will be very appreciated. Have Good day.

[@johnrogers9606]

Dear Steve Bishop, Thank you for the informatve ACCESS VBA videos. I created a nav form as you demonstrated except that I used a defined query to provide the sql string. However, are you aware in my case that your demonstrated technique with the navigation control is that if you delete a complete row record from displayed data in the nav subform this does NOT update the underlying data and when the nav button is re-pressed the orginal data without the row deletion(s) is re-displayed? How can this be retified? Please help...

[@ragubirsingh2854]

Amazing Video...thanks for this all video.....

[@lyndam1917]

thank you for this video. very helpful

[@islammmi]

how can you have a search form to go to only just one specific record in the navigation form. based on for example the ID (which is a primary key field?

[@abeibrahim5846]

Hi Steve, Thank you again for great video Tutorials. Please, make a video (soooooon) that is focus primarily on "How to move (place focus) on field/control between: main form to 1,2,3,4,5 layers in both direction, using buttons and/or event. There are NO good resource that go into VBA navigation between panes in Navigation Control, Thanks!

[@kaaa3485]

Thanks for the tutorial. I created a navigation form but when I click on the tab, it stay the same color. I want to be able to change color once I click on it. and If i clicked on another tab, previous tab go their regular color. How to change the Tab color on got focus event? thanks.

[@kheshikabachoo5730]

Thank you Sir.... How to exist the navigation bar?....

[@sareekashinde1404]

I created Navigational form on which i have Button for Employee Details(form).So when i click on Employee Details button it shows a form which has command button - create/save new emp record , when i click button for creating new emp record nothing haapens it does not create new emp. Button works good on form only but if i used on navigational panel it does not work.Please help me to understand why it does not work on navigation form where i have subform with new record button.Thanks

[@kastordle]

Thank you very much for sharing your knowledge. Your access videos are without any doubt the most advanced and are very funny too!!! One question, please. Is there any similar to navigation controls in Access 2003?

[@ProgrammingMadeEZ]

***** Not that I am aware of except for possibly some ActiveX controls that are not native to Access.

[@dldsalam81]

Thank u so much

[@yandeb1]

Hi thanks for your amazing videos ! How can we open the form2 by code and show a form from a second layer navigation control, and get the navigation button related to that form "highlighted "(the user can see the appropriate selected tab according to the form that is showed)? Yannick

[@ProgrammingMadeEZ]

+yandeb1 You have to use the DoCmd.BrowseTo method.

[@561414]

Thanks a lot for the info, man. I really appreciate you explain everything so well. Now, I have come across a problem that seems to be a *bug* with navigation forms... sometimes, when you click a navigation button, it prompts the user to save changes, even though no changes were made, is there any solution for this?

[@ProgrammingMadeEZ]

+He dicho Not too sure honestly.

[@snowedunder738]

How to set permission navigation can view or can't view

[@abeibrahim5846]

Hi Steve, Have you ever experienced Form Corruption after adding a navigation control (after you have populated the controls with forms.)?

[@ProgrammingMadeEZ]

It happens from time to time. Try compacting and repairing or re-adding the controls.

[@AliTwaij]

excellent thanks

[@vilastonape192]

How to create access2003 command bar style menu in access 2013

[@hightrainctc]

Thanks very helpful vedio

[@jienke]

Hello and thanks for the knowledge, I have a question: I want to requery a form in the navigation form, but "Me.requery" is not working in the navigation form. How can i do that?

[@ProgrammingMadeEZ]

+Julien Mathys Do you mean navigation pane? If so it already auto updates when you add something.

[@ahawk850]

I just found your series and I am learning a lot, Thanks for the great video. I am working with Access 2010 Navigation Tabs and subforms. I want to use a subform to update data, but automatically switch to a form that has the fields locked for "read-only" after saving or updating a record (Clicking on the "Save Record" button). Thanks for any help...

[@ProgrammingMadeEZ]

So make a form that is read only and jump to it after someone clicks on the save button of the edit form.

[@ahawk850]

Thank you for your reply to my question. I have the "read only" form in place on button1, button2 is the editable version. Now, I just want to automatically switch back to button1 as part of the "Save Record" sub routine. Is there a command will do that for me?

[@ShimonWosner]

Question! How do I reference a control from a navigation form, in my query? Thanks in advanced, I love your videos!

[@ProgrammingMadeEZ]

Have you watched my beginner series? I addressed this in that series.

[@ShimonWosner]

Yes. I tried to watch the whole playlist, but maybe I missed one. Do you remember on what video you addressed it?

[@ProgrammingMadeEZ]

kzbin.info/www/bejne/bH65gq1rocurm7s

[@ShimonWosner]

Thanks for your fast response, But i'm trying the reference a control from a 'Navigation' subForm

[@ProgrammingMadeEZ]

I'm not sure what you mean by navigation subform.

[@urielramirez27]

Thank you very much for being a teacher to all of us. I like that you cover the subject througly and the production timing of you videos. I hope that you explain the error on Access when you use a Navigation form in an accdbe file, it will give an error message and this is a bug in Access 2010, I'm not sure if they fixed in Access 2013. The code to get rid of that error message is '//This addresses the annoying "Requested type library or wizard is not a VBA project" error. If DataErr = -25357 Then Response = acDataErrContinue End If

[@mividalocastudio9366]

GENIUS

[@AnythingGoesCodes]

there's a lot more to navigations controls than people think. They have layers like onions and ogres

[@abdulwahabal-anesi1961]

lovely