Solved

Access 2007 - Hiding everything on load up and then creating toolbar via VBA

Posted on 2008-10-31
15
375 Views
Last Modified: 2010-04-21
I have an Access 2003 database, which hides all of the toolbars and then creates its own.  However, I now need to have this database running on an Access 2007 PC.  Ideally I would like it to do the exact same, which is hide everything, open the Main Menu and then generate the icons through VBA.  If anyone could give me some pointers - it would be greatly appreciated.
0
Comment
Question by:Andy Brown
[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
  • 8
  • 7
15 Comments
 
LVL 46

Expert Comment

by:tbsgadi
ID: 22860537
Hi AndrewDBrown,

I had something similar, did any changes in 2003 & it works in 2007.

Gary
0
 

Author Comment

by:Andy Brown
ID: 22860662
What did you do?
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 22860669
Just opened it in 2007 & it worked.
You can't make changes to it in 2007
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Andy Brown
ID: 22860674
Sorry, It's my first time playing with 2007, but when I load the 2003 database in 2007.  It dispalys the ribbon, sidebar and doesn't want to run the code in the Main Menu without intervention .
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 22860696
You need to make sure that all the Trustee settings are set to allow macros.
Also that StartupShowDBWindow is False.
0
 

Author Comment

by:Andy Brown
ID: 22860702
Thank you - but how about hiding everything and displaying my custom icon bar.
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 22860743
Are you using an mdb in 2007 or accdb?
0
 

Author Comment

by:Andy Brown
ID: 22860789
mdb, since I will still need to use the database on some older 2003 platforms
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 22860814
try using CommandBars("Menu Bar").Visible = False etc
0
 

Author Comment

by:Andy Brown
ID: 22860830
No that doesn't do anything in 2007.  Just to recap.

It's and Access 2003 mdb database
I just want to run it on 2007 in the exact same way (same toolbards/icons etc)
I don't want the ribbon or sidebars to be displayed

Ultimately, I need to control it all via VBA, so when it loads it detects the version.  If 2003, carry on as normal, if 2007, hide everything and set cust icons.
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 22860931
Maybe allow everything in your trustee settings to check that your macros are working.
I have a 2003 DB & have no problem hiding everything in 2007
0
 

Author Comment

by:Andy Brown
ID: 22860946
But what about hiding the ribbon?
0
 
LVL 46

Accepted Solution

by:
tbsgadi earned 500 total points
ID: 22860989
When you hide the main toolbar it hides the ribbon
0
 

Author Closing Comment

by:Andy Brown
ID: 31512000
Thank you for all of your help on this one - I'll have a further play/read.

All the best
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 22861033
Glad to help! Good Luck!
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

749 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