I have a chart with zip codes and a population rate.
I want to make a chart that has the rate on the x axis and the number
of times that rate occurs on the y axis.
I will assume the ZIP and RATE stuff is in A1:B200 (labels in row 1)
Label in G1 to read RATE (but leave it empty for now), label in H2 to read
Make a list of rates in G2:G20 (say)
In H2 =COUNTIF($B$2:$B$200,G2)
Copy down the row
Select H1:G20 and make a...Mell Install Question
We have MELL Installed on a Web Server. It is working fine and we have
several modules up and running and will be adding more and more..
When we first installed eLearning, we said 'NO' to the SQL Server peice of
the install. Now we'de like to have it log to SQL Server but am not sure
how to go about doing this. reun the install? uninstall and reinstall?? I
know there must be a way to implement SQL Server without having to reinstall
the whole thing !!!!
Can anyone help?
...Exchange question #2
I have just taken over a medium size office, running Exchange 6.5 on Small
Business Server 2003, clients run Outlook 2003. My immediate problem is I
have two users who cannot send email to several specific addresses outside
the company. Everyone else can send to these addresses. When these two
people send email to the outside addresses, they immediately get an email
back stating that the address doesn't exist or something to that effect. It
appears to be bounced right back from the server. Does anyone have an idea
here? Thanks in advance.
Can you post the NDR?
Bharat Sune...Drop down. *EASY* question!
BlankHiya everyone :)
I was just wondering if anybody could explain something reeeeally easy for
In Excel, I would like a two drop-down features in my columns of my
The first one (columnE) with the options 'yes' or 'no'.
The second one (columnD) with a list of names, eg.
Thankyou for ANY help you can give me!
"Do you know where you're going to?"
Data>Validation, choose a type of list, and then just type the values comma
(remove nothere from...Experts Question
I'm writing a multi tool application, something like outlook.
I have an MDI application of course.
Inside the MDI the user may choose any of few Mini tools (something like
calendar,contacts,mail, tasks etc).
A mini tool may be an MDI - e.g. one of my mini tool is a resources editor,
which means that the user may first choose the "Resource Editor" mini tool,
and open/create many windows to edit.
Another mini tool will be "Scripts Editor", which the user may choose to
open many scripts views.
My problem is how to implement the switching between mini tools, I wanna pu...Simple help with implementing Outlook-like GUI
I am an experienced unix programmer who sometimes has to do something
in the windows world, and always has newbie-questions.
Basically I want to write an application program that looks like outlook
in that it has nice icons down the left hand side that choose the
content of the main area in the right hand side.
So I started the MFC App wizard, and got me a SDI program with a
CLeftFrame (CTreeView) and a CMainFrame (CFrameWnd).
Then I prepared the following snippet of code to draw the buttons:
// Create a pushbutton
pmyButton = new CB...Simple Simple Simple
Just started Excel (again) and need to make an easy speadsheet fo
calculating square inches.
Column A: Height
Column B: Legnth
Column C: Total Tags per 16 x 24
Column D: Cost per tag
Figures I know: each sheet cost me $9.98. each sheet is 16 x 24 inches
What I want to do is enter the Height, enter the Length and have th
total (sum) be entered into columns C and D.
I can't believe I forgot how to enter formulas. Any help will b
Message posted from http://www.ExcelForum.com
One Way, might be better ways but this'll work:
List the colou...Install question
can I have SQL Server 2008 Express with advanced services
with SQL Server 2008 Enterprise Evaluation installed on the same
On Fri, 30 Apr 2010 07:49:10 -0700 (PDT), Gilles Koffmann
>can I have SQL Server 2008 Express with advanced services
>with SQL Server 2008 Enterprise Evaluation installed on the same
You should be able to do this, have you tried and failed?
I am using Visual Studio 2003/C#
I created a new xml schema/xsd file (Project Create new item->Dataset)
I then added Elements to the schema using the designer
From the toolbox I then created an instance of my dataset.
I then dropped a grid (Infragistics UltraWebGrid) onto my form, and bound
the grid to my dataset.
At runtime, I configure the columns of the grid, get some records from the
Employee database (SQL Server2k),
and add some rows to the grid.
The user then enters some data into various cells of the grid.
I am now ready to update the database with the contents of the grid.
What ...Simple hack to get $500 to your home. 06-05-10
Simple hack to get $500 to your home at http://uknews.tk
Due to high security risks,i have hidden the cheque link in an
image. in that website on left side below search box, click on image
and enter your name and address where you want to receive your
cheque.please dont tell to anyone.
...Simple Query Wizard hangs
I am using Access 2003
When I initiate the "Simple Query Wizard", I am presented with the first
screen - "What fields do you want in your query"
When I click on the pulldown list to select a table, I get the following
"The expression On Get Focus you entered as the event property setting
produced the following error: the text you entered isn't an item in the list
* the expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure].
* There may have been an error evaluating the function, event, or macro&q...WDF Interrupt question
I'm sorry I just start learning windows drivers development. I'm looking at
Interrupt servicing in drivers in WDF. WdfInterruptCreate create the
interrupt object but where do we put the information about interrupt vector?
I noticed we can get vector by using WdfInterruptGetInfo, but where do we set
I think I have found where it comes from. From Hardware Resource list, which
is filled by PnP Manager.
On Mar 22, 12:56=A0am, mpefareo <mpefa...@discussions.microsoft.com>
> I'm sorry I just start learning windows drivers development. I'm looking ...I Need a Simple Sales Software
I am looking for software to keep track of my prospects, customers, and the
notes of the sales process. I spend about one hour a day on sales and
marketing, so I prefer a simple and inexpensive software. Maximizer,
Outlook, Act, and Goldmine seem made for the full-time professional
salesperson. Please let me know if what I am looking for exists.
...Make it more simple or intuitive to do simple things
I appreciate the fact that applications are becoming more versatile and able
to do things that we hardly thought possible in the past but I feel that in
this added complexity you are losing sight of the need to do simple things
easily without resorting to trial and error or consulting "help" which often
anyhow doesn't lead one straight to the solution! An example is how to
produce a chart with a series of months i.e Jan Feb Mar etc appearing on the
X axis. This is no doubt something that resulted naturally in the first
versions of Excel charts or in a competitor's ea...Curious Database Query Question
When creating a "New Database Query" from another Excel workbook, when you
get to the "Select Workbook" dialog, there is a small checkbox labelled
According to the help file, it has this to say:
"To prohibit updates to this file, select the Read Only check box."
I don't understand why this is an issue. In my understanding, database
query is a one-way transfer of data from the external source to your excel
workbook...if you edit the data in your workbook, that *doesn't* change the
data back in the external source...right?
Am I wr...Simple public folder permission problem
I have a public task list folder. However even though I have given everyone
"Author" priviledges and full control of the directory, users cannot update
the tasks (although they can create new ones). The changes to tasks get
reset to their original values.
Where should I look to fix this problem?
How did you grant Author Access, via Outlook or ESM? What do you meanyou
gave them full control of the directory?
"Brian Taylor" <firstname.lastname@example.org> wrote in message
> I have a public task list folder. Ho...SOP process question
We use SOP and have a new process that I'm not sure how to handle. We
receive an order from a customer for a year's worth of product. We need to
book the order to show a quantity of 12 but bill and fulfill 1 item monthly.
Is there any automated way to fill the order monthly (decrement the inventory
by 1 every month) and invoice without having to go in to every order?
I looked at using recurring orders but that does not give us the line item
with a quantity of 12 for reporting....I feel like I'm missing something very
Yes and no....
...Recipient Policy questions #2
I wanted to change my addressing scheme from the current lame one to
something like %email@example.com. When i change this ...will all my users
email address' automatically update to these new address' ? or do i need to
make other changes?
Also...is there a way to keep those old address alive for a bit (via
forwarding/connecting) so we dont miss anything...or will this perm remove
the old ones?
Keep the old addresses, insert new address in Recipient Policy and set it as
default. This will ensure when recipients hit Reply they see the correct
One of my email accounts is set as IMAP. When I open
outlook it connects to the account and checks email.
However, if it is diconnected from the account for some
reason, it would not connect to the account again (even
if I try file connect to...). I have to close outlook
and to open it again to get connected again. How can I
solve this problem?
...What is simple text?
When creating a custom list that includes a column of accounting formated
data, I get an error message that 'fields without simple text will be
ignored'. The result is all other data except the accounting formatted data.
I suppose it means without the currency symbol and thousands delimiters.
On Fri, 8 Apr 2005 11:01:04 -0700, TexMas <TexMas@discussions.microsoft.com>
>When creating a custom list that includes a column of accounting formated
>data, I get an error message that 'fields without simple text will be
>ignored'. The result is ...Question on anatomy of a query
I was looking at an article by Plamen Ratchev (which I had printed a while
ago but can't find it online anymore) where he states that the first thing a
query does if there are 2 tables involved is create a Cartesian Product
(cross Join) between each table. Then the ON filter is applied.
If Table A has 20,000,000 rows and Table B has 30,000,000 rows - the system
would read all the rows and put all the combinations together to get
600,000,000,000,000 rows? Then apply the ON filter???
Where would it put the data it just read?
Does it read all this into a temporary table in...Filter Question!
I have a table [tblAccountStatus] that has around 6 fields for receiving
2 of the fields are [ClientID] (Number) and [ModeOfPayment] (Text)
I have created a query using these to fields , made a combo box using this
query ,put it on my form and made Control Source [ModeOfPayment]
Now what I would like to do is when I enter the ClientID on to my form the
query will only show [ModeOfPayment] that has been entered with that
Hence when I select Mr Tom Cruise , I will get a selection my from my Combo
Box as the names of the checks I have entered under his ClientID
Hope thi...simple question
Okay, I have a very simple question. Where do the old
posts go after they run off the last page of this
newsgroup? Sometimes I would like to refer to a post that
I remember seeing in October, but is no longer on the
The search function seems to only search current posts as
If anyone has some input please email me at firstname.lastname@example.org
have you tried google groups, they keep archived old posts:
"Joe Proehl" <email@example.com> wrote in message
news:099701c5...Macro Output Question
I was given some excellent help on the forum, and thanks to all. Need help
with one more thing to finish. I was given the below macro to be able to
enter a number in one cell and the output cell would continuously add up the
sum. I need to take the output sum and subtract it from another cell, but I
keep getting an error. What do I need to do to make this happen.
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If .Count > 1 Then Exit Sub
If Not Intersect(.Cells, Range("C2:C15")) Then
I...Simple Macro is not so simple
I am trying to record a macro which will automatically perform the insert >
comment function to a selected cell. Should be easy right? Alas no
There's sample code on my web site, for inserting comments:
> Hi all,
> I am trying to record a macro which will automatically perform the insert >
> comment function to a selected cell. Should be easy right? Alas no
Excel FAQ, Tips & Book List
Wow! Nice one :-)
Thank you M...