• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 278
  • Last Modified:

msaccess 2000 to msaccess 2007

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
Shen
Asked:
Shen
  • 3
  • 2
1 Solution
 
ShenAuthor Commented:
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
 
GrahamMandenoCommented:
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
 
ShenAuthor Commented:
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
 
GrahamMandenoCommented:
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
 
ShenAuthor Commented:
thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now