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...Exchange 5.5 to Exchange 2003 Migration Question: No ADC??
I have an environment where I need do do an Exch 5.5 to 2003 Migration.
The domain has already been migrated from NT4 to 2003. The only thing
is, is that there is no Active Directory Connector setup anywhere in
the environment. That leads me to my first question I guess. How is
this possible that Exch 5.5 is even working with AD?
In terms of upgrading, what would recommendations be? It is a single
Site. I was thinking about bringing up a new Exch 2003 server, and
using "Move Mailbox" to the new exch server. Replicate all the
necessary public folders, decomission the old ...Passing data from one form to another
Hello I have a form called frmMaindB and it has 5 text boxes on it
(txtEmployeeTime, txtDTRegular, txtDTReason1, txtDTReason2, txtDTMaintenance)
when I double click on the text box it opens up a pop up form named
frm_DecimalConversion. On this form I have two text boxes one box I enter
data into and the other calculates or converts the data to a decimal. The box
that converts the data is called txtDecimal. Then I have a close button which
I want to use to close the pop up form and insert the data into the text box
I double clicked in to get the pop up or (frm_DecimalConversion). I have r...data value in Form field if no table entry
I have a form with a field which pulls through and concentenates 2 fields
called [ContactFirstname] and [ContactLastName]from my table
There are however some customers for whom I do not have names and therefore
instead I would like Sir/Madam to appear in the field in the form
I think I have seen this done somewhere using ELSE? but can't find it
Any help/ideas gratefully received
Perhaps something like this:
Nz(Trim([ContactFirstname] & " " + [ContactLastName]), "Sir/Madam")
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access use...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.....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
...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...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...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
...Help ! formatting data to text
I am creating data in an Excel spreadsheet. I then want to get that data
into a simple text email. I have some problems and questions...
1) how do I get the columns of data to line up evenly when I copy the data
to email text ? Keep in mind I need to be in simple text format, not HTML
or rich text.
Every time I do this, all columns become chaos and are unreadable.
2) Is there a simple way to automate the creation of an email from an excel
file ? this is less important to me.
Thanks in advance
#1. I think it may have to do with what email client you use, too.
I copy and ...How can I stop charts from refreshing when changing source data?
My problem is, that I am working with a lot of data and when I change some of
the ranges all charts in my view refreshes and it takes much time. My pc is
aP4 3GHz, 2GB RAM so that should not be the bottleneck. Is there any way to
force the charts not to update all the time?
...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...how do I remove fx from the function line, can't enter data
I have the fx displayed just under my toolbar, and I can't enter or change
data in any of the cells in the file. I can't get the red X, the Green check
mark, or the black = sign to appear. There are very few areas that are not
"greyed out" under the headings at the top. This situation applies to all of
the excel files on this computer. I have Excel 2000. Please help.
Can you move the cursor around anywhere in the spreadsheet?
> I have the fx displayed just under my toolbar, and I can't enter or change
> data in any of the c...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 ...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...Activities for an Opportunity Order
Is there any way to have activities for an Order in an Opportunity rollup and
appear in the Activities/History for the Opportunity? They show up for the
related account, but it would be helpful to be able to see these in the
On Apr 20, 12:10 pm, Rick M <R...@discussions.microsoft.com> wrote:
> Is there any way to have activities for an Order in an Opportunity rollup and
> appear in the Activities/History for the Opportunity? They show up for the
> related account, but it would be helpful to be able to see these in the
> related Opp...Active Directory/Exchange problem
Before I joined my current employer the admin here upgraded from
Exchange 5.5 to Exchange 2000(Box A) and then added another Exchange
2000 box to the organisation(Box B)and migrated the data in Box A to
Box B. Box B is now the working exchange server and Box A is no longer
The problem is that if I actually shut down Box A I can add a new user
to Active Directory but I am unable to modify a users email/smtp details.
mail can still be transferred with no problems which would lead me to
believe that Exchange is Ok but there is some sort of Active Directory
link between the two bo...how do i recover data in publisher
i have been entering addresses to set up a mail merge. i cllicked the "ok"
in the window and lost all data . can i recover it
Look in a folder in My Documents named "My Data Sources". Publisher data is
saved as .mdb(Access) file.
Did you try selecting "Edit Address List" in the Mailings and Catalog menu
"dee" <email@example.com> wrote in message
>i have been entering addresses to set up a mail merge. i cllicked ...Using subtotals as single data entries
Sorry about the subject--I couldn't figure out how to describe it
I have a large file (16,000 records) of amounts billed by roughly
10,000 service providers. A number of these providers have multiple
office locations, so each record is unique to a specific office
location. In other words, a provider who billed from 3 different
office locations will have 3 entries. Each provider has a unique
provider ID number, which stays the same regardless of which office
location he is billing from.
I want to be able to subtotal the amount billed by each provider for
all their office locations...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> ...How can I keep track of when (date and time) data is entered into.
I am trying to create a spreadsheet for a high school class. I need to be
able to track when a student has entered data into specific cells of the
spreadsheet. Any ideas?
In the code behind the worksheet, enter (eg)
Private Sub Worksheet_Change(ByVal Target As Range)
Cells(1, 1).Value = Now()
This will enter in Cell A1 the date and time at which any entry is made in
If you need the location of the time-stamp to vary according to which cell
is changed then you can test the value of Target and vary the destination
Return email address is n...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...How can I cut data out of HTML table, into msExcel and just take the data & columns? (but NOT the formatting & URLs!)
This is driving me ABSOLUTELY NUTS!
How can I keep the rows & columns of data that I am copying and pasting
off a website (my own in this case!), into a spreadsheet... WITHOUT
taking all the data formatting?
If I paste out of Ms IE v6 into Ms Excel (2003), it does at least keep
columns (something that doesnt happen if I paste out of FireFox, fwiw).
But it pastes with all the formatting & URLs etc - which I DONT WANT!
OK, I can save as .CSV, close, 2 warnings, and re-open but when done
REPEATEDLY this is a damned nuicance!