How do I fix this so I don't get an "Error 2015"
x = Application.CountIf("E5,E6000", "T13065")
How do I fix this so I don't get an "Error 2015"
Not tried it but I would think
Providing T13065 is a string you are counting. If it's a range reference
Microsoft MVP - Excel
"2D Rick" <firstname.lastname@example.org> wrote in m...Cannot log in using WindowsID (was able to before)
I just bought MS Money 2007 Deluxe yesterday. The install went smooth,
without any issues. I registered a new WindowsID and was able to successfully
log into MS Money.
However, today when I tried to log into MS Money, the messge apeared that
the "Money was not able to recognize your WindowsID" or something like it and
that "You will still have access to some functions but will not be able to
make online updates".
Now I'm not able to make updates. Any idea what this could be? Is the
authentication server for WindowsID down or something?
See the post under Mon...Use Form button to move current record to another table
I have a database which consists of computer names and model numbers.
As time goes on the computers get old and are no longer in use. I also
have an identical table that I have been copying the old computers to.
Once copied to the old computer database I delete the computer record
from the current computer database. Is it possible to accomplish this
task with one button?
Say you had a button on each record called cmdArchive, and it's purpose
is to move this record to an archive table, and delete that same entry from
your current table.
Each record should have a unique identifying ...Can't use Merge feature
If I have a postcard file I've already made on the
screen, when I try to pull up the "Merge" feature under
Tools, it is shaded grey and I can't open it. It insists
that I either form a new database list of addresses or
edit the one that I want to merge. I don't want to edit
the one I want to merge. I just want to MERGE it.
If, however, I have just a postcard template on the
screen (without it having been made into anything), I CAN
pull up the "merge" feature under Tools. It is not
How do I un-shade the "merge" feature?
To merg...Default value of combo box based on another that uses DLookUp
I have a problem I'm trying to overcome regarding just one form which gets
its data from 1 table.
I'm trying to set the default value of a combo box to be the same as another
combo box on the same form.
The scenario is:
I have a form for entering info about financial planning Statements Of
Each client has a Plan Writer prepare their plan.
To find the plan writer that last prepared the plan for a client I have a
combo box with a DLookUp as its Control Source.
I'm usin...Getting an Error when there is nothing to show
The bottom of my report which is a statement shows #Error when there is no
Invoices to add up. Can I have it blank instead. this my text Box Control
thanks for any Help....Bob
Bring the total from a subreport onto a main report
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.h...Cannot send mail from outlook, error 0x800CCC78
This message started to appear back in Sept and I haven't been able to send
e-mail from Outlook ever since (apart from a 2 day period in Novemeber when
the issue disappeared just as quickly as it appeared).
I now have to cut and paste e-mail i recieve into the e-mail interface of my
provider in order to get e-mail sent.
I have posted this error 3 times now and haven't got a solution, plenty of
questions about versions, platforms, port numbers etc etc, but no fix.
Judging by the hits on google to this, it is and established problem.
Come on Microsoft, do your stuff.....Password Protection #4
I have a password protected sheet. For one of the
columns, I have a validation rule and have a list of
values that the column can take.
I put a password for the sheet and now no can change the
sheet except for the column where I have the validation
rule. When I click on that column, the small arrow
appears and the drop down box appears and I can select a
different value and change the cell. All other columns
Cant we protect a column that has a validation rule with
a "List" as option?
Not that I'm aware.
But doesn't the Data|Validation provide the sa...Change outbound server in header to fix 550 Can't verify your host name error
The headers on the outbound emails show the internal DNS name of our
exchange server; obviously this won't resolve properly at the
How/where in Exchange 5.5 can I force the IMC to use a real fqdn on
You can do this in TCP/IP properties\Advanced\DNS tab of machine. And
yes, this is not just for Exchange, so you may consider forwarding all
outgoing mail to some relay server (your firewall or ISP's server).
Professor Frink wrote:
> The headers on the outbound emails show the internal DNS name of our
> exchange server; obviously this...help!! smtp protocol error occurred
exchange 2000 srv/windows 2k srv
smtp protocol error occurred when trying to send mails.
Still waiting for some relavent information so we can
help you solve your problem.
>exchange 2000 srv/windows 2k srv
>smtp protocol error occurred when trying to send mails.
I had that problem, I telneted into the servers that the error occurred and
found I was on a blacklist. Had to sumit to an open relay test, and bam, no
I have set up a new spreadsheet with pupil's achievement levels in different
subjects. Each subject data is stored on a separate sheet. Each pupil has a
unique ID - which is on each sheet. Is there any way I can set up excel to
combine the results of one pupil acheivements in all subject areas. i.e. will
excel look on each separate sheet and locate the results for a particular
pupil - if so - how? Any help gratefully received.
Here's one set-up to try ..
Link to a sample file at:
...Visual Basic Error
Every time I shut down Outlook, I now get the following
Microsoft Visual Basic error: "Compile error in hidden
module: Autoexec" This started after I installed the
software for People PC Dial -up Service. They haven't
responded to my question and Tech Net/Knowledge base come
up empty. Help!!! Thanks
So, uninstall that software. It's obviously the problem and if they won't
support it then it's useless to you.
[MVP - Outlook]
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Exten...Error- Project is used by another user -Please select another proj
Please see the subject line, when im trying to open a particular project.
it gives me following error.
I checked the current users, there are no users. Apart from me.
There are some non PA users,i tried to remove them from activity.
inspite of me removing them from activity, im geting the same error.
There is a stranded user in PA000001 table. You need to clear this
> Please see the subject line, when im trying to open a particular project.
> it gives me following error.
> I che...can you tell me what an error 920 is?
I'm trying to save a visio file out as a jpeg, or gif, or png. I keep
getting the error with no explanation of what the error means - any help is
You can go to the following link and it explains the issue you are having and how to fix it: http://support.microsoft.com/default.aspx?kbid=295691
> I'm trying to save a visio file out as a jpeg, or gif, or png. I keep
> getting the error with no explanation of what the error means - any help is
...How to use structured reference (ListColumns) in VBA
I want to do something simple...loop through a range retrieving values one at
time and taking action on that value. This range is an Excel 2007 table
column. Easy enough...BUT I want to use structured references to a table
column by NAME, not numbers. I don't want to define new names, just use the
table column headings. I've found ways of doing it with quotes, but that's
not structured....the names in quotes do not change if the table heading is
changed by the user.
The formulas change if the table column heading is changed, but I want it to
change in VBA to...Protection and grouping
I protected a sheet leaving some columns unprotected.
These unprotected columns are grouped.
When I protect the sheet, I am no more allowed to hide the grouped
columns (by hitting on the "-" button).
I allowed all conditions in the "Protect Sheet" window, but nothing changed.
Anyone can please help me?
If you already have the outline/subtotals/autofilter applied, you can protect
the worksheet in code (auto_open/workbook_open??).
.Protect Password:="hi", userinterface...User Authentication Error
I am running CRM 3.0. I have the system administrator role. When attempting
to merge 2 account records I receive an error that states,
"The user authentication passed to the platform is not valid."
I cannot merge the records. If anyone can, please advise. thanks.
...Report Error 11-24-04
When attempting to run CRM Reports for the first time we are receiving the
error "Information is needed before this report can be processed" I have
found documentation that states that this can happen if your server has an
underscore. Our server does not it is named ourcompany.server.eeecrm Can
the periods have the same effect as the underscore. Or does anyone have
Hi There -
Hope you don't mind but I wish to piggy-back on your post.
I get the same error on our custom reports that use OLE DB to connect to
another SQL server other than the MS CRM ...Using Excel in Mac office 2004 with Microsoft/Mac 2008:Analysis toolpack
Although I am disappointed with Office 2008 for Mac because of the
Analysis toolpack, I figured things out quite recently that I can
install my Mac office 2004 and use the excel package that contains the
Analysis tool pack. How? ...... let me show you:
1. Insert your CD for Mac office 2004
2. When it open on your desk top, two options will be given to you to
download the software
(a) Office set-up assistant, and (b) Microsoft office 2004.
3. CHOOSE MICROSOFT OFFICE 2004 (Drag the icon onto your desk top) and
will start to run/download.
4. When done, this will appear as ...Script Errors 08-12-04
When launching CRM 1.2 through the web interface or
through Outlook I am experiencing errors. This occurs on
all the PCs on our network.
CRM installed on Windows 2000 Advanced Server
Client PCs running 2000 or XP Pro
Browser IE6 with all updates.
The main 3 I see are:
Error: Syntax Error
Error: 'ORG_DATE_START_DAY' is undefined
Error: 'ORG_DATE_FORMAT' is undefined
URL: https://crm/home/home_home...Userform combobox matchrequired = True; error with no selection
I have a userform that includes a combobox which is optional for the user,
but if they do use it, they have to select one of the three values provided
(no creativity allowed).
This works fine if the user ignores the field, or if they make a selection.
They can even click the combobox 'arrow' to see the values and then click to
another part of the form without making a selection. They can tab through
controls including this one without any problem. All good.
However, a user may enter the field (mouseclick) thinking they might want to
make a selection, then decide again...Failed to open mmf error appears
A pop up window appears with the message 'failed to oepn
mmf'. I assume it is referring to Microsoft mail format.
What could be triggering this error.
What version of Outlook, and when do you see this error?
> A pop up window appears with the message 'failed to oepn
> mmf'. I assume it is referring to Microsoft mail format.
> What could be triggering this error.
>What version of Outlook, and when do you see this error?
>> A pop up window appears with the message 'fail...Unknown error code
Hi, I'm trying to set up email in outlook 2007. After I put in all the
information and click on "test account settings", I'm getting an error
message. I mean, in the task tab, the "log onto incoming mail server (POP3),
the status is completed" but on "send test email message, the status is
Failed. and the error message is giving is "an unknown error code: 0x80040607
Does anybody knows out to fix this?
Have you been able to send mail out before using that account, possibly with
another mail client?
"DM" <DM@discussions.microsoft.com> ...Autoenrollment errors after adding SSL certificate
Hello, I'm running an all Windows 2003 domain with an exchange server which
is setup so that Outlook web access is using SSL which required that I
installed a certificate. Ever since I've set up exchange to use this
certificate I receive the following errors in the Application log for both
my Domain Controllers (both also Windows Server 2003) which occurs every 8
Both Domain Controllers show the following errors in the Application Log
Computer: DomainController1 or 2
Event ID: 13
Automatic certificate enrollment for loc...Outlook 2002 SP3- Runtime Error when opening Outlook
I'm getting a runtime error- Microsoft Visual C++ Runtime
Library / Program C:/Program Files/ microsoftoffice/
office10 /outlook.exe. This App has requested the runtime
to terminate it in an unusal way.
This only happen the first time I open Outlook for the
day. It shuts down, then I can reopen it and all is fine.
I have try to debug it and the detect & repair option in
the help tab.
Any help is Appreciated!