hello to all
My form has 2 comboboxes:cboCategory and cboPriceRange, with the important
columns being CategoryID and PriceRangeID respectively. The item showing in
cboCategory determines the choices available in cboPriceRange. All of this
Now, I want to use these 2 selections to filter my records to show ProductID
and ProductName when a button (cmdFilter) is clicked. It the user selects
Power tools and $100 - $200, I want to filter my records to show only
Products matching these criteria.
I'm new enough to coding that I can't seem to get the code for this bu...Multiple Y axis values
I have a number of data sets (vertical bars) in my graph. I would like to
display various Y axis values on the right or left side to indicate the value
of the vertical bar. It appears that I can only have (2) Y axis values
displayed. Is there a way to show more?
On Jan 17, 10:37=A0am, Flashoflight
> I have a number of data sets (vertical bars) in my graph. =A0I would like =
> display variousYaxis values on the right or left side to indicate the valu=
> of the vertical bar. =A0It appears that I can only have (...about filtering
can i specify a field as criteria in query
On Fri, 26 Mar 2010 22:04:55 -0700 (PDT), soha <email@example.com> wrote:
>can i specify a field as criteria in query
Yes, just enclose its name in square brackets.
A clearer question will get a more detailed answer. A field from the same
table? some other table? which record should provide the field?
John W. Vinson [MVP]
On 26 =D9=85=D8=A7=D8=B1=D8=B3, 21:45, John W. Vinson <jvinson@STOP_SPAM.Wy=
> On Fri, 26 Mar 2010 22:04:55 -0700 (PDT),...Filtering without Filter
I just don't get the following. Any ideas?
"A" row I have two different values I use: "Contact" and "Not a contact".
"B" row I have the person's name (employee).
"C" row I have a quantity, just one number.
Now what I need is to output quantities of how many Contacts Employee1 or
Employee2 or Employee3 have.
Also what I need is to get the number of contacts - which can be found on
Should I use COUNT.IF ? Row A can have 2 or more different values so should
there be somekind of conditional IF function included?
I have a report created but I would like another report that shows the
calculated text box "InvoicingPercentage": show records w/less than 100%
in this field and
From a subreport text box "SitesComplete": show only sites that are less
than 100% complete
full name: [Sites].Report![SitesComplete]
...Filtering & 'Show all' when w/book protected
I have a workbook which is password protected and shared.
Users can use the filters set up across the top row, but often it'
hard to be sure that there isn't a filter in place. What would be grea
(1) the 'Show all' button worked when the book is protected. Why i
this disabled? :confused: It's not doing anything more than removin
the filter which the users _are_ able to do! At least the users coul
just hit the button and be sure that all filters are de-activated.
(2) Failing that - is there an alternative? e.g. a macro? Or is i
possible to change the colouring of...Filter Switches vs Macro?
Excel 2000 ... I have Filter Switches which I activate
with various recorded Macros (1 Filter Switch per
Macro) ... this is working fine as long as there is not a
Filter Switch already activated.
Above said ... I need a little Macro instruction I can
paste into my recorded Macros that will set any activated
Filter Switches back to ALL before activating the Filter
Switch I am calling for???
This so I do not get multiple Filter Switches activated by
my Macros ... Thanks ... Kha
resets all filters
> Excel 2000 ... I ...Count with multiple condition
I want to get the count of rows from A1:A20 where the value is greater
than 10 and smaller than 20. I know I could do it by
=countif(A1:A20, "<20") - countif(A1:A20, "<=10")
But I want to do it within one function (nested functions are ok with me
like f(g,h)) like:
=countif(A1:A20, "<20 and >10")
=countif(A1:A20, and("<20", ">10"))
and it doesn't work, a little search on the google turns out that
countif can only have one simple condition within it. And it sa...VBA change filter match from INCLUDE to EXACT,
I expect my macro to set a filter by exact match based on a value in
The (part of) macro goes like this:
Sub Search ()
On Error Resume Next
On Error GoTo 0
UserVal1 = Range("G2").Value
If UserVal1 = False Then
Selection.AutoFilter Field:=1, Criteria1:="*" & UserVal1 & "*",
However this macro dont find EXACT match - but INCLUDED match
Question 1: What correction do I have to make to instruct the macro to
...If Missing #, Show Letter on multiple sheets
Stumped on how to solve this. What I'm trying to do is list what
alpha-characters are missing by detecting if a number is present. All of the
worksheets are exactly the same except for the alpha character they
What I need is an algorithm which will detech what is missing from each
sheet. I have a # to identify if a alpha is missing, but I need a way to
For example, assume there are three worksheets: wks1, wks2, and wks3. If
cell B15 on wks1 has 1, wks2 cell B15 has 2, and wks3 cell B15 has 3 I want
the algorithm to return "". However, ...Using COUNTIF in multiple wooksheets
I am trying to use countif to count the word "complete" in a range on
mulitple wooksheets. I select my range and then hold shift to select other
worksheets to include but it comes up with #value. When I do it with one
worksheet it works fine. Help would be appreciated.
COUNTIF does not work with multiple sheets
First put a list with all sheets in a range on the summary sheet, assume you
have 10 sheets you can put ALL their sheet names in for instance H1:H10,
assume you want to count in the range A1:A10 in those sheets
=SUMPRODUCT(COUNTIF(INDIRECT("'...Multiple user accounts not working properly
I am running Windows XP and have three user account
logins. I was also running Outlook Express and set up
three email accounts (each on their own login).. the
first two email setups worked great. But the third one
wasnt recognizing my password as valid. I Contacted the
ISP. Walked through setup. Still didnt work. ISP
instructed me to access mail via the internet. That
worked. ISP said that proves the account is valid.
Now, I just upgraded to Outlook 2003. Same problem with
the third email user account. Funny thing is that
this "3rd" email account is one of the tw...Filters
I am receiving email that is flagged as spam by my ISP's email server. It adds
"*** SPAM ***" to the subject line.
I created a "rule" to move such messages to the deleted items folder and to mark
them as "read". However it's not working.
I also cannot seem to find where I can edit the rules or filters. I can only add
a rule to an existing message in the inbox which as I said, doesn't seem to
work. I'm still seeing them.
When I looked at an existing rule it seems to be filtering on the entire subject
line rather than the spam bit. When creating t...Custom filter
I am using the autofilter, and wish to Customise a data set in one of my columns.
A column has a listing of numbers 1-32. I wish to undertake a filtered selection of of only cells wish contain the numbers 1,2,3 & 7. How do I do this using the autofilter option? I have tried the 1-3,7 option but it didn't work w/ the 'contains' mode.
Can anyone advise? Thanks,
Unfrotunately Autofilter only allows for a limited number of criteria.
I appears that you now need to use advanced filter. That allows for a
lenghtier criteria lsit like 1, 2 ,3 , 7.
Message posted from http://ww...Paying expenses out of multiple accounts
Hi, I just started with Microsoft Money 2004. It seems great so far... I
entered in our paychecks and bills. I have one main checking account that I
want to pay bills out of. I have another checking account for household
expenses (groceries ...etc)also daily expenses such as gasoline costs and
clothing. I also have a third account that I use for entertainment and
dining out. (this keeps me disciplined) :) The bills that I entered are all
linked to the correct acct. However, the misc. expenses such as gas are being
deducted from my savings acct. I deleted them from the acct. and tri...Auto-filter toolbar icon
Is there a way of getting the toolbar icon for auto-filter to toggle
the feature on or off? It only seems to switch it on then I have to
navigate through the menu (ok, not that much of a hardship!) to switch
it off again.
You could attach a macro to that button, with code to toggle the
AutoFilter on and off.
If you store your macro code in a workbook that is always open, such as
Personal.xls, and you can use it in any workbook.
On Error Resume Next
Paul Cunliffe wrote:
> Is there a way of getting the toolba...Color printing issues
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
I have an unusual printing issue with Word (and Excel for that matter). Graphics and colored text print out very faded or with incorrect colors. <br><br>When I print the very same graphics from Photoshop, they print fine. Which suggests to me that the printer is NOT the issue. The printer has new cartridges, all drivers are current, and it has been cleaned. <br><br>I have the same issue printing on a Windows machine. <br><br>I am using RGB colors. <br><br>Any ideas?...Oval fill and color
Hi. Someone helped me out with a macro to create an
oval. This oval currently has a transparent, green
background and a black line. Can someone tell me how to
make this oval have no fill and have a green line? Is
there somewhere in the excel/visual basic documentation
to find help with something like this in the future?
Here is the code:
Set myOval = .Parent.Shapes.AddShape(Type:=msoShapeOval, _
myOval.Fill.ForeColor.SchemeColor = 42
myOval.Fill.Transparency = 0.5
Mi...Multiple Email Addresses #9
I've got a user with 3 email addresses. Is there a way to
have the mail for each address go to a separate inbox
Confusing post. Explain more clearly what you want.
Include your Outlook version.
Are you talking about messages you are sending or receiving? Do you really
mean email addresses or email accounts?
"Jean" <firstname.lastname@example.org> wrote in message
> I've got a user with 3 email addresses. Is there a way to
> have the mail for each address ...Filter/Display only certain rows of information based on a user na
I have a spreadsheet that contains a list of employee names (In Column "A")
and information across a row related to them....Each employee is under 1 of 4
managers and what I need to do is have a way for the manager to log into the
spreadsheet and only display the employees that is under them.
Thank you in advance for your help,
Is the exclusivity down to confidential data or is it just to make it easy
for the Managers to see their own staff?
Is there a column that contains the Manager's name?
If so and if confidential matter is not a p...Filtering of outbound messages
Is there a way (native to exchange) to block (and redirect preferably)
outbound messages to specific email addresses on my server? I attempted to
do so with the Recipient Filtering in the Message Delivery Properties but I
guess that only applies to inbound messages.
Any help that can be provided would be appriciated.
You could use a transport event sink although that is not for the faint of
"Glen Green" <Glen Green@discussions.microsoft.com> wrote in message
> Is there a way (native to exch...IF COUNTIF & COUNTA on Filtered Visible Cells #3
Thank you for assistance. Unfortunately, the formula is not retrievin
the correct results.
The formulae below tells me how frequently the ROOMS are being used b
different Groups and how long they have not used them. The formula
works ok on non-filtered data but when I use Autofilter the results ar
not as they should be, because the results also include the non-filtere
data rather than just the Filtered Visible Cells.
Using the Formulae below, I can obtain the required data from th
Columns in a non-filtered state.
=IF(COUNTIF($V$10:$V10,$V11),COUNTA(INDIRECT("V&q...Filtering SPAM from foreign countries using an RBL site
I'm using Windows SBS 2003 Premium, Exchange 2003, ISA Server 2000 and
Symantec Mail Security for Microsoft Exchange Servers 4.5.2.
Appears I'm about 95% anti SPAM. They are still some SPAM coming in and
getting past my RBL and filters. Unfortunately these are "Korean" SPAM and
they are good. They do not use text in the body and the subject lines are in
Korean. They use links and HTML in their body so my filters cannot pick it
up. Unfortunately I cannot block because they do use Yahoo dot com as their
email providor. Is there some kind of language filter I can apply or...Deleting multiple rows from value list
Is there a way to delete multiple rows in a value list for a Text column? I
have over 200 rows out of a value list that are duplicates that I need to
delete. I can delete them row by row but I'd like to click on the 1st row
and shift click on the last row that needs to deleted. Is this possible?
Thanks in advance (from a Project newbie)
Yes. Select then click on the cut icon. Try it.
"Val" <Val@discussions.microsoft.com> wrote in message
> Is there a way to delete multiple ro...Counting Unique Days based on multiple criteria
I've scoured the newsgroups and web for some type of solution that
would lead me to solving my problem but I still haven't been able to
figure it out, soooo....it's time to post.
The following is what my sample data looks like:
My requirements are twofold. Firstly I need a count of total entries
for each year/month combination. For example:
2008-08 = 3
2008-09 = 4
2008-10 = 2