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,
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.
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?
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:
*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.
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.
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.
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?
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?
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.
On my database, for startup, I had the toolbars taken away from the user. Is there a quick shortcut to pull them back up? I noticed that the 'Tools' option is gone.
I have a database (split) I developed using Access 2000 (Office Professional). I installed it in a lap top that has Office Prosessional 2002 and am encountering several problems: 1) The shift-key bypass does not work; 2) My application uses an access wizzard switchboard. With the lap top, when I open a form from the switch board and subsequently close it, Access closes; 3) When I just open Access in the lap top, I get none of the standard tool bars. (I don't know if I caused this). This has to be something obvious that I just cannot see. Thanks in advance for your help.
I've created a new database, and unticked the options in Startup which mean the various menus at the top are hidden - and I don't know the keyboard commands to get them back :S
I created a database and put some time into it at work here. I am sure this is a simple fix but I need to know how to get my tools back at the top of access. :(
What I did was open startup, unselected all the features that locks the database user out from changing settings and just using the switchboard and forms. Well, I cant figure out how to get into the file and change it all around now. :eek:
I am using access 97 at work now so please respond asap with an answer about how to get to change my tables, forms, and use tools again...:confused:
Here is something I hope someone can help with. I have mostly completed my Access program. I was toying around with the startup options and I selected not to have my toolbars in the startup in fear that other employees at work could mess up the program. Now I would like to tweet my database and add to it but have no toolbars to make any changes or add new form or anything. Is there a way to now change my startup options back to normal and get back my toolbars or do I have to re-create the complete database? Help please!!!!
How do I get rid of the start up dialog? The boxes which pop up and say "Security warning, Unsafe expressions not blocked" and the other that says "warning this document may not be safe blah blah blah".
Hey, I was messing about with tools>startup because I wanted a form to appear whent he database was opened.... I unchecked far too many options in there, and now I cannot design and modify my database anymore... it just goes straight to the form, but i cannot get anything back in design view.. is there a way to fix this??