Exchange Active Sync #4
I have a user with a Sprint PalmOne Treo 650. Sprint advertises that this
supported by Exchange 2003 Server Active Sync. Microsoft has documented
Active Sync is included with Exchange 2003 at no additional cost.
I have not been able to find documentation on how to install and configure
Exchange 2003 Active Sync to support a Sprint PalmOne Treo 650.
Can anyone point me to Microsoft or Sprint/PalmOne documentation on how to
setup Exchange 2003 Active Sync to support a Treo 650?
I work with the American Red Cross, a non-profit organization. I appreciate
your help and support.
On ...Excel 2007 Need to permanently change Normal settings for gridlines
I am using Excel 2007 for the first time and find the gridlines delineating
the cells are so faint as to be nearly indistinguishable. I can go into the
cell formatting and modify the normal style, and it is just the way I want
it. But I can't find a way to make Excel remember this and treat it as the
new definition of the Normal style. I don't want to have to redefine Normal
every time I open a new spreadsheet. Someone please help!
The changes you describe are changing the Border color and NOT gridlines.
Go into Excel Options and cl...Changing which database Business Portal points to
If I install Business Portal 2.5 (GP) and point it to our Great Plains
development server with an old Dynamics database, once we decide to
take it live, how do I go back and point it to the live Great Plains
server? Is this something that can only be done during the installation?
Let me preface my response by saying I only have experience with BP 3.0....
In BP 3.0 several tables are created in the Dynamics database to support the
various BP functions. Unless you plan to move or copy those tables you will
probably have to reinstall BP 2.5 in order to have them created.
Our attempt to cop...Cannot set menu in MFC ActiveX control
I am dynamically creating a CMenu object and trying to assign it to my
ActiveX control. Windows balks and gives me a 1436 error, something to
effect that a child window cannot have a menu. It is not a child window,
it is the instance of COleControl, the top level window. (I verified this
by inspecting m_parentHwnd.) I am trying to assign the menu within the
OnCreate event at which time the control has a valid handle, and have tried
it before and after the call to the parent OnCreate.
Does anyone know the magic words to make this work?
On Mon, 8 Dec 2008 16:22:02 -0500, Duane A. C...Changing Titles by a formula
From cell A1:A10 I have standard titles that are linked to
another sheet. I only need to change the office and date
per each title. Is thier a way to do that making the
office and date a formula in another cell?
example of title
ABC Comp, Office 38L Sales as of 6/07/2004
I need to only keep changeing the 38L and date.
Say Office # is in Column 'C'
in cell A1:
="ABC Comp, Office "&C1&" Sales as of "&Today()
----- Heather wrote: -----
From cell A1:A10 I have standard titles that are linked to
...problem in changing the text of sentences before tables
I am developing a word automation application. In a method of mine, I change
the text of some sentences of an opened word file, but the problem is when I
change the text of a sentence which located before a table, it will be moved
to the first cell of the table. My code is as follow:
void myMethod( long startingSentenceNumber, const char *toBeSearched, const
char *replacement, bool replace )
Sentences sentencesList = m_document.GetSentences();
long sentencesCount = sentencesList.GetCount();
CString replacementCStr(...reflecting values in a column into a row
I am creating a chart to map a round-robin chess game. If there are 4
players, then all 4 has to play one another.
if I have the names
Then I'd like to type them into a columns and write a formula in a
row to pick up the names
the spreadsheet should then look like this:
John Mike Sally Bill
I think it may be achieved with the Indirect() function, but my Excel
2007 help seems broken and I can't figure it out without an example.
With names in A2:A5
Enter in B1 =INDIRECT("A"&COLUMN(B1))
Or...can't change/delete bills and deposits
suddenly one day i realized that when i tried to change a
bill, i could click "ok" but nothing would happen. I
thought it was because i upgraded to 2004, so i deleted
the bills and rescheduled. about 5 of the bills will not
delete either. the error message is: "Money could not
write to your Money file. The operation could not be
performed or another application finished this task before
you. Please try again."
Now some of the newly scheduled bills will not allow me to
change the properties, i click ok but nothing happens when
i edit the series.
I have repaired ...Outlook 2007: When i Save a New Rule outlook Change it automatically...
I have this problem with Outlook 2007. I have 15 e-mails addresses in
my outlook, but i can=B4t create the rules for send all the received
mails to each emails folder.
I want to create a simple rule that move all the e-mail that i get
from "firstname.lastname@example.org" to the folder "Inbox/
email@example.com". When i create the rule, all works fine, i
select the correct e-mail account name, the correct destination
folder, etc... but when I hit the SAVE button in rules window, Outlook
2007 changes the account automatically to another one. Not
automatically...Change Row/Column Height & Width
I know I should be able to automatically set a row height to the max
necessary by hovering the cursor between the 2 rows I want to adjust and
double-clicking, but sometimes this doesn't always work. Why is that that -
do I need to adjust a setting? And is there any way to set it so that if
text is added or deleted the row height would change automatically so thatthe
text fit appropriately?
Set the row format to Autofit and cells to Wrap Text
Gord Dibben MS Excel MVP
On Tue, 19 May 2009 12:14:04 -0700, DaveL <DaveL@discussions.microsoft.com>
>I know I should be ...Changing Functional Currency #4
Try to change the functional currency to Z-CNY.
ERROR = Activity for this currency already exist.
Finance made 2 GL transactions.
Can we remove the transactions (Tools >> Utilities >> Financial >> Remove
History) or (File >> Maintenance >> Clear Data ) then change the functional
Which tables should I remove history or clear data.
Can someone on the board help us?
Once you process a transaction, you are stuck with the functional currency.
I have not seen a table fix for this problem on the board. Consider creating
a new database an...need to make a formula that would add a field value to current dat
I have made a form in which I input different values. On of the values is
(How Many Days). Now I need to a assign a default value, or expression (not
sure which way to go about this) that will take the date value for (Date) and
add the value (How Many Days)
I figured that the formula should read =sum([Date]+[How Many Days])
But that is not giving me any results, thanx for your help in advance
=DateDiff("d", Date(), [How Many Days])
"J Man" wrote:
> I have made a form in which I input different values. On of the values is ...Change default "SaveAs" to *.msg rather than *.html
Using Outlook 03, I regularly need to save emails and prefer to save as
*.msg so the attachments are contained within the one file.
How can you change the default SaveAs command to Save as Type in a *.msg
format (rather than *.html) so the type is already *.msg without having to
use the pull down?
Outlook provides no way to change that.
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
"TroyB" <firstname.lastname@example.org>...adding date/time picker to inputbox control
Hi all,is there a way to add a date/time picker control to inputbox?...change column name from letters to numbers?
I'm importing a 3rd party CSV file into Excel and then comparing some of
the contents to a printed spec. Each numbered field in the spec
corresponds to a column in the work sheet. I'd like to change the column
headers from letters to numbers. Is that possible?
Tools-->Options, General tab. Check the R1C1 Reference Style.
"Jerry" <email@example.com> wrote in message
> I'm importing a 3rd party CSV file into Excel and then comparing ...column value translation
I'm sorry if this is already here somewhere, but I could't find any references.
I need to upload a list of people into our computer system and this list is
comprised of their names and the code for the branch where they work. The
computer system into which I need to upload this list will not recognize the
current branch ID code for those employees, but I do have a list that is
basically a comparison of the two different codes. For example branch code
800 on the list equals branch code C001 in the system. I need to get a way in
excel to convert all the branch codes that are next...Changing of range (Address) to (Cell)
I have encounter a problem with the use of range
From a recorded macro, it's listed this way
ActiveChart.SetSourceData Source:=Sheets("Trend").Range("A1:M2,A24:M28"), PlotBy:=xlRow
And I edit it to this way
ActiveChart.SetSourceData Source:=Sheets("Trend").Range("A1:M2," & Cells(StartX, StartY), Cells(LastX, LastY)), PlotBy:=xlRow
And obviously VBA compiler won't let me go this easily, it happen to give an "evil-comment" on my source range, May i know how can i solve this
Try this, assuming the...domain controller
If I have a more powerful comuter than needed, can I run
Exchange 2003 on a Windows 2003 domain controller, which
happens to be the first domain controller in the domain?
Yes, you can though it's not recommended.
"rook" <firstname.lastname@example.org> wrote in message
> If I have a more powerful comuter than needed, can I run
> Exchange 2003 on a Windows 2003 domain controller, which
> happens to be the first domain controller in the domain?
Yes it is extreamely not recommended because your so called &qu...Net change and percentage of change
I have a list of parts that have had price increases. One column has the old
price the other has the new price. I need to show the difference, whether it
is positive or negative and the percentage of the increase or decrease. The
difference is not a problem. The problem lies in calculating the percentage.
I don't how to do that. Can someone tell me?
> I have a list of parts that have had price increases. One column has the old
> price the other has the new price. I need to show the difference, whethe...Out of Office not active Entourage 2008 exchange 2007
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: Exchange
Hi, <br><br>I have Entourage 2008 with latest service pack. Exchaneg 2007 sp2. MAC OS X 10.6. Out of Office works for Outlook and OWA. When I open up Entourage on any MAC and go to Tools, the Out Of Office is dimmed/ not active? Any idea? <br><br>Thanks, <br><br>Mike
...Working with a worksheet that is not the active worksheet
How can I make this code work on my worksheet named February, when it is not
the active worksheet?
' Macro2 Macro
If Range("C184").Value = "" Then
Rows("184:228").Hidden = True
If Range("C184").Value <> "" Then
Rows("184:228").Hidden = False
If Range("C229").Value = "" Then
Rows("229:273").Hidden = True
If Range("C229").Value <> "" The...XML Deserialize of empty value
I'm encountering a strange issue when deserializing a piece of XML. If I
have the following XML and try to deserialize it, everything works:
If I have the following XML, everything works:
BUT if instead I have the following XML, the "margin" element is always 0:
Why...Fill cells with interpolated values
What is the easiest way to fill cells with linear
interpolated values ?
e.g. i have value 5 in cell A1, and value 15 in cell A6.
Cells A2 ... A5 should now be filles with 7, 9, 11, 13.
of course, it's not a big deal to write a formula for
interpolation, but maybe there is more simple way, (just
by some mouse clicks....?)
Select the range A1:A6 with your start and stop value in their respective cells,
and then do Edit / Fill / Series / Trend / Linear
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/...Changing Average Cost GP 9.0 Error
When we try to change the average cost information for an item per the
documentation, (tools >> utilities >> inventory >> change average cost), we
get this message. "Use the Inventory Adjust Costs window to change the cost
of one or more reciepts. The average cost of an item is recalculated when
teh changes are proceses"
We would like to change it without using the Inventory Adjust Costs window
because there are no recent purchases and receipts of the particular item in
Would anyone have any suggestions?
The average cost is the aver...Search and display a value from a XMLDOCUMENT
I have the following XMLDOCUMENT loaded in memory:
And I need to retreive the value in <NUM_VALOR>, I had tried of many ways,
but I can´t do it,
Please somebody h...