Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2008-10-31
15
Medium Priority
?
389 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
Independent Software Vendors: 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 2000 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

580 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