I need help with a sumif formula. I have two spreadsheets. On my report
spreadsheet I want to use a sumif function that looks at two columns in the
other spreadsheet and give me a total based on the following criteria.
1. Look at the date in F2 and compare to the date in C2. Count if the date
in F2 is greater than C2.
2. If F2 is blank, and today's date is greater than C2, count.
Do you mean
"stevestr" <email@example.com...POP3 Question #4
I have SBS 2003 wiuth Exchange 2003 where I am downloading my email into a
global mailbox. Is there a way i can view a log or status to see if mail is
...Another MDI or SDI question
I would like to convert my VB app to VC++, but I am unsure as to which
framework to use. The application will interface to a hardware device
to monitor, record and analyze data. There will only be one set of
data, but I would like to view it in various formats (spreadsheet,
graph, etc.). Because of the multiple views, am I correct to assume I
should choose MDI? Any advice would be appreciated.
This sounds definitely like MDI. I have built, in all my apps, two SDI apps, and regretted
both of them (I had to rewrite them as MDI). The rest of my apps are dialog apps, and one
of those uses tabbed ....pst large file manangement
We have a problem mananging our .pst folder files when
they get over 1GB using Outlook 2000. Does Outlook 2002-
3, work better with these large mail files? Is auto-
archiving the only solution?
Thanks ahead of time for any info,
OL2003 doesn't have the 2GB limit.
Still, best not to let PST files get that big in general - performance
> We have a problem mananging our .pst folder files when
> they get over 1GB using Outlook 2000. Does Outlook 2002-
> 3, work better with these large mail files? Is auto-
> archiving the o...pst help
I had an outlook pst file of about 1gig on my desktop and using a backup
program backed it up and then imported it into my laptop (for the first
time) which took over an hour. I cleaned up (deleted) some emails in my
inbox (from about 4,200 emails to 3,700) I then exported the file from my
laptop and then imported that file (still about 1 gig) back to my desktop.
The import did not reflect the email deletions I made on the laptop though
but the pst file size jumped from 1 gig to 1.8 gig. I don't see any
duplications in my emails or contacts. I'm using Outlook 2003. I would like
to get ....pst files #11
Do the contacts reside within the .pst file?
If the outlook.pst and archive.pst files are backed up will I be able
to restore all data in case of corruption or loss?
Are there ways to retrieve data from .pst files other than Outlook?
Yes, yes and none that I'm aware of (of course I may be wrong).
"badgolferman" <REMOVETHISbadgolferman@gmail.com> wrote in message
> Do the contacts reside within the .pst file?
> If the outlook.pst and archive.pst files are backed up will I be able
> to restore all data i...No pst file on computer
I purchased Office 2007 standard. I install the product no problem.
everything works except outlook. When starting outlook for set up it tells me
can't find .pst file.
I have no outlook pst file on my computer at all. It then lets me try to
find it, but it is not on machine. I uninstalled Office then tried to
reinstall it but I still have the same problem.
Any thoughts or help ?
Did you have Outlook on the computer before if yes which version was it? The Office
2007 Standard that you are trying to install is it a Retail or an Upgrade version
...Outlook 2007 Calendar question.
I want to set up a rule when a meeting request comes in it will automatically
color code it to a color that I choose if there is writing in the message
part of the meeting request. This would be helpful if someone has typed more
information in the meeting request other then the subject.
I’ve looked under automatic formatting and don’t see anything under the
advanced section. That would allow me to do this.
...Bubble chart question #2
I suspect not many of you are using bubble charts, but I am trying to verify
whether I have a problem or if Excel does. Excel 2007 bubble chart using the
X Y Size
-16 -4 5
-13 -15 2
-8 0 3.5
-4 -19 3
-2 -10 4
0 -4 3
0 14 3.5
8 -19 4
9 5 2
11.5 -5 4
The X-axis data does not plot the negative values correctly, they are all on
the positive side. It appears that this feature preforms the same way in
2003. I realize that I can plot this using other chart types, but.... Any
comments would be appreciated.
If this helps, please click the Yes button.
Shane Deve...New OE newsgroup user questions
I'm new to newsgroups and access via Outlook Express. Where can if find
documentation or descriptions on how to really use OE effectively w/ forums.
My main question right now is:
How do I reply to a reply that someone posted to my new post?
If I click Reply Group in OE I get a msg "Do you want to reply to the entire
newsgroup. Is this the correct options to add another level of input to my
original post, or will this go to every post in the newsgroup?
I would also like to know how to do things like:
Searching forums for specific words or phrases?
Can I se...eConnect Licensing question
I am helping a company that wants to generate journal entries to Dyanmics
GP. From searching online I believe that this would be done using eConnect.
My questions are:
1. Is this the correct way to communicate from an application to GP?
2. How is eConnect licensed?
3. Where can one download documentation on how and when to use eConnect?
Direct replies to firstname.lastname@example.org would be fine as well
eConnect is a way. Integration Manager is another way.
eConnect, by itself, requires some programming because it's a set of API's.
There are some add-on products, like Sc..."stronger" or "more powerful" repair for PST files than SCANPST?
I'm having a problem with Outlook 2003 crashing frequently and
unpredictably and with Outlook sometimes hanging while starting up. In
the latter case, I need to use Task Manager to stop the Outlook.pst
process and then restart. I run SCANPST very frequently, several
times a day, because of all the crashes.
Sometimes Outlook stalls on startup right after I've run SCANPST.
Other times, Outlook crashes after only a few minutes of usage, right
after a SCANPST. So I'm wondering if one of the expensive commercial
Outlook repair utilities can fix my problem(s). I would have to pay
f...Team/Business Unit Question
I'm trying to work out the best way to configure CRM 3 for our organisation
(we provide support services to doctors) to replace an existing database.
This existing database had a contacts section for details of all our
professional members, linked to their organisations they belonged to. This
database though also kept a separate 'module' for contact and service info
that a select group of our staff could access for a confidential health
service we also provide.
At the moment in CRM we have one business unit for our organisation and at
the moment all our crm users can se...Threading question
Is there a way to protect a section of code so that all the statements in
the protected block are executed without being interrupted by another
I have a worker thread that adds a value to an array (a circular buffer)
then increments the array index. If the user clicks on a button of a form
in the main thread, sometimes the main thread code will then access the
array after the value has been added, but before the array index has been
I know I've seen ways to protect code in other languages (Pascal or Ada I
think) but how can this be done in vb.net?
t...OWA Permissions Question with A.D.
Here is my dilemma. Last year we added a group to our AD to block the
"Department" field in our A.D. As long as users are in this group they
can not read the "Department" field. Even when using outlook, the
"Department field is there, but the content is blank due to the
permissions. Recently we discovered the using the OWA for exchange 2003
we could read the contents of the "Department" Field. I know that
OWA/Exchange pulls data from the A.D> but i can not figure out why OWA
bypasses this permission.
Does anyone know what why OWA is bypa...go to page question
How do I move around in a document--namely, how do I go to page x or to
page first or page last?
Herb Tyson MS MVP
Author of the Word 2007 Bible
"richard" <email@example.com> wrote in message
> How do I move around in a document--namely, how do I go to page x or to
> page first or page last?
On 12/17/2009 6:12 PM, Herb Tyson [MVP] wrote:
> Press Ctrl+G.
Thank you. But I wonder why I could not find th...Need help on OU question
Windows 2003 Domain Controller Standard Ed SP2
Installed SQL 2005 SP3
The installed Sharepoint 3 sp2
During install it created a sharepoint OU
But now I can not find it any where
My question is how do I display the OU that are on my server
I seem to be brain dead and cannot find them anywhere
Using AD sites and Services
AD Users and Computers
AD Directory Domains and Trusts
Not sure where else to look
Any ideas or suggestions would be greatly apprciated
Any chance that you removed the Advanced view option in AD UC?
...Formula question -simple for those who know
I'm trying to add a number that was calculated by means of a formula in one
column to the sum of a different column.
Column A (running balance) Column B (sum)
Col A's number is running balance. I copied the formula down so that the
next row changes the formula to =+e6=c7-d7
I want that running balance to add to a sum in another column.
I can add the first cell to it, but it doesn't change if the running balance
changes. I know that is because it's pointing to that single...Questions on ms dropTarget and vc debuger,need your help
Near days, my vc6 even can't debug CView::function(),
or atoi() funcions, pls tell me why.
another question, the COle
if (!ms_dropTarget.Register((CWnd*)this))//meet error,
for the first reason, i don't know what happened.
ide: vc6.0 with sp6
os: windows 2000 with sp4
debug symbols: windows 2000 debug symbols downloaded from ms web.
Could you please tell me which is a god site where I can
start learning about exchange server? I am a newbie so
please tell me a beginner's site for Exchange server
Waiting for your reply.
Thanks in advance,
I would recommend starting at www.microsoft.com/exchange and you will find
some great info there.
"Emmanuel Mathew" <firstname.lastname@example.org> wrote in message
> Hi Friends,
> Could you please tell me which is a go...New OWA Question
We have two servers, old 2000 Exchange and new 2003 Exchange on Small
Business Server. We used to access OWA externally by pointing the router to
direct traffic on port 80 to the old server. Since we’ve migrated to the new
2003 Exchange server we cannot get OWA to work from the outside.
It works fine from the inside, but if we direct the router to aim port 80
traffic to the new server, it just comes back with page not found. Still
works fine using OWA internally on the new server Just cannot get to it from
My question is: is there a port different than 80 we need to direct to t...Export to XML question
The below is a test code to export xml file. The fields Comment and Tip
hold xHTML code. The problem occurs if I add the Tip field then I get the
The XML page cannot be displayed
Required white space was missing. Error processing resource
'file:///C:/1.xml'. Line 1, Position 646
It seems that XM file cannot fully exported and some text is missing.
I apprecaite any input.
DECLARE @SQL VARCHAR(1024)
DECLARE @sqlFlds1 VARCHAR(225)
DECLARE @sqlFlds2 VARCHAR(225)
DECLARE @sqlFlds3 VARCHAR(225)
DECLARE @sqlFlds4 VARCHAR(225)
DECLARE @sqlSt...Data Validation Question #6
Thank you. It worked. Just curious, is it a "bug" in Excel or somethin
Casey's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=454
View this thread: http://www.excelforum.com/showthread.php?threadid=26764
I think it's "by design". It happens when you manually move that message to
some other place. Then, all the messages will appear there !
Juan Pablo Gonz�lez
"Casey" <Casey.email@example.com> wrote...Question about Application.ScreenUpdating = False
In my excel file there are two sheets: A and B
B is very hidden
in my vba code I am in sheet A and I need to insert a value in Sheet B
Application.ScreenUpdating =3D False
Sheets("B").Visible =3D xlSheetVisible
Sheets("B").Visible =3D xlSheetVeryHidden
Application.ScreenUpdating =3D True
But I can see the macro running (for one second I can see the sheet B
How can I solve this problem?
Why does it have to be visible to start with? Something in your code that
does UN necessary selections?
Micr...Exchange IMF questions
Exchange 2003 SP2. IMF configured and working OK but I have some questions:
1) Is there any way to make IMF learn that certain emails are junk and
certain ones are not?
2) How is the IMF filtering updated?
3) Is there a way to make IMF not check emails from certain "good" domains?
4) Does the IMF feature to deliver suspect emails into the users "Junk
E-Mail" folder (rather than the Inbox) work with older Outlook 2000/2002
versions? I created the Junk E-Mail folder for those users by logging into
their OWA site but they never seem to receive "suspect" ema...