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 ...Distribution Files for MFC in VS .net 2003
I have an app that was developed under Visual Studio VC++ 6.0 & MFC and
deployed at our customer site.
I have since installed Visual Studio .NET 2003 and rebuilt the application
under the new development environment. I wanted to do a quick test of the
executable and copied it up to a test machine and tried to run it. I got a
series of "unable to find xxx.dll" errors.
I realized that none of the new DLLs were installed on the test machine.
Does anyone have a pointer to a good document on what distribution files are
required? I know about the obvious ones like MFC71.DLL...Wrong unread count in inbox (1 is list but no there is no messages)
I'm trying to figure out why a user has this problem. The
unread inbox count shows 1, even if there are no unread
messages in the Inbox.
Thanks in advance!
Check your view (View, Current View, Customize Current View) and make sure
there are no filters set.
Author, Special Edition Using Microsoft Outlook 2003
Author, Absolute Beginner's Guide to OneNote 2003
***Please post all replies to the newsgroups***
"mr_gustav" <firstname.lastname@example.org> wrote in message
news:17b1b01c418c3$e7e4aff0$a10128...Sending email messages without clicking the Send & Receive bu...
Is there a simple way to tell Outlook to send outgoing messages automatically
when you click the "send" button? Sometimes I have to click the "Send and
Receive" button after I click "send."
On Sun, 13 Mar 2005 19:03:01 -0800, "NewUser"
>Is there a simple way to tell Outlook to send outgoing messages automatically
>when you click the "send" button? Sometimes I have to click the "Send and
>Receive" button after I click "send."
Since you don't say what vers...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...Sorting Attendee Lists in Outlook 2003
Is there any way to sort attendees by either name or attendee status in
Outlook 2003? I don't know how Microsoft could be so oblivious to the
need for this feature.
You can't even click on the column headers to sort, let alone print out
a list of people sorted by accept and decline. Microsoft's online help
system recommends Alt + PrntScreen???? How archaic is that?
Is there anyone out there that can help me???
...Importing spam list
I have a long list of spam email addresses that I want to
import into outlook. How do I do this? Do they have to
be separated by commas?
Where is this spam list generated?
What version of Outlook?
Where do you propose to import them?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, Paul Ellis asked:
| I have a long list of spam email addresses...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...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...selected row count of list box
Is there a way to get the selected row count of a list box dynamically as
the user selects rows? Delphi has an event called "OnSelectionChanged" but
Access is much more limited. I don't want the user to have to exit the list
box or click a button or anything manual in order to see the # of rows he's
selected. How can this be done?
I know about "lstCusts.ItemsSelected.Count" but not sure what event to use
it in to accomplish what I need.
Never mind. I did this and it handles both mouse and keyboard selections:
Private Sub lstCusts_AfterUpdat...Data Validation List not showing
I'm using Excel 2003. My data validation lists have stopped working on one
sheet in my workbook. It is working on all other sheets.
I have googled the problem and found the following advice:
1. Make sure freeze panes is off.... check.
2. Select "Show All" under Tools->Options->View->Objects ... check.
The problem remains. Any ideas?
"Stopped working" doesn't do much to describe your problem. When you select
one of the "stopped working" Data Validation cells, do you see the drop-down
arrow to the right of the cell? When you select t...manufacturing scrap not calculating on pick list and serial #'s no
I have entered my percentage of scrap on a MFG BOM and is seems to be
calculating properly in the setup. When I release the components and add
them to a pick list the scrap is not calculating.
I also choose serial numbers and they do not carry thorugh and print on the
Is there some setting that I have missed?
...Prioritize Internal Email
Is there a way in Exchange 2003 for me to set delivery of internal email to a
higher priority than internet mail?
What specific issue are you trying to address?
MVP - Exchange
NEW blog location:
"Patrick" <Patrick@discussions.microsoft.com> wrote in message
> Is there a way in Exchange 2003 for me to set delivery of internal email
> to a
> higher priority than internet mail?
> -Patrick ...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
I get an error message while recieving my emails (send and recieve) and when
I hit the button again it starts recieving from the begining again resulting
in duplicate messages then it ends in an error like the beginning again.
My email is Yahoo mail plus
|| I get an error message
Interim Systems and Management Accounting
Dorisall <Dorisall@discussions.microsoft.com> wrote:
> I get an error message while recieving my emails (send and recieve)
> and when I hit the button again it starts reci...Program Trying to Access Email Addresses #3
Outlook 2002. When I try to create new mail, forward, or
reply I get a dialog box telling me:
A program is trying to access e-mail addresses you have
stored in Outlook. Do you want to allow this?
If this is unexpected, it may be a virus and you should
How do I determine what program is trying to access the
Outlook addresses? I have up to date Norton Anti-virus
definitions and have done a system scan, with nothing
Thanks for the help.
...Can't receive EMail #5
Keep getting this pop up along with 'server did not
connect within 60 seconfs, do I want to wait
A time-out occurred while communicating with the server.
Account: 'Richard', Server: 'pop.east.cox.net', Protocol:
POP3, Port: 110, Secure(SSL): No, Error Number: 0x800CCC19
Please reply using firstname.lastname@example.org
please read this information from Microsoft
Ich habe nichts gemacht, gestern gings noch!
Bitte in den Newsgroup antworten damit jeder etwas davon hat.
Bravestar@Datenschutzminis...Need Help with drop down list with conditions...
I need help.
I'm having a very difficult time creating a sequence of list which change based on the item selected on the main list, lets call it the index:
The Index list, the first list, would define vendors. In this case Hotel Companies (e.g Hilton, Marriott, Sheraton).
The following list, the 2nd list, would define properties, but the properties would vary based on which hotel company is selected (e.g. If Hilton, then "The Plaza, the Waldorf Astoria. If Marriott, then Marriott Marquis, Marriott Convention Center etc etc...) on list #1.
And Last but not least, the 3rd list would...email icon
I have an email in my inbox in windows live mail and the envelope icon has a
red or purple arrow pointing to the left. What does this mean?
It indicates that you replied to that message.
A green arrow pointing right indicates that you forwarded the message.
Windows 7 Ultimate 64
"xgdude" wrote in message
I have an email in my inbox in windows live mail and the envelope icon has a
red or purple arrow pointing to the left. What does this...emails not showing up in deleted items until i do a find?
This just started happening a last week. A message comes
in the Inbox and I click the delete key so delete it.. so
far ok. then i go into the deleted items folder it's not
visible. but if i do a find then they show up in the find
box but still not in the folder. any ideas?
this program makes me crazy sometimes *s*
starindy <email@example.com> wrote:
> This just started happening a last week. A message comes
> in the Inbox and I click the delete key so delete it.. so
> far ok. then i go into the deleted items folder it's not
> visible. b...some emails not coming through internally
I have a 3COM NBX phone system. It has the capability of sending an e-mail
to a user with the voice message attached.
That system is on my 10.1.x.x network.
My exchange server is on my 10.3.x.x. network.
There's a place in the NBX system to put the name of the SMTP server. I've
tried both the email.mydomain.com and the IP address of the server.
The messages do not come through.
If I change the e-mail address for delivery to an account such as yahoo.com,
it comes through no problem.
I have a test exchange server at home. If I set it to go to that, goes no
where. I ...Only new email window?
Is there a way that I could have a shortcut on my desktop that does not open
the whole application, but rather ONLY open my new email window? I send out
a lot of email, and I also have a lot of other apps running.
Please let me know if that is possible. Thank you,
Steve F. <firstname.lastname@example.org> wrote:
> Is there a way that I could have a shortcut on my desktop that does
> not open the whole application, but rather ONLY open my new email
> window? I send out a lot of email, and I also have a lot of other
> apps running.
Create a shortcut whose target is: