Domian Local into Domain Admins Group
How do I make a 'Domain Local' security group which contains a Universal
group from another domain, a member of the Global 'Domain Admins' group?
DL's can't become a member of GG's
you can not. Domain global groups can contain only users and global groups
from the same domain...
If you need to grant Domain Admins equivalent privileges to accounts from
other domains, add them to the domain local Administrators group and local
Administrators groups on all domain member computers...
"Cosmo" <Cosmo@discussions.microso...Finding characters within a text
How to check, using single formula, that a text within a certain cell
contains one of certain characters? For instance, how to check if there is a
'R', 'L' or 'Ps' character within cell A1 that reads 'W-RII'.
Thanks in advance
Hmm..not very elegant, but maybe
Returns TRUE if the text in A1 contains 'R', 'L' or 'Ps' .
FIND is case-sensitive, use SEARCH if you also want to find lower-case
Joerg Mochiku...Auto Forward mail to a group of External addresses
Can someone please tell me how I create an Auto Forward
to a group of external email addresses.
I want to setup an auto forward on my exchange so that
all mail sent to email@example.com is then forwarded
to a group of email accounts such as firstname.lastname@example.org,
Can someone please tell me how I set this up on an
exchange server. I know how to do it for an individual
but I can't work out how I create an auto forward for a
group of people.
Thanks for any advice!
what version Exchange? only the terminology is different...create custom
recipients/contacts ...Word 2007: word count wrong?
I have an issue with some .doc files when opening in Word 2007. In some
cases the word count in the status bar is different of the word count of the
"Word Count"- window (CTRL+SHIFT+G) or the word count in Word 2003
Example file: http://go.microsoft.com/fwlink/?LinkId=79595
Word 2007 (status bar) show 61019 words
Word 2007 (Word count window) show 61010 words
Word 2003 also show 61010 words
This issue I have not with all documents, but only with some files and it
seems that I have this problem only with .doc files but not with .docx files.
(installed ve...How to create an "and" rule in Query Based Distribution Groups
With Exchange 2003 Query Based Distribution groups, is it possible to create
an "and" rule? ie, all users who are based in "London" "and" have the first
Please reply to news group only. Thank you.
"Curtis Fray" <email@example.com> wrote in message
news:OjVc...How to install Exchange in an "Administrative Group"
I am running Windows 2003 and Exchange 2003 on a DC in my lab. Exchange is
installed in the "First Administrative Group".
Now I want to install a second Exchange 2003 Server in another
"Administrative Group" called "Midwest". This is what I did:
1. Installed the second Exchange 2003 server in the "First Administrative
2. Created the second "Administrative Group" called "Midwest".
3. Tried to move the second Exchange 2003 server into the "Midwest"
The problem was that I was not able to &q...Can I abbreviate one value in a data series?
I've got a chart where one value (8,300) greatly exceeds all the others. Is
there a way to abbreviate this value so the other data points show better in
One way is to break the Y axis, have a look at these examples of how to
> I've got a chart where one value (8,300) greatly exceeds all the others. Is
> there a way to abbreviate this value so the other da...groups detail section totals access 2003
I know this can be done, but haven't figured out how yet. I have what
basically is a summary report that my sql comes up with for the detail
rows. I want to total these rows in the report and display
immediately below the detail section. I don't really want to group
anything, but want to treat the whole detail section as a group.
That being said, how can I get a "group footer" on the designer so I
can add my total columns. If I use "sorting and grouping", it starts
grouping things and that is not what I want.
I don't want to use the "page foo...Simple Access counting queries
Hi, hoping someone can help a relative newbie with a pretty simple
query. My database (Access 2007) has three tables:
Purchases (many-to-one links to both of the other tables, this is
basically a linking table)
I have two simple queries I'd like to get out of this database, but
I'm a bit stuck on how to construct the SQL. Any direction you can
give me would be helpful.
1. List of all customers who have purchased 2 or more products (or 3
or more products, or 4+, etc.)
2. List of all customers who have purchased both Product A and Product
B (or A, B, and C, or B an...Count # of cells b/w cells ...
I have the following data in a column: 7 0 0 0 7 0 0 0 0 0 7 0 0 7 0
0 0 0 0 0 7 etc.
The number of zero's between the 7's is random. I want a formula tha
would count the number of zeros between the 7's.
AriBari's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2504
View this thread: http://www.excelforum.com/showthread.php?threadid=38806
Assume A5:A20 is the data, try this:
B5 = A5+B4 (copy formula down)
Now make a table with 2 column...Return values that sum to a known value
I have a list of data and would like to know if there is a formula that would
return any items from that list that sum to a known value.
Have a look at this thread for something similar:
> I have a list of data and would like to know if there is a formula that would
> return any items from that list that sum to a known value.
...organizing hotmail emails within outlook 2003
At home I have outlook 2003 on windows xp configured so that my hotmail
email is picked up in outlook. I have outlook on exchange at work and
have found that organizing my email by color is invaluable. I tried to
organize my hotmail email by color and with rules, however outlook will
not let me do so. Is there a way around this? If I could get the mail
in my hotmail account into the main default "inbox" under personal
folders in outlook then I can organize the email how I want to, however
when I try to do this I have no success in doing so.
colors are controlled by views, not r...count if a match occurs
I have two rows - say Row 1 and Row 2.
In the first row I have a answer key.
In the second row I have answers from a student.
I would like to write a formula where it counts how many answers student got write.
Here is a example:
Row 0: Q1 Q2 Q3 Q4 Q5 Q6
Row 1: 1 4 2 3 4 1
Row 2: 3 4 1 3 4 1
So student marked 4 questions correctly: Q2, Q4, Q5 and Q6.
Hence, the formula should return 4.
I know one way to do it but I am sure there is more efficient way to do it.
The way I know: Use if statement to compare two corresponding entries and output 1 if...Count Age Grouping
I have an access 2k database in which I need to count groups of
records of individuals by that age groups such as
14- 20 no of individuals
21-30 no of individuals
31-40 no of individuals
41-50 no of individuals
51-60 no of individuals
61-70 no of individuals
71-80 no of individuals
80+ no of individuals
I have both DOB and Age fields in the table
I have tried several queries but with no luck and ideas
On 19 Mar 2007 16:51:49 -0700, "Nemesis_uk" <firstname.lastname@example.org> wrote:
>I have an access 2k ...Count the text in a column
I would like to count the text in a column then for it to add a figure in
another cell if it meets the text criteria
Do you mean count the characters?
as an array formula (committed with Ctrl-Shift-Enter)
(remove nothere from the email address if mailing direct)
"Peter Curtis" <PeterCurtis@discussions.microsoft.com> wrote in message
> I would like to count the text in a column then for it to add a figure in
> another cell if it meets the t...Calculate Subreport totals in a main report Group footer
Apologies if this has been answered before but I can’t find it.
I have a main Report with a Group called “Product_Category” which lists a
number of “Products” in the Detail
I have a Subreport named “product_costs” which has a record for each date
and Text Boxes named “materials” and “fuel” (there are more but I’ll keep it
The Subreport sums all costs and has Text Boxes named “summaterials” and
“sumfuel” in the footer (all with a height of 0.1cm)
The Subreport is embedded in the Detail of the Categories and linked by
In the Detail of the Main Rep...Selecting cell value for a sum, based on a condition
Trying to come up with a formula or method that will enable me to sum values
based on a condition. For example, I have three columns which contain a
condition and two amounts. If the condition is of the 'each' variety, one value
will be used in the sum. If the condition is of the "square foot" variety,
another value will be used. Here is a small diagram that may help visualize
A B C D
1 Measure Unit Cost S.F. Cost Summed Total
2 Each 3.00 .30
3 S.F....Enable/Disable a Form Control Based on Security Group Permissions
How do I enable or disable a control in a form based on a user’s security
group membership? For example: If I have a checkbox on a form (call it box1),
I want box1 to be enabled if the user who opened Access is a member of a
security group called “Breaker Test Admin.” For members of any other group
(except of course “Admins”), box1 should be disabled.
Thank you, for your help!
On Mon, 02 Jul 2007 18:57:13 GMT, "BenS" <u35527@uwe> wrote:
>How do I enable or disable a control in a form based on a user�s security
>group membership? For example: If I have a checkbox on a ...how to insert borders on flyer within Microsoft publisher?
Please help, I'm trying to insert a border around a flyer...I'm using
Is it a clipart border, Borderart or a simple rectangle? What problems are you
having? What version Publisher? Any border you insert should be sent to the back
so it does not interfere with your main design.
Mary Sauer MSFT MVP
"Harriet" <Harriet@discussions.microsoft.com> wrote in message
> Please help, I'm ...How do I make X-values of a chart dependent on values in cells?
I have a chart which can go from x-value 0 to x-value 200. However
I'd like to be able to input min X-value into a cell, and a max X-valu
into a cell, and the x-value in the chart changes to reflect that.
Is it possible to do that?
Thanks for any replies.
Message posted from http://www.ExcelForum.com
There is no automatic way to do this but take a look a Tushar's
AutoChart Manager for a possible solution.
Kashgarinn < wrote:
> I have a chart which can go from x-value 0 to x-value 200...EXTRACTING UNIQUE RECORD BASED ON CONDITION
This is a multi-part message in MIME format.
I would like to extract unique records based on a condition. For =
example, how to extract unique record from column 'B' when column 'A' =
has "AP" or any other desired condition.
The data is as follows:
A B =20
AP PATRICK CUDAHY INCORPORATED=20
AP PATRICK CUDAHY INCORPORATED=20
AP SUGAR CREEK ...set value of a group of activex control points
Have a spreadsheet that has some 20+ activex control points (option buttons).
Is there a way to group all these controls together & set their initial
values the same? Trying to setup a "reset" type of operation that would clear
all control points. I can do them individually via properties, but it's too
...Storing distinct values in an array
in the speadsheet, i have a column containing a series of numbers
maybe of them repeated multiple times...
i would like to store all distinct values in an array
any ideas on how i could do that ...
eg , if these were the numbers going down column then 1 3 5 7 5 3 5 7
5 4 3 4 5 7 8 5 3 .. store 1,3,5,7,9,4,8 in an array, in no specifi
shimeel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1583
View this thread: http://www.excelforum.com/showt...Move server between Admin Groups #2
We are going to be going through a reorganization soon and will need to move
some exchange servers from one admin group to another. I know there is not
a native way in Exchange 2003 to do this. Does anyone have ideas on how to
accomplish this besides a swing server to the new Admin Group?
Third party Software?
Our environment is 2003 Forest functional and domain level. Exchange 2003
On Tue, 3 Jan 2006 14:16:23 -0500, "Tim Kalligonis"
>We are going to be going through a reorganization soon and will need to move
>so...Can Entourage be used to access Google Groups
I am in the process of switching from PC to Mac. In Entourage, I see this
news server. Can I get some of my newsgroups in Google Groups to show on
Entourage or Mac Mail?
Responses off group will be welcome if I have asked something everyone
except me knows.
On 1/31/10 3:25 PM, Michael Plog wrote:
> I am in the process of switching from PC to Mac. In Entourage, I see this
> news server. Can I get some of my newsgroups in Google Groups to show on
> Entourage or Mac Mail?
> Responses off group will be welcome if I have asked something e...