curving text #2
I'm making an oval sign for my business and the text must follow the curve
of the oval. Can't seem to do it...
Give Word Art a try. The "A" icon on the left side of the screen.
Don - Publisher 2000
"Betty Boop" <Betty Boop@discussions.microsoft.com> wrote in message
> I'm making an oval sign for my business and the text must follow the curve
> of the oval. Can't seem to do it...
I have the an example on my web site. Scroll way down
http://msauer.mvps.org/wo...Split tasks a splitting headache
Inherited another Project IMS. I am noticing right off that the previous
scheduler has been starting tasks without their FS preds completing.
Yeah, it does show up as a spit bar in the gantt chart. But, does anyone
know a way to filter out just task that started before predecessor
completion? I'm dealing with several thousand lines. Thanks.
trailerpup's Profile: http://forums.techarena.in/members/116596.htm
View this thread: http://forums.techarena.in/microsoft-project/1290853.htm
...RMS 2.0 #2
Does anybody know what will be new with version 2.0? Allot of press about
Vista but nothing about RMS 2.0!
This is a multi-part message in MIME format.
They just released updated brochures to resellers last week and I expect =
them to be public near the end of December for either a mid January =
release or heard Friday, maybe February (because of Vista on Jan 30)
Check Point Sof...How to randomly split a whole dataset into two sub-dataset?
At your possible convenience, might anyone please kindly answer my
question? Thank you very much.
How to "RANDOMLY" split the whole data set (n=2000) into two sub
dataset (n=1000; n=1000) in SPSS or Excel?
Thank you very much.
Please take care
zencaroline <email@example.com> writes:
> How to "RANDOMLY" split the whole data set (n=2000) into two sub
> dataset (n=1000; n=1000) in SPSS or Excel?
Create a new variable whose value is randomly distributed. Sort
the data on this variable. Take the first 1000 cases ...Why can't I Export selected cells to tab-delimited text file?
This should be an easy thing to do.
I'd like to set up a "refreshable" text export, in much the same way that
you can set up a "refreshable" text import.
Maybe I'm missing something, but it seems that Excel has little in the way
of Export capability.
Yes, I know there is a slightly more cumbersome way of doing this:
copy - open text file - paste - close text file - click "yes" in save
This macro is fairly simple to implement:
Public Sub ExportSelectionAsDelimitedFile()
Const sDELIM As String = vbTab
Const sPATH As...Update data function across 2 workbooks
My question is, is it possible for data to be ported over 2 workbook
just by clicking on the data on the first one via external links?
For example, I have 2 workbooks - -catalogue.xls- and -order.xls-. Wha
i want is for my customers to be able to look at the items available i
-catalogue.xls-, and when they see an item that they want to order, al
they have to do is to click on it, and the data in that highlighted ro
will be ported over to -order.xls-.
Is such a thing even possible? If it is, how shoud I go abou
constructing such a spreadsheet? What values shoudl I define, etc etc?
thank you...Separating left and right columns of text evenly
I'd like to use Publisher to re-do a menu. How do I keep the menu prices in
an evenly spaced column to the right side of the text box? It would be
similar to creating a table of contents, perhaps?
a table would probably be the easiest
Microsoft MVP Expression
"Retired Chief" <RetiredChief@discussions.microsoft.com> wrote in message
| I'd like to use Publisher to re-do a menu. How do I keep the menu prices
| an evenly spaced column to the right side of th...Invisible text in drop down parameter query
Don't know if the subject is explanation or not for what Ive got
but here goes
I have been trying to build parameter queries with drop down list
combo boxes using the following tutorial
my platform is Access 2003
all was going well until I run the form with combo boxes, I can run
but when I choose from my drop-down lists no text is visible until I
click in the list and then the selection is visible, I tough this must
just be a font color problem, but I cant seem...Join text
Ok. I will try to explain.
I want to join text from several cells and I'm using a function
But I want the text to be formatted in the recevied cell, i.e. font
size from A1 shall be 18, a2 italic and a3 normal.
How do I do that?
tnx for your answer
Robert57's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29838
View this thread: http://www.excelforum.com/showthread.php?threadid=495454
First copy the result of the formula and paste...Conditional formatting for rows containing text
Is it possible to conditionally format for rows containing certain
text? I receive a weekly report of hours and costs from our financial
department that I need to sort and enter information into a
spreadsheet for actuals vs. budget. This information comes to me with
column A looking similar to this:
1234 Sum of Total Hours
1234 Sum of Total Cost
1235 Sum of Total Hours
1235 Sum of Total Cost
1236 Sum of Total Hours
1236 Sum of Total Cost
1237 Sum of Total Hours
1237 Sum of Total Cost
with the #'s being different ch...2 Workflows
I need to create a workflow that, when a field is populated in one entity,
will create an Alert prompt to the user as a reminder that they need to edit
a field on another entity.
And I would also like to know how to create a workflow that will, when a
field is populated in one entity, create a new record for another (related)
Is this possible? Thank you very much.
On Aug 17, 6:49=A0am, Bernardina <d...@discussions.microsoft.com> wrote:
> I need to create a workflow that, when a field is populated in one entity=
> will create an Alert prompt to the user as a reminde...Stacked Chart Colours Disappear #2
I have a stacked bar chart. When I view it on my screen it is in color
However when I do a print preview or I copy it as a picture it turn
into a black and white chart. I can't figure out how to display to ge
it to copy in color. I originally thought it had something to with th
patterns I was using in my stacked bars, but after removing th
patterns, I still have the same problem.
What it is going on?
Message posted from http://www.ExcelForum.com
Your print preview depends on the printer you have chosen.
If you are getting B/W, than yr prt is black and white
Try choosi...Multilevel Lists
I am trying to set up the format for a new multilevel list
I want it set up so that:
Level 1 text: Is ilays bold and black
Level 2 text: Is always normal black
Level 3 text: is walwys red
Where do I set this at? It looks like in the formating for the list I can
only edit the font style of the list numbers not the actual text after the
Link each list level to a distinct style and define the font and paragraph
formatting in the style.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"Going...Text box visibility
On my form "Finalise Jobs" i have (amongst other controls), "Date ready" -
txtDateReady, "Date Required" - txtDateRequired, "WhyDelayed" -
txtWhyDelayed, and a search Combo Box - cboSearch.
The following code is attached to txtDateReady :-
Private Sub txtDateReady_AfterUpdate()
If txtDateReady > Forms![Finalise Jobs].txtDateRequired Then
Me.lblWhyDelayed.Visible = True
Me.txtWhyDelayed.Visible = True
Me.lblWhyDelayed.Visible = False
Me.txtWhyDelayed.Visible = False
and the following...IMPORTING TEXT DATA
I get emails from a service I use, it gives me client profiles in emails that
vary in size and lenght (foregoing zonal OCR) the data in these unstructured
emails I would like to extract are separated by semicolons as follows on
different zones of the email:
Company Name: Jones Furniture
Name: Betty Jones
Title: Office Manager
Address: 123 Main Street
City: Home town
I want to be able to export this data to either Outlook or ACT 2005, I can
print to TIF (with a printer driver I purchased) and then OCR using Office
2003 Imaging or I can print to hard copy and then ...Disabling 1-2-5-10 Minute security
I 'd like to know if some knows how to disable the "allow permission" to run
for 1-2-5-10 minutes from outlook. I have an application the sends messages
through outlook but it's becoming an issue.
You may find this page useful: http://www.slipstick.com/outlook/esecup.htm
Ben M. Schorr, Outlook-MVP
**I apologize but I am unable to respond to direct requests for assistance.
Please post questions and replies here in the newsgroup. Mahalo!
"Peretz Stern" <firstname.lastname@example.org> wrote in ...Why is my text hidden behind other cells?
I changed my text to be 90 degrees. When I type, the text only shows in that
box. I cannot make it appear OVER the other cells. I need to learn how to
'bring it to front'... if that makes sense. HELP!
I don't think you can. The only ways to show all the text would be to either
increase the height to the row or merge some cells together.
"dANA" <dANA@discussions.microsoft.com> wrote in message
>I changed my text to be 90 degrees. When I type, the text only shows in
> box....sum column with 2 if criteria
this is the formula I entered as an array and I get an N/A#. I'm trying to
look match 2 criteria and then add the remaining cells in column K.
Instead of "WCenterA" I'd like to use a cell reference.
I figured a combination of If and SumIF formulas, but couldn't get that to
work either! Help!!!
SUMPRODUCT is not an array function. It sounds like you have an #N/A in of
&...How do I convert text to uppercase?
How do I convert all text in an existing Excel sheet that contains both upper
and lower case letters?
If a1 is upper then =upper(a1) will return ( UPPER)
=lower will return all lower case
=proper will capitalize first letter of each wor
SilverM78's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1463
View this thread: http://www.excelforum.com/showthread.php?threadid=26264
See my web page
David McRitchie, Microsoft MV...Display Data On Split Form
Not sure how to ask this but here goes.
In AC 2007 I have a split form that I want to display a value
that will show regardless of the row I select in the datasheet.
This is the number of vacation days one will have through-out
the year and of course it changes as vacations days get used up.
Any help will be appreciated,
"JamesJ" <jjy@darwin_roadrunner.com> wrote in message
> Not sure how to ask this but here goes.
> In AC 2007 I have a split form that I want to display a value
> that will show regardl...how do i change hours and minutes into a decimal number? #2
i am trying to turn total flight hrs into a decimal number( ie: 2045hrs
10mins into 2045.10). can anyone help me with a formula which may help in
this? time is given HH:MM but i need it turned to HH.M.
The decimal time for 2045h 10m is obtained by multiplying the time by 24 and
formatting as general or a number but this will give an answer of 2045.167
and not 2045.1 because .1 of and hour is 6 minutes not 10.
> i am trying to turn total flight hrs into a decimal number( ie: 2045hrs
> 10mins into 2045.10). can anyone help me with a formula w...Count Cells in a particular row w/ text
Is there a way I can total up all the cells in a range which have any
text in them what so ever?
=Counta(A1:A100), will count cells that are not blank
if this helps please click yes, thanks
> Is there a way I can total up all the cells in a range which have any
> text in them what so ever?
That counts TEXT only, ignores numbers.
That will count all non-empty cells regardless of data type.
Microsoft Excel MVP
<email@example.com...Convert to Text with Heading on the first line
I have this table named tblTrans and I need to
transfer this into MS-DOS Text format.
I have used the DoCmd.TransferText command.
My table looks like this:
CODE | PAYCODE | AMOUNT |
001 001 235
001 001 111
001 001 213
001 001 212
My output should look like this
Where the first line should contain 111 as the group code
(found in another table named tblGrp) and 771 is
the total amount.
What do you think should I do with this?
I need your help. I would apprecaite w...Can't find my Front End Folder after database split
I just split my database base to allow for ease of use for multiple users.
Ererything, it seemed, went smoothly until i try to find the fron-end folder.
It is nowhere to be found. Should it be label ****_fe.mbd like the back end?
It will be called that, unless you typed something else in the save as
dialog. I thought it ended up in the same folder as the backend after
Easiest way is to go back to the original and split it again, this time take
note of where you save it before you press the button.
"Joe" <Joe@discussi...Attaching a file "Inline" with text
This is a pretty simple question, but I can't seem to find the answe
I am using MS Outlook 2002. It automatically opens Word as the emai
editor. Now, I want to attach a file so that it appears as an ico
"inline" with the text, and NOT as an entry in the "Attachments" tex
box right under "Subject".
Note that I don't mean adding the contents of the attached file in th
body, but I just want the file to appear as an icon in the body of th
I know this is possible, as I receive many attachments this way, but
can't seem to fin...