Solved

msaccess 2000 to msaccess 2007

Posted on 2013-12-03
5
265 Views
Last Modified: 2013-12-05
we have an application in msaccess 2000 that need to be converted to msaccess 2007.

In 2000 it runs the  RunCommand WindowHide in the autoexe macro. However in 2007 this does not work. How could i accomplish the same in 2007
0
Comment
Question by:Shen
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 

Author Comment

by:Shen
ID: 39692514
looking at the application more i noticed that the main form has on the property form open event: tools.hide toolbar and then on the close event: tools.show toolbar.  Maybe this is the problem and not my the runcommand windowhide. Please help.

thank you
0
 
LVL 20

Expert Comment

by:GrahamMandeno
ID: 39694502
Hi Rick

What is the window you are trying to hide?  Is it the Navigation Pane (which used to be the Database Window)?

If so, go to Access Options > Current Database and uncheck Display Navigation Pane

If you need it done via the macro for some reason, then before executing the WindowHide command you must select something in the nav pane:

SelectObject Table, , Yes

Note that you do not have to specify the table name.

Best wishes,
Graham Mandeno [Access MVP since 1996]
0
 

Author Comment

by:Shen
ID: 39698477
Sorry for not replying before. I was assigned to work on another task.

I put in the main_form open event:

DoCmd.ShowToolbar "Ribbon", acToolbarNo

and in a button that only shows for admins:

 DoCmd.ShowToolbar "Ribbon", acToolbarYes

This hides the ribbon but not the navation pane.

I will try to add the winodw hide.

Could you provide the specific commands to do this.
0
 
LVL 20

Accepted Solution

by:
GrahamMandeno earned 500 total points
ID: 39698853
I understood from your original question that you were using a macro, not VBA code.  Not to worry - IMO it is much easier in code:
DoCmd.SelectObject acTable, , True
RunCommand acCmdWindowHide

Open in new window

-- Graham
0
 

Author Closing Comment

by:Shen
ID: 39699329
thank you
0

Featured Post

Get HTML5 Certified

Want to be a web developer? You'll need to know HTML. Prepare for HTML5 certification by enrolling in July's Course of the Month! It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to set-up an On Demand, IPSec, Site to SIte, VPN from a Draytek Vigor Router to a Cyberoam UTM Appliance. A concise guide to the settings required on both devices
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
Suggested Courses

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question