error bars #2
Help! I am trying to put error bars on my data. I have
a number of series in my chart (xy plot). One set has a
number of points (series 1), then I plot the average of
those points in a different color (series 2) on top of
that data, but when I put the error bars on the series 2,
they are masked by the data from series 1 even though the
data point of series 2 is on top of the data from series
1. Does anyone know how I can pull the error bars to the
front so they are with the associated data point? I have
tried moving the order of the series, but the error bars
always remain in th...Error 2185 on Snapshot form
I have a bound form that has several unbound controls in the header that are
used only to filter the records on the form. The detail section has only one
bound field enabled, and its only function is to allow the user to
double-click it to open a detail form filtered to the record on which the
I have AllowDeletions = False, AllowAdditions = False, and RecordsetType =
Snapshot because this is not an input form, just a search form.
Now, in all my filtering controls, I have code similar to this to drop down
the control on the first key press:
If Len(ThisControl.Text)...sumif formula #2
At the moment I am trying to work a sumif formula
The problem I am encountering is once I have set the range and criteri
it won't pick up the sum range as the range I am specifying is fo
example J15:CB45 - it will pick up J15:CB15 but I need it to pick u
the whole range - do you know of anyway I can resolve this.
My formula is =sumif($J$3:$CB$3,E$3,($J15:$CB45)) but it doesn't see
to work this one does though =sumif($J$3:$CB$3,E$3,($J15:$CB15)) bu
that doesn't help me!
I have put a print screen of the spreadsheet I am trying to work on.
Message posted from htt...Delete on Continuous form gives error 2046
I have hunted the newsgroup and tried many different things, but I still
can't seem to get this right...
I have a main form for entering in order information, and a sub form for
adding in the items ordered. The subform default view is set to 'Continuous
Forms', Allow Additions/Deletions/Edits are all true.
the data entry property is false if that makes any difference.
I have put a button (btnRemoveItem) into the details section of this subform -
and have tried to write the code to have the current record deleted when the
button is pressed. The code I used that gives th...sendobject error 2295
I have a small app that distributes notification emails to different users
based on 2 criteria selected by the user. I select the receipients based on
the input values they indicate. The distribution lists are static strings
from another file that I use... This approach has been working well with
single quote enclosed email address separated with a trailing ; i.e. 'a
user1'; 'a user2'; I assign the appropriate string(s) to a local variable
that I use as the sendobject TO and CC parameters.
I have confirmed every email address used in the strings are valid.
I now rec...Merge Error in Contacts
We converted an Act Database putting most of the records into Leads and only
qualified records into Contacts.
I've been in the process of identifying and merging duplicates.
My latest test stripped all EMail addresses out of Leads and Contacts,
sorting them and identifying duplicates.
I can merge a Lead with a Lead
I can merge a Contact with a Contact.
Here's my problem:
If I convert a Lead to a Contact and then try to Merge the two records I
get an error followed by the following Script Error
Error: 'crmMergeForm' is undefined
There is an older answer in the "Archives" here, but that didn't work for...
F, 3/7/08 - Error 2024 - "The report snapshot was not created because you
don't have enough free disk space for temporary work files."
The Code is...DoCmd.OutputTo acOutputReport, "BudgetSheet", _
"Snapshot Format", "C:\BobDev\S" & Format(Now(), "mm/dd/yy") & ".snp", False
TIA - Bob
This part of your expression, which you can test in the Immediate Window,
results in illegal characters (forward slash) in your output...error in sum formula result
I'm no Poweruser of Excel, just an occasional user with a little experience,
but I have come across a strange behavior, and wonder if you have seen this
before, and what might be causing it.
I recently did a new spreadsheet to track some costs, and constructed a
simple formula to extract a sum from three cells. The three cells each
contained currency numbers, lets say 235.45, 100.44 and 95.51. The formula
I used was =SUM(F13.F15), and the result was off by -.01. In other words
the last three digits of each number, 5,4 and 1 should have yielded a 0, but
in fact returned a 9. I chec...error 16003, can't receive emails
Operating System: Mac OS X 10.5 (Leopard)
Email Client: pop
Hi there. I can send emails fine but when i try to receive i am getting error message 16003 and "an unknown error has occurred in Entourage." Any ideas? Many thanks!
...Error when publishing
When i publish, my website is showng the directory listing, not the home
page. How can i correct this?
by having an; index.htm or index.html or default.htm or default.html page in
the root folder...which one of the four will depend on what your server is
set up for.
what is the file name of your "home" page?
Microsoft MVP Expression Web
"Suki arts" <Sukiarts@discussions.microsoft.com> wrote in message
> When i pu...sumif across multiple sheets in excel 2007 based on a condition
I have a small work book, tracks deliveries made and trucks used.
I have seven sheets Saturday thru Friday and one sheet that totals
The weekly sheets have 34 rows representing 34 stores that we service and
the total sheet also has 34 rows that contain the totals for that week.
Here is my question I am trying to, on the totals sheet, sum up the total
trucks that we used per store per week. In the cell would be entered 0, 0.5,
1, 2 and so on depending on how many trucks we used for that day. Yes we use
0.5 if the store was combo'ed with another store. I ne...Lost mouse click after displaying error dialog
I am having a problem with a modification I am doing to an old piece of
code. It is using Visual C++ 5.0.
Basically I have added some code to check the range of a typed in value. If
the value is out of range I am using an AfxMessageBox to display an error
dialog. This is all triggered in the ON_EN_KILLFOCUS handler for the entry
The problem I am having is that after clicking the Ok button on the error
dialog, the next mouse click is 'lost'. Also the mouse cursor shows as an
input cursor anywhere over the application window until I do the 'extra'
click, then it goes ...trigger odbc error
We have been experiencing issues where users are deleting records from
inventory tables and making administration a real task. I have created
a trigger to run and email me what has been deleted from one of the
tables. However when I test the trigger it gives me an error stating
that the DELETED table is not a valid object. Below is the trigger I
created and following that is the error I get.
CREATE TRIGGER dbo.IV00104_delete
exec master..xp_sendmail 'email@example.com',
@query = 'SELECT ITEMNMBR, CMPTITNM
...SUMIF or SUMIFS
Here is what I have
Col A Col B Col C
1310 3 3,463.00
1315 3 740
1369 3 -178
1375 3 -105
1640 3 110
1310 4 1,460.00
1315 4 1,521.00
1375 4 -65
1310 6 3,284.96
I am trying to figure out a way to add column C to a new cell if
Column A is between 1310 and 1369.
> Here is what I have
> Col A Col B Col C
> 1310 3 3,463.00
> 1315 3 740
> 1330 3
> 1369 3 -178
> 1375 3 -105
> 1640 3 110
> 135 4
> 1310 4 1,460.00
>...Error PLEASE HELP!!!
I'm trying to syudi Ansi C in this program like suggested by my University
#define MAXLINES 5000 /* max #lines to be sorted */
char *lineptr[MAXLINES]; /* pointers to text lines */
int readlines(char *lineptr, int nlines);
void writelines(char *lineptr, int nlines);
void qsort(void *lineptr, int left, int right,
int (*comp)(void *, void *));
int numcmp(char *, char *);
int StrCmp(char *, char *);
/* sort input lin...out box error
i get this error on this accouts
The message could not be sent. The authentication setting might not be
correct for your outgoing e-mail [SMTP] server. For help solving this
problem, go to Help, search for "Troubleshoot Windows Live Mail", and read
the "I'm having problems sending e-mail" section. If you need help
determining the proper server settings, please contact your e-mail service
The rejected e-mail address was 'firstname.lastname@example.org'.
Subject 'ttest shipent.net'
Server Error: 550
Server Response: 550 not local host ...Error: The ordinal 6880 could not be located in the DLL MFC42.DLL
I know - this is an old problem but still, I can't overcome it:
A year ago I have stared receiving the above application error when I
navigate to folders containing AVI files.
Dismissing the dialog is followed by an apparent Windows Explorer
The solutions I found in several sites are as follows:
The WinXP file version 6.02.4131.0 *has* the ordinal 6880. Therefore,
you've installed poor software installing an older version of that
file. If you're lucky, that copy was installed in a program folder and
can ...Organization Settings Error
Seems like everyone is having a similar issue with CRM 3.0, no supprise then
Problem: Error message to contact sysadmin when selecting either System
Settings or Fiscal Year Settings. (you can access Auto Numbering)
Tried: Changed expiry on server to immediately from 3 days. Rebooted both
server and client, with no fix.
Deleted all cached Internet files, with no fix.
Can anyone help ?? (my only other thought is to wait till Monday and see if
anything hanging in the system expires (3 days)). Any help greatly
I dont know if this helps?
You may have...Error Code :0x80040605
Outlook asked me to upgrade the Connector when i choose to repair, nothing
happened except that my email account could not sign in and when i choose
remove the outlook connector automatically removed.
Troubleshooting Outlook Hotmail Connector -
Ben M. Schorr, MVP
Roland Schorr & Tower
Author: The Lawyer's Guide to Microsoft Outlook 2007:
"Karen" <Karen@discussions.microsoft.com> wr...Installation error
Does any have experianced problem with instaling service
pack 4 on win200 prof. When I tried to install it I got a
message outlook express\wabmig.exe is open or in use by
another application. I can resoved this problem We are
running ehchange server 5.5 for only internal emails and
Please help !
...Rules and Alerts gives me Out of memory or system resources error
Every time I go to "Tools" / "Rules and Alerts" I get the following
Microsoft Office Outlook:
Out of memory or system resources. Close some windows or programs and
Everything else is working perfectly fine, it's just this one function.
I am getting the same error from any PC that has Outlook 2003
installed! This is really annoying. Anyone with similar problem?
> Outlook 2003
> Every time I go to "Tools" / "Rules and Alerts" I get the following
> Microsoft Office Out...another sumifs plea
I'm struggling to convert a sumifs line from 2007 to excel 2003.
The line I have working correctly in 2007 is:
=SUMIFS('Washing MC Rental'!$K$4:$K$21,'Washing MC Rental'!$Q$4:$Q$21,"=
0.00",'Washing MC Rental'!$L$4:$L$21,">28/2/2010")-SUMIFS('Washing MC
Rental'!$K$4:$K$21,'Washing MC Rental'!$Q$4:$Q$21,"= 0.00",'Washing MC
Can any one please help me to put this into 2003?
Best Regards Dave
=SUMPRODUCT('Washing MC Rental'!$K$4:$K$21,...uxtheme.dll Error with VS Tool Add-In
I deployed a GP add-in with Visual Studio tools. Works beautifully on an XP
machine, but when I installed it on a Win2k machine it throws an exception:
System.DllNotFoundException: Unable to load DLL 'uxtheme': The specified
procedure could not be found. (Exception from HRESULT: 0x8007007F)
at Microsoft.Dexterity.Shell.UI.DexUIForm.OnPaint(PaintEventArgs e)
at System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e,
Int16 layer, Boolean...Error message
If I use this formula =O14+L14+I14+F14 I get an error message.
If I try this =IF(ISERROR(O14+L14+I14+F14),"",O14+L14+I14+F14) nothing
shows even though cell O14 has the number (45).
Any help appreciated.
My guess would be that one or more of the cells you are adding is text.
"Kazza" <Karen_Thompson90@hotmail.com> wrote in message
> If I use this formula =O14+L14+I14+F14 I get an error message.
> If I try this =IF(ISERROR(O14+L14+I14+F14),"",O14+L14+I14+F14) nothin...mfc error
Microsoft is reporting an mfc error and I want to know how to delete the problem