L Lisa Aug 10, 2009 #1 Say, is there an easy way to have the Navigation Pane collapse when a form loads? I'm not a programmer. Thanks.
Say, is there an easy way to have the Navigation Pane collapse when a form loads? I'm not a programmer. Thanks.
D Damon Heron Aug 10, 2009 #2 In the form's Activation Event, found in the properties sheet, add this code (in the VB window): Private Sub Form_Activate() SendKeys "{F11}" <<<< add this code here End Sub Of course, if the nav pane is already closed, this will open it ( it toggles back and forth - try the F11 key to see)... Damon
In the form's Activation Event, found in the properties sheet, add this code (in the VB window): Private Sub Form_Activate() SendKeys "{F11}" <<<< add this code here End Sub Of course, if the nav pane is already closed, this will open it ( it toggles back and forth - try the F11 key to see)... Damon
L Lisa Aug 11, 2009 #3 I had used SendKeys in the macro and it worked, but was far clunkier. This is easier. Thanks so much.
I had used SendKeys in the macro and it worked, but was far clunkier. This is easier. Thanks so much.
M Mark Andrews Aug 11, 2009 #4 I thought this was the normal way, if you want to avoid sendkeys: To hide the pane use: DoCmd.RunCommand acCmdWindowHide To Show the pane: DoCmd.SelectObject acTable, , True http://www.pcreview.co.uk/forums/thread-3089845.php Mark
I thought this was the normal way, if you want to avoid sendkeys: To hide the pane use: DoCmd.RunCommand acCmdWindowHide To Show the pane: DoCmd.SelectObject acTable, , True http://www.pcreview.co.uk/forums/thread-3089845.php Mark
H Hans Up Aug 12, 2009 #5 Mark said: To hide the pane use: DoCmd.RunCommand acCmdWindowHide Click to expand... When I tried that in Form_Open event code, it hid my form. Changing Form_Open to the following both hid the navigation panel and left my form visible. DoCmd.SelectObject acTable, , True DoCmd.RunCommand acCmdWindowHide
Mark said: To hide the pane use: DoCmd.RunCommand acCmdWindowHide Click to expand... When I tried that in Form_Open event code, it hid my form. Changing Form_Open to the following both hid the navigation panel and left my form visible. DoCmd.SelectObject acTable, , True DoCmd.RunCommand acCmdWindowHide
M Mark Andrews Aug 12, 2009 #6 Good reply, I just put up what I saw on the website. I usually just hide the navigation pane at startup by unchecking the box in Access options. I would use this code over the sendkeys method. Mark
Good reply, I just put up what I saw on the website. I usually just hide the navigation pane at startup by unchecking the box in Access options. I would use this code over the sendkeys method. Mark
H Hans Up Aug 12, 2009 #7 Mark said: Good reply, I just put up what I saw on the website. I usually just hide the navigation pane at startup by unchecking the box in Access options. Click to expand... Good point. I was curious to see it work. But didn't pause to consider whether I would actually use it. I would use this code over the sendkeys method. Click to expand... Me, too. Regards, Hans
Mark said: Good reply, I just put up what I saw on the website. I usually just hide the navigation pane at startup by unchecking the box in Access options. Click to expand... Good point. I was curious to see it work. But didn't pause to consider whether I would actually use it. I would use this code over the sendkeys method. Click to expand... Me, too. Regards, Hans