By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,269 Members | 1,506 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,269 IT Pros & Developers. It's quick & easy.

access options won't work in 2007

P: n/a
Hello All,
I have an app that has been rock solid (sofar) installed using Sagekey
scripts etc and is currently a 2002/3 file.

However client is upgrading to 2007 (so I have setup a test machine
with XP & Office 2007 - this will be the setup on the client machines)
and when I try to open the entire database is open despite using the
following:

Public Function SetStartupProperties()
'ChangeProperty "StartupForm", dbText, "frmLogOn"
ChangeProperty "StartupShowDBWindow", dbBoolean, False
ChangeProperty "StartupShowStatusBar", dbBoolean, False
ChangeProperty "AllowBuiltinToolbars", dbBoolean, False
ChangeProperty "AllowFullMenus", dbBoolean, False
ChangeProperty "AllowBreakIntoCode", dbBoolean, False
ChangeProperty "AllowSpecialKeys", dbBoolean, False
ChangeProperty "AllowBypassKey", dbBoolean, False
ChangeProperty "AllowShortcutMenus", dbBoolean, False

End Function

The navigation bar allows access to all parts of the app.

Under normal circumstances, the app opens in runtime mode so nothing is
viewable. I also can't access the Access Options from the File menu to
set these points.

I would appreciate any suggestions or pointers as to where I'm going
wrong.

Many thanks
John

Jan 27 '07 #1
Share this Question
Share on Google+
5 Replies


P: n/a
John, the Nav Pane should not be visible once you set StartupShowDBWindow to
False. In fact, that's the property that Access 2007 sets when you uncheck
the box under:
Office Button | Access Options | Current Database | Display Nav Pane.

Are you sure this code is running? Is it being called? Is the database in a
trusted location so the VBA code can exeute?

Once you get that sorted, there are a few more properties you might want to
set, such as AllowDatasheetSchema and DesignWithData. Details:
http://allenbrowne.com/ser-69.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<fl****@hotmail.comwrote in message
news:11*********************@l53g2000cwa.googlegro ups.com...
Hello All,
I have an app that has been rock solid (sofar) installed using Sagekey
scripts etc and is currently a 2002/3 file.

However client is upgrading to 2007 (so I have setup a test machine
with XP & Office 2007 - this will be the setup on the client machines)
and when I try to open the entire database is open despite using the
following:

Public Function SetStartupProperties()
'ChangeProperty "StartupForm", dbText, "frmLogOn"
ChangeProperty "StartupShowDBWindow", dbBoolean, False
ChangeProperty "StartupShowStatusBar", dbBoolean, False
ChangeProperty "AllowBuiltinToolbars", dbBoolean, False
ChangeProperty "AllowFullMenus", dbBoolean, False
ChangeProperty "AllowBreakIntoCode", dbBoolean, False
ChangeProperty "AllowSpecialKeys", dbBoolean, False
ChangeProperty "AllowBypassKey", dbBoolean, False
ChangeProperty "AllowShortcutMenus", dbBoolean, False

End Function

The navigation bar allows access to all parts of the app.

Under normal circumstances, the app opens in runtime mode so nothing is
viewable. I also can't access the Access Options from the File menu to
set these points.

I would appreciate any suggestions or pointers as to where I'm going
wrong.

Many thanks
John
Jan 27 '07 #2

P: n/a
Hello Allen,
Thanks for the response.

When I have the database open, I try to do exaclty as you've suggested

Office Button | Access Options | Current Database | Display Nav Pane

However, when I click Access Options, nothing happens.

Not sure why not, but I have tried several times without success.
Regards
John


On Jan 26, 9:59 pm, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
John, the Nav Pane should not be visible once you set StartupShowDBWindow to
False. In fact, that's the property that Access 2007 sets when you uncheck
the box under:
Office Button | Access Options | Current Database | Display Nav Pane.

Are you sure this code is running? Is it being called? Is the database in a
trusted location so the VBA code can exeute?

Once you get that sorted, there are a few more properties you might want to
set, such as AllowDatasheetSchema and DesignWithData. Details:
http://allenbrowne.com/ser-69.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<fly...@hotmail.comwrote in messagenews:11*********************@l53g2000cwa.go oglegroups.com...
Hello All,
I have an app that has been rock solid (sofar) installed using Sagekey
scripts etc and is currently a 2002/3 file.
However client is upgrading to 2007 (so I have setup a test machine
with XP & Office 2007 - this will be the setup on the client machines)
and when I try to open the entire database is open despite using the
following:
Public Function SetStartupProperties()
'ChangeProperty "StartupForm", dbText, "frmLogOn"
ChangeProperty "StartupShowDBWindow", dbBoolean, False
ChangeProperty "StartupShowStatusBar", dbBoolean, False
ChangeProperty "AllowBuiltinToolbars", dbBoolean, False
ChangeProperty "AllowFullMenus", dbBoolean, False
ChangeProperty "AllowBreakIntoCode", dbBoolean, False
ChangeProperty "AllowSpecialKeys", dbBoolean, False
ChangeProperty "AllowBypassKey", dbBoolean, False
ChangeProperty "AllowShortcutMenus", dbBoolean, False
End Function
The navigation bar allows access to all parts of the app.
Under normal circumstances, the app opens in runtime mode so nothing is
viewable. I also can't access the Access Options from the File menu to
set these points.
I would appreciate any suggestions or pointers as to where I'm going
wrong.
Many thanks
John
Jan 27 '07 #3

P: n/a
Are you saying you changed the option through the interface, closed and
restarted the database, and the Nav Pane is still visible?

That's not what I am seeing. Are you talking about the RTM or the beta?

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<fl****@hotmail.comwrote in message
news:11*********************@v45g2000cwv.googlegro ups.com...
Hello Allen,
Thanks for the response.

When I have the database open, I try to do exaclty as you've suggested

Office Button | Access Options | Current Database | Display Nav Pane

However, when I click Access Options, nothing happens.

Not sure why not, but I have tried several times without success.
Regards
John


On Jan 26, 9:59 pm, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
>John, the Nav Pane should not be visible once you set StartupShowDBWindow
to
False. In fact, that's the property that Access 2007 sets when you
uncheck
the box under:
Office Button | Access Options | Current Database | Display Nav Pane.

Are you sure this code is running? Is it being called? Is the database in
a
trusted location so the VBA code can exeute?

Once you get that sorted, there are a few more properties you might want
to
set, such as AllowDatasheetSchema and DesignWithData. Details:
http://allenbrowne.com/ser-69.html

<fly...@hotmail.comwrote in
messagenews:11*********************@l53g2000cwa.g ooglegroups.com...
Hello All,
I have an app that has been rock solid (sofar) installed using Sagekey
scripts etc and is currently a 2002/3 file.
However client is upgrading to 2007 (so I have setup a test machine
with XP & Office 2007 - this will be the setup on the client machines)
and when I try to open the entire database is open despite using the
following:
Public Function SetStartupProperties()
'ChangeProperty "StartupForm", dbText, "frmLogOn"
ChangeProperty "StartupShowDBWindow", dbBoolean, False
ChangeProperty "StartupShowStatusBar", dbBoolean, False
ChangeProperty "AllowBuiltinToolbars", dbBoolean, False
ChangeProperty "AllowFullMenus", dbBoolean, False
ChangeProperty "AllowBreakIntoCode", dbBoolean, False
ChangeProperty "AllowSpecialKeys", dbBoolean, False
ChangeProperty "AllowBypassKey", dbBoolean, False
ChangeProperty "AllowShortcutMenus", dbBoolean, False
End Function
The navigation bar allows access to all parts of the app.
Under normal circumstances, the app opens in runtime mode so nothing is
viewable. I also can't access the Access Options from the File menu to
set these points.
I would appreciate any suggestions or pointers as to where I'm going
wrong.
Many thanks
John
Jan 27 '07 #4

P: n/a
Hello Allen,

I can't access the Access Options at all.

I'm using the beta - could this be part of the problem?

Thanks
John

On Jan 26, 10:33 pm, "Allen Browne" <AllenBro...@SeeSig.Invalid>
wrote:
Are you saying you changed the option through the interface, closed and
restarted the database, and the Nav Pane is still visible?

That's not what I am seeing. Are you talking about the RTM or the beta?

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<fly...@hotmail.comwrote in messagenews:11*********************@v45g2000cwv.go oglegroups.com...
Hello Allen,
Thanks for the response.
When I have the database open, I try to do exaclty as you've suggested
Office Button | Access Options | Current Database | Display Nav Pane
However, when I click Access Options, nothing happens.
Not sure why not, but I have tried several times without success.
Regards
John
On Jan 26, 9:59 pm, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
John, the Nav Pane should not be visible once you set StartupShowDBWindow
to
False. In fact, that's the property that Access 2007 sets when you
uncheck
the box under:
Office Button | Access Options | Current Database | Display Nav Pane.
Are you sure this code is running? Is it being called? Is the database in
a
trusted location so the VBA code can exeute?
Once you get that sorted, there are a few more properties you might want
to
set, such as AllowDatasheetSchema and DesignWithData. Details:
http://allenbrowne.com/ser-69.html
<fly...@hotmail.comwrote in
messagenews:11*********************@l53g2000cwa.go oglegroups.com...
Hello All,
I have an app that has been rock solid (sofar) installed using Sagekey
scripts etc and is currently a 2002/3 file.
However client is upgrading to 2007 (so I have setup a test machine
with XP & Office 2007 - this will be the setup on the client machines)
and when I try to open the entire database is open despite using the
following:
Public Function SetStartupProperties()
'ChangeProperty "StartupForm", dbText, "frmLogOn"
ChangeProperty "StartupShowDBWindow", dbBoolean, False
ChangeProperty "StartupShowStatusBar", dbBoolean, False
ChangeProperty "AllowBuiltinToolbars", dbBoolean, False
ChangeProperty "AllowFullMenus", dbBoolean, False
ChangeProperty "AllowBreakIntoCode", dbBoolean, False
ChangeProperty "AllowSpecialKeys", dbBoolean, False
ChangeProperty "AllowBypassKey", dbBoolean, False
ChangeProperty "AllowShortcutMenus", dbBoolean, False
End Function
The navigation bar allows access to all parts of the app.
Under normal circumstances, the app opens in runtime mode so nothing is
viewable. I also can't access the Access Options from the File menu to
set these points.
I would appreciate any suggestions or pointers as to where I'm going
wrong.
Many thanks
John
Jan 27 '07 #5

P: n/a
Hello Allen,

I managed to get the window hide, but the system is crashing on the
custom menus - must be a beta problem. The beta is all that I have
received as part of my MAPS - so I'll have to wait for the full
version.

Thanks for your help

Regards
John


On Jan 26, 10:45 pm, fly...@hotmail.com wrote:
Hello Allen,

I can't access the Access Options at all.

I'm using the beta - could this be part of the problem?

Thanks
John

On Jan 26, 10:33 pm, "Allen Browne" <AllenBro...@SeeSig.Invalid>
wrote:
Are you saying you changed the option through the interface, closed and
restarted the database, and the Nav Pane is still visible?
That's not what I am seeing. Are you talking about the RTM or the beta?
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
<fly...@hotmail.comwrote in messagenews:11*********************@v45g2000cwv.go oglegroups.com...
Hello Allen,
Thanks for the response.
When I have the database open, I try to do exaclty as you've suggested
Office Button | Access Options | Current Database | Display Nav Pane
However, when I click Access Options, nothing happens.
Not sure why not, but I have tried several times without success.
Regards
John
On Jan 26, 9:59 pm, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
>John, the Nav Pane should not be visible once you set StartupShowDBWindow
>to
>False. In fact, that's the property that Access 2007 sets when you
>uncheck
>the box under:
> Office Button | Access Options | Current Database | Display Nav Pane.
>Are you sure this code is running? Is it being called? Is the database in
>a
>trusted location so the VBA code can exeute?
>Once you get that sorted, there are a few more properties you might want
>to
>set, such as AllowDatasheetSchema and DesignWithData. Details:
> http://allenbrowne.com/ser-69.html
><fly...@hotmail.comwrote in
>messagenews:11*********************@l53g2000cwa.g ooglegroups.com...
Hello All,
I have an app that has been rock solid (sofar) installed using Sagekey
scripts etc and is currently a 2002/3 file.
However client is upgrading to 2007 (so I have setup a test machine
with XP & Office 2007 - this will be the setup on the client machines)
and when I try to open the entire database is open despite using the
following:
Public Function SetStartupProperties()
'ChangeProperty "StartupForm", dbText, "frmLogOn"
ChangeProperty "StartupShowDBWindow", dbBoolean, False
ChangeProperty "StartupShowStatusBar", dbBoolean, False
ChangeProperty "AllowBuiltinToolbars", dbBoolean, False
ChangeProperty "AllowFullMenus", dbBoolean, False
ChangeProperty "AllowBreakIntoCode", dbBoolean, False
ChangeProperty "AllowSpecialKeys", dbBoolean, False
ChangeProperty "AllowBypassKey", dbBoolean, False
ChangeProperty "AllowShortcutMenus", dbBoolean, False
End Function
The navigation bar allows access to all parts of the app.
Under normal circumstances, the app opens in runtime mode so nothing is
viewable. I also can't access the Access Options from the File menu to
set these points.
I would appreciate any suggestions or pointers as to where I'm going
wrong.
Many thanks
John
Jan 27 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.