Solved

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

Posted on 2008-10-31
15
338 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
  • 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
 

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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

747 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now