Hidden Menus On Startup - How To Unhide
Jul 23, 2007
Hello,
I have hidden most of the menu bars for my database (from the tools.. startup.. menu) and I dont have a backup of my latest database (yes, I know, stupid.) The only menus I have are File, Edit, Insert, Records, Window and Help. The database window is also not displayed.
How do I get them back..? My database is set to load a form on startup, all data is accessed via a set of forms linked from the first. I cant access the tables, design view, anything. I feel like such a muppet...
Help!!
View Replies
ADVERTISEMENT
Jul 23, 2007
Hello,
I have hidden most of the menu bars for my database (from the tools.. startup.. menu) and I dont have a backup of my latest database (yes, I know, stupid.) The only menus I have are File, Edit, Insert, Records, Window and Help. The database window is also not displayed.
How do I get them back..? My database is set to load a form on startup, all data is accessed via a set of forms linked from the first. I cant access the tables, design view, anything.
Help!!
View 2 Replies
View Related
Oct 11, 2007
Hi..
I got a access file from a friend of mine, but when i open it in access, i don't see any tables or the standard menu buttons.
The only menu i see, is a docked menu with a couple of submenus, wich in turn open forms, where you can enter data..
How can i see the tables and bva script behind this access file?
I tried F11 and Alt-F11, but is does nothing.
He won't tell me how he did it, because he doesnt like to share what he knows...
Can anyone help me??
Thanx !
View 6 Replies
View Related
Oct 27, 2006
Whilst trying to tidy up my database in the Start-Up menu, I checked the boxes that hid all toolbars and menus, so now when I open the database, all I get is the opening Main form I created.
Does anyone know how to correct this please, I need to continue working on the database and it is driving me nuts............
View 1 Replies
View Related
Apr 19, 2007
I disabled all the menues in the startup....how do I reverse this?
View 3 Replies
View Related
May 4, 2014
I am able to bypass the shift key so I can disable ribbon and all menus at startup.
But the issue I have is anytime someone makes a copy of the database or it is their first time opening it they get prompted with the security warning:
"Security Warning - some active content has been disabled, click here to enable"
and it gives them complete access to see the back end of the database because while that warning message is popped up ... before they click "enable" they can go do anything in the database including see tables, data, and vba.
Once they click "enable content" that first time the bypass takes effect and the ribbon and all menus disappear, but if they dont click it they can navigate all around the db
how can i stop that?
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 31, 2005
I created an app., for tracking changes, where once the user is logged in , the login form is hidden.
When a user modify the status of a change, i cretaed an event procedure in the update before. In that event procedure i am opening a new form to ask to continue or not and then i hide it. When the program comes back to the form where the event procedure is, it closes the hidden form, which asked to continue or not. The problem is that it closes the login form as well.
To sum up:
-Login form is hidden
- Edit form calls Confirm form
- when user comfirm, teh comfirm form is hidden.
- Edit form, close Comfirm form and also login form. (i dont want to close login).
Here is the code to close comfirm form in edit form....
DoCmd.Close acForm, "comfirm"
thank you, max.
View 1 Replies
View Related
Jan 15, 2005
Yes...I am a newbie. In an attempt to secure my database, I accidently hid my entire datebase from everyone, including myself. How do I "unhide" it if I can't see it? I know that there is a really simply answer to this problem but I haven't found it yet. Please HELP!
View 6 Replies
View Related
Mar 25, 2015
In what I believe is called the Navigation Bar - the bar at the left of the Access screen, one can see the various tables, queries, forms and modules associated with a project. As an experiment, I right-clicked on a form, and clicked the option "Hide in this Group". Now it doesn't show up in the group. But I can't figure how to get it back. I assumed there was some sort of unhide command like in Excel. If there is such a command in Access I can't find it. How do I make it so I can once again select this form so I can open it in design mode. (I assume that the form still exists in the project, because I didn't delete it).
View 2 Replies
View Related
Dec 21, 2005
I did hide the menu bar,
Tools->customize....
but how can I unhide the menu bar, because hide/unhide option is on the menu bar. If I hide it, then I cannot unhide it.
View 4 Replies
View Related
Sep 13, 2006
Dear Friends I made my a stupid mistake and I don't know how to rectify it.
There is a inventory software built in access xp. In order to protect database I've cleared all the options from that is
a) Display Startup form
b) Display status bar
c) Allow Full menus(Changed with Custome Menu)
d) Allow Default shortcut keys
e) and foolish thing cleared Use special key also
I've given a task to modify program where I may have to add New form. I don't know how to unhide database window. pls suggest me what to do....
View 2 Replies
View Related
Apr 24, 2008
Ive set a formula within a query field to hidden, and i cant seem to get it to display again, i have gone to tools>options>view and checked view hidden objects but still nothing
any advice?
View 2 Replies
View Related
Oct 16, 2004
This is complicated!
I need to be able to have user run 5 different queries,
I think, and have the results from those queries show
up one under the other on one form footer.
Ex. fld 1 fld 2 fld 3 Date Range
fld 1 fld 2 fld 3 Date Range
fld 1 fld 2 fld 3 Date Range
Each of the rows would be based on a different query.
Also,
part of the query has a date range, and I would like
to have the Date Range from query show up next
to each row.
Thanks
View 1 Replies
View Related
Apr 8, 2008
I have a Access database that is used as the user interface for general users but the data is stored in SQL. My client has asked that general users be able to see only selected fields in the table. This means that they must only use the form to view records and not be able to get to the table.
How do I disable the the Window Unhide in the MDE?
View 2 Replies
View Related
Aug 18, 2004
*Disclaimer-I am a self-taught Access developer, so please bear with me*
I have been handed the task of developing a database to keep track of active and terminated security badges. I have a form that displays certain data for each employee. I have a check box on the form that signifies if the employee is active or terminated. The 'Term Date' box is on the form, but is currently disabled. I have been trying to find a way to have the 'Term Date' field enabled if the 'Active' checkbox is unchecked so that a termination date can be entered. Any suggestions? Please help!!
I don't know enough about Access to determine if this is possible, but I also was wondering if it was possible to reverse the action if needed (re-check the 'Active' checkbox and re-disable the 'Term Date' field)
I'd greatly appreciate any help that anyone can provide!!
View 6 Replies
View Related
Oct 6, 2006
Hello,
I woul like to programatically (with VBA code) hide and unhide the database window.
In Access 97, this can be done with Tools > Startup > Display database window box (check/uncheck).
But I would like my program does that himself : when the user launches the application, the database window should be hidden and when he leaves, the database window should be shown again.
Thanks.
View 9 Replies
View Related
May 7, 2013
I hid a query and now need to modify the fields, how can I unhide the Query in 2010?
View 1 Replies
View Related
Mar 5, 2014
I want to be able to open a form and unhide some fields on that form that have been set to hidden, basically if the file paths are wrong it ponts them back to my form where they fill them in , normally these are hidden
Code:
'checks to see if the file paths in the admin screen are ok before allowing to go foward to avoid errors from dowloading data
'get the file path to import data
Dim ImportLoc As String
ImportLoc = DMax("[Path]", "TblsysTransImport")
'Gets the file path to export data
Dim ExportLoc As String
ExportLoc = DMax("[Path]", "TblsysTransExport")
' checks to see if the file path is valid to stop people going further if incorrect or first time use If Dir(ImportLoc, vbDirectory) = "" Or Dir(ExportLoc, vbDirectory) = "" Then MsgBox "sorry but your Import / Export locations dont exsist " & vbNewLine & "These are required so you can download your scan data. " & vbNewLine & "You will now be redirected to enter valid paths"
'open form where they update the paths
DoCmd.OpenForm "Frmadmin", acNormal
'normally hidden
Frmadmin!Line111.Visible = True
i tried to use Frmadmin!Line111.Visible = True
but it says object required (line111 does exist?)
View 3 Replies
View Related
Jan 11, 2014
I downloaded a time clock template the other day and Ive been tweaking it for a while now. There is one thing I can't figure out:
There is a form called frmClockOut, which is a subform on frmClockIn.
This subform appears after the ClockIn button is clicked. The problem is, if I close the database for any reason, and leave someone clocked in, the ClockOut button does not appear until after you re-click ClockIn.
The developer has put in a safety so that it does not "double-punch" someone in or out so its ok there. Id just rather keep this subform open or always showing and cannot figure out where its done on here.
I will upload the blank template that I tweaked.
View 3 Replies
View Related
Jul 22, 2014
I would like to hide/unhide the navigation pane completely by using two buttons (pop the hood & close the hood) in a form. At this moment I used the following code:
Private Sub Command77_Click()
DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide
End Sub
Private Sub Command78_Click()
DoCmd.SelectObject acTable, , True
End Sub
This however makes my form shut down and not my navigation pane.
View 6 Replies
View Related
Sep 15, 2013
I have tab control form with (5) tabs. For this discussion - Tabs 1 through 5. For a blank (new) form sheet tabs 4 & 5 need to be hidden. Based on what is selected via the drop down box (on tab 1) then tabs 4 & 5 may remain hidden or needed to be un-hidden. Example: [DropDown1]
Selection 1: stay hidden
Selection 2: unhide
Selection 3: unhide
Selection 4: stay hidden
Selection 5: unhide
Selection 6: stay hidden
Selection 7: unhide
Selection 8: stay hidden
Selection 9: stay hidden
I think one I figure this out then I can use the 'OnCurrent' event to check the drop down selection as a user selects the a record or scrolls through records.
View 2 Replies
View Related
Jan 18, 2006
I was curious,
How do you add a Menu to a form? Like is there a way to have a Main Menu bar and add the individual menus/menu items with custom events? As well can i cusomize the context menu for the form, or make a popupmenu that is executed upon clickin a command button?
There is a lot of help on how to attach menus to properties and such, but I can't find an item "Menubar" in the access interface.
Thanks
Jaeden "Sifo Dyas" al'Raec Ruiner
View 2 Replies
View Related
Apr 13, 2006
I have an application that hides all the normal Access menus, so that the user can only use the buttons that I have put on the screen forms. Now however, when I open up access, I cannot get to any of the Access menus. It shows the toolbar, but not the normal FILE/EDIT...TOOLS/HELP menu.
How do I toggle this back on? Everything I have been able to find so far tells me to go to the TOOLS menu ---- I cannot get to the TOOLS menu.
Thanks. BTW, I am not really as stupid as this post makes me sound.
Mike Redmond
View 6 Replies
View Related
Jun 26, 2005
I'm sure there must be a simple answer to this question but I have been unable to locate the answer.
I recently finished a database program under Access 97 and unchecked the boxes to allow menus. Now I need to fix a few mistakes and need to access my code or the menus to do this. Is there a way to get access to my code.
Any help would be appreciated.
Thanks
rtamd
View 2 Replies
View Related
Mar 16, 2006
I did something in the start up options with this database.
Now when I open it I can't get Access to function as normal.
There is no right click, no tool barr or menu.
Any ideas?
View 1 Replies
View Related