Dynamics 10 Upgrade fails "product 949 does not support upgrading
I have installed new instance of Dynamics 10 with latest service pack (new
folder). I ran utilities and before I even get a chance to upgrade the data,
I receive and errors "Product 949 does not support upgrading from version
We have version 9.0 running fine with Field Service in the set file so why
won't it upgrade?? We only use a small part of field service (historical
lookups in SOP) so I can't just drop it. Since it's a self-installed module
by default, how can it not upgrade???
I believe you have to be at least on 9.0.281 version of GP.
I am no...Check current cell is empty
I'm getting stuck...
If I enter some new data in Sheet2, column A, then this cell will be copied
to last cell of sheet 1 columnA automatically. This task can be done now
IF the data is overwriting some existing data, no need to copy.
my logic is
if the active cell is empty, and the target column is 1, then do the copy
else, do nothing
The question is: how can I check the current cell is empty?
Thank you in Advance
If IsEmpty(ActiveCell) Then
MsgBox "Activecell Is Empty"
MsgBox "Activecell Is Not Empty&quo...Lookup based on criteria in 2 columns
I am trying to use a vlookup or other function to return the value in the
amount column based on the location and date. Here is a sample of my data:
Location Date Amount
101 9/15/8 10
101 9/16/8 20
101 9/17/8 15
102 9/15/8 50
102 9/16/8 75
102 9/17/8 67
For example if I wanted to return the amount for location 102 on 9/15/8,
what formula would I use? I tried using variations of vlookups but had no
Peo Sjo...Standard MFC controls behave different when showing polish characters
I have a rather simple to describe but difficult to solve problem.
Our customers want to use our ANSI MFC program to show different
For example Polish.
When I set the font for the different controls they behave different.
For example the CEdit shows the polish characters just right but the
CButton with checkbox style shows glyphs instead of the special
Every control that is owner draw and uses for example the DrawText()
function of the device context shows the characters right.
I've experimented with _UNICODE for the display part and everything I
could ...Inserting form values into a table
We have a form with values taken from an sql query that comes from two
different tables. We would like to enter the information into a third table.
Can some one direct me to code that will do the following:
1. Provide the Insert sql that shows us how to add the form values to the
2. Show us how to loop while inserting the information into the table (there
could be several lines on the form, each must be inserted one at a time).
I have worked with Access before and have never had a problem inserting
information. However, I cannot quite figure out how to insert informtion
through an ...Rollup 2 and Office 2007
I already have Roll Up 1 and the Office 2007 compatibility patch installed.
If I now install roll up 2 will I have to reinstall the office 2007
MS CRM Certified Professional
Chat with me on MSN / Gmail / Skype : ID Is :.. firstname.lastname@example.org
> I already have Roll Up 1 and the Office 2007 compatibility patch installed.
> If I now install roll up 2 will I have to reinstall the office 2007
...Microsoft POS #2
I have a group of customers that I am working on setting up A bundled POS
I have looked at RMS and Microsoft POS. The customer's are small bulk food
stores. They package all of the bulk food in various containers and weigh it
with a Hobart scale producing a label with an system 2 price enbedded
barcode. These are UPC A formats. They are for the most part simple single
store installs and donot require the complex RMS system.
I have setup the Microsoft POS version 2.0 and found it will work perfect
for these customers. The only problem when you programed the system you
l...Outlook 2003 keeps crashing #2
I get this message when I look in System information. Outlook keeps
crashing quite often. I cannot for example delete two messages without
outlook crashing. My colleagues do not have this problem. We are using
the Microsoft mail exhange server.
Faulting application outlook.exe, version 11.0.5510.0, stamp 3f1380f0,
faulting module mso.dll, version 11.0.5606.0, stamp 3f334cce, debug? 0,
fault address 0x003b6e16.
Does anyone has a solution?=20
1) I would definitely apply Service Pack 2for Office 2003 + applicable
critical security updates.
2) Have you tried starting O...move cell contents
Is there a way to move a cell contents to another cell with a formula. ex:
if a5="Name" then move g5 to j5? Also, I am using
=INDEX(Sheet1!B3:B12,INT((RAND()*10)+1),1) to pick random names from a list.
I have the formula in different place pick random names from different list.
This does work, but I have different list with some of the same names and
with the random pick I do not want the same name to appear.
Thanks for any and all help.
a formula can only affect the cell it is in, it can't move or change another
cell for this you need some code ...Excel 2007
When I select cells to copy as a picture in Excel 2007, the resolution is
terrible. Text and objects with shadow's are very blotchy when pasting the
How do you change the resolution of a 'Copy Picture'?
...visible cell only
I'd like to use the PERCENTILE function in a list that has been autofiltered
and get the results based only on the visible cells.
I've used SUBTOTAL in order to get count, average, min and max. But I need
to get the .25 and .75 percentile figures for the filtered data (visible
I've scoured these forums. I've scoured the web. I've found some vba code
that was supposed to select only visible cells but it doesn't work for me. I
posted last week in the programming section of these forums (and again this
morning) but got no reply. I figure...worksheet tabs 01-06-10
In the 2003 excel-- Is there a way to have the worksheet tabs automatically
go in alphabetical order-- or do you have to do in manually?
Use this code:
Dim iCount As Integer
Application.ScreenUpdating = False
iCount = Sheets.Count
For i = 1 To iCount - 1
For j = i + 1 To iCount
If Sheets(j).Name < Sheets(i).Name Then
> In the 2003 excel-- Is there a way to have the worksheet tabs automatically
...Using part of a cell in a chart title
I have a chart which should get a title. However, this should be partly be
used from a cell e.g.
"counted with 5%"
5% should be taken from the cell and used in the title.
Is this possible?
Yes it's possible but all of the chart title needs to be in the cell. So you
may need to use a helper cell and concatenate text and value.
Andy Pope, Microsoft MVP - Excel
"Nicole" <Nicole@discussions.microsoft.com> wrote in message
news:5CB7A971-AA7F-4C34-BB42-7DC283AA2958@micro...Adding Industry Codes
I am picking up the pieces on a previous installation of CRM, and want to add additional industries to my industry dropdown in the Lead form. For the life of me, I can't find the proper table in the database. Can someone be good enough to point me in the right direction?
You don't do this via a table, you need to do it via form customization.
You will need system admin rights, then go into System Customization and
modify the Lead form. After making the changes, you will need to publish
the change via Deployment Manager and issue an IISRESET.
"Chris...adding name /creating field/query?
I can create an invoice_number field in a query using the primary
field ID from the main table as
but if ID say is 100, I cannot work out how to create
We aren't there. We can't see what you're looking at.
Where did "renewal_invoice_100" come from and what does it mean?
Please post the SQL statement of the query you are trying to use.
Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor
http://micro...what's the formula for adding symbols in cells?
I have a chart that has blank info in the legend. I want
to add an * to indicate something, but just inserting a
symbol doesn't work. Any ideas? Thanks.
To add information to the legend, you need to add to a series name.
Right click on the chart, select Source Data from the pop up menu, click
on the series tab, select a series, and either type something in the
name box, or click in it and select a cell with the mouse.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
> I have a chart tha...How do I merge cells with multiple data values?
I've tried highlighting the two cells which are in the same row. It
suggested that I format and align. Both of which I've tried. I keep getting
the same error message, "The selection contains multiple data values. Merging
into one cell will keep the upper-most data only." I need to make the cells
one with all my information. Is this possible?
Not knowing what you want to do, let me make a suggestion. Put all your
data into the first cell and leave the second cell empty. Select both
cells. Click on Format - Cells - Alignment tab. In the "Horizontal" b...outputting values to a range from one formula
I wish to generate a table automatically by means of a single
formula that applies an iteration on a starting given value with
a given step, and the computed values are posted/entered
automtically into cells from a given cell onwards, say below
it, until the computed value reaches a certain given limt.
This is somehow the inverse of INDIRECT or of OFFSET. These
can pull values from a variable addresses of cells. What I need
is to push values into a variable addresses of cells.
Can anyone help me on that??
---------------------------------------------------------...Please ignore #2
Testing a posting problem
...2 register ruinning together on one z report
Is this possible, to have two registers running on one z report ?
We have a small store and would like to setup a second register as a backup,
temporary addition ( during rush hours)
Since we are a small show i do not need to have a separate register reports.
Can two registers ring up all sales together as one ?
How can i set this up ?
No, you can't do that.
You might be able to use the Register Analysis report available in SO
Manager Utilities/Crystal Reports to get something close to a single Z
Tiber Creek Consulting
email@example.com...Can you only merge up to a certain number of cells
I am working on microsoft excel 2003, I have a sheet that I merged cells
starting with line 8 through 43...when I type my information in the merged
area I can see all that I am typing...say it goes up to line 30 once I hit
the enter key I can only see up to line 20. Even when I print it out it only
prints up to line 20...I have checked to make sure there are not locked cells
etc. I cannot figure out at all why this is happening...is there only up to
a certain number of cells you can merge?
From "Excel Specifications and Limits"
Length of cell contents (text) ...matching contents #2
E1 thru E10 contains sequentially-sorted data. B1 thru B6 contains
sequentially-sorted data which matches SOME (but not ALL) of the data
in Col A. For example.
1 1 1
2 3 2
3 4 3
4 5 4
5 6 5
6 10 6
I need to move the data in the cells in Col B next to the cells in
Col E that have the same contents. For example:
1 1 1
3 3 3
4 4 4
5 5 5
6 6 6
10 10 10
Besides dr...Workbook_Open Help #2
Here's the code
Private Sub Workbook_Open()
Call Unhide_Sheets '
Fable's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=218
View this thread: http://www.excelforum.com/showthread.php?threadid=26252
and there's no application.screenupdating=false statement in your
"Fable" <Fable.1d07w...Sum column values that contains text &/or dates
Column D3 thru D43 contain a mixture of values & dates. For example:
D3 = 16,026.76
D4 = 11-18-05
D5 = blank
D6 = 6,855.34
D8 = blank
D9 = 5,270.00
D10 = 11-02-05
Need sum to equal 28,152.10 (total only values from entry or formulas)
Thanks so much. mikeburg
mikeburg's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24581
View this thread: http://www.excelforum.com/showthread.php?threadid=489114
If your dates are text strings which say "11-18-05"...Outlook Express 5 #2
On loading, error message "MSIMN caused an invalid page
fault in module DIRECTDB.dll at 017f:7dbf3070.." Appeared
to coincide with display config change?
Ask in an Outlook Express forum. This is an Microsoft Office Outlook forum.
Outlook Express is family of Internet Explorer and Outlook of the Office
Here is the link for the right forum
Microsoft Office and Microsoft Office related News
Also Outlook FAQ, How To's, Downloads and more...