If I create two connectors with different names but exactly the same
configuration will that cause them to "load balance" or would there be a
precedence for one always over the other? Also, if one were to go down (as
connectors seem to do from time to time) would the other be used in its place?
In my experience it will not load balance in any effective or controllable
"Dan" <Dan@discussions.microsoft.com> wrote in message
> If I create two connectors with diff...data validation custom criteria formula question
in the custom criteria formula for data validation, i have input the
the formula works just fine, except i want to allow only whole numbers
greater than -1. this formula allows numbers to be input with decimals
and produces no error message.
is there a way to resolve this?
thanks for any help!
Message posted from http://www.ExcelForum.com/
this will allow either 'X' or a whole number >-1
Frank...IE8 Redirect to Virus Scan
Running W7 32 bit with IE8, sometimes when I go to Yahoo and click to close
IE8 it redirects to a virus scanner web page all by itself. How can I fix
it? I did a full scan with MS Essentials and no virus was detected. What to
do? I copied the scanner site URL last time and it is:
NEVER post possibly dangerous, clickable links in a public newsgroup or
Can I install MSE to clean up my already-infected computer?
I have been using the following code in an MFC application and it has worked
// Check for user cancel
if ((nLoops++ % 0x1F) == 0)
// Check for escape key
if (::PeekMessage(&msg, m_hWnd, WM_KEYFIRST, WM_KEYLAST, PM_REMOVE))
if (msg.message == WM_KEYDOWN && msg.wParam == VK_ESCAPE)
m_bAbort = true;
nLoops = 0;
It is used to detect Escape within a tight loop.
I now want to use the same code, but while a modal dialog box is displayed
(the code is not part of my dialog box class but is called from t...Simple Question on Addition
I searched the discussion groups for the answer to what seems to be a simple
question, but found nothing. I have a group by query with three columns:
The query is grouped on the first column, itemNo.
I want to add the Debit column to the credit column and show the result in a
third field, Total. For each record, the Debit column contains currency
amounts. The Credit column contains either negative currency amounts or is
Here is my nonfunctioning SQL. When I run the query, the Total column is
blank for every record.
SELECT eBayFees_lastMont...W2K3 Site Links question
I am learning about AD sites and I am confused about how to link two sites
As a practice I have created two sites, Columbus and KC, and when I created
them I assigned them the DEFAULTIPSITELINK object.
I have now created a second site link, called 'columbus-2-kc'.
My question is: How do I link my two sites, Columbus and KC, to this new
site link, columbus-2-kc?
Do I just change the cost of the columbus-2-kc site link to a value lower
than DEFAULTIPSITELINK? Or do I have to physically link the Columbus and KC
sites to the new site link?
Regar...A question on VBA compatibility between versions of Excel.
Is there some kind of compatibility issue with VBA when going between
different versions of Excel?
I recently wrote an Excel application for my daughter which relies
heavily on the use of Visual Basic macros. I tested it on both my
desktop machine and my laptop with no problems. However when I emailed
it to her, it would not run and went to a VBA debug screen. For a test I
emailed it to my wife�s computer and tried to run it there. On her
machine, it loaded and everything worked except one sort routine.
I am running Excel 2002, my daughter has the latest version, and my
wife�s machine...Query Question 02-08-08
I have a query set so I pull distinct dates say from 1/1/08 thru 12/31/08 to
take out duplicate accounts, I need to run this on a monthly level. I need
to run this report in 2/08 and I do not want the accounts whom I have counted
in 1/08 to show up in my 2/08 report and so on. I only want them to be
counted 1 time in the year.
What expression or operator words can I use. I have tried for example
between 1/1/08 and 12/31/08 and between 2/1/08 and 2/29/08. This string will
pull in my 2/08 accounts but it is also pulling in 1/08 accounts if I had
contact with them in 2/08.
I use a q...scale/scanner question
does anyone know if the metrologic ms2020 scale/scanner will work with rms i
know metrologic has good opos drivers i m not sure if rms has the ability to
work with scale scanners?
any help would be appriciated
On Aug 6, 5:47 pm, "midwest pos" <morna...@msn.com> wrote:
> does anyone know if the metrologic ms2020 scale/scanner will work with rms i
> know metrologic has good opos drivers i m not sure if rms has the ability to
> work with scale scanners?
> any help would be appriciated
Yes. I use them in my store and they do work.
www.gree...Newbie question #4
Please help, I'm a total Excel newbie. I need to create a spreadsheet that
works pretty much like a checkbook register. I need to be able to make daily
entries of deposits and withdrawals (dollar amounts) and keep a running
balance. I don't want the balance column to extend all the way down the
worksheet either zero (if that's the current balance) or the most recent
balance . Excel help on "Calculate the running balance" says to "copy this
formula into the current balance cell for each new transaction." Is there a
way to extend the formula without having ...attachment question #3
should be easy but I can't find the answer.
When I receive and open an email with an attachment - I can see the
title of the attachment but I can't find the type (e.g., exe, txt). A
right click just gives options like Open or copy. How can I tell what
type of attachment it is before I open it?
Open Windows Explorer - tools, folder options, view tab. Untick 'hide file
extensions for known file types'.
old guy wrote:
> should be easy but I can't find the answer.
> When I receive and open an email with an attachment - I can see the
> title of the attachment but...Pivot Table Question #11
I have 2 worksheets with similiar data from 2 different systems. For example
worksheet 1 has:
FileID Expense Type Total
1234 Repairs $100
5678 Rent $300
worksheet 2 has:
File Expires Expense Type Amount
1234 10/22/08 Rent $435
5678 12/31/08 Rent $100
Can I use a Pivot table with Consolidated ranges to create a Pivot table
which would compare the amounts by File and Expense Type in the 2 tables? For
example one row might look like
File Expense Type Worksheet 1 Worksheet 2...New User Question 2 of 2
As I mentioned in my New User Question 1 post, we just converted our store to
I am a database professional with significant experience with FoxPro. I
would like to learn how to maintain and modify the RMS system without having
to always have to call a solutions partner for every little thing.
Is there training available? Manuals? Whatever is out there would be great
to know about.
Thanks in advance!
I knew nothing about RMS and I can tell you that I still know nothing about
database programming. I now konw RMS pretty darn well, and can do a lot with
the softw...best practice question
I am looking for some suggestions on how to handle a specific scenario. I
know there are quite a number of different ways to do this, and I am looking
for comments from the CRM team, other partners, and customers on their
experiences with this scenario to determine what the best practice would be.
Scenario: Tracking job applicants and opporunities.
Companies have a number of job postings/opportunities, or even open
opportunities for particular roles (ie: web developer). Companies receive
job applications with resumes from applicants. Follow-up phone interviews
and in-person interv...Question on emailing to categorized emails.
Outlook 2002, on Windows XP Pro.
Ok ... I've categorized a bunch of my email addresses. I can look at that
list (in my contacts) by selecting the category. There's just over 50
names. The people in that list want to each have a copy of all the emails
in the list. So I need to email each of them and include a reference to all
those in that category. Can it be done. If so ... how? I thought it would
be easy to figure out, but I'm miffed!
Are the others all using Outlook also, or are they using different e-mail
MVP - Outlook
*** Messag...Question about PAYEE Microsoft Money 2006
I'm using Microsoft Money 2006 on Windows XP Home SP2.
When I first started using this program I could update my Credit Union
account directly from Money. For all the transactions involving my
VISA Check card the PAYEE field was filled in with abbreviated
information about the business I had visited. Example would be
"Chevron/Joes" or "SAFEWAY/#1233" or "YUM YUM TERIAKY #4". In
January my Credit Union implemented the secret question login which
effectively disable the ability to get direct updates. Now I log into
my Credit Union online banking service an...question about bcc outgoing messages
Is there a way, using Exchange 2003 to have all messages sent by a
group of individuals to be bcc'd to another user?
We would like all messages sent from a certain group, to have those
also go to a supervisor for review.
Can i do this?
The clients all use OWA for email so I can't do this with an Outook
If by group you meant a group of users - you can move the users to another
Store and enable Message Journaling on the Store. This will archive messages
to a journaling mailbox.
I've set up a calculated field that expresses percent profit.
A number of the calculations evaluate to #DIV/0!.
Is there a way to remove/hide these ??
you can extend the calculated field's formula, with
Hope, this helps..
"s boak" wrote:
> Hi Folks:
> I've set up a calculated field that expresses percent profit.
> A number of the calculations evaluate to #DIV/0!.
> Is there a way to remove/hide these ??
> Tha...Virtual server question
I just setup a brand new Windows 2003 Server domain along with an Exchange
2003 Server. Everything is working well.
The Exchange server is using a new domain name for the e-mail. I would like
to have the firm's old email still delivered for a couple of months.
I had the DNS from our ISP forwarded no problem. Do I just need to create
another virtual server with the old domain name and then create a new policy
for the SMTP?
Do I need a different IP address on the Exchange server? I have two NIC
cards in the server, but as of now just using one.
Thanks in advance for your re...Range question in '97
Can you have sheet specific named ranges?
sheet1!game, sheet2!game, sheet3!game
so they can be referenced in a lookup, pulling values from the correct
Yes. Select sheet1,
then in the 'Names in workbook' put Sheet1!game, then add the range in the
Repeat for sheet2, etc.
(remove nothere from email address if mailing direct)
"Adam Kroger @hotmail.com>" <adam_kroger<nospam> wrote in message
> Can you have sheet specific named r...question about how Windows Server 2003 handles disk IO
It seems like several years ago I read an article about how Windows handles
the threading of disk IO. It suggested that disk access via drive letters was
faster than mount a volume as a folder under a drive letter.
We have a server is the recipient of disk-to-disk backups, and we have three
storage volumes mounted as separate drive letters, and then we have three
more that are mounted as folders under a single drive letter.
I'm looking for documentation that would describe how Windows handles IO,
especially the performance of drive letters versus mount points under a drive ...Control Box Data Question
I am using a control box list to drop down the various part numbers that we
use. I then use that number as part of a VLOOKUP function to return
corresponding data. This problem is that VLOOKUP sees the number in the
linked cell with " " around it. Why? and how do I get rid of it? The
quotes do not effect looking up in text fields and I can get rid of them by
adding a second step where the linked cell is multiplied by 1 and that cell
is then the reference cell for VLOOKUP. I can also get around this by
adding " " to my lookup numbers so they match , but either case l...Question about WM_LBUTTONUP
I have a custom button in which I override OnLButtonUp and OnLButtonDn. When
OnLButtonDn occurs I start a timer which causes some action to be taken
while the button is down. When OnLButtonUp occurs the timer is stopped and
the action stops. My problem is there is a case where the OnLButtonDown
causes a file dialog to open. When this occurs, I lose the OnLButtonUp
message which prevents the timer from being stopped. The message doesn't
appear to get to the parent either. I've verified this using spy. Is there
some other place I can get this message in this condition?
how to format x - axis scale?
If you have a scatter chart (XY!), just double click on the axis, and
edit the parameters on the Scale tab. You cannot format a category X
axis the same way; this means the X axis on a column, line, or area chart.
Jon Peltier, Microsoft Excel MVP
> how to format x - axis scale?
...Ask a surprising question
CDgl *p; //CDgl is a class of Dialog
UINT Thread1( LPVOID pParam )
UINT Thread2( LPVOID pParam )
// TODO: Add your control notification handler code here