filter by selection 08-23-07
Why I can't make filter by selection on subform on Main Form
...automatically change number of bars in bar chart
is there a way in excel 2003 to automatically adjust the number of
bars that are displayed in a bar chart? (and in other charts as well?)
I've got a table with categories that adjusts automatically depending
on inputs, i.e. there can be 5 categories, 6, 10 or whatever. now if I
link the data ranges to this table then I get bars for each of the
rows in this table, even if there's no data (or "") in them. This
means that all the charts look awful.
can this be done automatically?
and a more advanced one:
i've got XY charts where I draw boxes for each of th...Counting lines when using a filter
After using a filter to view certain rows of a spreadsheet, is there a way to
get an accurate count of how many rows are shown by either clicking and
dragging the mouse over the selection or clicking on the first row and then
shift-click on the last row?
Thanks in advance,
How about using SUBTOTAL function
"hagan" <email@example.com> wrote in message
> After using a filter to view certain rows of a spreadsheet, is there a way
> get an ...Advance Find in Activities Histories
I asked this a while back but the answer did not work, and perhaps it was
that I was not clear in my description of the problem, so I will try again.
I have just converted activities from 20,000 clients from Goldmine into CRM
1.2. Most of these contacts/accounts have numerous activities which we have
converted to historical activities on the Activities/History Tab. When you
open an Account, go to Activities, then the History tab, all the activities
display. I can click on the Type title to sort them and use the page -> to
move between the pages and pages of activities. In some cas...Automate Numbers
I am looking for advice for the best way to solve a problem.
I am developing a system of telephony extensions etc at a
workplace, some sites may have 200+.
I am trying to automate entering all the extension numbers, rather than
manually inputting them. I also have a format for the range of extensions,
but don't know if Access will allow me to give an example and then create the
extension for me automatically in sequence.
Sounds simple enough.. what is your format?
"Lisa W." wrote:
> I am looking for advice for the best way to solve a problem.
I seem to remember reading somewhere that you would be
able to get online updates to the Junk Mail filter in
I can't find anything on officeupdate or in the help
files about obtaining junk mail filter updates.
The reason I ask, is over the past two weeks, I've
noticed a dramatic increas in the number of junk mails
that get by the built in filter.
Some of them are obvious, like Subject: "Hey how are
Emails like this used to get captured. Now I'm having
to "Add Sender to Junk Mail list" wh...count number of entries in cell
I am trying to count the number of entries in a cell. For eg in cel
A15..I have rat,cat,mat,fat....The function should return 4. Is there
inbuilt function to do that or what would a macro to do that loo
Message posted from http://www.ExcelForum.com
are all your entries separatet by a comma. If yes try
> I am trying to count the number of entries in a cell. For eg in cell
> A15..I have rat,cat,mat,fat....The function should return 4. Is the...How to express Between Queries in advanced find
I need to express queries such as:
<entity>.<startDate> <= Today &&
<entity>.<endDate> >= Today
> I need to express queries such as:
> <entity>.<startDate> <= Today &&
> <entity>.<endDate> >= Today
Queries in Advanced Find are, by default, AND queries unless you change it
to OR. So you'd just do this by putting in ...Sorting filtered list on form with a Command Button
I have a form CLIENTLIST. When I open this form it runs the query
qryClientLst. One of the fields in the query named ClientID has the criteria
"Like [Enter Client Number]". When I open the form CLIENTLIST I'm prompted
to "Enter Client Number". When I do the form opens and only the files with
the client number I entered appear. So basically it's a filtered form. All
of this works fine.
I created a command button above the column ClientId on my form so my users
can click on the button and sort Ascending or Descending. Below is my code
for this. My only...want parentheses, not negative numbers
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
I'm trying to make an aside comment at the bottom of a 2008 excel table and need my information for one cell to appear in parentheses, but the program keeps autopopulating it to be negative number. <br><br>Thanks for your help.
Parens are standard formatting for negative values, they can't be used as
"literal" text characters in conjunction with numerical values. If you want
them to display rather than the minus sign use Format> Cells - Number &
select the...Advanced Conditional Formatting and Changing Cell Colours
I have three basic (for programmers) conditional formatting problems
to solve in Excel for which I require some help. These are the last 3
conditions I need to complete for the worksheet so any help will be
really appreciated. They are as follows:
If cell Y2 is > 0 and cell Z2 = 0 I need to change the colour of cell
If cell Y2 or cell AA2 > 0 and cells V2, W2, or X2 = the value "Z" I
need to change the colour of the cell containing "Z" (V2, W2 or X2).
If changing the colour of only the single cell containing "Z" cannot
be done, I guess changing t...Number Formats #2
I've been working with number formats lately. I wrote in the custo
format ???.??? to align a set of numbers by their decimals. Fo
example, 1.25, 12.45, and 137.98 would all align by the decimal eve
though they take up different amounts of text.
The problem is that I want to add superscript letters after some of th
numbers. So I would want an "a" to come after 1.25 in superscript.
When I add the "a," the number format no longer works and the number
do not align by the decimals.
How can I add the letter and still make the number format ???.??
Messa...How to filter lower case characters in an edit control?
Hi to all,
I created a class that enherits from CEdit and overrode its OnChar() message
handler to intercept the entered keys and filter only those that are lower
case. It also verifies if an entered key is upper case to convert it to lower
case and filter it.
Everything works good except the conversion from upper to lower case. The
problem is that even if the OnChar() handler does convert the character to
lower case, the character is still displayed in the edit box as it was
entered, i.e. in upper case.
Please note that if I remove the line: "nChar = tolower(nChar);", the u...Advanced Optimization Options
are 'Advanced Optimization' Options Inherited?
like I have a app in which I have set these options and in it I am using 3rd
party control of which I don't have source code nor do i know if they are
using any of these options.
so if I set some advanced optimization options will those also apply to that
"Abhishek" <firstname.lastname@example.org> wrote in message
> are 'Advanced Optimization' Options Inherited?
"Abhishek" <email@example.com> wrote
> are 'Advanced O...Junk filter: CRAP!
I have upgraded to Outlook 2003 from Outlook XP a couple of weeks ago. At
first, I thought that the junk filter was good. Well, that was after a few
hours of using OL.
Now, after a couple of weeks and an average of 150 messages per day (of
which more than 80% is junk), I can tell that the junk filter does a VERY
poor job! I used to use PopFile and I was able to get a success rate of 99%.
I am definitely very far from that figure with OL 2k3.
I tried the low level setting (i.e. the default). Needless to say that
(apart from no automatic filtering), it's the worst setting. I then deci...Counting & Filters
Hoping somebody can help me here. I have forgotten how to create a
formula which will tell me how many rows are visible after setting a
filter. I would like to know the results to calculate the number of
call types made in a day by changing the filter and returning a
See the help for the Subtotal worksheet function
Regards Ron de Bruin
"Tom Westlake" <firstname.lastname@example.org> wrote in message news:email@example.com...
> Hi All,
> Hoping somebody can help me here. ...Item Serial Numbers for Matrixed Items
I have a question regarding serial numbers for matrixed items. I would like
to set up an item, and then include a matrix for size, color, length, and
still maintain invenotry on each color/sytle combination, and have a serial
number for each item.
Can anyone provide details as to how to best accomplish this.
this comes in:
Red, Green, Yellow
and each color has small, med, large.
Each item has a serial number.
Create the item using the New Item Wizard as a matrix item.
At the end of the wizard select "Edit this item"
On t...CRM should let me decouple conditional statements in Advanced Find
We have set up a number of saved searches in CRM 3.0 that users would like to
use Save As to create a copy and then add search terms to. Unfortunately,
CRM 3.0 does not allow you to decouple conditional statements once the search
has been saved. In order to add an AND condition, this feature is required.
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...Outlook's Junk mail filter??
In Outlook 2003, how does the Junk Email filter "learn"?
Is it updated through MS updates....or?
As I noticed on my Outlook, it sends over to the Junk Mail Folder a lot of
SPAM that I have not programmed it to do...rather it has done it on its
Where would Outlook get the Junk Email filter rules from?
I've noticed that the filter is updated monthly via Microsoft Updates.
"Gordon J. Rattray" <firstname.lastname@example.org> wrote in message
> Hi there,
> In Outlook 2003, how doe...Advanced Security Headaches
I am having so many problems with this and unfortunately, on version 8, it is
almost impossible to setup a lot of classes using the standard GP user class
setup without pulling your hair out (and can't get access to certain things
like business alert setup etc).
I created a brand new user class using user class setup with no
restrictions. Assigned user to class.
Ran receivables integration with no errors.
I then modified the user class using adv security to remove all windows
within tools > setup, routines and utilities.
Re-ran the integration and now get error "Unknown GP...Advanced Searching
Can you search through Purchase orders by item
Can you search by more than just the start of the lookup code? (ie search
for all things red?)
...Hide Report Filters
When I run a report, I export them to a HTML File. The outcome shows the
report title, Filters used, and data. I am trying to have the filters hidden
so that when the report is exported to HTML it only displays the report title
and data. The only way I can do this is edit the HTML file after it is
created but I do not want to have to do that every time. Just wondering if
there is something I can put in or take out of the .qrp report to get my
desired end result.
Well, if you want to use exactly the same filter everytime, you might be
able to do this by entering the criteria in t...Numbers
When transferring data from my AS400 to Excel, the
negative numbers appear on the AS400 with the minus sign
at the back of the number. Ex: 123-
Is there a way to make excel recognize this as a negative
number through the customize option--or any way at all?
for each c in selection
"Mry Alice London" <email@example.com> wrote in message
> When transferring data from my AS400 to Excel, the
> negative numbers appear on the AS400 with the minu...Message Filtering Doesn't Work
We moved our Exchange 5.5 server from an NT 4.0 server to
Windows 2000 Server. Everything works fine, except for
Message filtering on the Internet Mail Service Connections
tab. It looks to be set up correctly and it should be
sending all e-mails from the listed domains to the turf
directory, but it isn't and all these e-mails are coming
through. FYI, we created c:\turfdir on this server and
modified the turfdir registry entry to reflect this.
Are you blocking a whole domain? If so, you have to have
it in the format of:
...Double V. Single Help
Why is 'ans1' true if double and false for single?
Dim x As Double / Single
Dim y As Double / Single
Dim ans1 As Boolean
Dim ans2 As Boolean
x = 0.3000000000000001
y = Math.Round(x, 2)
ans1 = y = 0.3
ans2 = Math.Round(y, 2) = 0.3
Dim x As Double, y As Double
Dim a As Single, b As Single
Dim ansX As Boolean, ansY As Boolean
Dim ansA As Boolean, ansB As Boolean
x = 0.3: y = Math.Round(x, 2)
a = 0.3: b ...