Hide/unhide Menu Bar
Dec 21, 2005I 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.
ADVERTISEMENT
Hide / Unhide
Aug 31, 2005I 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.
Hide/unhide Txt Fields
Oct 16, 2004This 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
Hide/Unhide Database Window With VBA Code
Oct 6, 2006Hello,
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.
Using Buttons To Hide / Unhide Navigation Pane
Jul 22, 2014I 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.
Forms :: Access 2010 - Hide Menu On Startup?
Feb 4, 2015Well, I made the move and am using Access 2010 now and I am running into a couple issues.
First off, I want to get rid of this menu on startup:
Not sure what it's called (ribbon, menu bar, etc). I am able to hide it using
DoCmd.RunCommand acCmdWindowHide
DoCmd.ShowToolbar "Ribbon", acToolbarNo
...in the OnLoad event, but this only works when running the opening form from the form list. When the form runs at startup the menus do not hide.
Also I would still like to have the file menu available because sometimes the user need to access the print menu to choose an alternate printer.
How Do I Unhide My Database? :(
Jan 15, 2005Yes...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 RelatedHow To Unhide A Form
Mar 25, 2015In 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 RelatedHow Unhide Database Window
Sep 13, 2006Dear 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....
Unhide Query Field
Apr 24, 2008Ive 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?
Disable Window Unhide
Apr 8, 2008I 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?
Unhide Based On Previous Value
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!!
Hidden Menus On Startup - How To Unhide
Jul 23, 2007Hello,
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!!
How To Show A Full Menu On The Menu Bar
Feb 19, 2007Hi 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!
Menus Hidden On Database Load - How To Unhide
Jul 23, 2007Hello,
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!!
Queries :: Access 2010 - How To Unhide A Query
May 7, 2013I hid a query and now need to modify the fields, how can I unhide the Query in 2010?
View 1 Replies View RelatedModules & VBA :: Open Form And Unhide Labels?
Mar 5, 2014I 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?)
Forms :: Unhide - Always Show Form From Template
Jan 11, 2014I 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.
Unhide / Unlock Normal Access Table View And Menus
Oct 11, 2007Hi..
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 !
Forms :: Unhide Form Tab Controls Based On Drop Down Selection
Sep 15, 2013I 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.
Drop Down Menu Inside Drop Down Menu
May 15, 2006Ok, 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!
:)
Need Help With Menu Bar
Dec 9, 2005Before 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
Help With Menu Bar
Apr 4, 2006I 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
Menu
Oct 3, 2006Hi,
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.
Menu Bar
Feb 8, 2007I 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?
Menu Bar
Mar 1, 2008In 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?