Forms :: Command Bars Custom Shortcut Menu - Font Color Picker

May 15, 2014

I 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.

View Replies


ADVERTISEMENT

Modules & VBA :: Creating A Custom Shortcut Menu

Jun 5, 2014

I'm working to put together a shortcut menu for a form that will be viewed as a datasheet. I'm trying to put together the vba to create the menu. I'd like a lot of the standard options i.e. sort a-z, filter toggle etc. I'd also like to add the menu option that is displayed in the default menu called "Text Filters". I've been unable to find the id code for that option, and since it, when chosen opens another menu, I'm not real sure how to code it. Here is what I have so far:

Sub CreateWIPShortcutMenu()
Dim cmbRightClick As Office.CommandBar
Dim cmbControl As Office.CommandBarControl
' Create the shortcut menu.
Set cmbRightClick = CommandBars.Add("cmdWIP", msoBarPopup, False, True)

[code]....

View 2 Replies View Related

Modules & VBA :: Creating Custom CommandBarControl Objects For A Shortcut Menu?

Aug 16, 2013

I finally got tired of having 100 macros managing my different custom shortcut menus, and decided to figure out how to generate the shortcut menus programatically (because lets be honest, Macros are the devil.)

I found a good tutorial here : [URL] .....

and was able to create some basic shortcut menus like the following:

Code:
Sub CreateCopyShortcutMenu()
Dim cmbshortcutmenu As Office.CommandBar
Set cmbshortcutmenu = CommandBars.Add("CopyShortcutMenu", _
msoBarPopup, False, False)
'ID 19 adds copy command
cmbshortcutmenu.Controls.Add Type:=msoControlButton, Id:=19
End Sub

Nice and simple, now I have a copy command. But the problem is that I also need some custom commands. Most (possibly all?) of these would be function calls.

View 3 Replies View Related

Tool Bars / Menu Bars - GONE

Apr 20, 2006

Help! 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.

View 14 Replies View Related

Forms :: User View - Reduce Amount Of Options On Menu Bars

Aug 15, 2013

I 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 Related

Forms :: Toggle Box That Changes Color Font?

Aug 2, 2013

I created a form that has about 200 fields and all the fields are utilized at a point depending on the work order assigned to us. I wanted to know if it's possible to put like a toggle box or a check box etc. next to the field so if it is checked it would be in a Dark color and the ones not utilized are in a shade of gray. All the fields are coming from the same table. Another thing it's an estimate worksheet so a row would have something like, Labor, QTY, HRs, Overtime, total as columns, so I would want a check box to have control over those but one for each row, EX contractor, locksmith.

View 3 Replies View Related

Forms :: Adding Entries To Shortcut Menu Dynamically

Jul 26, 2013

I am using Access 2003 and have a custom shortcut menu. I wish to add some entries to this shortcut menu dynamically.

Background : I am displaying a list of customer orders and wish to offer the user the facility to filter the search for one item instead of the default of ALL.

The dynamic entries would be the unique order item reference nos. retrived for that particular customer retrieved via recordset . So the menu would show :

ALL
------
Model 1
Model 2
Model 3
etc.
...

How am I able to add these entries to the menu, the selection text will be the filter text I use to report upon.

View 11 Replies View Related

Forms :: Change Font And Background Color Based On Date?

Mar 28, 2013

I would like to change the Font and background color based on dates.

-I have a text box (Training Event) on a form populated from a field (Training Dates) in a query.

- I need the font and/or the background in that text box to change to red when the date is 12 month past, yellow 11 months past, white 10 months past and green for 9 months past.

View 3 Replies View Related

Forms :: Change Font Color And Appearance While Entering Data Into A Form

Mar 13, 2013

I would like to be able to change font color and appearance while entering data into a form (example: italicize a word). Is there any way to activate the font format while in a form?

View 2 Replies View Related

Turn Menu/tool Bars On & Off

Jul 15, 2005

What 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 Related

Creating Customized Menu Bars

Aug 4, 2005

Greetings.

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

View 10 Replies View Related

Forms :: How To Create Custom Menu Options In 2010

Sep 15, 2014

How to create custom menus in Forms in MS ACcess 2010. For example, I have a form fmrMainMenu. At the top of the form I want to create a menu labelled "Reports" that when clicked or hovered it displays a list of sub-menu options of all the Reports available in the database. Once the user makes a selection the report is generated. The functionality that I am looking for is similar to the old menu options like File, Edit, etc., in MS Office.

View 3 Replies View Related

Disable All Menu Bars Except The Right Click Mouse

May 1, 2006

Hi,

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.

View 1 Replies View Related

A Useful Color Picker

Apr 6, 2006

After Searching the Web, I couldn't find anything that did something as simple as this, choose a color....

So here is one!

Waste not, want not....please feel free to use it!

View 1 Replies View Related

Showing Changes With Font Color

May 26, 2005

I did some searching on changing the color of a font if you change the data. I found a few posts but they really don't fit the need.

I am using a continuous form (which makes this even more difficult) and when someone changes data in a field I want that forecolor to change from black to red.

Is there an easy way (I know not everything is easy) :) in the conditional formatting to create an event? I am thinking not but thought I would ask.

My GUESS is that I need some sort of temp table to verify the data against then return with the forecolor change.

I am using A2k.

Thanks RichB

View 14 Replies View Related

Tab Control Box - Font Color

Oct 5, 2005

I believe thats the proper word for it. Attached is a screenshot of a section of the database that I have started working on. It is to track placement for a college. Its my first ever and I am fairly good at making things look good, but as far as function - I am terrible.

I can change the raised box that the tab control sits on to a dark maroon when someone has a felony (so it notifies the user of this status)

Private Sub Form_Current()
If [Felony] = True Then
Felonybox.BackStyle = 1
Felonybox.BackColor = RGB(159, 19, 44)
Else
Felonybox.BackStyle = 1
Felonybox.BackColor = RGB(208, 207, 202)
End If

End Sub

I also have this done on After_Update.

I am trying to change the font on the Tab Control to Red when this occurs as well (only change the 'Criminal History CONFIDENTIAL' to red). I can not find this option anywhere, is this something that has been done or CAN be done?

Using A97

John D

View 3 Replies View Related

ALT+ Shortcut For Custom MenuBar

Jan 31, 2006

I have created custom menus for forms. The menus come up and go away as needed when the form is open. No problems there. The problem is that the ALT shortcuts aren't working when the form has the focus. If I leave the database main window open and give it the focus (form is popup) the ALT+ works fine, but when the database is complete I will be hiding the database window. I have experimented with that already and still get the same results. I have tried making the form modal and popup, popup only, modal only, and neither. No matter the configuration:eek: , the ALT+ does not seem to work. In case it isn't clear, ALT+C if the menu is &Control, etc...And I have removed the built-in menus so there is no conflict that I'm aware of with the ALT+ commands.

I'd appreciate any help you can give on this problem.

View 7 Replies View Related

Changing Font Color According To Selection

Jun 14, 2006

(Simplified example)

On a form I have a combo box - let's call it cmboSickness. it has two options "flu" and "malaria". On the same form I have two command buttons - one ehich opens a malaria form and one which opens a flu form. If I select flu then I want the words on the flu command button to change to red. How do I do this and where do I put the code?

I have tried -
If me.cmbosickness=flu then
cmdflu.color=255

but this doesn't work...

View 3 Replies View Related

How To Change Font Color In A Form

May 16, 2014

All I want to do is change the font color and weight of a couple of columns in a form. No conditions or change when button is pressed or anything like that. Just be blue and stay blue.

I've tried making it a memo, rich-text field and it didn't work.

It works fine in the "member details" form, but not the "member list" form.

Member Details:

Member List:

View 6 Replies View Related

2 Mins Of Your Time! Shortcut Menu

Mar 13, 2007

Hello,

I am going crazy! I have managed to do this in a previous database and now I can't remember how I did it.

I want to create a shortcut menu for a report that when I right click the mouse button it gives me the option to print. When I select print on this shortcut menu it goes straight to the printer instead of giving me the printer dialogue box.

Please help!

Thanks

View 4 Replies View Related

Textbox Font Color Dependent On Check Box

Oct 25, 2004

i have a report which i need to make certain results displayed in Red, if there is a check in the box.

example:

my report is called OEEModel
on the form i have a chkbox - called "FailureModeInPlace"
i also have 2 text boxes called "EventCode" and "CodeDescription"

what i want to do is for each record that is displayed with a chkbox ticked that the font in the two boxes turn red and bold...

can this be done please if so...how

cheers

Andy

View 1 Replies View Related

Changing Font Color Of Just Part Of A Label

Sep 11, 2015

Is it possible to use two color fonts on one label? I want to bring attention to the user that by clicking a certain button they can perform a search by "Name" and by clicking on the other button, they can perform a search by "Appointment".

I have a switchboard type form with some buttons. The two buttons in question are labeled, "Search for Appts by Name" and "Search for Appts by Appointment". I want to keep the "Search for" section of the button in black font, but change the "by Appointment" and "by Name" to red font.

View 3 Replies View Related

Hide Partial Command Bars

Sep 15, 2005

Hi,

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

View 3 Replies View Related

Modules & VBA :: Text Font Color Based On Tab Selected?

Aug 8, 2014

We have a navigation page with 5 tabs and several navigation buttons underneath their respective tabs linking to reports.

In the main part of the navigation page we have 17 search parameters (text boxes and combo boxes)that the user can use to sort through all the reports we have in the different tabs.

What we would like to do is to have the label text to change to "red" if one of the 17 fields are "required", remain "black" if it is included in the report but not a mandatory search parameter, or turn "light grey" if that parameter is not included in that report.

For example:

My search parameters are: people, phone, and cars

If I were looking at a report of people that included addresses, phones, etc...name and phone would be required search parameters. However, even though I can search by car, it is not in this particular report and the label text should be greyed out. (If the actual text box could go inactive that would be even better).

I have read about buttons being turned colors based on a drop down box choice, but I have not been able to find anything about using a navigation tab subform button to make the colors change in the main navigation form.

View 14 Replies View Related

Modules & VBA :: Edit Font Color Based On Field Value & Age

Mar 4, 2015

I am attempting to adjust the font color of a date field on a report based on the value of two other fields. I have the below code set in the "On Format" property of my detail section - however it does not work when I open the report to view.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.Frequency = "Annually" Then
If Me.ClassDate < (DateAdd("yyyy", -1, Date)) Then
Me.ClassDate.ForeColor = vbRed
Me.ClassDate.FontBold
End If
End If
End Sub

View 1 Replies View Related

Change Font Color Of Selected List Box Item

Jun 3, 2013

My list box will be used to populate a form, is it possible that once the item is dble-clicked, it reverts to a different color to let the user know it has already been selected once or can the row be locked once it has been selected?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved