I have two tables: issues and position.
The issues fields are populated with the lookup value from the position table.
I want a query that will count each "oppose" and each "support" for each
issue in the issue table.
I tried the DCount like this in the criteria for the issue I'm trying to
and get an error that says "can't find the 'field' you entered in the
Your help is much appreciated! thanks.
Do you have a field named "Field" ...Place Date in One column when entry is made in another column.
Column J cells of my spreadsheet will contain cash contributions made by
certain individuals. When a dollar value is entered in cell J5, I would like
to have the date of the entry automatically entered in cell k5.
Am unable to figure our a function to handle this. Any help is appreciated.
Microsoft Excel MVP
"JT" <JT@discussions.microsoft.com> wrote in message
> Column J cells of my spreadsheet will contain cash contribu...How can I set up a shared excel worksheet and work offline
I have a group of laptops on a windows 2003 network. I have set up shared
Excel Workbooks to allow users to modify different worksheets at the same
time. I would now like to take this a step further. I want to allow two or
more uses to take a copy of the shared workbook away from the offce with each
user being able to work on their part and then be able to save them back to
the network with all changes being saved. I was hoping the "make available
offline" feacher would work but it seems that it will not.
Please give any suggestions of workarounds or other software that ma...Calling stored procedures from another one
I'm trying to achieve an architectural design in my application and its
backend database that allows an object oriented design, granularity and
I recently came up with an idea that seems to help me accomplish these goals
but want to get some feedback.
The goal in this particular case is to take care of business with a single
I was trying to come up with an architecture for registering people. The
problem is there are different types of people e.g. Clients, Employees,
Each group has common elements as well as their ...Intercepting Messages
How do I catch the message that you get when you insert a new usb stick into
a machine? I am trying to catch the message that says, "found new device and
need to reboot to complete installation". Is this possible?
You could start here...
"Tim Hunter" <TimHunter@discussions.microsoft.com> wrote in message
> How do I catch the message that you get when you insert a new usb stick
> a machi...OWA sends message as HTML script
OWA has been sending an HTML script with all the coding for an individual who recieves and sends message. No other user has this issue, except him. Everything is normal when drafting the message. The messages do not show up as HTML code until after recieved or sent. We are using Exchange 2003. The client browser is IE 6.0 SP1, and OS is 2000 Pro. What could have caused this, and what can we do to fix this. I appreciate the assistance in advanced. Thank
<script></script><META http-equiv="Content-Type" content="text/html; charset=utf-8"><H...Mail from one person not getting through to another
I have a very curious problem. We have Exchange 2000 running on an SBS
2000 server. All of our internal users are in the domain and all but
two of them have Windows XP desktops using Outlook 2000.
The two exceptions are graphics designers who have Mac OS/X machines,
have domain accounts (and mailboxes) and access their email via POP3,
using built-in Mac clients.
The problem is this. One of the Mac users, call him M1, can't receive
any mail from one of the XP users, call him X1. What's perplexing are
1) M1 can receive mail from other XP users,
2) M1 can send mail to all...Setting column labels to letters
I just noticed that my worksheet column labels (across the top) are numbers
instead of letters. Don't think it's always been that way, but I want to
change it now and haven't found anything yet in Tools or Help that
references it. Would someone please point the way. thanks,
Go to the Tools menu, choose Options, then the General tab.
There, uncheck the "R1C1 reference style" setting.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Gene Goldenfeld" <email@example.com>...How do I set-up for tractor feed plant labels in publisher
I do not even know if it is possible ... I have been unsuccessful to date
I am trying to set up my own program to print labels
4.5" long and .5 high
they are tractor fed ...connected to each other top-to-bottom with no space
I want to print 3 small lines in 3 1/2" of the space
I can set up the text part but getting the labels to tractor fed instead of
sheet feed is the issue
Have you tried your printer manufacturer's web site for support? Okidata and others
have pretty good support documents.
This maybe helpful
Page alignment is lost when you print a long documen...Need to copy and match data from one workbook to another workbook
I have one workbook that has book information such as book code, title and
I have another workbook that has the ISBN Number and the amount of revenue
that it has made
I need to look up the revenue by ISBN number on the one sheet copy and paste
it to a different sheet that has the rest of the book information. Is there
an easier way to do this. I was thinking about the index, match formula but I
can't get the formula to work. Any other suggestions? Any help is greatly
Did you try VLOOKUP?
"clc_80" <clc_80@discussio...Repeats messages sent
I send a message and the person receiving it may receive
as much as ten copies one right after the other one. My
outgoing box shows the message there forever, but with a
sent date and time.
How can I make sure it is sent only one time and shouldn't
it go to sent instead of just hang in outgoing.
Occurrs most of the time, not all of the time.
I need to change my keyboard to an arabic setting and I'm told to install
windows xp professional cd rom. HELP, I can't find my cd rom.
"rbrooks" <firstname.lastname@example.org> wrote in message
>I need to change my keyboard to an arabic setting and I'm told to install
> windows xp professional cd rom. HELP, I can't find my cd rom.
I looked around my office and it was not here!
I don't think you left it here.
On Sat, 13 Feb 2010 16:54:49 -0700, "Richard in AZ"...Red "recipient could not be resolved" messages.
Has anyone come across red "At least one recipient could
not be resolved to a record in the system" warning
messages on emails sent to/from CRM? Is this normal?
Composing and sending an email via the CRM homepage..
Create an Activity.. Email, I have no problems.
Composing and sending an email to the same user via
the "CRM Email" button in Outlook, however, differs.
The recipient receives the email, but addresses other
than the recipient are displayed in red username@domain
format, not the normal blue Last Name, First Name account
format. The "recipient coul...Axapta 3.0: Setting the linktype of DataSources at runtime
I have a button on form. It's click-EventHandler contains a line:
CIRTRAStndTourOrderLine_ds.linkType(Transporteinheit.valueStr() ? 3 /*
InnerJoin */ : 4 /* OuterJoin */);
Where "CIRTRAStndTourOrderLine_ds" is the data source generated by MorphX
(CIRTRAStndTourOrderLine) is a table. "Transporteinheit" is a StringEdit.
The behaviour I would like to achieve is, that if I enter something into the
StringEdit it sets the linktype to InnerJoin otherwise to OuterJoin another
In MorphX I set the linktype to OuterJoin (as a default).
The problem i...One click from e-mail and the record opened. How ?
I create a case for example, and automatically it sends an e-mail to X
persons with all the specs from that particular case. Of course it's create
from a e-mail template.
What I need to know is, in that template, can I insert a link, that will
open a new window with the record of that case. (Record of the crm inferface
for that case.)
I've been told stuff about the c360 third-party software e-mail link. But at
my view It's only to give an update about a specific case the person is
working on. Which is not what I'm looking for.
I want the specs of that case, and h...Disappearance of all messages inside the inbox
I wish you could help me out, our corporation network is
under servers, we have about 144 users connected and is
currently using Microsoft Outlook as our e-mail service.
My question is is it possible that everytime there is
power outage all the emails inside our inbox disappears or
was that just an excuse of the administrator. It happened
4x now. What could possibly have happen? anybody knows?
please help me out asap! tnx!
Help us out first.
Version of Outlook? Is this using Exchange? If yes, is mail delivered to
Exchange mailboxes or personal folders? If Exchange mailboxes and th...Error message #88
When I try and send an e-mail I keep getting an ERROR message. I looked all
throughout the site and and didnt see the ERROR message that I received. I
got a welcome message from you too so I am confused.
I really LOVE Outlook and dont want to change back to Yahoo! So if you
could help me out I would REALLY appreciate it.
Thank you much! :)
Mandee <Mandee@discussions.microsoft.com> wrote:
> When I try and send an e-mail I keep getting an ERROR message. I
> looked all throughout the site and and didnt see the ERROR message
> that I received. I got a welcome message ...To schedule a recurring message delivery
I want to schedule a message delivery on regular basis, say 3 times everyday.
I check with Outlook but it seems not for recurring message delivery.
I am running Exchange 2000 server, is there a way to configure on server or
on client side?
Have a look at this link. Hope it helps.
> I want to schedule a message delivery on regular basis, say 3 times everyday.
> I check with Outlook but it seems not for recurring message deli...how do i transfer messages from outlook back online
I opened outlook and all the messages were there. now when i log in to my
xtra account online, there are no messages in the inbox. how do i get them
"november" <email@example.com> wrote in message
>I opened outlook and all the messages were there. now when i log in to my
> xtra account online, there are no messages in the inbox. how do i get them
Unless your ISP offers an IMAP account option, the only way is to forward
them to yourself, after having set Outlook to keep a co...[FIXED] For those with error : "Your Out of Office settings cannot be displayed, because the server is currently unavailable. Try again Later."
We are in the process of migrating from Outlook 2003 to Outlook 2007,
and one user had this error with OL2007.
It appeared that there was a disabled item when running Outlook 2003
(Help, About, Disabled items).
Re-enabling it allowed me to open the OOO assistant (from OL2003).
And then, when I started OL2007, it was OK, I could access it !
Which disabled item was it? Can you be more specific please?
"Luuke" <firstname.lastname@example.org> wrote in message
> We are in the p...counting values in a column
I have different values in a a column that I need to count.
Column A: 2,25,45,52,25,30,2,45,80,60
and I want to count values as follows
<30 = 4
>30 and <60 = 4
>60 = 2
I have tried countif and sumproduct but it doesn't work correctly. Your
assistance is greatly appreciated.
Set up a table in column B1:B4 like this:
where 999 represents a number which is surely higher than the highest value
in column A,
select range C1:C4 and enter this formula:
and confirm it with Ctrl+Shift+Enter (it's an array formul...How to get the "Raw Message"
How do I get the raw message with full headers, etc. in
outlook? In my other mail client, there is a magnifying
glass on the tool bar and this opens up the raw message. I
am getting a lot of spam and rejected messages and want to
see the information on sender and routing that is provided
in the headers but not shown in the normal outlook window.
With the message open, select View | Options
PATRICK REED [Outlook - MVP]~~~~~~
-Microsoft Certified Professional (MCP)
-Have you checked http://www.slipstick.com?
-Please post your Outlook version!
"Benedikte Wh...Writing messages into Outlook's Personal Folders
I am writing an application that imports and exports messages into
Outlook's folders (PST) by using XMAPI from C++ directly. I am not
using CDO or COM. I am fine with reading messages from folders.
But I don't have an idea of how messages are written back into the
Outlook's folders using XMAPI. Specifically, how to initialize and
create a new message, directly using XMAPI functions in C++. Please
guide me on this.
Wrong group. Try posting in one of the MAPI discussion forums -- see
Sue Mosher, Outlook MVP
Author of...cannot print message to another printer
Without opening the message in Outlook .I would like to
print the message on a printer other than the default
printer yet the box to select the printer is greyed out.I
do not want to print in table format, I want to print in
...Your message did not reach some or all of the intended recipients. #5
Some of emails only we are getting the below message, i don't understand why
it is validate 'http://spamblock.outblaze.com/184.108.40.206'
There was a SMTP communication problem with the recipient's email server.
Please contact your system administrator.
<inkdomain.ipcldom.local #5.5.0 smtp;553 Message from
220.127.116.11 rejected - see http://spamblock.outblaze.com/18.104.22.168>
Ink Products Co. Ltd
You are missin...