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'...[ANN] Office 11.3.8 update
A new security update just came out.
I suspect it requires 11.3.7 to install.
Anyway, time to run the Microsoft Updater or to grab it from
--- Mac:MS MVP http://www.cortig.net/wordpress/ ---
http://www.mvps.org - http://mvp.support.microsoft.com
MVPs are not MS employees - Les MVP ne travaillent pas pour MS
Remove "NoSpam" to e-mail me - Retirez "NoSpam" pour m'�crire
I just let the Microsoft AutoUpdate do its thing. The only Office...conversion #3
I am trying to upgrade from Outlook 2000 to Outlook 2003
on a new computer. When I attempt to export the data in
my email files (inbox, sent,etc.)I do not have
the "received" information exported - when mapping the
fields I am unable to map several of the email fields;
therefore, they are not exported. I have been unable to
find the normal email fields to use in my mapping. How
do I map normal email fields in an export operation? If
I do not export this information my new computer has no
idea when I received my old emails/
In the old days, the easiest way to keep all da...BackUp #3
how i can take backup of all my company emailboxes and
...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...Reporting IRA distributions
I have an IRA account with corresponding cash account. I
am trying to get the distribution from the IRA to show up
as "Retirement Income" in the Tax-Related Transactions
report. How to do it?
The distributions are handled as a transfer from the IRA
Investment cash acct to a checking account.
Thanks for any help. Money 99, BTW. Do I need to
upgrade to a later version?
...Queries and Charts
Does anyone know why the expressions in queries work fine for reports but not
...Pass parameter from FORM to QUERY
I have an append query that I trying to call from a cmd btn...but it
prompts me for the parameter(ie QuoteID)...
How do I tye it into my call:
Dim stQueName As String
stQueName = "Quote Query"
DoCmd.OpenQuery stQueName, acNormal, acEdit
On Apr 13, 12:56 pm, jlt...@hotmail.com wrote:
> I have an append query that I trying to call from a cmd btn...but it
> prompts me for the parameter(ie QuoteID)...
> How do I tye it into my call:
> Dim stQueName As String
> stQueName = "Quote Query"
> DoCmd.OpenQuery stQueName, acNormal, acEd...C# Adding Days to a Date
I have 2 objects:
objContract.activeon and objContract.expireson.
I am trying to add 364 days to objContract.activeon and assign it to the value
// Contract Start Date
DateTime dt = DateTime.Now;
objContract.activeon = new CrmDateTime();
int iFound = 0;
string sTemp = "";
if (objAccount.paymenttermscode.Value == 1) // due on receipt - use Todays
objContract.activeon = objInvoice.CFDinvoicedate;
else // ...Separating Date and Time in a cell
I have a column of cells in the format "11/01/02 06:21". I would like to
separate the text into 2 cells - one with the date and the other with
the time. My attempts with LEFT and RIGHT have been unsuccesful. Thanks
for your help
Message posted from http://www.ExcelForum.com/
For the date use
replace A1 with the first cell of your range
you probably have to reformat the first to
mm/dd/yy (or whatever the setting is)
Note that you can do this by just using format but if you want to compare to
other cells with just pure d...Changing query execution sequence
I got a spreadsheet which would execute a bunch of queries. It's noted that
the queries are executing in the sequence of when it was added to the
spreadsheet. Does anyone out there know of a way to switch the order without
deleting and recreating them?
...3 Levels in Extended Pricing
Is it possible in Extended Pricing to have 3 levels of discounts. I assume
yes because the max level in price trace is 3.
I set up my Base Price Book to be all my List Prices.
I then set up another price book and set it to be 50% of Base (Dealer Pricing)
and then I want another price book to be "10% off of Dealer"
I would then assign customers to this special price sheet/book.
So doing a price trace I would have:
Dealer Original $100 Percent off 50% Unit Price $50
Special Original: $50 Percent off 10% Unit Price $45
Under my "Price Sheet Detail Maintenance...Report Can Grow not aligned horizontally
I have a report where I have 1 row of text, memo, number, and date fields.
The memo field can contain up to 4-5 lines of wrapped text. I have set all
teh rows to "can grow". However, on my report, the conditional formatting
For instance, the fill (which I have set to a gray color) in the memo field
is about 3 lines deep when there is a lot of text in the memo field, but the
text and number fields associated with that record are actually only 1 line.
This essentially looks like a mess, small gray filled boxes for the text
fields and a large gray ...date function #3
This is a multi-part message in MIME format.
I have a cell A1 with date 5/2/07. If in cell A2 I do month(A1), I get =
5. Is there a way to return May instead? either through a command or =
formatting? I can reference cell A2 with the 5 with a if(cell =3D 5, =
"May", ) in cell A3, but the date in cell A1 varies from Jan to Dec and =
the 12 embedded if's in cell A3 are too long (that is the error I get =
when trying to do so), plus i...Custom reports #3
I want to pull a report on how many customers I am getting
every hour of the day. Does anyone out there know how to
do that? I can try writing a query if someone can tell me
which table I can find this information in (timestamp,
transaction etc). Any help is appreciated.
This info is given at the end of the Z report.
If you want to use it in a query open the Z report
recipt file using the Notepad and see the fields that
are used... Report.Hour.HourSales etc...
Hope this helps...
> I want to pull a report on how many cust...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:
...multiple iterations of same query
Running Access 2003 on Vista.
I have a query that chooses 15 records at random. This works fine.
What I want to do is run the same query for approx 110 different users, each
with their own randomly selected 15 records. Obviously, I want to avoid
manually running the same query that many times. How can I get around this?
Post your query SQL.
Build a little, test a little.
> Running Access 2003 on Vista.
> I have a query that chooses 15 records at random. This works fine.
> What I want to do is run the same query fo...how to run onhand value report
I get the message enter parameter when entering the zoom feature
On Sat, 6 Mar 2010 17:36:01 -0800, junebugg
>I get the message enter parameter when entering the zoom feature
You'll have to give us some more context than that, junebugg. What's the
"onhand value report"? What's the "zoom feature"?
You can see your database; we cannot!
John W. Vinson [MVP]
...how do I change date format in the header in Excel XP ?
I need to chage my date format, in the header to Day; Month DD, YYYY
ie. Saturday; May 23, 2005.
Woudl you please help me out ?
Check this out.
but change the format to "dddd, MMMM dd, yyyy"
"Hesam" <Hesam@discussions.microsoft.com> wrote in message
> I need to chage my date format, in the header to Day; Month DD, YYYY
> ie. Saturday; May 23, 2005.
> Woudl you please help me out ?
> Thank you.
&g...cannot send e-mail #3
I am getting the following message:
message from Outlook 2000, you may receive the following
error message: 0X800CCC78 error: The message could not be
sent because the server rejected the sender's e-mail
It gradually has disabled all of my 3 accounts on Outlook.
I can send, but not receive. I think there is some
software corruption or a virus.
Deleting and re-creating the account does not work
Mario D'Avirro <email@example.com> wrote:
> I am getting the following message:
> message from Outlook 2000, you may receive the following
> error mes...Report: Cell #1, Cell #2, Cell #3, Cell #4
I am stuck again and would love som help :(
I would like to repeat all words found inside ~25 cells, separated only
by ", ", ignoring empty cells.
A1: [Apple ]
A5: [Syrup ]
A6: [ ]
A7: [ ]
A8: [ ]
The result should be something like:
[Apple, Orange, Banana, Tomato, Syrup]
JemyM's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26945
View this thread: http://www.excelforum.com/showthread.php?thre...Option trades with past expiry dates not showing up in Portfolio M
Money 2006 Portfolio Manager does not show closed option trades that have
expiry dates in the past, even when the "show closed positions" is checked.
The transactions are still there in the investment accounts, just not visible
in portfolio manager. I just called microsoft support and have notified them
of the issue and hope that this issue is fixed as an update. If not, it
pretty much makes the portfolio manager (and Microsoft Money 2006) useless
for option trading investors.
"MumbaiBabu" <MumbaiBabu@discussions.microsoft.com> wrote in message
news:1...How to show query parameters on an Excel page header or worksheet?
Is it possible to display query parameters on a page header or on a
worksheet? I have a worksheet that uses a query to retrive data from an ODBC
database. The Query prompts for the Start Date and End Date. I would like
to be able to print the worksheet and display the Start Date and End Date the
user typed in. Thank you for your assistance.
...Tricky ComboBox / Filter query
On Sheet1, from A1:A2931 I have dates, every day from 01.01.02 to
31.12.2009 (A1="01/01/2002", A2="02/01/2002", etc).
On a Userform I have 2 ComboBoxes: 1 for month, one for year. Is it
possible to use these to filter Sheet1 and leave only those dates
chosen in the dropdowns (eg, December 2004 only)?
...How do you sort a date range by month?
We are trying to find out how many birthdays fall with in a given month using
You could use a helper column, with something like = A2. Format this
(Format - Cells - Number - Custom: mmm. Now you can use Data - Subtotals,
"At each change in: Month" and "Use function: Count."
"Brewisc13" <Brewisc13@discussions.microsoft.com> wrote in message
> We are trying to find out how many birthdays fall with in...