What names should be on a SSL Cert for hub/cas 2010 using cas arra
I was just currious what names should be on a SAN Certificate for a couple
cas hub servers that host a CASarray with NLB. Are just the external names
sufficient or are all the internal ones neccesary as well?
mail.domain.com (external casarray VIP and NLB IP)
I believe that the below names are enough for the SAN, you don't need
internal certificate names if you will not assign it for SMTP service on the
&...Form Record Source
The form source used to be a table then at a later stage I set a query to be
the record source. Now the client is complaining that when many users open
the same record it loses that record (this suggestion is not proven)
Can the change of the record source be related to the problem that they
Using a query as the source for a form is not a problem.
If you have not already done so, split the database so that each user has an
independent copy of the front end. If that's a new idea, see:
Split your MDB file into data and application
h...Maianting copies of all emails
We wanted to maintain a copy of any incomming and outgoing emais hence we did
it through our surfcontrol server. Now any email coming and leaving our
system also gets stored on our specified location. The problem is that we
cannot get a copy of any internal communications because internal
communications do not go through surfcontrol and it gos directly through
exchange. Is there a way in exchange where we can store a copy of all the
internal emails as well?
On Tue, 6 Jun 2006 06:11:02 -0700, Shaqs
>We wanted to maintain a copy of any in...Cut, Copy, Paste using Insert Key in Outlook 2007
Since I am left-handed and use the mouse with my left hand, I have grown
accustom to using Ctrl-Ins for Copy, Shift-Ins for paste, and
Shift-Delete for Cut.
While in an opened message in Outlook 2007, I can use these key
combinations (due to an editor option in mail format tab of the options
dialog), but in the preview pane, I am not able to do it.
Is there some way to enable these key combinations in the preview pane
of Outlook 2007?
cd <firstname.lastname@example.org> wrote:
> Since I am left-handed and use the mouse with my left hand, I have
> grown accustom to using Ctrl-Ins for Copy, Sh...How to transfer and copy Pictures from iPhone to computer?
[url=http://www.transfer-iphone.com/transfer-photos-from-iphone-to-computer-with-iphone-tool-kits.html][b]How to transfer and copy Pictures from iPhone to computer with iPhone Tool Kits?[/b][/url]Do you want to copy Photos/Pictures from iPhone to computer for printting? [url=http://www.transfer-iphone.com/transfer-files-sms-contacts-call-list-ibooks-from-iphone-to-computer.html][b]iPhone Tool Kits[/b][/url] is an easy to use utility designed to help you back up all your files on your iPhone, so that you can recover any lost or missing songs, videos, books, photos and so on. It can easily [b]ba...Conditional Formatting #115
I two rows of data, some numbers and some are N/A.
I need to highlight both rows when the top number is higher but when I use
conditonal formatting it will highlight the cell contain "N/A".
Is there a formula I can use to get around this?
in your conditional format formula
> I two rows of data, some numbers and some are N/A.
> I need to highlight both rows when the top number is higher but when I use
> conditonal formatting it will highlight the cell contain "N/A".
...SEARCH COPY OF TEXT
We have an excel spreadsheet with names and addresses in columns On 3
different worksheets. Is there a way to have excel search the doc for same
entire data. ex:
Jane Doe _ Exel would see that and stop since there is a Jane Doe already
Please help I really don't want to ctrl -f 380 times to make sure..
Thanks to anyone that replies
So you have some kind of cell that's used for data entry and you want to check
if that name appears in any of those other 3 lists?
If I used A1 on Sheet1 as my data entry cell, I could put this in B1:
Thought this was all going, getting sucked down the plug hole. Where are all my
favourite gurus going to now? Alt windows 98 ? Let me know.
pebble in Boulder
> Thought this was all going, getting sucked down the plug hole.
> Where are all my favourite gurus going to now? Alt windows 98 ?
> Let me know.
I strongly recommend you start reading, if not become a member of this
Otherwise, yes, the newsgroup alt.windows98 is a logical choice.
Also be aware that June 1 was not...Conditional Formatting on an XML list
Another Excel newbie requiring assistance with conditional formatting,
I've been tasked by my employer to create a Spreadsheet in MS Excel
2003 for the purpose of displaying an XML *list* which is output from
one of our legacy 3GL systems.
I've created the spreadsheet using the map genetrated automatically by
Excel, based on the actual XML file to be imported, and I can import
the data at will. No problem there (I've set the import function to
overwrite all previously stored data on selecting the 'refresh all'
option on the import to...Copy from worksheet 1 to worksheet 2, 3 , 4 etc..
Okay. I learned a thing or two but still not working for me.
Sheet 1 looks like this
Monday Tuesday Wednesday Etc...
John Smith off 4am 4am
Katie Jones 4am 4am 4am
Dawn Moran 4am 4am off
I would like sheet 2 (renamed "Monday") to list the names with "4am" under
the column Monday. And not list the names with "off" under the Monday column.
So "Monday" sheet should look someting like
Dawn...How to add more that one tables or queries to report record source
How to add more that one tables or queries to report record source? In Access
Add more than one tables or queries to report record source. Thanks.
> How to add more that one tables or queries to report record source? In Access
Create a new query in design view.
Add as many tables and/or queries as is appropriate.
Join them on their common fields.
Select fields from them to display in the output.
Save the query.
Run it to make sure it retrieves the data you want.
Create a report and point it to the new query ...Protect Formatting #2
Dear Andy, firstly thanks for your response.. But i think yo
misunderstood my question.. What i wanted to protect was the PAGE SETU
- means the margin settings, fitting to 1 page etc.. The cells and dat
protection i know can be protected as you said..
I just want the PAGE SETUP to be protected.. Means irrespective of wha
they update in sheet, if the sheet is set to fit 1 page wide x 1 pag
tall it should not allow the other users to change this setting..
I have 3 worksheets for one week, these are 1) values, 2) summaries of
values and 3) graphs of the same. I have copied this within the workbook so
that I now have sheets for weeks 2, 3 and 4 and it has worked well except
for the graphs. The values for the graphs still relate to the values from
week 1. Why is this? Is there a way round it without redoing the data
sources for each of the graphs?
have a look at
"Aardvark" <djurmann(at)hotmail.com> sc...Date format #23
Hi I have i excel shhet one colum as imported data from another program. I
have this date format in the colum: 111504, im trying to format the cell but
i got this result: 4/14/05. With the format date 50498 the result i got is:
Can anyone help me?
"Jean-Francois Boucher" wrote:
> Hi I have i excel shhet one colum as imported data from another program. I
> have this date format in the colum: 111504, im trying to format the cell but
> i got this result: 4/14/05. With the format date 50498 the result i got is:
> Can anyone help me?
...Exchange 2007 Archiving not working for outlook 2010 users
I've got Exchange 2007 on a single server. Under Org Config I have a
journaling rule setup to journal every email to a certain mailbox.
This works great except for users on outlook 2010. When you log into
the archive mailbox, most users emails are included as attachments as
expected, but outlook 2010 users messages have only a "corrupt.eml" as
the attachment, not the original email. As its only a couple people at
this point, I wonder if its because of outlook 2010, or if they are
somehow encrypting their emails so they can't be archived? Thanks,
You might want to ask...How to Break a link to a source in Excel 2000?
Trying to break links in a excel file. but does not appear in the links
dialog box. Is there any other option of breaking links in excel 2000
and search for Findlink.zip
> Trying to break links in a excel file. but does not appear in the
> links dialog box. Is there any other option of breaking links in
> excel 2000
...screen is showing slides in backward order .. . help!
Hello I have a pptx presentation with six slides. For some reason,
everything is defualting the the right (the bullets come out to the right of
the words, the slides print as handouts in backwards order, the outline pane
is on the right hand side of the slide pane). THis is only happening for
this presentation. Others I create are the typical way PP usually works.
I wish I could upload it here but am unable to do so.
See your other post
john ATSIGN PPTAlchemy.co.uk
Free PPT Hints, Tips and Tutorials
http://www.pptalchemy.co.uk/powerpoint_hints_and_t...Email distributes copies to all many times
Hello, I have a new SBS 2003 server with Exchange
installed. 5 people in my business got sent the same email
from someout outside the company. Normally I would have
thought this would just send one copy to each person in
the To: list.
It actually sent 5 copies to each of the people! And seems
to do this everytime you send an email to more than one
person. 3 people they get 3 copies!!!
Any ideas why? or how to fix this?
Are you using the POP connector?
Jack D wrote:
> Hello, I have a new SBS 2003 server with Exchange
> installed. 5 people in my business got sent the sam...Formatting cell pattern color
when I format a cell with a color or a pattern. The formatting does not show
on the worksheet. It shows OK on print preview.
Take a look at this:
>when I format a cell with a color or a pattern. The
formatting does not show
>on the worksheet. It shows OK on print preview.
If the high contrast setting is turned on you won't see the fill colour.
There's information in the following MSKB article:
OFF: Changes to Fill Colour and Fill Pattern Are Not Displayed
http://supp...copying a formula down a column
I am trying to copy a formula down a column where c1=a1,c2=a4,c3=a7 an
so on but when Itry to drag the formula down the column it doesn't cop
properly. Does anyone know a simple answer to this. Thanks in advance
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
Put in C1: =INDIRECT("A"&3*ROW()-2)
Copy down col C
Please reply in newsgroup
<at>yahoo<dot>com for email
----------...Formatting Dates #2
I Have a spredsheet with the birth dates of several people. I wan
these dates to change color when they are 30 days away. I can do thi
now with the [cell value is between =today() and =today()+30
conditional formatting formula but I have to input the current year fo
the birth day, I was wondering is there any way to get the same resul
and input the actual year of the birth day. Ex. If the birth day is o
1 Jan 1984, I want the cell to change color on 2 Dec of every year an
the change back on 2 Jan
pknivens&...Copy and Paste without copying Formulas
I have created a workbook with several sheets. The first
sheet consists of a master list of 8000 numbers. The
second sheet is where I paste a smaller list of numbers.
The workbook performs a search and returns numbers that
match on the third sheet. The third sheet also has
formulas. I want to be able to copy and paste the
resulting info on the third sheet to another workbook
without copying any of the formulas......I just want the
info. Any suggestions??
Gord Dibben Excel MVP
On Thu, 18 Nov 2004 14:21:13 -0800, "Ken"...Copy unique data to a different WS
This is my situation any suggestion or help will be greatly appreciated.
Date Prod ID
A bit more detail would help.
Is this a one time operation, or something that needs to be live and linked
in some way.
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
It's easier to beg forgiveness than ask permission :-)
"Sdbenn90"...Outlook Express sends 2 or 4 or 6 copies of the same e-mail
My neighbor asked me to solve a problem with his computer - seems like
Outlook Express (Ver
6.0) flashes an error message when he sends an e-mail. (Typical Microsoft
error message in that it doesn't say what the error is) Then, the
application sends 2 or 4 or 6 copies of the same e-mail. Any ideas?
He also uses a laptop, and Outlook Express works as designed when sending
e-mail from the laptop (through the desk-top router). I did remove
(unsuccessfully) the Outlook components, rebooted and saw that Outlook was
still there doing its' nasty thing of sending 6-8 e-mails.
...Conditional Date Formatting
I have a spreadsheet tracking dated shipments from our suppliers to our
I am showing the rows for shipments that are due to go out in 7 days
(or less) shaded in red, and those that are 14 days out in green ----
=$A2-TODAY())< 7 ....
Rows for shipments due to go out 6/1 or earlier are shaded green, while
those due on 6/2 are not shaded - which is what I wanted.
Thinking about it, it might be better if the "green" rows (8-14 days
out) could be expanded to include the end of the workweek - in this
case, 6/1 is a Thurs, but it would be better t...