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

Acc 2007 Hidden Navigation Pane reappears after programatically linking to an external table

P: n/a
I have set the Navigation Pane so that it is not displayed on startup
of my application. However, if I programmatically link to an external
Access table, the navigation pane automatically reappears. Is there
any way to avoid this? I am using the code below to link the external
table.

DoCmd.TransferDatabase A_ATTACH, "Microsoft Access", sourceDBName,
A_TABLE, sourceTableName, destTableName

Jul 8 '07 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Patcick, I believe this is a problem with TransferDatabase in A2007.

Hopefully it will be fixed when MS releases a service pack.

--
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.

"Patrick" <pg****@improvementpath.comwrote in message
news:11**********************@z28g2000prd.googlegr oups.com...
>I have set the Navigation Pane so that it is not displayed on startup
of my application. However, if I programmatically link to an external
Access table, the navigation pane automatically reappears. Is there
any way to avoid this? I am using the code below to link the external
table.

DoCmd.TransferDatabase A_ATTACH, "Microsoft Access", sourceDBName,
A_TABLE, sourceTableName, destTableName
Jul 9 '07 #2

P: n/a
On Jul 9, 4:57 am, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
Patcick, I believe this is a problem with TransferDatabase in A2007.

Hopefully it will be fixed when MS releases a service pack.

--
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.

"Patrick" <pgo...@improvementpath.comwrote in message

news:11**********************@z28g2000prd.googlegr oups.com...
I have set the Navigation Pane so that it is not displayed on startup
of my application. However, if I programmatically link to an external
Access table, the navigation pane automatically reappears. Is there
any way to avoid this? I am using the code below to link the external
table.
DoCmd.TransferDatabase A_ATTACH, "Microsoft Access", sourceDBName,
A_TABLE, sourceTableName, destTableName- Hide quoted text -

- Show quoted text -
Is there a way I can hide the pane again or minimize it via code?

Jul 9 '07 #3

P: n/a
You can hide the nav pane by selecting any object in it, and then hiding it.
Same as previous versions:
DoCmd.SelectObject acForm, , True
RunCommand acCmdWindowHide

--
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.

"Patrick" <pg****@improvementpath.comwrote in message
news:11**********************@22g2000hsm.googlegro ups.com...
>
Is there a way I can hide the pane again or minimize it via code?
Jul 9 '07 #4

P: n/a
On Mon, 9 Jul 2007 19:57:03 +0800, "Allen Browne"
<Al*********@SeeSig.Invalidwrote:

In the meantime, try the alternative:
tabledef.Connect
tabledef.RefreshLink

-Tom.

>Patcick, I believe this is a problem with TransferDatabase in A2007.

Hopefully it will be fixed when MS releases a service pack.
Jul 9 '07 #5

P: n/a
On Jul 9, 8:17 am, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
You can hide the nav pane by selecting any object in it, and then hiding it.
Same as previous versions:
DoCmd.SelectObject acForm, , True
RunCommand acCmdWindowHide

--
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.

"Patrick" <pgo...@improvementpath.comwrote in message

news:11**********************@22g2000hsm.googlegro ups.com...


Is there a way I can hide the pane again or minimize it via code?- Hide quoted text -

- Show quoted text -
I have a client who just _had_ to move to office 2007! :)

thank you. I'll give it a try

Jul 9 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.