Solved

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

Posted on 2008-10-31
15
351 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

867 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

12 Experts available now in Live!

Get 1:1 Help Now