Too large incoming email
My college has received a *large* email which now is
jamming her Inbox. She can select it but not do anything
(view, delete,...) with it. What to do?
Can you edit the Inbox somewhere outside Outlook?
...VBA Text Color
I would like to change the text color to Red for a string being returned to a
window through vba when certain conditions are met.
I can see the vbRed control but cannot get it to work, Object Required.
Has anyone been able to change the text color through vba, and how is it set?
I don't believe VBA can directly change the colours on a Dexterity field or
window. You can use the unsupported but very useful method of pass through
Dexterity SanScript to change the colour of the text or the background.
I think you already have the company background colour VBA example. I...Can't have a null value if another field has text.
I have tried a few different things to try and get this to work, but I
can't seem to figure it out. Basically, I have a form with some text
boxes linked to fields on a table, and I want one of two things to
happen (the first one would be preferred, but if that's not possible,
the second would be just as good):
1) If Field 1 is updated to a Null value and Field 2 has text in it,
move the text from Field 2 to Field 1 and change Field 2 to a Null
2) If Field 1 is updated to a Null value and Field 2 has text in it, a
message box pops up that essentially says "You can't do ...Excel hart has OLE onject errors in Access 2007
I am trying to build a chart on a form in Access 2007. I have already
created it in Excel and want it to look the same but it seems that the
formatting options are greatly reduced, fewer chart options, and formatting
variations in Access.
I tried to copy and paste the chart from Excel 2007 onto my Access form, and
gave it the query as the data source but got messages "The operation on the
OLE object failed. The OLE server may not be registered. To register the
OLE server, reinstall it."
If I remove the name of the query I get an identical chart to the one in
Excel, ...Excel 2000 #4
I have a filled series of numbers that are relative. How do I change them to
Do you that they are produced via formulae?
(remove xxx from email address if mailing direct)
"billytre" <firstname.lastname@example.org> wrote in message
> I have a filled series of numbers that are relative. How do I change them
No Bob, Just a straight fill by dragging.
"Bob Phillips" wrote:
> Do you that they are produced via formulae?
&...Change link between form and subform
I have a form with a subform in it.
I would like to change the way they are linked so instead of linking from
Old ID, they link to New ID
I don't know anything about code, is there a way to just change the cell it
Bring up the properties of the subform, and change the values in 'Link Child
Fields' and 'Link Master Fields' on the Data tab of the properties dialog
box. Make sure you have the subform selected, not the form within the
> I have a form with...email text missing when sent
I compose an email within Outlook and send it. The sent
email only contains the first character of the text. The
recipient of the email does receive it, but with only the
one character in the text. When I look at the copy of the
email in my Sent folder, the text only has one character.
I repeated the process several times with the same result.
The above was done with my Options set to Rich Text. When
I change my Options to use HTML, everything is sent fine.
This problem just occurred yesterday. I've been sending
emails without problem for months. I didn't change any
I am trying to link and .slk file to a .xls file all the
links appear to be updating but i keep getting a message
that excel cannot update 1 or all of the links. Is this
common when linking with an .slk because i have several
linked wrk books and have never had this problem.
...Formulas coming up as text
Formulas continue to appear as text and will not calculate. how to get
formulas to always calculate.
If your formulas appear as text, then you need to first clear the cells
before entering formulas. Select the cells, hit Edit-->Clear-->All. Save the
file, format the column as General, and try again.
"cheryl" <email@example.com> wrote in message
> Formulas continue to appear as text and will not calculate. how to get
> formulas to alway...Linked Forms
Hello, I am doing a project that requires two forms.. The first form
contains the data for a business the second form contains data for the
How do I link the two forms together...?
Send a common key piece of data from the first form (say the company name) to the second form page and include it in the second form
as a hidden form field
(then if using a database to store the results link with a relationship the 2 results tables by the common field)
For form passing information see http://irt.org/articles/js063/index.htm
____...Can I insert Auto Text of Last Updated in Excel 2003?
Can i do the above on a sheet or in a Header/Footer?
Using a macro yes
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
"jess_steven" <firstname.lastname@example.org> wrote in message
> Can i do the above on a sheet or in a Header/Footer?
...Right-Click in Excel 2002
My right mouse button is set to "select" a cell. How can
I change it to bring up the menu that allows me
to "delete" "insert" rows/columns?
I was accustomed to this feature in my previous version of
Just in Excel, or in all applications? Look at Start, Settings, Control
Panel, double-click Mouse, and change settings there as appropriate (like
possibly you have button configuration set to "left-handed." Change to
"gambersh" <email@example.com> wrote in message
news:04d301c381fa$c4b72590$a301280...Text on cart based on data in a cell
I have a chart on a separate sheet witch is based on a filtered list on
another sheet. I would like to label my chart to show witch filter as been
applied, is this possible? (Ho, and if so, how would I do it?)
Thanks for any help.
Select the chart, press the equal key, then select the cell with a
mouse. This adds a text box in the middle of the chart, which you can
move around and format as needed.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
> I have a chart on a separate s...Links not linking
I have written a fairly big spreadsheet linking through the pages with SUM,
SUMIF and SUMPRODUCT formula's
What I am now finding is that when I update one page it doesn't update the
rest, even if I am only typing in a figure to the SUM function.
I have check and the calculations function is on automatic.
is there a fix or something that I could run to make sure that all the
formulas are working correctly.
Just a guess (since you already checked tools|options|calculation tab).
How about selecting all the cells (ctrl-a (twice in xl2003)) and then
what: ...Find/replace with different text colour messes up
When doing a Find/Replace on a certain word that needs to have a different
colour than default - say, red - Excel incorrectly colours the whole cell
instead of just the word that was searched on.
To see this in action, try this:
1.. Open up a blank Excel sheet
2.. Enter some text in a few cells - "This is a test", for instance. Now,
let's try to use search/replace to colour only the word "test" in red.
3.. Open up Search/Replace
4.. On the "Search for"-line, enter: test
5.. On the "Replace with"-line, enter: test
6.. For the "R...Linked Table Manager in ACCESS
I am trying to change a field in an ACCESS table and get an error message
that says the table is a linked table and fields can't be changed. After
googling for some answers, I think I should be able to find out the link
using "Linked Table Manager" in ACCESS. However, the "Linked Table Manager"
button is grayed out. Any ideas/suggestions are welcome.
Open the table in Design View. Reduce the window so that you can see the
window's top bar. Right click in the top bar of the window (usually blue in
color) and select ...to use workday function in excel vba code
is there a way to use wrokday function in my worksheet controls.?
i have a date time picker in my worksheet and a text box and a button.
on click of this button i should get next desired date.
like when i select a date from the calendar and click on button ther
is onclick function in my macro.
this onclick should calculate next desired date(assume if i choos
10/11/2005 and add 2 to this date i should get 12/11/2005)
i know how to use workday function using a cell reference
i don't know how to put this into a vba code.
if i use workday("10/11/2005&qu...Word as a Text Processor in Outlook w/ Exchange
Sice I set up a new Microsoft Exchange Server account in my Outlook 2003
SP2, I can't use any more Word as a text processor to write my e-mails.
I only have the HTML option.
So I don't have the nice Word feature (real time spell checking, etc.). Too
Any idea? Is there something I missed to set up on the Exchange Server?
Check from within Outlook. Tools/Options/Mail Format and make sure you have
the option to use "Microsoft Office Word 2003 to edit my email messages"
"Nicolas Macarez" <firstname.lastname@example.org> ...Adding a control line to excel chart without showing up in the leg
How can I add a control line, (such as average, ucl, lcl), to an excel bar or
line chart and not have the control line series show up in the chart legend,
or data table?
Any sugestions would be greatly appreciated.
On Sat, 15 Sep 2007, in microsoft.public.excel.charting,
TWeaver <TWeaver@discussions.microsoft.com> said:
>How can I add a control line, (such as average, ucl, lcl), to an excel bar or
>line chart and not have the control line series show up in the chart legend,
>or data table?
Single-click twice on the legend entry for the control line, and ...Link To A Cell From Chart
I have a text box in a chart worksheet. Can I link it to an information from
any cell in other worksheet in the same workbook.
Yes. Click the text box icon, then click on the chart sheet to insert the
text box. Click in the formula bar and =Sheet1!A2 (or whatever cell you want
Greeting from the Gulf Coast!
"Salza" <email@example.com> wrote in message news:firstname.lastname@example.org...
> Hi all.
> I have a text box in a chart worksheet. Can I link it to an information
> any cell in other worksheet in...Excel 97 tabs
Is there a way to change the fonts and/or background
colors on the Excel 97 file tabs?
This was established in Excel XP
"SS" <email@example.com> wrote in message
: Is there a way to change the fonts and/or background
: colors on the Excel 97 file tabs?
...Text Wrap #2
Is there anywhere in Publisher that i can customise my preferences? I would
like to change the default settings for inserting an image to no text wrap.
This is a time consuming process everytime i insert an image (right click,
format object, layout tab, wrapping style "none", ok), would be so much for
efficient for me if i could change the default settings so that the image
came in like this when inserted (currently the default wrapping style is
"square"). Any ideas?
It is very critical for my business to learn the basics
and the backbone of links in Excel. Are there any
tutorials or articles that gives wealth of information
about MS Excel links? (in Excel 9.0.6)
Web addresses are also welcome.
You can also post to my e-mail above.
Thank you in advance.
I would advise you go to the newsgroup "microsoft.public.excel.links", and
read everything you can about their troubles there and the
Vaya con Dios,
"Mustafa" <firstname.lastname@example.org> wrote in messag...Thank you microsoft.public.excel.charting
The following is an excerpt from the acknowledgments in my forthcoming
book, Just Plain Data Analysis [the companion web page is here:
"To prepare the tables and charts in this book, I acquired near
mastery of the 2003 Microsoft Excel charting software and considerable
experience with the 2007 version. Excel is much more powerful than a
counter sorter, but the frustrations are the same. My masters in my
quest to earn a black belt in Excel charting were the regular
contributors to the microsoft.public.excel.charting newsgroup: Rob
Bovey, Debra Dalgleish, Shane ...Right clicking on text does not bring up hyperlink option
I want to add a hyperlink to another area in my Excel workbook.
On one sheet when I right click on text that I want to add the hyperlink to,
I don't get the hyperlink option. It has the following:
insert page break
reset all page breaks
set print area
reset print area
There is no hyperlink option. Any ideas? Thanks in advance.
The cell menu (the one you get when you rightclick on a cell) is different if
you're in View|Normal or View|Page break previ...