473,386 Members | 1,733 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Can I transport a custom menu bar with a db file

Hey all,
I want to burn an access database to a disc, and give it to someone else. Is there anything i need to do to ensure that the custom menu bar I created for the startup form goes with it,? like in startup options, form properties etc. I cant find anything like in Word or Excel that gives an option to store it either in the file or globally.
Ive left all boxes checked in the startup options except 'show database window', and 'display status bar'. My custom menu bar name has been selected as the startup menu bar. Ive also selected it in the properties box for all forms and reports.
If theres anything else I should do, could someone please let me know? or does access attatch it automatically?
Cheers!
Dec 10 '06 #1
7 1709
missinglinq
3,532 Expert 2GB
Access DBs are pretty much self-contained. Everything in the Db will go with the .mdb or .mde file.
Dec 10 '06 #2
NeoPa
32,556 Expert Mod 16PB
Try it out before burning the CD.
I think a toolbar is outside of any database and is associated with your Access Install.

You could consider adding some code to your database to add the toolbar programmatically OnOpen and delete it OnClose.
I do that in Excel but I've no code specifically for Access. Sorry.
Dec 10 '06 #3
missinglinq
3,532 Expert 2GB
Custom toolbars, etc do travel with the .MDB files! When yu think about it, wouldn't make any sense otherwise! Why allow you to develope custom toolbars, menus, etc if you can't place them on a client's machine?
Dec 10 '06 #4
NeoPa
32,556 Expert Mod 16PB
Custom toolbars, etc do travel with the .MDB files! When yu think about it, wouldn't make any sense otherwise! Why allow you to develope custom toolbars, menus, etc if you can't place them on a client's machine?
Sorry to imply you may have been wrong MissingLinq. That wasn't the idea I was after.
I was only going from my experience with Excel where the reverse is actually true (Don't ask me to explain or double-guess MS's development ideas).
If you say it works that way in Access though, that's good enough for me.
Dec 10 '06 #5
missinglinq
3,532 Expert 2GB
Isn't that the truth. My answer was based on a AC2000 app moved to a machine running AC2003. Of course, as we all know, funny things happen from version to version, which is my biggest gripe with Billy Bob's boys in Redmond.
Dec 10 '06 #6
redtux
2
Custom toolbars, etc do travel with the .MDB files! When yu think about it, wouldn't make any sense otherwise! Why allow you to develope custom toolbars, menus, etc if you can't place them on a client's machine?
Unfortunately they dont seem to - they seem to be installation dependent, ie: if you change in one db it affects all databases you open

If anyone knows a way doing this without adding code to every onload/onclose,it would be appreciated
Nov 30 '07 #7
sierra7
446 Expert 256MB
I endorse MissingLing's guidance. The custom menu bars DO move with the app. (The tricky bit is learning how to import them from one app to the next!)

I presume you have created new menu bars and given them a new name and not just customised the default ones (sorry to ask silly questions but sometimes. . . .)

Also make sure you are not confusing Menu bars with cutom Tool bars.

Defining the preferred menu bar in start-up and calling it in each form does it for me.

You normally get an error if you try and open a form which has a named menu that is not present (can not be found)
Nov 30 '07 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: microdevsolutions | last post by:
Hello I am using ASP.NET - I have written a Custom Control (to output some information) that has a public property declared. I have a user control that is a wrapper around the above custom...
1
by: Karl Irvin | last post by:
I have database with a custom menu bar. The database has been distributed to several people as an mde. All but one of them have the custom menu bar as specified in the Tools>Startup options but one...
7
by: Ian Hinson | last post by:
I have an Access app that has been distributed with run-time installation to many different customers over many years. It is developed in Access 2000. The custom menu bar has had no problems in...
0
by: Roman Muntyanu | last post by:
Hi all, I wrote add-in that can do different job for files with different extension. When I do right click on the file I see all my custom menuItems in context menu of solution explorer for all...
0
by: R.A.M. | last post by:
Hello, I need your help with a problem concerning Menu control. Could you help me please? I have created custom Menu: public class DemoMenu : Menu { public DemoMenu(string ID, string...
27
by: Wayne | last post by:
I've been clicking around Access 2007 Beta 2 and can't see the custom menu bar designer. Is it in the beta? Maybe I'm blind. The question that comes to mind is: Will custom menu bars be the same...
10
by: jubei | last post by:
I've been trying to write a custom widget for a project, however when i try to run code that uses it i get the following error > ./nokiagui.py Traceback (most recent call last): File...
5
by: lorirobn | last post by:
Hi, I am trying to create two custom menu bars for my application, one for read-only users (without delete record), and one for update-access users (with delete record). I only need File and...
6
by: Neil | last post by:
I have a form that has its own custom menu bar in Access 2000. I'd like to make a copy of the menu bar and use it with another form. How can I do this? Thanks.
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.