Field1 or Field2 must be null
Is it possible to set a constraint on a table across two fields such
that one of the pair must have a value and the other be null?
Dan Neely wrote:
>Is it possible to set a constraint on a table across two fields such
>that one of the pair must have a value and the other be null?
You can use the table's Validation Rule:
[f1] Is Not Null Or [f2] Is Not Null
MVP [MS Access]
On Tue, 12 Jun 2007 10:21:03 -0700, Dan Neely <email@example.com> wrote:
>Is it possible to set a constraint on a table across two fields such
>that one of the pair must have a value...owa not displaying messages
when using ie6 owa is diplaying the folders ok but the 2 panes for
viewing the messages and viewing an individual email content is blank
with 'loading.....' message in one of the blank panes. It never
actually loads anything into these 2 panes.
Am using IE 6, sp2, xphome, msoffice 2003
mozilla firefox 1.5 and opera 9 display ok.
it's a problem with the active x control - try deleting the control and
clearing the cache (from IE's tools, options dialog) and restarting the
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Is there a way to get and display the version of Excel the user has?
Thanking you in advance,
Fable's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2185
View this thread: http://www.excelforum.com/showthread.php?threadid=263941
also do a search on info in help.
there are some other goodies there too.
>Is there a way to get and display the version of Excel
the us...Modifying the Display Name
Here is what I'm trying to do:
We have a group of contractors that work onsite and we want to be able to
make it clear when they send email internally or externally that they have
In other words, when John Brown (an employee) sends an email, external
recipients see "firstname.lastname@example.org" and internal recipients see "John
When Jack Smith (a contractor) sends an email, recipients should be able to
tell somehow that he is a contractor. Something like email@example.com
(contractor) or Jack Smith (contractor).
I think i can ...I am getting an message saying"you must be an Adminstrator to...."
I am getting an message saying"you must be an Adminstrator to install Office
2007". Can someone please let me know how do I resolve this issue.
It means you must logg on to win using an account that has full writes
What version of win?
"D" <D@discussions.microsoft.com> wrote in message
>I am getting an message saying"you must be an Adminstrator to install
> 2007". Can someone please let me know how do I resolve this issue.
Log on to the computer as the administr...Display System Time in Smartlist for transactions.
The main user for our bank transactions needs the system time to appear on
the Smart List Bank Transactions lookup. What he sees now is 12:00:00 for all
transactions. I was told that the system time has not been connected to any
transactions yet, so that's why I'm asking for all transactions to have the
time stamp connected to them. The 'time' audit trail for us is just as
important as the date trail and I would think that any Great Plains user who
has let's say multiple batch bank deposits made during the day would want to
see the time entered in Great Plains as com...Excel does not display all of an axis label
When creating a scatterplot in Excel, the y-axis label doesn't display all
the characters. The last character is not shown, or in some cases only the
left half of the character is displayed. I have tried the setting the auto
text sizing on and off, with no effect. This is a recent problem that I have
not had with previous charts. Now, every plot has that problem.
Occassionally using a shorter label fixes the problem, but not always.
Bolding the font seems to prevent the problem. Trouble is I've got lots of
charts without bold and don't want to go back and change them ...Send/Receive doe not work... I can send but not receive in Outlook
I have my Yahoo (pop3) account set up in Outlook and have done for some
time. It has just decided to stop retrieving my incoming mail, however
I can still send mail through outlook. It is set up to leave a copy of
all messages on the yahoo server so I can access this through Outlook
on my office compuer also - this works fine.
The problem is with Outlook on my home PC. When I hit Send/Recieve
nothing happens, not even an error message. Can anyone help? I can't
find anything online.
Thanks a mil!
What kind of service do you have? I'vehad problems like that with
Verizon DSL, but...Must display as: send on behalf of XXXXXXXX
I hav exchange 2003 and xp pro clients. The PA has the right to send on
behalf of the GM but in the From: field is showing that the mail comes
directly from her which they don't want. How can i change this so that it
display : On behalf of the GM(the name of the name)
On Thu, 18 May 2006 22:56:01 -0700, Craig from Huguenot
>I hav exchange 2003 and xp pro clients. The PA has the right to send on
>behalf of the GM but in the From: field is showing that the mail comes
>directly from her which th...Invalid Item id
When invoking the Send method for the CRMEmail class, I get the following error back
<detail><error><code>8004020b</code><description>Invalid item id.</description><file>D:\crm\Build\3297\src\platform\include\OMCommon\OMSecurity.inl</file><line>1109</line></error></detail>
I did see the earlier posting about eliminating white space in the XML attributes and that isn't a problem with the XML being submitted
<emailactivity><mimetype>text/plain</mimetype><messagesubject>New Ship Del...Send to Mail Recipient Responds very Slowly
Within Word when choosing Send to Mail Recipient the system is very slow.
This also happens in Excel.
If the user is in Outlook and attaches a Word or Excel document it is fast.
...Send As won't work - Exchange 2003
I am trying to get the "Send As" privilege working and have followed the
instructions in MSKB 327000.
But I keep on getting the error:
"You do not have permission to send to this recipient."
I have also set up both users with full permissions rather then just the
Send As....but still no joy.
Domain Admins have no problem doing a Send As someone else.
Any help would be gratefully received.
...email sending errors
I have sbc yahoo dsl. just got it. I have intermittent
sending and receiving errors. Sbc says Outlook maybe the
problem. Has anyone had this problem with Outlook.
According to most reports and my dealing with them, SBC has very little idea
what they are doing. Outlook could not cause intermittent errors, it either
works or it does not. Tell SBC to do a loopback test on your line with and
without your modem. Or try to get them to change the routing circuit. Most
likely you have noise on your line that is messing up the DSL signal.
One thing, you do not have any of the filters or surge...Cell entries display problem.
A10 is Sum(A1:A9). When I enter values in these cells, cells A1, A2, A3,
and A4 do not display values,however, the values is there!A10 shows
correct sum and the values appears on the print screen. How have no
idea how this happens. Please help!
Thanks in advance!
Message posted from http://www.ExcelForum.com/
Couple of suggestions.
1. The Font is formatted to White(no color is default)
2. You have Custom Format of ;;; for those cells.
Gord Dibben Excel MVP
On Tue, 13 Apr 2004 17:11:55 -0500, Kim-Anh Tran
>A...How to display Account Summary report in iFrame
we need to display an account and all related records for activities and
notes in a single form
As the Activities tab in Account does not show Notes content, we think of
using Account Summary report in an iFrame
How could we bypass entities selection dialog and go straight to View Report?
Could URL be populated at run-time during OnLoad event?
Thanks in advance
If you take a look at the c360 site they do an add-on called 'Summary'
(http://www.c360.com/Summary.aspx). This displays all activities and also
notes/attachments in a single screen.
"Patrice M."...Cannot send e-mail 12-12-09
I get the message- The host 'STMP' could not be found. Please verify that you
have entered the server name correctly.
Please post the error message in its entirety. You can left click on it to
highlight and then right click to copy and then paste it into this thread.
Imperial Beach, CA
"Frank Brasacchio" <FrankBrasacchio@discussions.microsoft.com> wrote in
>I get the message- The host 'STMP' could not be found. Please ve...CDateTimeCtrl to display UTC
Ok, the problem is this; I am using a pair of CDateTimeCtrls one for
the date and one for hours/minutes/seconds. The problem I have is that
I need to work in UTC - all my internal calculations are using time_t
and the times shown to and selected by the user must be in UTC. I'm
getting into problems as the controls adjust for local time which I
don't want. I think I need to detect if an offset from UTC is in
effect and add/subtract that ammout when setting / reading from the
This is getting a bit ugly - can anyone think of a more elegant
I don&...Pub2002 Can I display 2 different files at once and edit between t
I want to condense a 50 page Pub 2002 document into a separate new file.
Rather than starting from scratch, can I display the old file and the new one
side by side on the screen at the same time and drag and drop between them?
If so, how?
Hi thosdew (firstname.lastname@example.org),
in the newsgroups
|| I want to condense a 50 page Pub 2002 document into a separate new
|| file. Rather than starting from scratch, can I display the old file
|| and the new one side by side on the screen at the same time and drag
|| and drop between them? If so, how?
Yes....OK, I must be retarded or something...
OK, I must be retarded or something. I am having the hardest time setting up
POP3 mail for external users. When I do, eithe it halts all mail with no
immediate return messages or it only allows delivery from an internal user
to an internal user. I obviously do not want to have the relay open. That is
understood. Here are the latest sub-genius steps I have done with no avail.
Exchange 2003 over 2003 native\native AD domain
All done under properties of <Server>\SMTP:
1. Accesss tab, Authentication button. Anonymous unchecked, Basic
Authentication checked, and the default domain is listed...Want to hide formula bar when displayed on the browser
We've developped a system that generates an Excel file that is
displayed on the web. Our only problem is we want to prevent the
formula bar from showing up in the browser. Since the system is part
of a highly secure Intranet network, we can't use a macro to hide it
when the file is opened. Is there anyone somewhere with an idea?
We publish on our intranet by copying the workbook to the require
If the formula bar etc. is removed via the Options menu before the fil
is saved locally this is reflected in the intranet copy
Message posted from http://www.ExcelFo...There must be a way...
I've got a quick question that's been bugging me for a while. If I'v
got data arranged by columns, but I've written a formula which I wan
to drag right (i.e. rearrange the calculated data into rows), then ho
can I write a formula so it will just copy over?
The problem is that normally when you copy a formula to the right i
will increment the column letter by one each time while keep ing th
row number referenced in the formula the same. Instead, when I copy i
to the right, I want the column letter to remain the same and the ro
number referenced in the formula to ...Default Contact list when sending email
When I send emails and I select NEW and then select TO.. the list defaults
to my global address list.
I need it to default to CONTACTS.........
can this be done?
Can you specify your Outlook version so we can tell you how?
"SamMJlo" <SamMJlo@discussions.microsoft.com> wrote in message
> When I send emails and I select NEW and then select TO.. the list defaults
> to my global address list.
> I need it to default to CONTACTS.........
> can...Displaying multiple images
You do it the same way as with one picture, but with anotherone instead :-)
To be serious, if you blit the picture, you just load anotherone an blit it
in another position. If you use some kind of picture control (such as a
static), add another one. Actually, the question is a bit too g...can't send mail from 32 Bit applications with office 2010 64 bit R
after installing Office 2010 64 Bit (RTM)
32 Bit applications can not send mail any more.
Messages like this open in a dialog box:
There is no email program associated to perform the requested action. Please
install an email program or, if one is already installed, create an
association in the Default Programs control panel.
Outlook is set as default which is also reflected in the corresponding
registry keys like HKLM\Software\Clients\Mail and
...must I include stdafx.h?
I am trying to use a couple files in two different systems, one of which
being an MFC project. What is the best way to write a fairly portable cpp
file? When I bring a certain cpp file over to my MFC project, it initially
will not compile because it doesn't have #include "stdafx.h" at the top. I
thought about adding something like this to the top of the file:
so that MFC would be happy, and my other system would not complain about not
being able to find stdafx.h. However, this does not compile either: "f...