Lost Active Directory for Microsoft CRM 3.0
Hi, We recently had a server failure on our Domain Controller which was
unrecoverable and our backups for active directory failed to restore.
The CRM database and application are on a seperate server so is fully
intact. But we have lost the AD, which means no access.
My question is what is the best method if any to recover the CRM system?
I was hoping in version 3.0 this is possible as i know 1.2 was a nightmare
due to the security descriptors.
Am i able to reinstall and attach to existing database and apply CRM
You're in luck, this shouldn'...Showing 0 after decimal with ROUND
I'm using the ROUND function like this:
=ROUND(C29*(92%),1) &- ROUND(C29*(108%),1)
Unfortunately, if the numeral after the decimal is a 0, then it doesn't
display. How can I force a 0 to display after the decimal?
Format the cell as Number with 1 decimal place - it would appear to be
formatted as General.
Hope this helps.
On Dec 4, 1:44=A0pm, Libby <Li...@discussions.microsoft.com> wrote:
> I'm using the ROUND function like this:
> =3DROUND(C29*(92%),1) &- ROUND(C29*(108%),1)
> Unfortuna...Date display in Excel
Format column of cells as Date, display as mm/dd/yy. Date
entered into cell, shows up correctly in the text entry
field at the top of the screen, but the data on the
worksheet displays as "33747", or similar number. Only
happening on one workbook.
Try tools|options|View tab|uncheck Formulas.
> Format column of cells as Date, display as mm/dd/yy. Date
> entered into cell, shows up correctly in the text entry
> field at the top of the screen, but the data on the
> worksheet displays as "33747", or similar number. Only
> happening on one...Multiple domains on one Exchange server / All but one domain shows up as spam #2
I am sorry if this is on the board somewhere but I have been searching
forever and havn't found a hint yet.
I have multiple domains setup on my exchange server. Lets say abc.com,
def.com, and hij.com. We only send email with @abc.com but can receive
from any domain name. Recently we merged with another company and we
brought back their email to our server, lets say xyz.com. Now I
configured a new recipient on Exchange 2003, so I now have two
policies. The first policy has the three original domains in it with
@abc.com as the primary domain. In the second policy I have configured
xyz.com t...VB Macro #2
I have a macro that is generating Excel files. When the macro runs, it saves
two different tabs in the workbooks as values. It needs to test and wait
until the formulas that are pulling amounts from another database are
correctly populated with the amounts.
Right now, I am getting N/A# instead of amounts for some, but not all, of
the files. I think the problem is that the formulas have not completed
pulling the amounts before the macro pastes that tab as zeros. (N/A# is what
appears when the formulas have not completed calculating - once they have
completed, the N/A# is replaced ...Displaying Scenarios
I have set up a number of scenarios on a worksheet as they
relate to different versions of my budget. Rather than
having to go in everytime and display each one
individuall, I would like to enter a parameter in one cell
that will automatically display the right scenarios.
Hopefully, using a conditional statement of some kind.
Any help would be greatly appreciated.
Jet Moulding Compounds Inc.
Ajax, Ontario, Canada
How about a worksheet_change event?
I created a couple of custom views and then rightclicked on the worksheet tab
that held the important cell. ...VCR to DVD Part 2
Many thanks for previous answers.
Yes, finalizing the DVD worked
I found that DVD-R need finalizing but DVD+RW disks do not
But why was I able to play the unfinalized DVD-R on one machine and not on
What was special about the first PC?
Bernard Liengme wrote:
> Yes, finalizing the DVD worked
> I found that DVD-R need finalizing but DVD+RW disks do not
> But why was I able to play the unfinalized DVD-R on one machine and not on
> two others.
> What was special about the first PC?
Almost anything will play a finalised D...cell contents revert to 0 when i click on the next cell
I put a number into a cell click on the next cell and the first cell reverts
to 0. If I format to number with 2 decimal places it will be ok but when I
try to take out decimal places it goes back to zero,
You haven't said what number you are trying to put into the cell, but I
suspect that the number is less than 0.5.
A quick test shows that if you set the cell to no decimal places then enter
a number less than 0.5 it is displayed 'rounded down' so it will show as
zero, if it's 0.5 or above it displays as 1.
If you need to put numbers less than 0.5 into youe c...set print area #2
Where is the "set print area" button in Excel 2002 that was in Excel '97?
> Where is the "set print area" button in Excel 2002 that was in Excel '97?
Are you sure it was "standard"? Only way I could get in was to right-click
the toolbar|Customise and drag it to the toolbar from Commands|File
...Upgrading from Money 99 to 2004
Is it worth upgrading from Money 99 to Money 2004. I
have several years of complete financial data in my Money
99 program. Just wondering if it is worth the cost and
hassel to upgrade. Is the upgrade path (conversion) from
Money 99 to Money 2004 pretty easy.
Thanks in advance for any replys and help.
Well, your mileage may vary on it. Some people like 2004, others don't. I'd
always recommend the trial before you buy though. You can get an idea of
what's in the latest version, whether it's suitable for you etc.
2004 should just convert a 99 file, assu...Does any one know of a template for purchases, business card siz
I would like to be able to have a business card size card that I can punch
the amount of purchase for my customers. After they make a certain amount of
purchases I would collect them and they would receive a discount on their
next purchase or a free item.
On Sun, 7 Mar 2010 15:54:01 -0800, captured memories <captured
>I would like to be able to have a business card size card that I can punch
>the amount of purchase for my customers. After they make a certain amount of
>purchases I would collect them and they would rece...OEM publisher 2002 Sp1-2
I have the OEM version of Publisher 2002 and cannot find the Export as web page under File. Is there a way I can get that feature with a standalone disk?
After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from Chicagogal <firstname.lastname@example.org>...
> I have the OEM version of Publisher 2002 and cannot find the Export
> as web page under File. Is there a way I can get that feature with a
> standalone disk?
The OEM version of Publisher is exactly the same as the release in every way
but the license, so the standalone version will be no differen...GP SP#2 hangs with sa and Collections Issue
I just installed 8.0 SP#2 (ran the script that it says to run cuz we had
upgraded from previous version to remove dups in smartlist tables) and when I
log into GP as sa, it hangs and CPU sits at 100%.
When I was able to log in previously to SP#2, I constantly received errors
about the CN_Collector_MAIN table with invalid column names etc. I've
deleted the table, then re-ran the create tables, but it keeps coming back
with this error. I've even gone into file > maintenance > sql and deleted
and recreated the table, but then get "number of results doesn't match ...Installed Font does not display in Word 2007
Only 6 of of 8 recently installed TTF fonts will display in Word 2007
Are the missing ones variants like Italic or Bold?
On Dec 25, 1:28=A0pm, GWHA <G...@discussions.microsoft.com> wrote:
> Only 6 of of 8 recently installed TTF fonts will display in Word 2007
...Changing ip address of exchange server #2
I have a back-end server and a smtp server in DMZ.
I want to change ip address of back-end server. are there any issues?
all incoming and outgoing emails are going via smart host.
No issues at all as long as you remember to change all the references to
this server in your firewall, SMTP scanner etc.
"Jack Dorson" <JackDorson@discussions.microsoft.com> wrote in message
> I have a back-end server and a smtp server in DMZ.
> I want to change ip address of back-end server. are ...How can I print on 8 1/2"x17" paper?
I have cut down an 11x17 paper to 8 1/2" x 17". I cannot figure out how to
change the paper size to accept and print anything bigger than 14." any
suggestions would be greatly appreciated
First make the size settings in the Printer Setup. You may need to use the
"mickilena" <email@example.com> wrote in message
>I have cut down an 11x17 paper to 8 1/2" x 17". I cannot figure out how to
> change the paper size to accept a...ANN: Optimizing the Performance of Microsoft Dynamics CRM 3.0 white paper
the White Paper "Optimizing the Performance of Microsoft Dynamics CRM
3=2E0" is now available:
...Money Updates #2
Was wondering about money updates. What exactly is the program downloading
during the update process? And if the program is updated on a daily basis,
why would I ever need to upgrade to a newer version?
In microsoft.public.money, invalid wrote:
>Was wondering about money updates. What exactly is the program downloading
>during the update process? And if the program is updated on a daily basis,
>why would I ever need to upgrade to a newer version?
It is mainly changes in online bank setup.
Despite appearances is typically does not change anywhere daily.
"invalid" <...Can't create the item #2
I use Outlook from MS Office 2003 Business Edition.
Everything has worked fine until the past few days. Now,
whenever I click on an E-mail address link inside a
webpage, I get a message from Outlook that says "Can't
create the item."
One person on this group gave me the following advice:
>Close Outlook, find and rename the frmscache.dat to .old
I did searches on all my drives and the file named above
was not found. I doubled checked the search to confirm
that it included hidden files and system folders in the
search. Still no luck.
...Does POS 2.0 support price-embedded barcodes?
Does anyone know if Microsoft Point of Sale 2.0 supports price-embedded
barcodes (also known as random weight barcodes)?
I have Digi scales that print out 12-digit barcodes with UPC and price info.
I would like to implement POS and not RMS because it is much less complex.
Thanks for any info.
POS 2.0 does not support price-embedded barcodes.
> Does anyone know if Microsoft Point of Sale 2.0 supports price-embedded
> barcodes (also known as random weight barcodes)?
> I have Digi scales that print out 12-digit barcodes with UPC and price info.
&...when opening an excel file, 2 files open (one is book1)?
When I click on an excel file, 2 excel documents open up. One document is
called Book1 and the other document is the actual document that I want to
open. How do I stop this from happening?
To prevent Book1 from opening you can append /e to your shortcut for opening
"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE" /e
Alternative to the above............
Go to Start>Settings>Folder>Options>File Types. Scroll down to MS Excel
Worksheet. Then if running Win98 OS Edit> select "Open" and Edit.
If using WinXP OS you would scroll down to...Formula to display nearest following Thursday in mm/dd/yyyy format
I have been reading and trying different suggestions here to no avail. What
I need is a formula to calculate the nearest following thursday, and display
it in mm/dd/yyyy format.
To be clear, I have a column of varying dates. I need a formula to return
the next thursday for each of those dates.
To illustrate, say I have 05/22/2010, 05/23/201, 05/24/2010, & 05/26/2010 in
cells A1 through A4. In cells B1 through B4, I would like to see 05/27/2010,
05/27/2010, 05/27/2010, & 05/27/2010 representing the following thursday.
Thank you for your help!
T...Fulfillment type orders
We have orders at the initial status (just entered) and the options to allow
delete documents and void documents are enabled on the Sales Order Type.
However, we can't get a void or delete button unless we move the fulfillment
order through the confirm process to an "Invoice" to get a Delete?
What's up with this? Very annoying.
I know it is subtle and wish there was a better way to display it, but the
Void option only applies to Invoice type IDs and not Fulfillment Order type
IDs ("Void Invoice Documents" vs. "Delete Documents"). Since both t...upgrading from Access 97 to Access 2007
I designed a database (forms, reports, et al) several years ago in Access 97
and it continues to work well. I've just received a MS Office Professional
2007 and wonder if it is time to migrate my data into the new program.
I've attempted two or three times to do this in Access 2002 and I keep
getting error messages along the line of "...corrupted file..cannot be
opened by Access 2002 (or some such message)..." The help radio button
opens up a box which suggests I do some programming in Virtual Basic to
perform my transfer task.
The easy way out, of course, is to sti...IMAP address on exchange sever #2
how can I find the IMAP address of my exchange server?