Dynamics upgrade version 8.0 to version 9.0
I am attempting to upgrade one of my clients from version 8 to version 9. I
am setting up a test environment for them to get around in so they can play
before we put version 9.0 into production. I get almost all the way through
the upgrade when the following sql error statement is populated "The
following SQL statement produced an error:
CREATE PROCEDURE uprGetNextTrxHistID @outNEXTRECNUM NUMERIC(14,5) OUTPUT,
@O_iErrorState INT OUTPUT AS DECLARE @tmpNEXTRECNUM NUMERIC(14,5), @IOError
integer SELECT @outNEXTRECNUM = ISNULL(MAX(CMRECNUM)+ 1, 1) FROM UPR30300
SELECT @tmpNEXTRECN...Want to modify this procedure to have a range of periods rather than a single period
This is a multi-part message in MIME format.
I have the procedure below
I want simply modify the periods procedure below to be -- perpost >=3D =
'201001' and <=3D '201012' so I want a range of periods rather than a =
single period as in the example below
I would really appreciate it if someone can help me out on this.
Declare @perpost nvarchar(8)
/* Do not edit Above=20
...dynamic object creation
How can i dynamicly create and display a subclassed object on a formview,
(i.e. the object is not shown in the resource editor) ?
Does anyone know how to delete names that are suggested
when addressing an email?
Remove individual addresses from the autocompletion cache by highlighting
the entry when presented in the suggested names list (use your arrow key to
migrate to the entry) and then hitting your Delete key before you tab out of
the field. To clear the entire cache, follow the instructions here:
"firstname.lastname@example.org" <email@example.com> wrote in
message news:1322701c3f736$fd90d...Download Payee names include date
My transaction downloads with payee info include dates so
the software doesn't recognise the payee and therefore
does not automatically assign the category. How can I fix
In microsoft.public.money, Joe wrote:
>My transaction downloads with payee info include dates so
>the software doesn't recognise the payee and therefore
>does not automatically assign the category. How can I fix
>In microsoft.public.money, Joe wrote:
>>My transaction downloads with payee info include dates
>>the sof...Moving Exchange to different server, different name
Can someone point me in the right direction if a KB article exists? I have read the article about moving to a different server SAME name, but that is not quite what I am doing. I want to move to a new server, different name. I assume that I will install same version of exchange on new server, move mailboxes, public folders, everything over to new server. Then follow the MS KB article about removing the first exchange server from your domain
Basically install another server and move everything over. ie move
mailboxes and replicate public folders. Rehome them if it is 5.5 moving to
A suggestion which a number of customers always ask for (and from another
development background I can clearly understand why.)
Scenario; you have an Account field on the form along with a Contact field
(with whatever field labels are appropriate.) The user selects an Account and
(due to the nature of the data) want to select a Contact, but a contact that
is related to the Account (as it’s parent.) i.e. they only want to be able to
choose contacts for that Account and not any of the others. This currently
isn’t possible – you are able to pick any contact (which I can understand
why, bu...Simple Question............Deleting "Name Box" name!
Say you have a range named "ABC" in Name Box. How do you delete it?
XL prior 2007:
Insert>Name>Define> PICK YOUR NAME > Delete
On 4 Dec, 14:58, Mike <mas_it_2...@yahoo.com> wrote:
> Say you have a range named "ABC" in Name Box. How do you delete it?
...Function for transforming long file name in 8.3 format
I hope not being OT here. I have a long list of names of files in a
column (obtained with JDirPrinter utility). I would like to sort the
column in ascending 8.3 DOS format name.
That is, I need to create or use a function that takes as input a long
file name as string, and outputs a short 8.3 file name.
Is it possible?
Thanks a lot
Ciao from Italy
> outputs a short 8.3 file name.
Hi. Here's one way:
Function ShortName(sFilePath As String) As String
'// VBA Library Reference: Microsoft Scripting Runtime
Set fso = CreateObject("Scriptin...Changing Name Range
I am importing Excel lists to my contacts in outlook 2003 and hav
experienced MANY problems, the worst of which is that Excel won't le
me change the Name Range in the lists and therefore I can't import th
list properly. No matter how often I delete and retype the new name
it returns to the old name. Please help, I would really appreciate it
kas's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1521
View this thread: http://www.excelforum.com/showthread.php?threadid=26878
Hi K...Need to change the name that appears when inserting comments?
is there a way to change the name that appears when it comes to inserting
comments into excel.?
the product is licensed to our company, but this is the name that appears
when inserting comments, and not the user who is inserting them.
When a comment is inserted in a cell, the inserter's name is stored in two
1. in the body of the comment
2. in the status bar message that appears when you mouse-over the comment
Excel uses the Username, not the logon name. To set the Username:
Tools > Options > General > Username
Gary''s Student - gsnu200...Named Reference
Can someone tell me what the pros and cons are (if any) of these 2 ways
of naming a range.
ActiveWorkbook.Names.Add NAME:="HOME", RefersTo:=ActiveCell
Dim HOME As Range
Set HOME = ActiveCell
It seems to me that the first method creates a named range that is
essentially meaningless to the user and is only used for VBA processing.
Additionally, if you don't write code to delete the named range it will just
sit there in the workbook waiting for somebody to ask what it means.
The second alternative is a clea...naming cells #2
I have done it both ways before entering formula and after, also i
have created a name with the title and defined a name without the
title, please help
...Same Account Name in Org
Any help would be appreciated. I have two issues which I need
Two exchange servers operating Exchange 2003 SP1 in Native Mode, on
Windows 2003 Standard (no SP1), residing in a Windows 2003 mixed
domain. Exchange org supports two domains (@domainA.com and
a. users in domainA connect to Exchange via Outlook using default
b. users in domainB connect to Exchange using POP
if userid (JDoe@domainA.com) is created, he has no issues connecting to
Exchange. However, userid (JDoe@domainB.com) is created, he cannot
connect to Exch...Inserting file name and path
I have some Publisher documents that I've been asked to include their file
name and path.
Is there a way to do this (like you can with Word), or do I have to type
these in manually?
You could find the file in its folder, right-click, properties, high-light the
path (location), copy ctrl+c, paste it into the document.
Mary Sauer MSFT MVP
"Glenda" <Glenda@discussions.microsoft.com> wrote in message
>I have s...Field Name printing
I am trying to print my contacts in "card style" but I don't want the
"Field Names" to print. Can this be done? Can I rename them to
something shorter so that it all fits in the small box for each
You can neither rename field names nor suppress their printing. For more =
control over the printout, consider using the Tools | Mail Merge command =
to merge the data to a Word document.=20
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outl...Preventing a user name in comments
Excel Comments always include an author name, in bold. Is there any way to
prevent this happening so as to avoid the necessity of manually removing the
author name / bold formatting every time a comment is added?
See Debra Dalglesh's suggestions at:
"Gabriel" <Gabriel@discussions.microsoft.com> wrote in message
> Excel Comments always include an author name, in bold. Is there any way to
> prevent this happening so a...show month number as month name in Excel?
I'm trying to format a field in an Excel Spreadsheet in such a way that it
displays a month name rather than a month number.
For Example, if a cell contains 8, I want the cell to show as August.
Conditional formatting only allows me 3 levels of condtions and isn't
I don't think you're gonna be able to use formatting for this.
But you could use a helper cell:
if A1 contained the month number.
Format this cell as MMMM
and you can keep the value as a real date.
If you want the text string fo...Mail server name
I have to migrate from Exchange 2000 (on windows 2000 server) to Exchange
2003 (windows 2003 server).
The new server has a differente name from the older.
The problem is that I have to change, in each client, the mail server name
Is there a way to update the Otlook client with the new server name ?
There's a tool available from MS, you can find it here:
hope it helps!
"Rod" <firstname.lastname@example.org> wrote in message ...Dynamic.txt
What is Dynamic.txt in custamization of Great plains
It shows any references to missing objects.
Charles Allen, MVP
> What is Dynamic.txt in custamization of Great plains
...Sheet Tab name
Is there a way to link the name of the sheet tab with a cell? I jus
want to put a text value in a certain cell and the sheet tab name woul
show that text value.
Thanks in advance
Message posted from http://www.ExcelForum.com
you can put this kind of code in your worksheet_change
event (of your worksheet module). e.g. try the following
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Intersect(Target, Me.Range("A1")) Is Nothing Then Exit
On Error GoTo errhandler
Application.EnableEvents = False
Me.Name = Target.Value
Application.EnableEvent...dynamic summing of an autofilter 'ed table
I have a very large table. I have placed and autofilter at the top of the
Just below the table I have a placed a formula that says =SUM(F5:F760) and
it sums up column F.
Now if I use the autofilter to filter out some of the rows I'd like the sum
function to recognize this and sum only the rows that pass through the
filter. This doesn't seem to work. How do I do this? Thanks!
have a look in HELP index for SUBTOTAL
"john boy" <john email@example.com> wrote in message
How can I exploit runtime creation in my app
After this how do I go ahead and create the object and get a pointer to
my CMyClass object.
I have used DECLARE_DYNCREATE etc etc.
"chilly" <firstname.lastname@example.org> wrote in message
> How can I exploit runtime creation in my app
> For Ex:-
> CRuntimeClass *pRt;
> After this how do I go ahead and create the object and get a point...reference workbook name in cell
Given: XL2002 Win XP
I have a workbook name DTS-351-Jan.xls and I would like to have cell
N3 in worksheet Main extract the 351 from the wb name so that N3 would
say 351. Is it possible and if so how? I will have other workbooks
that i would like to use the same formula in so it would be important
that the formula not conatain an absolute reference to 351.
On Sat, 09 Aug 2003 23:21:13 -0400, Dave Potter
>Given: XL2002 Win XP
>I have a workbook name DTS-351-Jan.xls and I would like to have cell
>N3 in worksheet Main extract th...Changed the user logon name and know can't mail him anymore
I have exc2003STD and outlook 2003. It was requested that the logon username
of one specific user changed from membercare to ABC membercare. My
technician went to the exchange box > went to AD > Open the membercare users
properties > Account tab > Change the account logon name there from
Membercare to ABC Membercare. He said that is the only thing he changed. Now
in the GAL is displayed ABC Membercare (i think he changed the display name
also but that's not a issue). My problem is now if i mail that user i get
the following error (Please help me to fix this as ma...