Change background color of query results from access in worksheet
I have Excel 2007 and selected Date => From Access and then navigated to an
Access DB and selected a query. I chose "Table" view. The query results now
appear in my worksheet which is great. However, I want to change the
background. Right now it alternatives by row between a light blue and a
darker blue. I want the results to have a white background with black
borders but have been unable to change the format. If I go to Home and
select No fill for a color background nothing happens. Is there a way to
change the query results?
Could be the r...Unable to change forecolor
Help please. I cannot change the forecolor of my textbox using
the .forecolor property
I want to change the text color to red if the value is greater than
This is the code snipset:
Me.IncAmtPaid = xIncAmtPaid
Me.IncFirstPay = xIncFirstPay
Me.IncCCPay = xIncCCPay
I do not see where you are trying to use the ForeColor property.
>Help please. I cannot change the forecolor of my textbox using
>the .forecolor property
>I want to change the text color to red if the value is greater than
>This is the co...Can't Send/Recieve
For some odd reason thins morning when I start Windows Mail it claims
are 'No new Messages.WM is set to 'Send and Recieve at Startup.' Also the
Send/Recieve button is disabled.
When I go online and access my email account with my it shows several emails
I was using Windows Live Mail and had problems uninstalling it and
went and deleted the folder for Windows Live 'casue I don't use any of the
Somehow the account got removed.
I recreated it and it's ok now.
Jame...Cannot receive incoming internet eMail
I ahve a win2003 network, with Exchange 2003 running. The DC was down for
about a week, so the email was not working, either. When the DC came back,
email started working, partially.
Now I can send email to outside, but I cannot receive any email at all.
Any idea?? Thanks!
From an outside connection, say your home computer, can you telnet to port
25 of your Exchange Server? Check your Event Viewer on the Exchange Server
for any Errors.
John Oliver, Jr.
MCSE, MCT, CCNA, Exchange MVP
Microsoft Certified Partner
"Rick" <Rick@discussions.microsoft.com> w...Executing change event with out tabbing off from a filed (DEX or VBA)
A field in a GP form, I have my cursor in that field. When I enter
data in to it, I need to split that string and insert the splitted
string in to two text boxes
(I will not be doing tab off from the field).
String which will be entered : 111112
I need to split the string into two strings
string1 : 11111
string2 : 2
As soon as data entry is done the splitting should happen (to string1
and string2). And string2 , ie 2 should be inserted in to a field say
If I enter data and do tab off from the field it is working fine. The
requirement is ,as soon as data is ente...Can an email be read without internet connection?
Am downloading an email to CD, but the computer I need the CD for has no
internet connection at present. Can I read & print the email without access
to internet? This is an HP notebook & the computer I need to read & print the
CD in is an IBM Aptiva 247.
Hula Girl wrote:
> Am downloading an email to CD, but the computer I need the CD for has
> no internet connection at present. Can I read & print the email
> without access to internet? This is an HP notebook & the computer I
> need to read & print the CD in is an IBM Aptiva 247.
Not sure what you mean b...Excel 2003 giving annoying "Send/Don't Send" error when closing
I am accessing an instance of Excel 2003 through a Codegear C++ program I'm
writing. The code looks something like this (not that it really matters all
TExcelApplication* ea = new TExcelApplication(this);
ExcelWorkbookPtr ewbPtr = ea->get_ActiveWorkbook();
// do stuff...
delete ea; ea = 0;
I can connect to Excel and write to it just fine. However, when I try to
disconnect from it and close/delete the Excel application instance, I get an
annoying Excel error message that says, "Excel has encountered a problem and...some emails not coming through since going to exchange, no details on why
Have a user that got 2 daily emails. One from a partner of ours that
was an automatic email sent, with a status of things. Has an attachment
that is a .docr
The other is a daily list of canadian exchange rate. No attachments.
He no longer recieves these emails and ht doesn't get any emails
Check your SMTP protocol logs - are these emails getting to your server at
Are you receiving other emails from outside on that email address? Other
-----------------...cursor has changed from 10pt to 7pt
my document is Times Roman 10pt but my cursor is very tiny, probably 5 or 6pt.
How can i change it?
If this is Word 2003, you have encountered a known issue. Change the zoom
to, say, 500% and then back to whatever you want. That should fix the "mini
cursor" bug (at least temporarily).
Microsoft Word MVP
"Claudia" <Claudia@discussions.microsoft.com> wrote in message
> my document is Times Roman 10pt but my cursor is very tiny, probably 5 or
> How can i ch...Open Spreadsheet--Formatting Changed to Date??
I opened my spreadsheet and some, but not all of the columns on every
sheet in the workbook has changed to a date format. I opened other
spreadsheets and there was no change.
Can anyone explain this. It's a real pain to deal with.
...Text Wrapping and received Emails
I have received an email that has lines in it longer than the page
width and dont wrap. I have tried help and searching here but cant
find a way to have outlook automatically word wrap incoming messages
to fit the text to the window any ideas please?
Are you sure this is a Plain Text e-mail? These should be wrapped
automatically for Outlook 2002 and 2003. HTML messages will be displayed in
the way got formatted.
Microsoft Office and Microsoft Office related News
Also Outlook FAQ, How To's, Downloads and more...
Tip of the month:
-Tips for...Default Email Acct
I have two email accounts at my ISP.
When I send email, how can I select which acct is sending?
Can it be set as a default?
"Numenorian" <email@example.com> wrote in message
> I have two email accounts at my ISP.
> When I send email, how can I select which acct is sending?
> Can it be set as a default?
What version of Outlook?
>"Numenorian" <firstname.lastname@example.org> wrote
>news:d...Sent emails not moved from Outbox to Sent folder
Using Windows Live Mail (Version 2009 Build 14.0.8089.0726) I often find that
sent emails are not moved from my Outbox to my Sent folder.
When first discovering this I would resend the email in the Outbox or query
the intended recipient (with apologies), asking if the email had been
received. In each instance the email HAD been sent, just never moved to the
1) Is there any way I can determine if mail sitting in my Outbox has
actually been sent -- without querying the recipient?
2) Is there any way I can get Windows Live Mail to properly move sent emails
from ...Assigning "Normal" Importance to incoming email
I have the Rules Wizard set up to assign an importance level to
incoming emails which I then group by. The problem is that many receive
a level of "None" even though the Wizard is supposed to give it a
"Normal" level. The "High" and "Low" assignments work fine but for some
reason "Normal" only works sporadically resulting in a few "Normal"
assignments and a lot with "None."
Has anyone found this quirk in their settings?
...Calendar 2000 & 2007 Status of Meeting Attendees Changing
I have a client who has set up a meeting and sent an update and the following
occurs: "once I sent an update, my attendees changed to “optional” from
“required” and the tracking is inaccurate as someone who accepted is not
showing up as receiving a response. Another attendee did not receive the
update at all."
She also is asking whether or not it makes a difference is she uses a
distribution list in her meeting invitation.
Can anyhone shed any light on why this is happening?
...When I insert new pages the fonts on the existing pages change
I have a 28 page document that I am trying to insert new pages into. When I
insert the new pages, Publisher changes the font on all the existing pages -
quite a mess. How can I avoid this??
On Wed, 28 Dec 2005 17:39:03 +0000, Jim wrote
(in article <A9F6706D-208F-4FB4-BECD-70077760824A@microsoft.com>):
> I have a 28 page document that I am trying to insert new pages into. When I
> insert the new pages, Publisher changes the font on all the existing pages -
> quite a mess. How can I avoid this??
Unlink the boxes. If the boxes are linked then the font will change globall...New ISP, no incoming emails....
Hi all, was up late last night VPN-ing into my network, and had to go
to bed after failing to solve this...
I hooked our work up with a new T1 yesterday... from the minute I did,
we have gotten no emails incoming....
We use an exchange 5.5 SP6a server for our email on a NT4 machine
(Please hold all your jokes and MS-doesnt-suppot-that-anymore comments
haha) and a seperate server to relay and filter our emails running GFI
I made all the new DNS and new IP address changes on my firewall, they
configured my new router remotely, I changed all the info on my DHCP
server and can ...Outlook Hangs when checking email addreses with directory service
I'm using Outlook 2000 service pack 3 in Internet Mail Only configuration
Outlook hangs about 75% of the time when looking up an e-mail address in the
university of bristol directory service
however outlook express can look up an address successfully in the directory
service 100% of the time and both outlook and outlook express
have the directory account settings exactly the same.
I would ask for help from the university's computing service but Outlook is
currently unsupported by them.
Any ideas why it hangs?
...can send but not reply mail in outlook 2003
I have a strange problem: I can send but not reply to external mail in
outlook 2003. Anyone have the answer?
"ms" <email@example.com> wrote in news:#tT#qAv9EHA.2568
> Hi there,
> I have a strange problem: I can send but not reply to external mail in
> outlook 2003. Anyone have the answer?
What happens when you try?
Ben M. Schorr, OneNote-MVP
Stockholm Consulting Group/KSG
Microsoft OneNote FAQ:
http://home.hawaii.rr.com/schorr...Stop Excel Changing Format
In Excel I want to just show a date as dd/mm in a cell. Every time I enter
this Excel shows the number in dd/mm/yy format, even when I change the cell
to use the General format. Any idea how I get Excel to show the number as I
Format as dd/mm
"Chris762" <Chris762@discussions.microsoft.com> wrote in message
> In Excel I want to just show a date as dd/mm in a cell. Every time I enter
> this Excel shows the number in dd/mm/yy format, even when I change the
> to...How to copy a missing font to publisher
I am missing the Antique Olive font in Publisher only. How do I get it back?
That font was included with some HP products years ago, that is how I acquired
my copy. Do you have the Antique Olive font in the font folder? If it is in the
font folder it should be in Publisher's font list. Do you have a font manager?
Might be it has lost its path.
Mary Sauer MSFT MVP
"Sharon" <Sharon@discussions.microsoft.com> wro...Looking for help...I can't send e-mail using CRM web client
I'm having a problem with trying to send e-mails vie the CRM web client.
When I try to send the e-mail I get a pop-up with the message in bold
"Unexpected Error" "An error has occurred. For more information, contact
your system administrator". I've checked the event logs, no errors are
showing up in either my CRM server or my exchange server.
I'm lost, new to CRM. Any help or ideas is appreciated.
You could try to add pre-windows2000 account to the administrator group on
the exchange server. Some time that helps
"Marty" wrote:...Font format of rich edit ctrl in dialogs, Help!
I have used a lot of rich edit ctrl in my dialogs (I am sorry that I haven't
use edit ctrl instead) and I found one problem now. The text displayed
initially in the ctrl (set by DoDataExchange()) has different font format
with the text which users type in later. Any experienced people can tell me
the functions to make these two font same? Otherwise I think I will have to
change about 100 rich edit ctrl to edit ctrl besides a lot of codes.
Thank you a lot.
...I can't send or receive email
I have a new computer with Windows XP & Microsoft Office
for Small Business. I have never tried to use my email
account until today. For security reasons, I first
installed Norton Internet security. I then configured my
email account. Everything seems to be working in the
programs except for the fact that I can't send or receive
email. Do you have any solutions?
First disable Norton completely, and try a send/receive. Then get back to
"Arnie" <firstname.lastname@example.org> wrote in message
> I hav...You do not have permission to send to this recipient. #3
I have a user that has multiple mailboxes in different Outlook profiles. One
of her accounts just recently started acting up. When she tries to send an
e-mail from she receive the following message:
You do not have permission to send to this recipient. For assistance,
contact your system administrator.
The wierd thing is that she does not receive this DNR in the same account
she is sending the e-mail to. The DNR comes in through a different account.
My theory is that she is sending an e-mail out from Profile1 and the actual