domain User accounts
im planning to install CRM and related softwares with the following user
i have a domain called "crm domain" which is in native mode.
i have separate machines to act as CRM server and SQL Server.
A user has been created in AD called as CRMAdmin. It is a member of the
Domain Administrators group.
- On the proposed SQL Server ,
- logged into the machine as "LocAdmin"
- installed SQL Server
- service running under local system account
- On the proposed CRM server machine,
- Prerequisites installed by logging into the machine as "LocAdmin" who has
local ...How do I link information in the LAST ROW of a workbook to another??
Hi all! :) I'm new here, so if by posting this message directly, I'm not
following procedure, appologies ahead of time.
I'm trying to link information from one workbook to another.
It's for inventory. We have a different page for each item number, and
every time the item is adjusted, it adds a new row to the speadsheet.
I want to be able to list ALL the totals from the different pages into
a new file, so people can see totals by looking at ONE sheet. The
problem is, the row number of the cell I need changes everytime the
source file is edited.
There doesn't appear to ...format based on data from another cell
I want the names in column B of my spread sheet to highlight either red or
yellow based on the value of the cell in column L, but with conditional
formatting you can only format based on the value of the cell you are
formatting, as far as i can tell.
conditional formatting can be used to do this,
select the column B cells that you want the formatting to be applied to,
ensure that the first selected cell is the first line visible at the top of
choose format / conditional formatting
where row 2 is the first row in the selected column an...Task reassignement approval preview
I have a team resource "Team A" with three tasks in a schedule. As a Team
resource manager "TM1" and logged in and click "assign Task to me". all three
tasks are transferred to my MyTask page. I selected all the three tasks and
then clicked 'submit selected".
As a Project manager to approve, I opened MS project Pro. it comes with a
message for updates to review. I clicked Yes. In the preview page, update
type shows "Task Reassigment Request" but it shows also that allthree tasks
are complete and % complete is showing 100%. Howev...Unable to modify doc
I designed a visio drawing. Saved as usual - I have later
gone into the doc to modify, but all of the functionality
has been disabled. I have looked on the system for an
answer of how to rectify problem and it suggests that i
should go in the 'show shape sheet'and un-protect it.
However, that has been disabled too. I have Visio
I am desprate to change the drawing and it is the same
for all of my docs.
What do you mean by the "functionality has been disabled"?
What sort of functionality?
If you open a brand new blank Visio draw...Hide user from GAL ??
How do you hide a user from the Global Address List?
(Win2k3 server AD with Exchange 2000 server, Outlook 2000, single domain)
in ADUC, on the Exchange Advanced tab of the user's properties, there's a
check box to select...
Susan Conkey [MVP]
"MLK" <firstname.lastname@example.org> wrote in message news:fzElg.22371$YI2.5145@trnddc01...
> How do you hide a user from the Global Address List?
> (Win2k3 server AD with Exchange 2000 server, Outlook 2000, single domain)
Set msExchHideFromAddressLists=TRUE and clear the attribute
Using admod...Within domain mail going to Junk Email on some users?
I have a weird situation, not sure if Exchange is causing it or if Outlook
When certain users email others within our single domain, their mail goes
directly to the recipient's junk email folder?
Any thoughts as to why? No Rules are causing it that I can see...
On Thu, 5 Jan 2006 06:01:02 -0800, "Ken Montgomery"
>I have a weird situation, not sure if Exchange is causing it or if Outlook
>When certain users email others within our single domain, t...Is this do-able?
A user has created a 'select' query in MS Access.
1/ runs the query (the user is prompted for an 'end' date / filter)
2/ switches to 'pivot table view'
3/ exports to MS Excel
We would love to do this in one step.
* I know how to link to external data in MS Excel, and could then refresh
the raw data in Excel. However, the number of lines in my resulting
spreadsheet varies so my pivot table would have to be recreated or the range
reset, I believe.
Thank you for any ideas.
(** Is there a better newsgroup to post thi...processing my mail at another PC
i have cable wanadoo broadband basic/ sitecom router DC202 V3/ windows XP on
the main PC ( outlook express 6.0 ) and just yesterday i connected another
PC to the network ( windows 2000 pro outlook 6.0 ).
how can i arrange all this so that i can read and edit my mail from which
ever PC I'm at?
I could'nt find the FAQ's, ...
I dont believe you can sync mail between two different apps. You would I
believe need to use either OE or OL on both
"john" <kade108NOSPAM@wanadoo.nl> wrote in message
> i ha...recursive serarch on a network directory with share permissions?
How would you do a search on a network directoru with share permissions? New
"as14177" <email@example.com> wrote in message
> How would you do a search on a network directoru with share permissions?
> to vbscript.
Can you elaborate a little? What do you want to search for? What role do the
permissions play? What operating system do you have?
...DL owner can't add users to DL
This is a common "How to", but I can't find the solution anywhere.
How do I give users permission to add/remove from a DL!
MVP for Microsoft Exchange Server
"connor_a" <firstname.lastname@example.org> wrote in message
> This is a common "How to", but I can't find the solution anywhere.
> How do I give users permission to add/remove from a DL!
> Tha...Another IF
the cells this calculation is directed at can either contain a number or a
"" value, it works great if one of the cells contains a "", but if there is
actually a number in one of them it still wont calculate, it doesn't add the
numbers up I still just get a blank cell.
Any help is truly appreciated
Not real sure what you're trying to do.
The 1st part of your formula is OK:
=IF(ISERROR('060906'!G16+'060906...winxp not able to join domain
hi! recently, i've some issues in a small grp of clients about 5% of the
total 1000 PCs. We're not able to join these PCs into our win2003 domain.
I've to rename the PCs before i can join to the domain. I've checked in the
AD, the computer name is not there and all the dns, gateway and etc are
correct. I didn't see any related msg in event viewer as well.
for some of these pcs i've to re-join the domain for the user to login again.
has anyone encouter this before? pls advise. thx
Are the machines created from a not sysprepped image? Did...How can set up Excel to be able to print checks?
I wish to be able to build a template so I can print checks from an excel
This file might be a help:
It's in the "Accountants" section on page:
It contains the "SPELLNUMBER" function, which can be used in your
spreadsheets, two methods to convert numbers to words and two cheque
The code is open and commented.
Andy Wiggins FCCA
Excel, Access and VBA Consultancy
"catherine" <catherine@discussio...Another Question lol. Formula this time.
I have a worksheet that I want to highlight if there is a number greater
than zero by changing the text colour.
=if(a1>0)colour text red
Any advice would be gratefully received
Check out Conditional Formatting under Format. Cell value is > Greater than
> 0 > OK
"Nevyn" <Nevyn@discussions.microsoft.com> wrote in message
> Hi again,
> I have a worksheet that I want to highlight if there is a number greater
> than zero by changing the text colou...View List of Connected Users in Business Portal
Prior to rebooting or applying patches to Business Portal server, we need to
view and see list of connected users in Business Portal so we can ensure we
do not accidentally disconnect them while they are working. I understand we
can view who has what databases open in SQL server hosting the Great Plains
database where we can view activities. However, it would be nice to view
within Business Portal server who is connected and have ability to notify
those users to disconnect or that server is going offline.
This post is a suggestion for Microsoft, and Mi...Share splits inaccurate data
When I split shares the daily change amount does not take the split into
account. For example, if shares split 2 for 1 the price divides in half but
the shares double for no change. But MS Money tells me that the price dropped
by 50% for the day of the split. Is there anything that can be done to fix
MS Money Standard - Canada
Thanks in advance.
Check to see if the split is recorded on the proper day by going to your
investment and chosing Update prices manually. The split should appear here
on the proper date. All historical prices prior to the date of the split...Can server 2003 forward a specific port to another machine?
I have to machine, 192.168.1.1,192.168.1.2. I want all the access to
192.168.1.1:8000 being forwarded to 192.168.1.2:7000.
Can server 2003 accomplish this or I should install some other software?
> I have to machine, 192.168.1.1,192.168.1.2. I want all the access to
> 192.168.1.1:8000 being forwarded to 192.168.1.2:7000.
So both the front end target (192.168.1.1) and the back end target
(192.1168.1.2) are in the same IP subnet. Correct?
Presuming that the above statement is correct (for the sake of
discussion), you have to worry about reply ...appending one Excel file to another
I'm trying to append to a annual Excel file a daily Excel file once
Preferably using DOS script once my user saves the Excel document
I do this for text files and word document but I am having trouble
Is there a way for the third line to work ?????????????
c:> del /q excel_master.xls
c:> ren excel annual.xls excel_master.xls
C:> copy excel_today.xls + excel_master.xls excel_annual.xls
ALSO: Would this work for TEMPLATES ?????
Can this be done without VB or VBA using DOS.
Tha...How do I modify ListView's scroll position?
I would like to get and set a ListView's scroll position using .NET 3.5
Is there an easy way to do this with managed code?
while searching on the web I seemed to have found one solution but it
requires Interop with some getscorllinfo/setuserinfo functions. Is that the
only way ??
On Tue, 24 Nov 2009 19:44:01 -0800, trant
>I would like to get and set a ListView's scroll position using .NET 3.5
>Is there an easy way to do this with managed code?
you can use listBox.TopIndex
On Tue, 24 Nov...should be able to print ATP
I would like to be able to print out the Available to Promise information.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=2d089892-1a1b-4a8a-9e3e-16757d015fff&dg=micros...Modified SmartLists aren't retained when upgrading to GP 10.0?
In the Upgrade Instruction manual for release 10, in the "Reports That Won't
Upgrade" section, it says "Modified SmartList reports aren't retained when
you upgrade to Microsoft Dynamics GP 10.0".
What does it mean by "modified SmartList reports"? Ones created using
SmartList Builder? Favorites saved?
Microsoft Certified Business Management Solutions Specialist, GP 9.0
Currently supporting: GP 9.0, SP2
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users
Get our Free Tips and Tr...how to display a form for the user to select a list of contacts from the addressbook
Does anyone know how i could (in vb or vb.net) display a MS Outlook screen
be used for the user to select a contact from the address book.
I need a screen to display the outlook contacts and for the user to select
one of them and this screen should return the selected contact.
Then i should be able to get the details of this selected contact.
The code will be used in an external application.
...Adding another company to eConnect
I am attempting to add a new company database to eConnect (I already have
130+). I am using the Additional database install option from the installer
and it is taking as long as it took to set the original 130+ companies up.
Does anyone have any experience with this?
...Configuring Outlook for Multiple Users
Here's my problem:
I am currently getting my in-laws first computer fine tuned for them.
The computer is running Windows XP and Outlook Professional 2003. My
goal is to make the process as simplified as possible to ease them
into using computers.
To that end, I have the computer opening generically, no separate user
accounts. However, I want to be able to set up Outlook so either one
can get e-mail from a separate account. For some reason, I remember
using Outlook at my old job. Everyone used the same computer, but we
could each log-in individually to Outlook from a "welcom...