Select whose birthday is in a certain month
How can we make a parameter query to know whose birthdays are in March for
example. What is the VBA in the form query. In this forum it is explain to
filter from start date and end date, but what we need is to select birthday
Thanks in advance
H. Frank Situmorang
See the following sample database:
Arvin Meyer, MCP, MVP
"Frank Situmorang" <firstname.lastname@example.org> wrote in message
news:CAA42C71-06A5-4157-87DD-529C40A2C94F@...If/Then statement that returns colors
Is there a way to use an if/then statement to set a cell color? For instance
...Mouse move selection
A Windows interface question, here for want of finding anywhere better:
(In eg an MDI document) when you hold the left mouse button down and move
the mouse, it creates a selected area.
When you move the mouse outside the client area it scrolls the window to
increase the area. The scrolling is faster (within limits) as the mouse
goes further away from the client area.
This is a standard Windows interface.
Problem: if a document has (eg) a very large horizontal extent, and the
window and its parent are maximised, then effectively there is no "outside
area" to enable one to a...Text color
When I open windows explorer and click on any word or folder way on the left
, it is highlited in a very light blue, how can I change that color to say
like dark blue like windows classic .
You would have to revert to a classic theme and then change the color for
"selected items" in the advanced color properties of Personalization/Windows
Color and Appearance. It's not customizable when running an aero theme.
Best of Luck,
Rick Rogers, aka "Nutcase" - Microsoft MVP
Windows he...Selective Column deletion #2
I'm not real familiar with writing code in Excel, so my question is
probably fairly simple.
I'm working with Census data and before importing it into SAS I want to
clean it up a bit in Excel. The problem is that the Census summary
tables give me three columns of information (an upper, lower, and
estimate), when I only need one (estimate). The matrices I work with a
usually in the 52x2000 range, so it gets very tedious to delete them by
hand. Can excel handle a 'delete if' or 'select if, then delete' type
delete if (column(contains(uppe...Change bars color
I have a dinamic chart to show the cash flow position, a scrool bar chagne
the data to the past and to the future (estimate), what I am looking for is,
to have an easy identification of the estimated period I would like to chage
the color of the bar.
I am using an Stacked Column chart with two variables.
regards from Brazil
Thanks in advance for your feedback.
What I usually do when I want to show a column chart with one color within a
certain range and another color elsewhere, is create two series, one each
color, and use formulas to change on series ...Can the color of the Command Bar be changed?
When you open up a window to show the contents of a folder, just below
the usual Menu Bar is the Command Bar with menus like "Organize" and
That Command Bar has a sickly blue-green color.
Is there any way to change the color of the Command Bar? At the very
least, I would like that color to be less saturated.
-- Steven L.
...Excel 2007 chart gridline color using vba
i want to apply a themecolor to a chart gridline using vba. I can
apply normal colors (RGB, index) but not the theme color. Any idea?
Here are the various ways fo changing the colour.
With .Axes(xlValue, xlPrimary)
If .HasMajorGridlines Then
.Border.ColorIndex = 5 'set color to blue
.Border.Color = RGB(0, 255, 0) ' green
En...summarizing selected data on a grid
I have a grid that I use to define attributes. I want to
summarize only the selected "types" (i'm just using "x" to
select on my grid). For example, by taking:
A B C
Type2 x x
Type4 x x
Type5 x x
I want to output:
With similar output's for B & C. I could do it with if
statements, but it's a pretty big grid, so I have a lot of
blank rows. Is there a better way? Thanks.
Have a look at your post: I suspect it has not reproduced as yo
intended. The table of x's doesn't seem to match the scri...CListCtrl Header height change??
CListCtrl Header height change??
Is it possible to change the height of a CListCtrl Header.?
...Selecting multiple public folders
I'm running Exch2003 and Outlook 2003. I need to add a user to a group of
public folders. In both Outlook and Exchange System manager I can only
select one folder at a time. Is there any way around this problem?
Pete Halasovski <email@example.com> wrote:
> I'm running Exch2003 and Outlook 2003. I need to add a user to a
> group of public folders. In both Outlook and Exchange System manager
> I can only select one folder at a time. Is there any way around this
Set up your permissions on the...Account not selected when coverting leads
There are 3 options to chose when converting a lead - account, contact and
opportunity. If you do not select the account, can you do so at another time?
Is there any way to create the account after converting if it was not
The Opportunity has to be linked to a particular account as it is a
required field in Opportunity.
The best thing to do is to create a default account and call it "None"
or anything you like and get the users to set the opportunities that has
no accounts when creating the opportunities to it as a temp account then
insert the correct info in the...Print Selection in Word
Attempts to print a highlighted area via print "Selection" fails when that
area includes a "Heading" Style along with a "Normal" style.
No error, the print job is just not created.
Seen in Word 2003 and 2007.
Thanks in advance.
Try updating the printer driver. Simply reinstalling the driver would also
be worth trying.
Microsoft Word MVP
"dkt" <firstname.lastname@example.org> wrote in message
> Attempts to print a highlighted area via print "S...EMail fonts, sizes and color
When I change my font type, size & color I can only click OK (tool-options).
Once I close Outlook it returns to the default font type, etc. How can I
change my default?
CD <CD@discussions.microsoft.com> wrote:
> When I change my font type, size & color I can only click OK
> (tool-options). Once I close Outlook it returns to the default font
> type, etc. How can I change my default?
What version of Outlook, what message format, what Outlook editor, and in
twhat window are you trying to make these changes? You're a little short on
Brian Tillman [...Selected/Unselected Filter on User Security Child Windows GP10
In GP 10 the child windows within the Security Task Setup and Security Role
Setup windows might be a little more user friendly if they had a filter for
those items that are selected or not selected. Just a suggestion.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
h...Problems with CListCtrl
I'm having trouble with a CListCtrl object. I'm trying to automatically
set the selected items of the list from my code. I try the following
m_List.SetItem (pos, 0, LVIF_STATE, NULL, 0, LVIS_SELECTED, LVIS_SELECTED,
The SetItem function returns non-zero, which supposedly means it was
successful. However, I don't see any selection showing up. I even called
RedrawItem on this list item, but it didn't help either.
Anyone know about this?
>I'm having trouble with a CListCtrl object. I'm trying to automatically
>set the selected ite...CTreeCtrl and CListCtrl problem
I use create a single document struct using MFC(explore
style).The left of the window is CLeftView class(which
inherit CTreeView).The right is CBrowserView which inherit
CListView.I want to display the content of a directory in
the right(CListview) when user click the item of the
In the LeftViw I add method "void CLeftView::OnClickItem
(NMHDR* pNMHDR, LRESULT* pResult)" because I want to know
which item be clicked by user.
data=mtree.GetItemDat...CListCtrl and sub item editting
Is it possible to implement CListCtrl sub item editting without creating a
I am using VS2003.
>Is it possible to implement CListCtrl sub item editting without creating a
There's no built-in support for this, so no, you have to provide some
implementation for this. Have a look on sites such as CodeGuru and
CodeProject, they'll have examples.
I've seen examples, I just wasnt sure if I needed my own ctrl.
"David Lowndes" <DavidL@example.invalid> wrote in message
news:k...Selecting or deleting data
Is it possible to have a formula which recognises whether to select o
A1 = xxx
A2 = yyy
A3 = zzz
C1 = (Nothing)
C2 = (Nothing)
C3 = zzz
The results in E1,2 & 3 should have data in A1 and A2 but not A3 or C
because Column C is for cancelled items and if it data in this colum
matches then they should cancel each other out.
Message posted from http://www.ExcelForum.com
try in E1:
and copy this down
>Is it possible to have a formula which recognises whether...nested select problem
Dim a As Double
Dim b As Double
Dim c As Double
a = 36.8
b = 44
select case a
case 36.6 to 37
Select Case b
Case 42 To 43
c = 26
MsgBox "hmm"'<<<<< this shud be shown as this is the point but it
isnt giving me this msgbox :S :S
Case 44 To 45
c = 26.5
what am i doing wrong?
On 9/2/2010 8:24 PM, Sabbir Ahmad wrote:
> Dim a As Double
> Dim b As Double
> Dim c As Double
> a = 36.8
> b = 44
> select case a
> case 36...How to add clistctrl into clistctrl?
How to clistctrl into a clistctrl? For example like adding checkbox ,
combobox, i want to add clistctrl into a clistctrl
...Filegroup restore used to selectively refresh filegroup in 2nd db.
I have TestDB1 comprised of 5 filegroups, which I've completed full/log
backups to to restore as TestDB2. When data changes within one filegroup on
TestDB1, I've taken a diff' + tlog backup and tried to use it to restore on
TestDB2 so that same filegroup would be essentially refreshed. My execution
sequence uses the last full, last diff', and tlog from TestDB1 but this
doesn't work? Why? Is there a way to do this in SQL 2K8? Thx. -CqlBoy
Message applying full backup:
>Processed 16 pages for database 'FGTestRestore', file 'FGTest_fg2' ...change colors in DialogBars
How is it possible to change the colors in DialogBars, I mean something like
OnCtlColor in simple dialogs,
> How is it possible to change the colors in DialogBars, I mean something like
> OnCtlColor in simple dialogs,
Tried returning your own brush when nCtlColor argument in
CDialog::OnCtlColor is CTLCOLOR_DLG ?, or am I misinterpreting your problem?
There is no problem in dialogs, I mean what to do if u want to change the
colors in a DialogBar ?
"Fahad Ashfaque" <FahadAshfaque@discussions.microsoft.com> wrote in message
n...Select distinct e-mail adresses
I want to extract some data from 2 tables One of the tables contains an
email address. I want the query narrow down so that a single email
address is only output once. What SQL statement can I use to get this
e.g. data contains
Field1 Field 2 Field3 EMAIL
a c w2 email@example.com
a d w1 firstname.lastname@example.org
a c w5 email@example.com
I only want to output
a c w2 firstname.lastname@example.org OR a d w1 email@example.com
a c w5 firstname.lastname@example.org
Thanks in advance
How about something like this?
SELECT Field1, Field2, Field3, EMAIL FROM
(SELECT ROW_NUMBER() OVER (Par...query return a randomly selected subset of records
I want to retrieve 10% of the records in a table, but want them to also be
randomly selected. In other words, I want to randomly subsample a group of
Does anybody know how this can be done, either in SQL or VBA?
Thank you very much.
This question would have been more appropriate in the MS Access Queries NG.
You can select the TOP 10 PERCENT of the records ordered by the RND()
SELECT TOP 10 PERCENT Rnd([OrderID]) AS Expr1, Orders.*
ORDER BY Rnd([OrderID]);
Microsoft Access MVP