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 7591
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: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
| |