I create a custom menu, and then assign hyperlink for running Excel application (C:Program FilesMicrosoft OfficeOffice10EXCEL.EXE). When I click on it, it has security message,
Hi everyone, I was trying out the options on the startup item of the tools item on the menu bar and my access window has gone except the following menu items: File,Window and Help. Can someone kindly show me how to bring back these seemingly lost items? Thank you for your willingness to help me out!
Ok, This is something I have long wanted to do, but cannot figure out.
I am working on a database for a company that orders a large number of Items. I have these all in one table (itemCode, itemDescription, price, categoryCode, etc). I have another table with categorys (categoryCode, categoryDescription) . Each Item is asigned a categoryCode and the appropiate relationship exsists. Right now I have a comboBox in a form that when selected opens a drops down menu with all the Items. Then another one auto loads up (continuous form) and I get the same drop down list of all the Items.
What I would like to have is a combo box then when it is selected shows the categorys, then based on that selection, I see all the Items that are in that category.
I guess another way of saying this simply is, I would like to create a drop down menu inside of a dropdown menu.
Is this possible? Does anyone have another alternative suggestion that might work well? I'm relectant to use a list box, becoase ideally it would be a drop down menu inside of a drop down menu as seen on many websites.
Before anyone get to upset with me I did search the board looking for the answer but only got more confused. I found the code I wanted to shut down the toolbars and menu bars but I need to allow the print options on the menu bar. How do I allow the menu bar up but only allow printing ?
I have this code in the opening for of my database but the tool bar "passdown" does not open. Could someone please help me understand why? thank you jon
Private Sub Form_Open(Cancel As Integer) ChangeProperty "StartupForm", dbText, "Frm-UserLogon" ChangeProperty "StartupShowDBWindow", dbBoolean, False ChangeProperty "StartupShowStatusBar", dbBoolean, False ChangeProperty "AllowBuiltinToolbars", dbBoolean, False ChangeProperty "AllowFullMenus", dbBoolean, False ChangeProperty "AllowBreakIntoCode", dbBoolean, False ChangeProperty "AllowSpecialKeys", dbBoolean, False ChangeProperty "AllowBypassKey", dbBoolean, False Dim i As Integer For i = 1 To CommandBars.Count CommandBars(i).Enabled = False Next i DoCmd.ShowToolbar "passdown", acToolbarYes
I was wondering if there is a way that I can create a 'message' that will appear whent he mouse is scrolled over a button. I have command buttons that launch my reports but would want the user to know what fields are included in each report...therefor, they can put the cursor ontop of a certain button and a small list will show them what is in that specific report
When the user log in the database, the database program will detect the user name, and then output his own menu bar.
It works fine. However, I got a problem, when I created the first menu bar, the menu bar have control box for the forms, the other 2 menu bars do not have it.
How can I make 3 menu bars with control box, minimizs, maximinize, close form boxes?
I could not find Menu design in Access...Is it available during design time? When I searched for it I found AddMenuItem to programatically add menu... I vaguely remember seeing menu design in VB 3.0 7 years ago...I am looking for something similiar..
This probably the simplest and stupidest question..please excuse me for that.
I was just editing my Access database (stored on the intranet) when a message popped up saying "Disk or network error".
I clicked the only option ("ok") and closed the DB. When I reopened it, it said someone else was viewing it and I only had read permissions. I close it again, and see that in the directory where my .mdb file is stored I have the .ldb file remaining even though it isn't open.
I restart my machine, and try and open it again. I have to compact and repair the DB at Access' suggestion, yet now I only seem to have limited functionality....??
I.e. there is no Tools menu, I can't right click on forms or tables to choose Design View (although if I highlight them in the database pane and click the BUTTON for Design View I am able to proceed)....
What's going on?!!
I've tried going to File > Open and in the little arrow on the Open button choosing "Open Exclusive", but it opens and does the same thing as above...!!
I've checked a different database in Access, and I don't seem to have gone potty, in every other one I'm able to see the Tools menu, etc...?
Anyone got any clues as to how I can get my lovely database back on its feet and functioning properly? :confused: :eek: :rolleyes: :mad:
:confused: hi ,,, i have this Microsoft Application and i have unchecked the check box (Allow full menus ) in the starup ... So when ever i run the application i only get the menu bars : File, Window, Help, AdobePDF
I have just opened Access and for some reason my menu bar is gone. I have fiddled for a few minutes try to find and restore it - but I am clueless. It is working fine in all other programs.
I do not want any menu bar in some application I have made using a switchboard. In the start-up function I unchecked all the checkboxes but some menu functions keep coming back. How can I overrule this?
I am about to create the menu (navigation) structure for my system but wanted it to be fancy. Anyone got any suggestions or GOOD websites that have different menu types. any help/suggestion would be appreciate!
I work for an Internet Marketing company and my boss wants me to design a huge huge form in Access - requiring alot of Drop Down Menus. Alot of them are simply Yes/No questions, some, however, are not.
This is what I have done so far:
I have a field called Sector which I have selected as a Yes/No Field.
In the Form Design View I have selected:
Row Source Type = Field List Row Source = Sector (this is a separate table in which I have put all the options)
In Format, instead of Yes/No, I have changed it to "-" - this is simply because when I view it Normal View the first thing in the Drop Down Menu is a Yes or a No.
This all seems to work fine until I try to select one of the options and I get this error:
"The Value you entered isn't valid for this field - For example, you may have entered text in a numeric field or a number that is larger than the FieldSize settings permit"
I have gone back and forth into the Design View on the Form and the Table trying different things, but nothing I do seems to work.
I don't even know if I have gone about doing this Drop Down menu in the correct way to begin with.
I'm not an Access Expert so please if anyone has any ideas please let me know. It'll be much appreciated :)
I'm currently using Microsoft Access 2000. In there I've created a Customized Menu. Now what I'm looking to do is - when I click a menu item, I want it to enable another menu item. I tried using "SetMenuItem Action" but it keeps on telling me that this function only works with customized menus. I'm sure I created a customized menu.
I have many forms having menus created by me. Instead of command buttons i used labels that can change colors on mouse move and execute procedures on click. It works perfect but on mouse moves it seems flickering. It's not a problem but it is a bit annoying. I'm giving a sample if anyone want to use my idea. I doesnt have many menus so maybe you can't see the flickering, but with many menus it is annoying.
I have searched and read and figured out how to make a custom menu bar. I see how I can use the forms property sheet to change the menubar that is available when it is open.
I've also seen code to hide the database window so that the form appears as a stand alone application. Like these links:
When I change the forms menubar property to me menubar, my menu bar is dsplayed when I open the form. It is displayed in the Access window, not in my form.
I have a database designed on court bookings in a racquet centre. On the court booking form i have a drop down menu of the courts and i want it so that when you click the "book" button at the bottom it removes the selected court from the list so you cant book it twice, any ideas?
