Toggle Navigation Tabs On/Off in VBA

[DCrake]

I have a A2007 application that I have developed in A2003 If I design a form in 2007 and have the Form Navigation tabs flag unchecked I cannot find a way to close a saved form. However if I turn them on I can. The issue is I don't want to have to do this prior to opening the app. Is there a way to toggle them Off on load and On on Unload?

 

[vbaInet]

Hello David, what do you mean by the Form Navigation tabs flag? Where is this located?

Or are you referring to Tabbed Documents or Navigation Pane?

 

[DCrake]

I think it is tabbed documents

 

[vbaInet]

Been having a look, this is it:

CurrentDb.Properties("ShowDocumentTabs").value = BooleanValue

You can only set the check box value, apparently. As with any db option, it would require a restart as well (as you know), unless you have a workaround.

 

[DCrake]

I understand that but the crux of the matter is why does A2007 not give you the opportunity to close a form from design view? Even if I scrool the boundaries there is no close button, neither does it exist in the ribbon.

 

[vbaInet]

I now understand the predicament. I've only just noticed the behaviour. A workaround is to Add the 'Close Window' button to the Quick Access Toolbar. Under the 'Choose commands from:' drop-down box in Customize, select 'Commands Not in the Ribbon' from the list and you will find that command listed there. Add it to the QAT.

 

[DCrake]

Will give that a go tomorrow

 

[vbaInet]

Oki doki. Let us know if that works for you.

 

[SOS]

Just right-click near the top of the form and you will get options including CLOSE.

 

[vbaInet]

That actually closes the application, not the object.

 

[SOS]

That actually closes the application, not the object.

Sorry, but you are wrong there vbaInet. If you select the right place in the form you get this:

 

[vbaInet]

I initially thought this was what DCrake was referring to but it isn't. This is how you replicate the "problem":

1. In the Current Database section of Access Options, untick the 'Display Document Tabs' check box and OK that.
2. As you know, close your db and open it again.
3. Open a form in design view and try to close it.

I wouldn't have known if DCrake didn't spot this.

 

[SOS]

I initially thought this was what DCrake was referring to but it isn't. This is how you replicate the "problem":

1. In the Current Database section of Access Options, untick the 'Display Document Tabs' check box and OK that.
2. As you know, close your db and open it again.
3. Open a form in design view and try to close it.

I wouldn't have known if DCrake didn't spot this.

Still works fine for me. It closes the form not the app.:

 

[vbaInet]

Try it in Design View.

 

[SOS]

Okay, no close in design view. So, my workaround has been to go to layout view and then close. But I agree that should not have to be done.

 

[vbaInet]

Yes, that was what DCrake was talking about which was I suggested adding the close button to the QAT.

It's silly isn't it! They must have their reasons or it was an oversight.

 

[SOS]

Probably an oversight.

 

[DCrake]

Investigated further and I realised only way to get the close option is to go from design mode to view mode then the short cut menu offers me the option to close. However this sometimes causes errors due to on load events.

 

[SOS]

Investigated further and I realised only way to get the close option is to go from design mode to view mode then the short cut menu offers me the option to close. However this sometimes causes errors due to on load events.

Try going to LAYOUT view instead of Form VIEW.

 

[vbaInet]

This works fine for me both in Design and Form view (except when its a pop-up form obviously). Is it definitely the "Close Window" button you added to the QAT or the "Close" button David? There are a few of these.