Solved

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

Posted on 2008-10-31
15
367 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
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: 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

790 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