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...Having problem of Outlook not receiving new e-mails
I have been using Outlook for over 1 year with Comcast
Broadband. Suddenly last week, I received a message that
Outlook 2000 was experiencing a problem when receiving new
e-mails and was going to shut down. I re-opened Outlook
and it looked different and then it asked for me set up a
profile and I canceled it. But after that window coming up
a couple of times after it shut down, I decided to put in
a new name and then I could not get to my old e-mails and
it acted like a new set up. Then I really got frustrated.
I was eventaully able to get back to my old e-mails and
have been able t...Outlook 2002 Appointments not visable
Outlook 2002 stopped showing my appoinment in any view. I
still get reminders and I can see a appointment on the two
month preview, where the date is in bold.
On Thu, 18 Sep 2003 09:48:08 -0700, "Dennis" <firstname.lastname@example.org> wrote:
>Outlook 2002 stopped showing my appoinment in any view. I
>still get reminders and I can see a appointment on the two
>month preview, where the date is in bold.
Uh, try posting this to the OUTLOOK NG, rather than the Money NG.
One. Try posting in microsoft.public.outlook.*
"Dennis" &...Have Outlook 2000. How do I get rid of spam?
I need step by step directions because I don't know the termenology.
When we open Outlook it comes up under my husband's e-mail. Then I Open
mine. He is not spamed. I get hundreds each day. HELP!
winnieB <winnieB@discussions.microsoft.com> wrote:
> I need step by step directions because I don't know the termenology.
> When we open Outlook it comes up under my husband's e-mail. Then I
> Open mine. He is not spamed. I get hundreds each day. HELP!
Step by step:
1) Open Internet Explorer.
2) Browse to http://spambayes.sourceforge.net/
3) Downoad SpamBaye...Outlook 2000 send/receive
I am having troubles trying to get Outlook 2000 to
automaticly send/receive e-mails...any help?
I am not sure if it is what you are looking for but here goes: Under the
Tools menu, click Options. In the dialog box that opens next click on Mail
Delivery tab, then make sure there is a check in the box beside "send
messages immediately when connected."
<email@example.com> wrote in message
> I am having troubles trying to get Outlook 2000 to
> automaticly send/receive e-mails...any help?
...Funky animated signature-outlook 98
How do I add an animated signature to my emails to make them look
funky? I know how to do normal signatures. Is there a website where I
can get animations from to use in my signature and how to I apply them
Does this sound really stupid?
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
...How do I copy a date from excel to a outlook calender?
I am looking to produce a spreadsheet with various amounts of data on. One of
the bits of data will be appointment dates. Can Excel, (or any other
database) update outlook appointments with either little on no user
intervention? If so, how?
...- About Outlook's archiving capabilities...
I am trying to take a load off Outlook (Office XP) by archiving old items,
but I'm new to the process.
Every folder I archive seems to generate its own "Archive" folder in the
Folder List... so essentially, all it did was move the old contents from one
folder to another.
My question is, am I really helping Outlook at all by doing this? The whole
point of archiving was to give it fewer messages to load at bootup. But it's
still loading them in the Archive Folders, isn't it?
What happens if I delete the Archive Folders? Am I helping Outlook's
performance at all? And ...Outlook 2003: Most messages are moved to junk folder
I am getting a lot of spam recently, at least looking at the numbers of
mails in my junk folder.
However, it turns out that these messages are not spam at all, but just
regular messages (even from the same domain), that should remain in the
regular inbox. Even when I identify a message as 'Not spam', then
subsequent messages from that sender keep popping up in the junk
Obviously I have changed the junk mail settings to 'No automatic
filtering' but Outlook keeps thinking it is smarter than I am.
Any idea? Googled the internet already but couldn't find anoth...An Outlook 2003 Problem
I just upgraded from Outlook 97 to Outlook 2003. However, when trying to
reply, forward, and compose with Outlook 2003, I got this error message:
"The messaging interface has returned an unknown error. If the problem
persists, restart Outlook."
The problem persisted. I restarted Outlook 2003, but it didn't help.
Any suggestions? Thanks.
How did you upgrade Outlook 2003 from Outlook 97?
Anyway If you use Hotmail or MSN mail,
check MSKB info below.
You receive a "The messaging interface has returned an unknown error " error message when you try to use Outlook to...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???
...outlook can't receive exe files
A guy here at work can't get exe files through his outlook. Is there a check
to uncheck somewhere to allow it to do this? He can receive normal
...Had to disable 'outlookaddin.dll' to access outlook
I'm using Outlook 2003(11.6568,6568) SP2 w/XP. I got a message "Outlook
experienced a serious problem the last time the ad-in 'outlookin' was opened.
Would you like to disable this add-in?" It has to be disabled to access
Outlook. It then explains how to enable 'Outlookaddin(outlookaddin.dll).I've
left it disabled and enabled it with the same result. I can receive email but
cannot send it
Outlook will not start unless I disable outlookadd.dll. Anyone have a solution? I think that it may be related to the Dell Media Direct.
Any help is much appreciated.
...Accessing MIcrosoft Outlook
Yesterday, when I tried to access Outlook in my home pC, I received
the following message:
Cannot open MIcrosoft Office Outlook. Cannot open the Outlook
window. The set of folders cannot be opened. The file C:|Users
\jillandgordon\AppData\Local\Microsoft\Outlook\Outlook.pst is not a
personal folders file.
Does anyone have any ideas as to how I can fix this?
Gordon in TX
Try this first
"Gordon McDougall" <firstname.lastname@example.org> wrote in message
news:d0e17ac8-0215-431c-971f-bd862b58a245@y17g2000yqd....Outlook color scheme
I've seen several different installs of Outlook 2003.
Some have an orange interface, some blue, some grey. I'm
not talking about Outlook web acess, but the local
installed copy. Can anyone explain this? I would like to
figure out how to change the interface color scheme.
It uses Windows color schemes. Change those from Display Properties
(Control Panel or right click you desktop).
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 ...Controlling multiple TCP connections from Outlook 2003 clients
I've noticed that Outlook 2003 clients can have multiple TCP
connections to the mailbox store on Exchange. As the following web
"This behavior is by design. Outlook can open multiple connections to
parallelize its data communications with the Exchange server. The
actual number of connections will vary according to the version of
Outlook that you're using and the mode in which you're using it. For
Microsoft Office Outlook 2003 in Cached Exchange Mode, you'll see four
connections for the mailbox, ...Add new record through Form view
I have a table which is linked to a form, i would like to have a command
button which will add a new record to my table.
On the click of command button it should view the last empty row of my table
in a form.
On Sat, 26 Dec 2009 11:11:01 -0800, Ranjith Kurian
>I have a table which is linked to a form, i would like to have a command
>button which will add a new record to my table.
>On the click of command button it should view the last empty row of my table
>in a form.
The Click event should show [Event Proced...Setting up my work outlook account at home
I do not know how to set-up my outlook at home to check
and receive email at home.
This is really a question for your Mail Administrator.
This depends on what ISP is used for work or if you
use the Exchange Server. Then there may be a domain
Nikki Peterson [MVP - Outlook]
"Liz" <email@example.com> wrote in message
I do not know how to set-up my outlook at home to check
and receive email at home.
...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...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...Adding an item to a popup menu in outlook's inbox using VBA
On rightclicking on the mailitems in the outlook's inbox
we can see a popup menu.i want to add a menu item to that
popup menu using outlook VBA.
Please do help me in this regard.
...Any FREAKIN' way to import DBX files into Outlook 2003
Importing via Outlook | Import from another Program or File
Importing via Outlook | Import Internet Mail and Addresses
Exporting from Outlook Express
Tried Many, many times...
Can Microsucks make this any more complicated...
It's a FREAKIN' DBX file collection
NO - No other Application has it Open.
YES - The Files ARE there
YES - the Internet Account IS there
Yes - I've wasted more of my time IMPORTING into Outlook Express in
VISTA just to RE-EXPORT back to Outlook. What a bunch of freakin'
Another 2 hours wasted - because one Microsoft applica...Outlook Live 2003 re: reply to msg sent to different e-mail account
Issue: I want a different e-mail account to display to recipient
I'm just subscribed to Outlook Live and using Outlook 2003. I simply
want to configure Outlook 2003 as I have my Outlook Express configured
(ie receipient sees the same "reply to" e-mail address no matter which
e-mail account I use to send the original e-mail). For my POP3
account, I easily configued Outlook 2003 to work using a different
"reply to" address. However, for the Hotmail account (http radio
button) I don't have the same options available to change the "reply
Rev...Backing Up Outlook #5
How do I backup copies of all mye-mail folders? Hod do I
backup all my contacts within the address book?
You can do a total backup of your Outlook PST file using
a back up program in Outlook.
To download the ad in go to
If you have trouble email me at firstname.lastname@example.org
>How do I backup copies of all mye-mail folders? Hod do
>backup all my contacts within the address book?
"Damon" <damo...Two instances of outlook 2002 on the same desktop.
I have two sets of accounts that I manage with my
outlook. I would like to be able to run two copies of
outlook, each working on thier own set of accounts. Could
any one help me understand how we can do this , please?
I would appreciate any help.