Web Services install error on AD LDS
I am trying to install GP 10 Web Services (with the SP3 installer) on a
Windows 2008 SP2 x64 server. Every time I try the install I receive the error:
The Active Directory Lightweight Directory Services role must be installed
on the computer before installing the Microsoft Dynamics GP Web Service.
I have installed AD LDS, and didn't receive any errors on install. I have
rebooted a couple of times, still the same error. I have uninstalled and
reinstalled AD LDS and still have the problem.
You may want to check the following KB articles for resolution to your
System...Adding 2nd server in an Exchange 5.5 environment
Is there an easy way to move the IMS connector from one Exchange 5.5 server
I recently added a new Exchange 5.5 server running on Windows 2000( No AD).
Now I would like to move the IMS connector so I can remove the original mail
server from the network. ( The Original server is a dog)
I have just started this process and the goal is to get my old P2 system out
of the network and replace it with a much faster Dual Xeon box, then upgrade
the new mail server to Exchange 2000..
Any suggestions would be greatly appreciated...
I believe the correct process is to instal...Countif help needed
I am trying to use a countif statement for column A to count the number of
times a District is "CAR" PLUS those CAR listings where column N (DAYS) is
>499. I've tried =COUNTIF(A:A="CAR")+(N:N=">499") and
=SUM((District="CAR")*(Days>499)) as an array, but neither works...help
MS Excel MVP
"Jessica Krall" <Jessica Krall@discussions.microsoft.com> wrote in message
news:1C4594ED-8F33-4E1E-9FB8-80066C05...Macro Help #4
I want to copy a Row of Text Data from 1 workbook and locate a blank row
in the 2nd work book to past the data.. Each time data is pasted it
will be on a new row.
I want this to be a Macro.
Message posted from http://www.ExcelForum.com/
I replied to a similar question on this forum which can be found at
You may have to tweak the code a little to suit your needs.
Hope it helps
Message posted from http://www.ExcelForum.com/
See the Excel/VBA/'Beyond Excel's recorder' page of my web site,
specifically, example 2
http://ww...adding months to an inputted date
I need a function that will take a date that a user has typed in a different
cell and will then add two months to the date. For instance, if I type
"2/12/05" in B1, then I want C2 to be: "4/12/05". Thank you for any help
that you may be able to give.
however what do you want the date to be in C2 if B1 is
> I need a function that will take a date that a user has typed in a different
> cell and will then add two months to the date. For instance, if I type
>...Need help with 2k OWA
I'm having a problem with OWA. I need to have my users logon without having
to type in the domain name. I have configured the default domain in Exchange
System Manager but OWA still will not function without adding the domain
name. If anyone has any suggestions...Please help!!
"Carl Johnson" <firstname.lastname@example.org> wrote:
>I'm having a problem with OWA. I need to have my users logon without having
>to type in the domain name. I have configured the default domain in Exchange
>System Manager but OWA still will not function without adding the...Microsoft Excel Help
Why are they called arguments when creating an Excel
function? i need to no for a Excel test! what makes them
if you mean the 'parameteres' of a function how would you call them
"martz" <email@example.com> schrieb im Newsbeitrag
> Why are they called arguments when creating an Excel
> function? i need to no for a Excel test! what makes them
...Need help grouping charts
I have identical charts which occur on multiple sheets. Is there any wa
to group them for editing?
When I group the sheets themselves, it seems to deactivate the charts
I tried doing it with a macro as an alternative and then flipping th
sheets one by one and keying the macro, but I get a message box with:
"Run-time error 1004", "Unable to get the ChartObjects property of th
Does anyone have any ideas
Izzy's Profile: http://www.excelforum.com/member.php?action=getin...Help with Now()
I am creating a spreadsheet and I need to have a cell and that record
the date and time each row is entered seperately.
The problem I have at the moment is whenever I add a new row of data i
updates the previous rows time?
does any one have any suggestions on how to stop this happening?
sydolly's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2712
View this thread: http://www.excelforum.com/showthread.php?threadid=46697
Now() is a volatile function and will change ev...Need help abbreviating an IF(COUNTIFS formula
I have a formula that when I hit enter says: "The specified formula
cannot be entered because it uses more levels of nesting than are
allowed in the current file format."
Here is my formula:
=IF(COUNTIFS($DP2,"A VIP",$DQ2,"B Customer"),"B
VIP",IF(COUNTIFS($DQ2,"B Customer",$DR2,"C Prospect"),"B
Customer",IF(COUNTIFS($DQ2,"",$DR2,"C Prospect"),"...Help with Raw Stock Data Collection
Is it possible to have Excel search through 1 minute raw data and be
able to determine if the price moves between a certain boundary for a
certain time then it will be classified as "Type 1". And if it is
increasing for a certain time then it will be "Type 2" and likewise
for when it is decreasing.
I want Excel to be able to automatically search through the raw data
and determine what is the type of state without myself having to
manually pinpoint it on the chart then going back and doing a manual
search and calculation in Excel. Only issue is that the exact number
determi...Outlook keeps asking for password
Server is SBS 2008 with SP2.
Clients running Vista SP2.
In the last couple of days (possibly after server updates were applied, but
not sure) every time users open Outlook they get a dialog asking for a
password. If the user enters their correct password the dialog just comes
straight back again.
On looking at the password request box, I notice it is quoting the external
remote domain name "remote.accordconsultancy.co.uk" not the internal network
name "accordserver.accordconsultancy.local". Can anyone explain what I need
to do to stop this annoying ...DB Mail is is not working. Need help please.
I have try stop and start the db mail by executing the SPs below but no luck.
Does anyone has seem the error below and how to fix it.
Thanks in advance for your advise/help.
EXECute sysmail_help_queue_sp @queue_type = 'Mail';
queue_type length state
I just wrote a check to the IRS, and in the Expense Catagory I indicated
"Taxes : Federal Income Tax". Yet in the Income/Expense report, this
payment is not included in my total federal taxes paid for this month. I
should note that the check was written from an Investment Account. If I
write the check from my checking account, the amount correctly shows up in
the Income/Expense report.
Any ideas as to why it works differently, depending on which account I pay
the tax from?
In microsoft.public.money, Tom wrote:
>I just wrote a check to the IRS, and in the Expense Cat...Adding % of total sales to a sales report
How would I add a field that shows what percentage is the value of sales for
an item compared to the report total?
Which report and what do you want to see?
Get Secure! - www.microsoft.com/security
You must be using Outlook Express or some other type of newsgroup reader to
see and download the file attachment. If you are not using a reader, follow
the link below to setup Outlook Express. Click on "Open with newsreader"
under the MS Retail Management System on the right.
"Geoff" <Geoff@discussions.micros...Calendar/Dates Help
I have an excel spreadsheet that lists every date in the year, with a
particular code in the next cell.
Monday 3/01/2005 11M 22M 32M
Tuesday 4/01/2005 11T 22T 32T
Wednes 5/01/2005 11W 22W 32W
Thursday 6/01/2005 11H 22H 32H
Friday 7/01/2005 11F 22F 32F
Saturday 8/01/2005 11S 22S 32S
Sunday 9/01/2005 11N 22N 32N
Monday 10/01/2005 11M 21M 33M
Tuesday 11/01/2005 11T 21T 33T
Wednes 12/01/2005 11W 21W 33W
Thursday 13/01/2005 11H 21H 33H
Friday 14/01/2005 11F 21F 33F
What I need is to be able to search by the code eg "33T" and have all the
dates listed for ...Urgent help with CStringArray
i need to return a CStringArray from a class method, but CStringArray (and
CStringList also) doesn't have a copy constructor!
I want avoid memory allocation within the metod because I don't want to
force the class user to deallocate pointers... this is the piece of code:
const CStringArray MyClass::MyMethod()
return StrArray; // this will generate a missing copy constructor
"Gaetano Sferra" <firstname.lastname@example.org> wrote in messag...vlookup help #3
I cant figure out the proper syntax for the attached workbook. Th
first 8 options on worksheet two work perfectly ( ie when checked, the
appear on worksheet 3) I dont know how to apply the formula of th
first 8 options to the rest of the checkboxes.
Can someone please help me figure out how to do this? Thanks i
Attachment filename: start order2.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=46674
Message posted from http://www.ExcelForum.com
Right-click on the sheet tab for the Options worksheet.
Select View ...Bill Pay Help
I just signed up for Bill Pay (I have Money 2005), I'm not sure how to
coordinate Bill Pay with my Bills list and my checking account register. It
makes a separate Bill Pay register, but won't allow me to merge it with my
checking account (as Help suggests). Tech support was completely useless, in
fact it seems they're in a hurry to get us off the phone.
...Just Help Me
Hello All . . .
Please answer the questionary in the following URI
Thanks a lot . . . :D
Post the question here, and we might.
(replace somewhere in email address with gmail if mailing direct)
"CorfuVBProgrammer" <email@example.com> wrote in message
> Hello All . . .
> Please answer the questionary in the following URI
> Thanks a lot . . . :D
...Help revising slow code
I am using the following code to remove all the lines in a worksheet that
have a zero value in Column H. Because there are thousands of rows in the
worksheet, this loop takes forever! Does anyone have any suggestions for
doing this more quickly? Thanks!
Dim Firstrow As Long
Dim LastRow As Long
Dim Lrow As Long
Dim CalcMode As Long
Dim ViewMode As Long
CalcMode = .Calculation
.Calculation = xlCalculationManual
.ScreenUpdating = False
Say i have multiple sheets dated 04/01/10 to 04/30/10, each contain names,
say A, B, C, D, etc... but these name does not appear in the same order in
each sheet. Now data is in time format in front of A, B, C, D, etc.
Eg. in sheet 04/01/10
like this data in other sheet till 04/30/10.
Now in a new sheet i want this data to be collated in time format in front
of the individual sorted in Alphabetical order. Also it should give me the
Sum of the data.
Is it possible and how?
Thanks in advance for the help!...corrupted PST file
I have Outlook 98, running on XP, on a PII 400Mghz Dell
desktop. My PST file is about 1.95GB. It has been
running extremely slow, and has had to be restarted a
bunch of times in the past 2 weeks. Yesterday, it gave an
error that the PST file was corrupted, and that PST file
need to have the Inbox Repair Tool run on the file, and
then the system restarted. I ran the Inbox Repair Tool on
the PST, and it did not work. I am totally unable to use
the file, which has all my critical contacts and emails.
If someone could help out, I would be MOST grateful.... I
pulling my friggin ...Autofilter help
I have 4 columns of data with an auto filter on - all ok
I then reduce my selection so I finally only have one row of data - all ok
Not ok: Problem: Is there an easy way that I can copy the data in the top
row of the filter, to another worksheet page - so if the filter is changed
so top line shows new result - still copies over the data in the top row of
Bearing in mind that the top row could be I.E. Originally Row 8 or 108
depending on the selection.
Autofilter Line = 1 2 3 4
eg Result of A/F a a a a <== copy the result of this line to
dif...Y-axis title truncated excel 2002
I can't get excel 2002 to show the complete y-axis title along the y-axis.
It truncates in the plot whatever I type
in the Chart Options, Value (Y) axis box. No problem with the Chart Title
Is it worth changing from excel 2002 to excel XP (which I have). I'm running
Others have reported this problem. One solution is to add some extra
characters to the y-axis title and to format these to a colour that makes
them invisible on the chart. I have never seen this myself - I use XL2002