upgrading the OS on Exch2003 box
I have successfully upgraded Exch2000 to 2003.
The OS is still Windows 2000 Server.
Now I'm ready to upgrade that box to Windows Server 2003.
Is there anything special I should note before upgrading, or is there
a specific document which addresses any known method or problems ?
"chrism" <chris@no_spam> wrote:
>I have successfully upgraded Exch2000 to 2003.
>The OS is still Windows 2000 Server.
>Now I'm ready to upgrade that box to Windows Server 2003.
>Is there anything special I should note before upgrading, or is there
>a...Finding characters within a text
How to check, using single formula, that a text within a certain cell
contains one of certain characters? For instance, how to check if there is a
'R', 'L' or 'Ps' character within cell A1 that reads 'W-RII'.
Thanks in advance
Hmm..not very elegant, but maybe
Returns TRUE if the text in A1 contains 'R', 'L' or 'Ps' .
FIND is case-sensitive, use SEARCH if you also want to find lower-case
Joerg Mochiku...Shrinking Text
in our Office (Word) 2007 application, WTS 2008x64, the following happens
(for some - not all- users):
A text is written and formatted normally and without any problems.
The document shall be printed. After the printjob is executed, the chracters
of the text lines are compressed to only a few millimeters in width. The
font height remains normal. Nothing is legible. This now ocurs on the
printed doc as well as on the screen. After the doc is saved and opened in a
different session, everything is OK and works well...
What can I do?
As always, every help and ...Centering text on a page
Is there a way to center text automatically in a row across the top of the
page without having to pick a column that is close to center, then using the
space bar to find the exact midpoint?
Select the cells across your page
Format > Cells > Alignment
Place check in "Merge cells"
Horizontal and Vertical drop downs should be set at Center
There is a standard toolbar button for this. Use:
View > Toolbars > Customize
Look under Format for the Merge and Center button
Click and drag it to your toolbar.
Norman Harker MVP (Excel)
Sydney, A...Text Effects Scrolling or Blinking text
How do apply the scroll or blinking feature to text that you want to
emphasize in a word document. Prior to MS2007 there was a feature on the
fonts tab that allowed a user to apply the following features to text
"marching ants, blinking text, scrolling marquee, etc. I cannot find the any
of these features anywhere in Word 2007. "HELP"
There is no direct access to them, but they are still available by macro
I posted the following macro recently, for use in Word 2007
Dim sAnimation As String
If Len(Selection.Range) = 0 Then
MsgBox "...Text to columns
Once I use the Text to columns feature in Excel, it seems there is no way to
turn it off.
Anyone know if there is a way to reset this so that newly pasted text will
not continue to get broken up (for example by the space delimiter)
Presently the only way is to exit Excel and restart Excel - then pasted text
all goes into one cell regardless of spaces.
Hope I explained that well enough
I may have been to hasty in making this assumption, it appears that the
problem I described below is only happening on one workstation - this may
indicate that the Excel Registry keys are in need of...What is 'Align Text to Base Line Guide'?
Trying to make sure all lines have the same amount of space between them I
selected paragraph from the format menu and under the line adjustments there
is a box 'align text to base line guides' Ok I did that, now there are lines
at the margines of my newsletter. What are these? Also selecting this pushed
my text down from the top edge of the text box. What is this?
The baseline guide measurements are in the Arrange, Layout Guides, Baseline tab.
There is help in the Help menu.
"Go_Girl3647" <GoGirl3647@discussions.microsoft.com...Report Writer Text Spacing Problems While Modifying a PO form
Due to Report Writer static text field size limitations, I am forced to try
to use two adjacent text fields to complete a sentence. I am having an
inordinate amout of problems trying to get words to align in sentences with
the correct amount of character spacing between words that span the text
field boundaries. And, the process of toggling between Report Writer and
Dyamics to get the Purchase Order form to reprint is time consuming. What am
I missing (besides patience)?
1) Setup a calculated field for your static text. Set the result type to
String, and use the Constant...How can I clear the last Data->Text to columns to formatting
I've noticed in Excel 2000 that if I paste text into various worksheets
within a workbook each paste will assume the Text->Column formatting that I
applied in the previous. How can I prevent it from happening ?
Just run another data|Text to columns against a dummy cell.
Specify delimited, but remove all the check marks from all the possible
(alternatively, you can close excel and reopen it.)
> I've noticed in Excel 2000 that if I paste text into various worksheets
> within a workbook each paste will assume the Text->Col...How to write a new entry in a combo box to its underlying table
Dear Access 2007 VBA Gurus,
I have a assets database (rather uncreatively named "Assets"). I use a form
(named "Asset Acquisition Input Form New") to enter new assets. The
"Manufacturer" field (combo box name "Manufacturers_ID) on this form is a
lookup to a Manufacturers table. What I want to happen is when I enter an
item that is not in the lookup list, I want a message box to prompt me to add
the new entry to the underlying table, or to cancel and select an item from
the list. I have no trouble with the MsgBox command itself. What I don&...How do text capture tools work?
Here are two examples of this technology.
Sounds like they will have to involve OCR, which works fine for standard fonts but
probably won't work with fancy fonts. Key here is to test them try a static control with
a TextOut and change the fonts and see what happens.
On Wed, 31 Oct 2007 15:02:04 -0500, "Peter Olcott" <NoSpam@SeeScreen.com> wrote:
>Here are two examples of this technology.
> http://www.deskp...Ordering by number and text
I use a report to print out checklists that in the detail section have item
number to delineate each checklist item. The item numbers as an example are
1-1, 1-2, 1-2a, 1-2b, or 2-1, 2-2, 2-3, 2-3a, 2-3b and so on. The report is
grouped by checklist section and the grouping works perfectly but when the
report is printed the item numbers are ordered in this order 1-1, 1-10, 1-11,
1-2, 1-3, 1-3a, 1-3b, 1-4, 1-5, 1-6, 1-7, 1-9.
Obviously I want the the order to be in proper numerical sequence where 1-10
comes after 1-9. but even replacing the '-' with a decimal point doesn't
...E-mail box sizes. Echange System Manger.
Now and then I need to find out the size of the various e-mail boxes in
Exchange2000. The problem is that the size indicated in the Exchange System
Manager do not reflect the same size when you look into Outlook.
Is the a way to figure out the correct e-mail size?
If not. Is this better in Exchange2003?
Thank you in advance.
I'd consider the Exchange value to be the most important given this is what
will be used for mailbox quotas, etc.
"Dag N" <firstname.lastname@example.org> wrote in message
> Now and then ...Spiral text
Does anyone know how to create spiral text?
In a draw program for sure. You probably can get close in Publisher, but it will
not look as good as a draw program can do.
Serif has a free program you can try. DrawPlus
Mary Sauer MSFT MVP
"jaykay" <email@example.com> wrote in message
> Does anyone know how to create spiral text?
I've downloaded the program, but can't figur...Email Text Dissappears when Save
When we save email messages (as a draft) the text dissappears, even when th I
use my administrator account. Anybody have any idea what that is happening.
...obtaining data in text form from a table
I like to be able to obtain the dates in a text format from the table
Test6 4-Feb,5-Feb, 9-Feb
Do I need to do this by macros and if so, any help would be appreciated.
Care Recipient Surname 4-Feb 5-Feb 8-Feb 9-Feb
Test5 4-Feb 8-Feb
Test6 4-Feb 5-Feb 9-Feb
Vlookup should do what you want, as in:
Adjust the ranges t...Count the text in a column
I would like to count the text in a column then for it to add a figure in
another cell if it meets the text criteria
Do you mean count the characters?
as an array formula (committed with Ctrl-Shift-Enter)
(remove nothere from the email address if mailing direct)
"Peter Curtis" <PeterCurtis@discussions.microsoft.com> wrote in message
> I would like to count the text in a column then for it to add a figure in
> another cell if it meets the t...Converting number to text
Is it possible to convert, say 1234 to one thousand two hundred and thirty
There is no direct functions to convert this. For a VBA solution check out
the below links
Jacob (MVP - Excel)
> Is it possible to convert, say 1234 to one thousand two hundred and thirty
...How to return the primary key from a combo box
I have a table containing two columns
Column 1: Primary key
Column 2: Name.
I want to create an unbound combo box that shows the name but returns the PK.
I have these properties set:
Control source: <is empty>
Row source type: table/query
Bound column: 1
Row source: <I have a select that returns the desired records>
In cboClient_AfterUpdate() I look at debug.print cboClient.Value and I see
the name. I need the PK so I can construct the query for the next combo box.
How do I get the PK
Thanks for the help
Message posted via http://www.accessmons...Simple Yes/No drop down box
Hi, I am looking to create a simple drop down box which has yes or no as the
options. For the life of me i can't remember how to do it.
Select the cell and then click on Data | Data Validation. In the
dialogue box for Allow click on List, and then in Source you can type
"Yes,No" (without the quotes) and ensure that In-cell drop-down is
checked. Click OK and then you have it.
Hope this helps.
On Apr 21, 9:41=A0am, Debi <D...@discussions.microsoft.com> wrote:
> Hi, I am looking to create a simple drop down box which has yes or no as =
...creating nested formulas from drop down box
Hi, I have cell A1 with a drop down box containing 26 available choices. B1
has the dollar amount matching to the choice in A1 using vlookup. E1 totals
several cells including B1 together. I want F1 to look at A1 and either
enter the number from E1 or NA. Here's billing example:
A1=January , B1=$5 ,C1=$10, D1=$1, E1=$16 (total of b-d1)
F1 is the column for January
G1 is the column for February
H1 is the column for March, etc
If A1 = Jan, then F1 should be $16
If A1 = Feb, then F1 should be NA or $0
This is the formula that has been working so far:
=IF((G2="...Setting Text in a ComboBox
Hi, Does anybody know why I cannot set the text in the
edit control of a CBS_DROPDOWN style CombBox control
I was able to change the text in the edit control part of
the ComboBox manually.
I don't know why can't you? Post some code. You should be able to
"Vincent Yu" <firstname.lastname@example.org> wrote in message
> Hi, Does anybody know why I cannot set the text in the
> edit control of a CBS_DROPDOWN style ...anchor picture to text box
(Publisher 2003) I have a newsletter with a Kudos box. In the corners of
the box I have a happy face. I'd like the happy faces to be anchored to
their corners so when I enlarge or shorten the box, the faces move along with
the text box.
Why not create a rectangle, insert the happy faces, group. The problem as I see
it would be if you resize, the happy faces could be distorted if you widen or
shrink the group. You would always have to re-size proportionally.
"Helen" <Helen@discussions.microsoft.com> wrote in message
news:193...Limit number of characters in a cell
Is there a way to limit the number of characters that a user can key into a
I want to get a list of names and addresses imputted by user, but I don't
want them to be more than 35 characters.
Thanks for the help
Take a look at Data|Validation.
You can have excel yell at the user when they hit enter after typing in a
Dr Senji wrote:
> Is there a way to limit the number of characters that a user can key into a
> I want to get a list of names and addresses imputted by user, but I don't
> want the...Text Ticker
i was asked to do a simple project
1-want do a text ticker can be scroll left to right and right to left
4-has a background image
please where can i start and how to do it
BitBlt background to offscreen bitmap
TextOut to the bitmap with appropriate offset and clipping region
BitBlt offscreen bitmap to client area of screen
Use a subclassed CStatic
On 18 Aug 2006 20:59:22 -0700, "Prafulla T" <email@example.com> wrote:
>i was asked to do a simple project
>1-want do a text tic...