Hi, I have just upgraded from 1.2 to 3.0. I am able to open CRM via IE and
get all the tool bars and options however in the data pain I am just
recieving the error message: An error has occurred. For more information,
contact your system administrator. I have been working on the assumption that
there is a permissions error but all seems fine both within CRM and on the
Any advice ?
...SDK integration in VS2005 #2
In my MFC application I have resources in german as default and in english,
all included in the .exe. Whenever the program runs under a german version
of the OS it appears in german if it runs on any other language it should
come up in english. I'm using this code:
MAKELCID(MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US), SORT_DEFAULT);
lcidUser = GetUserDefaultLCID();
LANGID langid = LANGIDFROMLCID(lcidUser);
if (PRIMARYLANGID(langid) != LANG_GERMAN)
LCID lcidUsEnglish =
MAKELCID(MAKELANGID(LANG_ENGLISH, SUBLANG_ENGLISH_US), SORT_D...Procedure to calculate distance using latitude/longitude
Does anyone know of a vba procedure for access that will calculate
straightline distance using latitude and logitude for 2 points?
> Does anyone know of a vba procedure for access that will calculate
> straightline distance using latitude and logitude for 2 points?
James A. Fortune
...Insert text in Cell A1 based on keyword criteria
I want to populate cell A1 with specific text (the word "Active")
whenever the word "Yes" is found in cells A2:A20. Whenever the word
"Yes" is not found in cells A2:A20 I want to leave cell A1 blank.
<email@example.com> wrote in message
>I want to populate cell A1 with specific text (the word "Active")
> whenever the word "Yes" is found in cells A2:A20. Whenever the word
> "Yes" is not found in cells A2:A20 I want to leave cell A1 blank.
=IF(COUNTIF(A2:...Windows OS to Mac OS applications considered upgrade license?
Operating System: Mac OS X 10.5 (Leopard)
I have office 2007 for windows now and I recently switch to a macbook pro and now I want to get office 2008 for mac. Would this fall under an upgrade? Your upgrade version requirements do not explicitly mention anything about switching from one OS to another. (and no, I didn't abandon you MSFT, I still run Vista in parallels but I don't want to run office in parallels)
On 4/18/08 4:03 PM, in article firstname.lastname@example.orgR9absDaxw,
"email@example.com" <firstname.lastname@example.org> wrote:
> Operati...NDR in 2 Exchange Servers 2003 on 2 domains
2 Exchange servers 2003. 2 domains. a.fr and b.fr. The Active Directory
domain is xxx.local.
Each domain is hosted on a distinct server, on the same Exchange
organization. When an email arrives from outside the non delivery receipt is
sent from email@example.com. As almost every MTA now is checking if the
'from' belongs to a valid domain, this does not work.
It is possible to change the NDR originator to firstname.lastname@example.org or
email@example.com. But this is valid for the whole organisation. And I need
the a.fr server to answer with firstname.lastname@example.org and the b.fr server answer
from po...Windows Mail on 2 computers
Is it possible to run the same e-mail account in Windows Mail on 2 computers
and synchronise the two? I use Vista Home Premium on a desktop and laptop
which are networked wirelessly through a Netgear router. Any ideas gratefully
You can setup the account on both computers and under Tools | Accounts |
Mail | Properties | Advanced set both to leave a copy of the messages on the
server so both will receive all the messages and set one computer to delete
them after a few days to ensure your mailbox on the server doesn't fill up.
Then you will have the received emails...Data validation, cell protection or other method?
I have used data validation to set parameters for valid data entry and I have
also used cell protection to prevent any type of data entry. What I am trying
to do in this instance is to prevent data entry but, instead of the standard
message that pops up when using cell protection, I want to display a
customized message such as:
Data for these fields must be entered in "Project Assumptions"
Can Data validation be used to prevent data entry of any kind or do I need
to look for a VBA solution?
Say you want A1:A10 to be restricted.
Select the range, A1:A10, then in Data Valida...Autoarchiving #2
Our company has windows 2000, we have emails that after
seven days are no longer needed, I have all the folders
archiving features set to how we want, but is there any
way for Outlook to "auto"archive without closing and
starting up outlook or going to File: archive? It would
be great to not have to do either since we do not shut
down the machine. Please post any answers or suggestions.
You should be able to set Outlook to AutoArchive every day, or however often
you like (1 day is the minimum)...this would be done through the global AA
settings in Tools | Options |...Calculating Taxes and Making calculations
Kindly plz tell me how do i go about making some small calculations
based on my existing data such as how to compute taxes and do other
calculations based on some quantitative data.
where exactly do i make modifications on my application???
Kindly help me out.
example might be a dropdown which has shipping options ie ups, fedex etc.
When you choose one it takes the weight of your package (whcih you enter)
then calculates a shipping cost.
search the archives of this group at groups.google.com and ...Move data from one server to another
We are trying to move some databases from a set of old servers to a new
servers and they are pretty large.. like around 100 databases and around
They are all SAN connected and I believe SAN based replication from one SAN
volume to a new SAN volume connected to the other server might be faster..
but I don't think SAN based replication works at a file level..
As an example, I may have 4 databases on one server and 2 of these databases
may move to NewServer1 and the other 2 to NewServer2... Backup and restore
may take forever.. Any other way to speed up these moves...Code To Insert Blank Rows
I have a file with a listing of entries, and in column B of all the entries,
are unique names. I need to create the code to reference the listing, which
at times will be 200 entries and other times 1000 entries, and evaluate the
data in column B, to then insert 2 blank rows every time a different name
appears. For instance
Initially column B has
(Row 1) Pears
After the desired code, the results would be..
(Row 1) Pears
(4) Blank Row
(5) Blank Row
(7) Blank Row
(8) Blank Row
(9) Grap...Reformat data to vertical format
Here is what I am trying to do.
I have about a thousand records that I need in a vertical format with
normal shared field name. Any suggestions
Psydwaze's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2437
View this thread: http://www.excelforum.com/showthread.php?threadid=37965
Creating a Spreadsheet from Database data (#dbdata)
http://www.mvps.org/dmcritchie/excel/snakecol.htm...I get the white box when inserting pictures in publisher xp?
I work at a school and we are having problems with the MS publisher not
showing pictures when we insert them. We have windows xp Pro installed with
Service pack 2. We would insert the picture on a blank document and then a
white box comes up, but no picture. What is the solution to this? On our
older machines it works OK with service pack 2.
View, pictures, detailed display...
Mary Sauer MSFT MVP
"donduck74" <email@example.com> wrote in message
news:F4234C22-F0A4-4...Interactive Chart Data?
Is it possible to select a group of data on a graph/cross-plot and then
"zoom" to or "highlight" that data in the spreadsheet? I hope it's possible
and I am just not smart enough to figure it out. Thanks for your time.
I believe what you are asking would be somewhat complicated to do and
require writing code.
You might try one of these options instead:
1- If your chart is on a separate Chart Sheet, rt-click the white space
(Chart Area) and choose Chart Options. On the Data Table tab put a check in
the box for Show Data Table to have a copy o...How to limit insertion of records
I have two tables as follows:
TABLE1: (BUSINESS TYPE)
Business Type (With a lookup choice like: Individual, Partnership, Company)
Business Type (Looked up from Table1)
I want the Table2 based subform, to allow only a SINGLE record to be entered
if an INDIVIDUAL business type is selected in the Table1 based main form,
Maximum of SEVEN records if PARTNERSHIP business type is selected in the
Table1 based main form, and UNLIMITED records if COMPANY business type is
selected in the Table1 based main form.
Any guidance shall be highl...OWA Attachments #2
Exchange 2003 SP1, Windows Server 2003
When users are using OWA externally I want them to be able to open any
attachments, but block them from being able to send attachments.
Is this possible? if so what is needed.
...entering data in excel invoices
...How to calculate age of a person?
I'm struggling to figure this one out. I have a date column and I'd like to
be able to calculate the age without doing it in my head.
I've tried to do this but am struggling.
Any help will greatly appreciated.
Visit www.cpearson.com and search for DATEDIFF
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"Grd" <Grd@discussions.microsoft.com> wrote in message
> I'm struggling to figure this one out. I have...EXCEL 2007 Formula to calculate INTEREST only on a 3 month bridge
I am trying to calculate monthly INTEREST ONLY payment on a short term
bridge/swing loan. Assuming an interest rate of 2.75%, paid monthly, Also
assuming it will be required for a 3-6 month period, amount approx $500,000.
Just switched to Excel 2007 but don't seem to be able to calculate using the
formula builder. Not sure if it is compounded daily or monthly.
You might want to check out the IPMT function. From the XL help file:
Rate is the interest rate per period.
Per is the period for which you want to find the interest and must...Due Date Calculated
I need assistance on an expression that allows for the due date of recurring
training to be one year from date completed. Details are as follows:
I have a form named [frmTRNComplete] based on table named [tblTRNComplete]
Form controls are: TRNID (combo box), DateComp (Text Box) , DateNext (text
box), Reccuring (check box)
I would like the DateNext to be 1 year from DateComp if Reccuring is true
and Date next to be blank if Reccuring is false.
I'll assume that you want to use the form to calculate the DateNext, and
that you are not trying to s...how to calculate outliers
Google is your friend:
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"ismhs" <firstname.lastname@example.org> wrote in message
...Filter data into separate worksheet
I'm in the process of trying to make a spreadsheet for work but I'm
just clueless... excel is not my area of expertise! :)
The original spreadsheet has 10 columns with various pieces of
information... column D is what is important to me... column D has 5
choices for "reasons"... I want the main tab to remain untouched but
in the other 5 tabs of the spreadsheet, I want the different "choices"
to then filter into the other tabs...
For example - the choices include "Coverage" "Equipment" "Customer
Service", etc... I want the tab entitled...Calculated field options???
Here's my Data:
In my pivot table, 'Country' is an item, and 'Status' is my only data field.
What I really need to show in my data area is two column of data, one for
'Green' and one for 'Blue'. I tried creating two 'Calculated' fields with
the following formulas, but they don't seem to be working:
'CalculatedField1' = IF((STATUS="Green"),1,0)
how can I format several dates such as 04/19/2003, 04/01/2004, etc. int
a yearly average for the employee tenure
Message posted from http://www.ExcelForum.com
right now say I have my yearly figures in i1-i9. The formula I though
would work is
=today()-average(i1:i9), but how would i format this to give me
yearly read out
Message posted from http://www.ExcelForum.com
One way is to use YEARFRAC with a third argument of 1 to get your
tenures in years and fractions of a year and then average the result.
However YEARFRAC does produce some annoying but small errors.