How To Hide All The Bars
Jul 28, 2007How can I remove all the bars specially the menu bar:
File, Edit, View, Insert,...
ADVERTISEMENT
Hide Partial Command Bars
Sep 15, 2005Hi,
How can I hide all the command bars except my customize tool bar ? I have hide all my command bars by the following code :
' Hide all window bar
Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = False
Next i
DoCmd.RunCommand acCmdWindowHide
I can change “CommandBars(i).Enabled = False” to “CommandBars(i).Enabled = True” but I want only my customized tool to be appear. What is the solution?
Thanks,
Le888
Tool Bars / Menu Bars - GONE
Apr 20, 2006Help! I'm not sure how I did this, but NO matter what database I go into i can see any toolbar or menu bar. Yes I tried the shift key. How do I turn it all back on?
When I right click I can get the database startup properties, everything has the check, yet I can't see any toolbars or menu bars. I've searched though the help, and I can't see to find out how to put it back.
Scroll Bars
Nov 7, 2005I'm trying to auto scroll the Detail Section where the user will able to see the last record on my continuous form.
Can anyone tell me how to do this?
My sincere thanks!
Scroll Bars
Nov 12, 2004Basically what I want to do is create a form that combines 2 tables. For example, I want to be able to display a name, then display and be able to scroll through all information associated with that name. For instance, if the name had more than one address, how would I create that form with the right relationships and with the scroll bars? Thanx
View 3 Replies View RelatedScroll Bars
Dec 12, 2004Is it possible to change the color of the scroll bars?
View 1 Replies View RelatedAllow Built-in Tools Bars
Aug 2, 2007Hello,
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
Textbox With Scroll Bars
Mar 12, 2008how can i make a text box (with multiple lines) display a permant scroll bar on the right hand side?
View 2 Replies View RelatedScroll Bars In Listboxes
Jan 7, 2005In the forms that I have made, none of the listboxes ever scroll with the mouse scroll wheel. I have tried to click into the listbox first to ascertain that the focus is in the listbox but nothing works. the only way to scroll is to manually drag the scroll bar tab.
I want to find out how i can make my scrolling work. I guess that there must be a global setting somewhere to switch it on or off... Any insight into this will be highly appreciated!
Turn Menu/tool Bars On & Off
Jul 15, 2005What is the best way to turn all the menu bars and tools bars off and back on when a form opens and closes? Can you just loop through the numerated objects?
View 14 Replies View RelatedCreating Customized Menu Bars
Aug 4, 2005Greetings.
I am pulling my hair out trying to create a customized menu bar. Eventually, I want to have a customized menu bar and tool bar for report and different customized menu bar and tool bar for forms. I created the tool bar for the report window. Then when I tried to create a new menu bar I could not remove menu selections without removing the same menu selections from the default Menu Bar.
I selected View->Toolbars->Customize...
Then I clicked on New (command button)
Then I named it (RptMenuBar)
Then I selected 'Built-In Menus' from the Commands Tab
Then I dragged the 'File' from the Command list into the new Menu Bar
Then I went to the new menu bar and dropped down the selections under File and started to left click and drag what I didn't in the NEW MENU BAR. However, it turns out when I did that the same selections were removed from the default Menu Bar.
I was ablel to restore the default Menu Bar. But I want to have a customized Menu Bar and be able to select that new Menu Bar and associate it with every Report that is in my Database.
Any ideas? If you have some good instructional references, please point me in that direction. Thanks.
SueB
Scroll Bars Missing From Text Box.
Nov 26, 2004Hi Guys,
I have a text box containing a lot of explanitory text and I want vertical scroll bars.
I have set the 'scroll bars / vertical' in the properties of the text box and yet...no scroll bars. I feel that some other setting is preventing the scroll bars.
Anyone got any ideas?
Forms :: No Scroll Bars On Web Database?
Feb 17, 2015My problem is that I have a couple of forms where scrollbars are not appearing on forms when they are too long to fit on-screen. Instead they're just going below the bottom of the screen and there's no way to access things at the bottom of the form. This is happening with a data input form as well as with a form I'm using to filter and display a report. I've tried selecting both "Vertical only" and "both" for the scrollbar property of the form, but it doesn't seem to make any difference.
The forms are being opened in "dialog" mode, the only option for opening a form in a web database when using a macro to open it, it seems. If I manually open the form in 'normal' mode, it has scrollbars. Also, if I open a report with a macro (on click), it has the option to open in 'normal' mode and has scrollbars and all is well. But if I want the user to be able to click a button to open the form, it seems I have to use dialog mode.
General :: Graph Not Displaying Bars
Jul 24, 2012i have managed to retrieve information to my graph but i am unable to see the bars.
View 2 Replies View RelatedHow To Label All Bars Of Chart At A Time
Jan 26, 2012How to label all the bars of the chart at a time?I wanted to select all the bars to label them but couldn't do it! Then how can I select and label all the bars at a time?
View 4 Replies View RelatedDisplay Scroll Bars In Form Problem
Nov 7, 2006Hi,
I sat my form properties to display both scroll bars, but it's only dispalying the horizontal one even though the form needs the vertical (a few text boxes are not displayed because they are at the bottom of the form).
I have tried to close the DB and reopen it again and played about with the properties, but it still does not show the vertical scroll bar.
Any help will be very much appreciated.
Regards,
B
Title Bars In Access Form, Tables Etc
Dec 13, 2006Hi Can anyone advise me if there is a a way to remove or hide the "title Bar" at the top of the window on forms etc. The bar I mean is the one with the icon followed by e.g "Access - Forms [switchboard -Form]"
Any help would be appriciated.
Many thanks
Paul
Setting Scroll Bars In Microsoft Access
Dec 15, 2007I am having a problem with displaying the scroll bars in Access. I have created a database which is viewed correctly in 1280x720 screen resolution, which is our standard setting. However, we have recently taken on some users with sight problems, and they are using a different screen resolution.
This means that the forms do not fully display on the page, and I would like to add scroll bars to the access window rather than the form so that the user can move up and down the displayed form. Is this possible?
Any help will be much appreciated!
Disable All Menu Bars Except The Right Click Mouse
May 1, 2006Hi,
For i = 1 To CommandBars.count
If (CommandBars(i).name <> "Right Click Mouse") Then
CommandBars(i).Enabled = False
End If
Next i
I tried to use this code.
However, right click mouse is disable.
How can I disable all menus except the right click mouse option?
Thanks.
Access Graph Not Displaying Bars - Selection From Combobox
Jul 20, 2012I am having a problem with my access graph, I have a combobox and based on that selection from the combobox I need it to display on the graph. It works fine ,but once i change the query to what i want to be displayed on the graph it doesnt show the bars , just the information .
View 5 Replies View RelatedForms :: User View - Reduce Amount Of Options On Menu Bars
Aug 15, 2013I have created a front end and put into production for my users but I want to reduce the amount of menu bar options they see so someone cant click on a button wondering what it does and mess something up. What is the best way to reduce the amount of options a user sees on the menu bars when they open the front end of the db?
View 1 Replies View RelatedGeneral :: Disable Navigation Pane Db Window / Tool Bars To Users
Mar 11, 2013I use Access 2007.I have a db split in FE(forms, queries, vbcode) & BE(tables only).I want users not to be able to view or explore the tables, the queries, the form design and details, in both Ends.Unfortunately, even disabling via VB code the menus, the db window, the tool & status bars, they appear and are accessible to the users (it only works in a non-split db, turned to an accde).
How can I disable any view on forms, queries, vbcode and tables details and data to users, in both FE and BE and only allow them to add data through specific form?
Forms :: Command Bars Custom Shortcut Menu - Font Color Picker
May 15, 2014I am currently in the process of creating a pop-up menu to allow my users to do some simple text formatting.I have used the following code to do so:
Code:
Dim cmbShortcutMenu As Office.CommandBar
' Create the new pop-up menu instance
Set cmbShortcutMenu = CommandBars.Add("popupFormatMenu", msoBarPopup, False, True)
' Add the bold button
[code]....
The problem is that I now want to add the FontColor picker control and I keep getting an error.I think the problem lies in the type of control I want to add. According to the Microsoft support files I downloaded the fontColor control is of type Gallery and ID = 11949, so the code should look something like this:
Code:
cmbShortcutMenu.Controls.Add Type:=msoControlButton, id:=11949
I need to replace msoControlButton with something else.
Is There Any Way To Hide A Form...?
Oct 2, 2006Hi.
I was just wondering if you can hide a form in the windows status bar?
Hide Duplicates
Apr 4, 2006Goal - Show how many policies (dbo_Policy22.Policy.Number) were cancelled during a certain time period (Invoice Date).
Problem - a policy can be cancelled more than once and I don't want to count it after the initial cancel status (885).
Question - Below is my query. I'm thinking I type "Distinct" somewhere, but I have no idea where.
Please help :) Thank you.
SELECT dbo_Producer22.Number, dbo_Producer22.Name, dbo_Invoice22.Invoice_Date, dbo_Policy22.POLICY_STATUS, dbo_Policy22.Policy_Number
FROM dbo_Producer22 INNER JOIN ((dbo_Insured22 INNER JOIN dbo_Invoice22 ON dbo_Insured22.Insured_Key = dbo_Invoice22.Insured_Key) INNER JOIN dbo_Policy22 ON dbo_Insured22.Insured_Key = dbo_Policy22.Insured_Key) ON dbo_Producer22.Producer_Key = dbo_Policy22.Producer_Key
GROUP BY dbo_Producer22.Number, dbo_Producer22.Name, dbo_Invoice22.Invoice_Date, dbo_Policy22.POLICY_STATUS, dbo_Policy22.Policy_Number
HAVING (((dbo_Invoice22.Invoice_Date) Between [Forms]![PfrmYearToDate]![txtStartDate] And [Forms]![PfrmYearToDate]![txtEndDate]) AND ((dbo_Policy22.POLICY_STATUS)=885));
Hide 1 Record
Apr 10, 2007I was wondering if there is a way to hide 1 record from a query
say I have 3 user accounts and on a form I only want to display 2 of them form the query,so the other record is still present but cant be deleted by accident or viewed