Creating a new field based on conditions
I have a database that tracks insurance information for our various vendors.
Each insurance type has 2 fields - a requirement field (yes/no), and an
effective field (some show an expiration date, some are yes/no). I have
created a query that will return only the records for which insurance is
required but is expired/missing. My problem is that I want to create a new
field that is calculated based on the values in the other two fields in order
to make the resulting report more user-friendly.
For example, if GLRequired is True and GLExpiration is <Now(), I want the
new field to say...Creating array of specific object types dynamically
little gotcha. Some COM objects requires array of specific type.
To give you example, following DOESN'T work:
[array]$X = @()
However below code works:
[int32]$X = @()
For my framework, array type can be dynamic and I don't know in advance what
type it's going to be. So what I would need is below:
[$PropertyType]$X = @()
This doesn't work with error message "Unable to find type".
As a workaround, I solved it using following:
Invoke-Expression "[$$PropertyType]`$Var = @()"
This code works as expected, I am just curious if ...Exchange 2000 DST Changes
How is one supposed to address the DST changes for Exchange 2000 if
they do not have extended support to get the patch? Will Microsoft be
providing a workaround like they did for Windows 2000?
I'm referencing the following article:
It states :
What to do before you run the Exchange tool
Install DST updates
Before you run the Exchange tool, make sure that client and server
computers are updated correctly with the operating system and
application DST updates. These updates must be installed in the
1. Install the Windows DST upda...Restoring Exchange 2000 cluster to "standard" Exchange 2000 Enterp
At the moment we are creating a "full" test environment built from backup
tapes from our live environment. DC's are all up and running. Our 2000 native
forest exists out of a top domain and 2 child domains. All DC's are running
2000 SP3 as well as the Exchange servers.
Exchange servers are located in the child domains.
In one of the child domains which is NL.top.net we have an Exchange cluster,
2 nodes active/active eg. These would be EX01 and EX02 and running EX04 and
Since we unfortunately do not have a SAN in our test site I will not be able
to do a DR...esm shows wrong exchange server version
I have an Exchange 2000 Installation with SP3 + Rollup package 870540-v2 +
Exchange System manager still shows Build 6249.4 SP3.
Should ESM show a higher Build number ?
Thanks for any replies.
IIRC, ESM only shows SP4 on clustered servers that have the update applied
For Exchange news, links, and tips, check:
"MC" <firstname.lastname@example.org> wrote in message
>I have an Exchange 2000 Installation with SP3 + Rollup package 870540-v2 +
...Remote Access or shared LAN access of Outlook without using Exchange Server ????
Currently I am accessing my desktop computer's installation of Outlook
through Remote Desktop, from my laptop. I can do this while on the same LAN
or remotely, through the internet.
This however is not really ideal, as I run my desktop at QXGA resolution and
my laptop has only a XGA screen. This means that when I get back home, all
the windows on my desktop are all messed up and really small.
What I would really like to do is be able to access remotely, in either one
of the ways you can do using Exchange Server.
I have a separate server machine (running Windows Server 2003 Stand...OL2003 (Exchange) and OE6 running in the same PC
We are currently upgrading our OS from W98SE to WinXP. Our VP is
using Netscape v4.67 with dial-up to access his personal email from
the ISP and Novell Groupwise for his internal corporate email.
With the new WinXP, he will be authenticate to Active Directory and
using Exchange 2003 (Outlook 2003) for corporate email. (Yep, no more Groupwise!!)
I want to move him away from Netscape to OE6 (built-in with XP pro).
During my test in the lab, for some reasons I can't have OE6 and
OL2003 running at the same time. (I can launch either one but not
both at the same time) He wants OE6 as his...SharePoint (WSS) 2007 / Outlook 2007 - Alert
This is a multi-part message in MIME format.
We have setup a SharePoint Server (WSS) 2007 and are using the alerting =
After we changes stuff on WSS, an alert message is generated and sent to =
an email account.
This e-mail account is hosted on an Exchange 2003 server.
When using Outlook 2007 to open the e-mail, we get:
Cannot open this item.
Wenn using OWA the e-mail can be opene fine.
Does somehow have an explanation for th...automaticly create graph
what i would like to do is create a spread sheet where by i entered the fixed
and variable costs as well as the selling price. i would then like a graph to
automaicly change and display the this info.
Does anyone know how to do this.
Decide which cells on the spreadsheet you wish to include in the chart.
Select those cells. Follow the menu option: Insert/ Chart, and answer the
questions in the wizard.
Have you looked in Excel help at the topics concerned with charts, starting
with "Create a chart"?
Have you looked at the training material under
http://office.microsoft.com/...Trying to create an Update query based on HR data to find upline V
Hi All, looking for some advice. I have an HR table that contains employee
information but does not contain management chain info. Basically i am trying
to determine who the employees upline VP is. The fields i have to work with
are [Employee Name], [Manager Name] and [Job Title]. I figure the logic would
be to check the employees' manager and if the manager is a VP (based on job
title), return the manager's name to a field called [VP]. If the manager is
not a VP then check that manager's manager, so on and so forth until a VP is
Any ideas would be much appr...Create static text from cell reference
I have two columns of text which I'm combining in a third column using the
formula (for C1, for example) =A1 & char(10) & B1
This gives me the contents of A1 on a line above the contents of B1 and
What I NEED to do is somehow create column C as TEXT, not as a REFERENCED
data from columns A and B. How do I create a cell that contains the actual
TEXT content of another cell instead of a REFERENCE to the other cell?
Select all the cells in "C" that have content. R-click them and select
"Copy" then r-click again, sele...NNTP move to Exchange?
I'm having a problem with getting a NNTP feed from a
INND 2.2.1 server to Exchange 2003; are there any known
issues here? Has anyone done this type of migration
before? What issues did you encounter?
It seems as if Exchange just wants to pull down a few
of the groups (of which we have over 100 internal) and
even with that, not even pull all of the messages in from
those few groups (it usually gets a few hundred
messages). I'm using the basic NNTP wizards but
everything looks to be configured correctly.
...Exchange 2003 OWA #6
Exchange 2003 OWA
I would appreciate if someone would be able to help me.
When I'm trying to access Exchange 2003 Server via OWA, I'm getting
error "The folder can't be displayed. You do not have permission to
perform this action" We also running Microsoft ISA Server.
...Creating a Graph
i want to create a grapg dynamically getting the values from a file..
take for example the first row is the x axis and the second row is the
y axis. i am planning to do this in mfc. what needs to be done for
this.. if somebody has an example relating this please send me the
link or the code.. thanks
Read the data. Plot it.
First, you have to read the data. You read the data and build an array of <x,y> pairs in
whatever way you want to save them, e.g., int, float, double. This is pretty elementary
To do a graph in a very fancy way, you should use an existing gra...Exchange Connector Wizard error
I received this error while trying to run this wizard for a generic CRM
user(what role does it have to have?) that would accept all email directly to
CRM. I ran it on a client computer (was this wrong?)
Here is the error, anyway.
"Failed to initialize the rule management subsystem."
What is the correct procedure to run this wizard? I did not find it anywhere.
...Exchange Server 2000 Secuirty Setup problems
I have apply wrong setting to our exchange server 2000 . The wrong setting
as from exchange manager . mail store , I have apply everyone send as and
receive as access right, the group included remote access via offline sync.
This setting once apply , all user access other mailbox without apply access
right. I have try disable this setting, after all local office user no
problems, but a remote offline sync laptop user does not work . The error as
below: Unable to display the folder. Microsoft Outlook could not access the
specified folder location. The file C:\exchange\shawnb.ost cannot b...Catch all outgoing email on Exchange and send copy to specified account
I have been asked to find out if there is anyway to configure our mail
server to catch all outgoing email from certain email accounts on our
Exchange 2003 Enterprise server and forward a copy of this email to a
specified account, also on the Exchange server.
If anyone could point me in the right direction I'd be grateful.
On 25 Oct 2006 04:10:54 -0700, email@example.com wrote:
>I have been asked to find out if there is anyway to configure our mail
>server to catch all outgoing email from certain email accounts on our
>Exchange 2003 Enterpr...Exchange 5.5 to 2003 upgrade issue 3
We have upgraded our Exchange 5.5 server to 2003 and moved all the mailboxes
and moved and re-homed the folders following the KB articles.
We turned off the 5.5 services and for a week everything was working fine.
Now for some reason the messages to the main distribution list is being sent
to the old 5.5 server on a x400 protocol.
How can I stop this and assure that the 2003 server is self contained so I
can get rid of this server?
...How do I setup an SMTP gateway / smart host for Exchange 5.5 internet bound mail
My current setup has a Windows NT 4.0 Exchange 5.5 server setting on our
company LAN behind a Microsoft ISA Server. The Exchange server's Internet
Mail Connector binds to (I assume this is the proper terms) port 25 on the
ISA server for inbound and outbound Internet Mail.
Our company has finally upgraded to a new Cisco Pix Firewall which we are
able to setup a DMZ on. The suggestion by our ISP is to setup an SMTP
gateway in the DMZ and have our internal Exchange server send mail to it
destined for the Internet.
I am aware that most of the work for making the connections from the SMTP
...Can you create custom activities? MSCRM 3.0
Is there a way to create a new custom activity instead of customising an
existing one? I have created a custom entity called 'Chat' utilising an
IFRAME. All works well but this entity really should be an activity
considering it's properties.
In fact I've just been introduced to MS-CRM 3.0 and don't really understand
what the difference is between an entity and activity. Would anyone shed the
light for me?
BTW, I think 3.0 looks great. Gotta admit it's improved.
In my experience, you cannot create custom activities. In fact, I have been
dire...Duplicate Containers in AD after Exchange 2003 Migration
The scenario is:
We migrated from an NT domain to a 2000 domain. Then about a year later we
migrated from exchange 5.5 to exchange 2003. Once the migration was complete,
we discovered that there were duplicate containers and OUs in "Active
Directory Users and Computers" which were empty. For example, when we did the
AD migration we created an OU hierarchy at the root of the domain. After the
exchange migration we found a duplicate hierarchy structure under the Users
container but it didnt actually contain any objects/information that was in
the original OU structure.
We don...Chart printing issue in Excel 2007
A spreadsheet with charts was created using Excel 2003. I have Excel 2007
and saved it in compatibility mode.
I inserted a couple colored lines on the chart and created my own legend
based on these. A couple of issues:
1. When I close the file or even minimize, 2 of the colored lines on a
couple of my legends disappear upon reopening.
2. When I try to print a chart, it looks good in Print Preview, but then
looks magnified,half off the page, and only one of my drawn lines is printed.
When someone with 2003 prints, the sizing is correct, but all of the
colored drawn lines are missing...Outlook won't conect to Exchange
Client: XP pro, Office 2003 Pro
Server: Server 2003
I cannot get a client's Outlook to connect to Exchange server--or at
least I THINK that's the issue.
I have tried everything that I and the sys admin can think of. We've
even uninstalled and re-installed the whole of Office.
Out of desparation, I tried something that I thought would probably not
have any impact, but it worked--temporarily. I deleted the use's mail
profile, and the application opened and displayed all the users mail!
I thought I was pretty close to being home free, so then I closed
Outlook and re-opened...Install 2003 after 2007?
I had Office 2003 and upgraded to 2007, other than Outlook I didn't like it.
I wanted to reinstall 2003 Excel & Word. Per instructions here I
uninstalled 2007 except Outlook and upon attempting to reinstall 2003 I get
the error message, "Business Contact Manager requires Outlook 2003, please
install Outlook 2003 before running setup". Help please.
Thanks in advance... Bob
Answered in the other group post
"Bob Newman" <firstname.lastname@example.org> wrote in message
>I had Office 2003 and upgraded to 2007, other tha...Re: Outlook 2007
I sent this 3/4 days ago but can not see it in the group. In addition
after this each time I go into news groups the name of the group
turns red in color?? Can not figure what this change in color
> Each time I start Outlook jumps a message: "A data file did not close
> last time it was used. It will be checked.... bla, bla, bla..."
> Vista ultimate, Dell computer. Could one do something?? Regards Ted
> A minute later comes up an other message that the file was checked.
Red means a subject you're following has been resp...