It worked. I created a new profile and that seem to do the
trick. Bonus!, my KeySuite for my palm seems to have come
over as well. I did a test sync with my Palm with a new
record entered in and it came over no problem.
Thank you for your help!!!!
...Sorting a Work sheet
Hi there, i have an example sheet here:
im want to be able to sort the countries on the left, by who has the highest
figures for that month, at the top ,and the lowest at the bottom, but, i
want to be able to select which month i want to find out for by a drop down
i select march from my drop down menu, and it sorts the sheet, with canada
at the top, and uk at the bottom (and obviously the appropriate ones in
between), but, if i then select may from my drop down box, it places poland
at the top, and usa at the bottom.
How would i do this - im not a pr...Money Plus 08 SP1 & Vista SP1 "stopped working"
Money Plus Dlx 08 SP1 184.108.40.2065
Vista Home SP1
I now get power exits with a "stopped working" when selecting the
Investments tab. Everything else seems to work OK. I suspect one or both of
the service packs.
Any ideas appreciated, Don
1. Close Money
2. Bring up Internet Explorer and go to the Choice page:
http://moneycentral.msn.com/investor/controls/setup.asp and choose the Basic
3. Close IE, start Money and see if that resolves the problem.
Alternatively in step 2 delete the moneycentral.msn.com cookie
"dbl30569" <firstname.lastname@example.org...COUNTIF Not Working
Can someone please offer some help
A B C D E
1 SPR NFR Week Priority Complete
2 1968 1 1 Y
3 9874 1 1 Y
4 1971 2 2 N
5 1972 1 1 Y
6 9562 3 1 N
7 9745 2 1 N
8 1976 3 3 N
Above are the rows and columns as my example
Goa - I want to know what SPR's (column A) have a 1 in the Week(C
column and also have a 1 in the Priority (D) column
The result should be at total of 2 - SPR's 1968 and 1972 both have a
in the Week (C) column and a 1 in the Priority (D) column.
Any help would be greatly appreciated
Message posted from http://www.ExcelForum.com
On Fri...Reapplying Notest Master not working
I've tried this in PP2007 & PP2010 RC. I have a handful of decks where
I've modified the notes master to include new headers and footers.
However many random slides in the decks aren't using the master. I've
tried to visit each one and apply the notes master, but in some cases
one of the following happens: (1) nothing happens, (2) only the slide
& notes field get updated, the footers & headers don't change.
Is there a way to say "blow away all customizations to the notes page
use the notes master for everything" ??? Seems like this should be a...Working days
I am trying to figure out how many days a vehilce is in my shop. If I have
(date in) and (date out), what formula can i use to find out the number of
workign days the vehilce was in the shop.
Doing WorkDay Math in VBA
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"MPAVLAS" <MPAVLAS@discussions.microsoft.com> wrote in message
news:5C7A7D21-8C60-4D46-AD51-419020744CCB@microsoft.com......Scripting workings in IE but not in Outlook
I added some script to change the default duration value to 0 when opening a
new task. This works great in the IE client, but not in Outlook. We are
using Outlook 2007. Any ideas or did I miss the chapter where it says you
can't script in Outlook?
Are you getting a script error or is the code not executed? If it's not
executed, can you confirm that you have synchronized the latest changes? Are
you in online or offline mode when trying?
Michael H�hne, Microsoft Dynamics CRM MVP
Cu...Excel formula doesn't work when put in from VBA, but works when written in Excel
I have made vba-code that makes a formula to be pasted into one cell at the
time in Excel.
vAktivCelle = "J" & i
vFormel = "=if(E" & i & "=0;if(((G" & i & "+H" & i &
vFormel = vFormel & "+G" & i & "+H" & i & "+I" & i & ")-F" & i &
vFormel = vFormel & "(G" & i & "+H" & i & ")*Parametre!$E$5+G" & i &
I'm having a problem with CString. Rarely but too often, GetLength returns
the wrong length. A recent example is a CString "OR" returned a length of
0xDD000002. As you could guess, this caused Serialize to have a heartattack.
Has anyone seen this kind of problem before and have an idea of the cause
and of a solution?
Frank Perry wrote:
> I'm having a problem with CString. Rarely but too often, GetLength returns
> the wrong length. A recent example is a CString "OR" returned...Sales Work file cannot be processed while other users are accessin
Trying to run check links on Sales Work, I keep getting the "This file cannot
be processed while other users are accessing it" error. The SY00800 table
does not exist, and I have rebooted the server. No other users are logged
into the system.
What should I try next?
You are saying the SY00800 does not exist in your DYNAMICS database.
"Mike Davis" wrote:
> Trying to run check links on Sales Work, I keep getting the "This file cannot
> be processed while other users are accessing it" error. The SY00800 table
> does not exist, and I have reboote...Color not working
I am operating Windows 2000, using Office Pro 2003. I am
no longer able to format my cells with colors, either
shading or text coloring. I have run the repair feature,
but it didn't work. Bold, Underline, and similar
functions still work.
Have a look at this:
Changes to Fill Color and Fill Pattern Are Not Displayed
>I am operating Windows 2000, using Office Pro 2003. I am
>no longer able to format my cells with colors, either
>shading or text coloring....working with wage tables based on years worked
set up table that would feed column "current wage". Table would consist of
years worked and associated wage. example:
name years worked current wage
etc for about 20 years
So what is your question? Looks like plain data input to me! No
calculations or anything like that required here. I would however enter the
wages in columns, rather than rows. In that way you use one row per
employee, so headings would be:
Name | Year1 | Year 2| and so on
Maybe an additional column ...work with templates
I have a template that was made for Excel but when I go to bring itr up I get
an error message that Excel does not recognise it and to go to auto text
format. How do I do that?? Where is auto text format??
The message means that Excel doesn't recognize the format of the file you're
trying to open.
The message asks you to save it elswhere as a Text(*.txt) file and open that
file in Excel using the Text Import Wizard.
Nothing about "auto text" format.
Obviously the template is corrupt.
You may get it open with the free program OpenOffice which does wondrous things
with ...Add working hours to date field
We offer computer support based on a certain response time in hours. I want
to have a date field, on the case form, to automatically set x WORKING hours
ahead, usually 8 hours. The actually hour value will be pulled from a
Does anyone know if this is possible or am I shooting way too high?
...Advanced find does not work Outlook 2003
I recently descovered that the advandced find option in
outlook 2003 does not work!
- I look in my inbox and I select a message from someone
(to check that I have at least one message from that
- I use advandced find, where I select from ... the same
The result is no mail.
What can it be?
...CInternetFile and share acces
I am trying to write an FTP application. This one should take a file
on a local PC and write it on an ftp server. But on this ftp server,
there is another application that should do the same thing with
another ftp server. So my problem is to be sure that the second
application do not access to the file at same time that the first one
For local file, we can use 'CFile::shareExclusive' open flag to
control access. Is there a way to do this with CInternetFile ?
...Open Office and Microsoft Works
How can I get my browser to choose the spread sheet from Open Office instead
of Microsoft Works' when trying to open an XLS file?
As it stands the latter automatically opens it.
Windows Vista Home Premium SP2, 32 bit and IE 8.
The reason: the file doesn't open properly as is, IOW a calendar shows up in
sections of four and incomplete as such.
"webster72n" <email@example.com> wrote in message
> How can I get my browser to choose the spread sheet from Open Office
> instead of Mic...Graphing work and remaining work over time
I would like to generate a graph showing total actual work and remaining work
for a top level task over time (week), This would enable me to show the
projected remaining work through the duration of the project as it decreases
from N to 0, and show the actual work completed though the duration of the
project as it increases from 0 to N.
The canned visual reports don't allow me to do this (that I can see anyway).
Maybe I'm missing something. I also can't see how to customize a visual
report that will do what I want.
Using Microsoft Project 2007 (not the Server edit...can I work on Publisher docs on Mac OS X
I have a need to amend MS Publisher docs I receive on a Mac OS X computer. Is
there anyway this can be achieved?
Phil.T <PhilT@discussions.microsoft.com> was very recently heard to
> I have a need to amend MS Publisher docs I receive on a Mac OS X
> computer. Is there anyway this can be achieved?
A suggestion I have heard:
Export your Publisher file as an MHT file.
Open them in Word 2004 on the Mac.
Then to go in the other direction, save as a web page, and reopen in
If possible, though, I would recommend opening them in Publisher running
under Virtual PC ...How Me works?
Form1 has two subforms, one with with recordsource Query1a and the other
recordsource Query1b. I have a button on Form1 that opens Form2. A user
makes choices on Form2, then clicks off a process that creates Query2a and
Query2b dataset, which needs to be shown back on Form1. So I'm trying to
change the recordsources for the two subforms on Form1. I've done this
before but I'm missing something about how "Me" works.
I reopen Form1, change the recordsouces of the subforms, but then the screen
does not yet know that the subform recordsources are different,so I t...does VS C++ 2005 actually work????
I recently purchased Microsoft VS 2005 and just cannot seem to get it
1. I tried converting a VS 2002 solution to VS 2005. It took a while to
realize there is a bug in Intellisense. The only solution was to disable
2. It seems class view has been rendered inoperable now that Intellisense
has been disabled. So this means browsing by namespaces and classes is not
3. I tried debugging the application but it seems the debugger cannot find
certain debug libraries such as 'MFC80UD.DLL'. I posted a message and hope
someone will know what is ha...Word 2007 automatic spell checker not working
I've tried turning on the automatic spelling and grammar checker via the
proofing options. For some reason it can only show grammar errors (green
squigly line) yet it cannot show spelling errors (red squigly line).
If I then select the check spelling and grammar option it only checks the
grammar. I've fiddled around with how checking every box I can try in the
proofing options but nothing seems to work!!!!
It's really doing my head in, having word but it won't correct any spelling
Any help would be gratefully received.
In the Proofing cat...Clean up Adventure Works or other CRM database for importation tests
How could I rapidly remove all contacts, opportunities, activities and
accounts in a DB?
I most of the times use the SDK for this. You will find a good example of
this on the Microsoft Dynamics CRM Team Blog:
Merijn van Mourik
Macaw Business Solutions
"Patrice Mariet" wrote:
> How could I rapidly remove all contacts, opportunities, activities and
> accounts in a DB?
"Merijn van Mourik" <MerijnvanMourik@discussions.microso...SBS 2003
We have a Windows 2003 SBS with SP2. We have been having problems with the
IIS websites since last Tuesday. They will run correctly for a few days and
then just stop. User's see the following message when they try to access the
"Internet Explorer cannot display the webpage"
The IIS websites will show up as "running" in IIS, and restarting the IIS
services doesn't help, but if the server is rebooted everything will come up
and work correctly for a few days.
There are not any errors in the application log, and the W3SVC1 log does...ordering by lowest cost not working?
I frequently generate orders for our 2 main suppliers at one time by using:
1. use reorder info
2. items from selected primary suppliers
3. order from supplier with lowest cost
When browsing through the purchase orders I have noticed that items
sometimes order from the supplier with the higher cost. Has anyone noticed a
problem with this feature? Version is 1.3.0203, I have not installed the
refresh yet because I had no other issues at this time.
Beverly's Pet Center