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 5 7580
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
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?
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?
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.
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Dales |
last post by:
I have a custom control that builds what we refer to as "Formlets"
around some content in a page. These are basically content "wrapper"
sections that are tables that have a colored header and...
|
by: fly_mo |
last post by:
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...
|
by: Wayne |
last post by:
I've been looking and maybe I've missed something but is there a way
to undock the navigation pane or at least not have it "always on top"
in design view? I realize it can be minimized, but having...
|
by: nico5038 |
last post by:
Access 2007 Linkedtable manager refuses to relink tables having a field with the "Attachment" datatype.
Problem:
When placing a split database in another folder, the Linked table manager should...
|
by: tony.abbitt |
last post by:
I have recently installed Office 2007 (SP1) retaining the previous
installation of Office 2003.
I have converted an Access 2003 database to Access 2007. The database
contains the VBA code...
|
by: chupachup32 |
last post by:
I'm a student trying to teach myself to use access. I somehow managed
to minimize my navigation pane and now I can't figure out how to
reopen it. The Access handbook says that, even when minimized,...
|
by: Bob |
last post by:
Hi,
In runtime environement my access 2007 application dont show the Navigation
Pane, anybody have this problem ?
Thank's for reply
Bob
|
by: prakashwadhwani |
last post by:
Office 2007 & thus Access has had it's menus replaced with the Ribbon
Bar. It's very disconcerting. In Word, Excel, Access, I feel totally
lost. Also all the shortcut Menu pulldowns don't work...
|
by: ncsthbell |
last post by:
I created a database using full blown access 2007. I have put it out for users to grab and test using Runtime Access 2007. They have entered data and now I need to go back into a table and change a...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
| |