No Tools Menu...?
Aug 4, 2005
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:
View Replies
ADVERTISEMENT
Aug 29, 2007
Hello,
I've read most of the General category on Toolbars and Startup Menus, but still can't figure this out. I have no VIEW or TOOLS on my toolbar, so I can't get to the startup menu, toolbars, or anything else. When I go to Customize, one option is Built-in Menus. When I try to drag the VIEW or the TOOLS to the menu bar, it won't happen. I have tried the Shift trick, but it did not work either. Can someone help me?
View 1 Replies
View Related
Dec 17, 2004
I wanted a Switchboard page in Access to open automatically when the database was opened. I've done that but, as I did it, while in the Tools/Startup to set Display Form Page (in this case a switchboard page but it's not opening full screen and I ow have no way of editing anything), I stupidly de-selected the options there...
Display database window, Display status bar, Allow built in tool bars allow toolbar/menu changes.
Now I have lost the tools Menu, the View Menu and others (where one sees, File, View etc at the top of the window) and I can't work out how to get them out. I can no longer view my Access pages in Design View so I can't amend the any pages.
Can anyone tell me how to get my View and Tools menus back on my Access app window?? It's a bit of an emergency... been up all night and have to hand this in as coursework at uni in about 3 hours and I've screwed up right at the end and can't do the last couple of things before putting it on a CD for my tutor to mark.
Help!
I'd also like to know how to get it to open the first form at full screen.
Thanks.
Ceri
View 1 Replies
View Related
Aug 15, 2005
hi there...
where can i find free access developer tools? please help..
thanks
View 4 Replies
View Related
Mar 22, 2008
Hello All,
I have made a critical error with my system, in tools on startup i unticked all the boxes, and now when it loads it brings up the system only and not the design view tables etc,
Is there anyway that this can be undone??????
View 14 Replies
View Related
Apr 13, 2007
*Can anyone tell me if or how to reffer to the options from Tools-->Startup in VBA code? I`m asking that because i want to open a database in different ways
taking in account the logged user.
*And another question: in access 2000 is possible to make .mde files? Because the option is dissabled in tools--> database utilities menu.
Many thanks,
bogdan
View 2 Replies
View Related
Aug 2, 2007
Hello,
I created a database, and was trying to get the welcome form, to load full screen. So I unchecked all Menu bar and Shortcut bar (allow)
So I now have locked my self out.
Any ideas, I once remember something like ctrl while opening the database, but that does not fix it.
Thanks,
Ranger
View 3 Replies
View Related
Mar 8, 2008
Although I have been using access for a year or two (self taught) I have only recently noticed that the form toolbox (the one with combo boxes and buttons etc on it) appears to have a library of procedure calls for calendars and all sorts of things sitting there waiting to be used. Is there a list somewhere of what all this lot does? I have been playing with a couple of date pickers but I don't particularly want to go through all of the rest to see what they do or if they would be useful.
Thanks
View 2 Replies
View Related
May 31, 2006
Could someone please give me a link or place to find a descreption of all the "More Tools" that you can use when building a form. If I had a list I could pick what is best for my database and explain things better to management...thanks.
View 3 Replies
View Related
Jun 9, 2006
Hi Guys & Gals,
I have a report that runs a number of queries via a macro in the on open property. These queries populate a table used in the report. The on close property runs a query to clear the table contents.
When a user ran this, he had a flurry of warning notices which I tracked down to the Confirm settings in the tools/options/edit find tab.
Is is possible to set these using vba?
I guess that this could be achieved using send keys, but this would probably be a bit clumsy - to say the least.
Can it be done so that the settings are changed only for the current session so that users have the original settings?
Any thoughts welcome.
Regards,
Keith.
View 10 Replies
View Related
Sep 7, 2013
I am building a tool rental data base.I have places a delete button on my Transfer form so the operator can erase any mistake that he/she just made on a Transfer ticket.When I push the button I get an error message saying that I can't delete the record because it is associated with 2 tables. I have one table the tracks the transfer and another that tracks the tools associated with the transfer.How can I delete the transfer and the associated tools records?
View 2 Replies
View Related
Jan 17, 2015
I want to hide external data and databasetools tabs only from my access program. How i do it ?
View 3 Replies
View Related
Feb 19, 2007
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!
View 2 Replies
View Related
Jan 17, 2015
i want to hide external data and databasetools tabs from my access program.
how i do it ?
View 3 Replies
View Related
Jan 8, 2014
I have created a simple login form that is based on User Name and Password.the table contains UserName, First Name, Last Name, Password and User Role(dev, admin...ect.)How can I change who can access different parts of the database?I want all the Development tools only accessable to People who have "dev" as a "User Role".Admin can only access the forms related to data entry and managers can view all forms but not the tables, querie and tools...ect.
View 3 Replies
View Related
May 15, 2006
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.
Thanks in Advance!
:)
View 2 Replies
View Related
Dec 9, 2005
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 ?
jon
View 4 Replies
View Related
Apr 4, 2006
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
End Sub
View 2 Replies
View Related
Oct 3, 2006
Hi,
I have a question.
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,
/////////////
Opening C:Program FilesMicrosoft OfficeOffice 10Excel.EXE
Some files can contain viruses or otherwise be harmful to your computers. It is important to be certain that this file is from a trustworthy source.
Would you like to open this file?
''''''''''''''''''''''''
How can I erase this security message? Thanks.
View 1 Replies
View Related
Feb 8, 2007
I was trying to change the form that appeared on Load by going to Tools>Startup and changing the settings there.
However now I have lost most my my menu bar i.e. Edit, View, Tools etc. I only have File, Window and Help. :eek:
How do I retrieve the menu bar in its original state?
View 3 Replies
View Related
Mar 1, 2008
In my access 2003 the principal menu is not more visible.
I have used the command:
CommandBars ("Menu Bar"). Visible = True
but it doesn't make to appear the menù.
What can I do?
View 2 Replies
View Related
Aug 10, 2005
Hello,
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
Cheers :)
View 4 Replies
View Related
Apr 29, 2006
I have a question of creating a few menu bars.
I made 3 menu bars.
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?
View 1 Replies
View Related
Aug 25, 2006
Hello, I have created my own Menu bar in access and would like to add sub menus to it.
Any help? Thanks.
View 3 Replies
View Related
Jun 27, 2005
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.
Thanks
View 2 Replies
View Related
Jan 3, 2006
: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
how can i get the other menu bars ?
any suggestions
thankx:o
View 6 Replies
View Related
