I have a form where I enter first names into a field called, FirstNames.
After up-date I would like to trim the first names so that if two names are
entered, e.g. James Todd, only James is the defaulted into the PreferedName
Thanks in advance
On Tue, 16 Oct 2007 05:41:00 -0700, Nick hfrupn wrote:
> I have a form where I enter first names into a field called, FirstNames.
> After up-date I would like to trim the first names so that if two names are
> entered, e.g. James Todd, only James is the defaulted into the PreferedName
> Thanks in advan...want questions
I want some set of questions on Word-2007 to check competency level of the
user. Please help.
Ananta, please refer to my other 2 postings: just check out the WORD part.
If my comments have helped please hit Yes.
"Ananta Gupta" wrote:
> Hello Everyone,
> I want some set of questions on Word-2007 to check competency level of the
> user. Please help.
> Ananta Gupta
> Ananta, please refer to my other 2 postings: just check out the WOR...Voting Chart
I have copied the voting information from Outlook and I
want to graph the responses in Excel. I know it can be
done with a pivot chart, but that is beyond my users
abilities. The data looks like this
Is there a quick and easy way to graph this in a pie?
You need to coun the number of "no", "yes", and "maybe"
Like this in D1,
and so on in D2 for "No" and in D3 for "Maybe"
Then in C1 type "Yes", C2 type "No", and C3 type "Maybe"...Outlook rule based on value NOT in name?
I have a lot of SPAM coming in with the sender's address set to my e-mail
address. However, the name is different. I would like to setup a rule like
If the sender's e-mail address = XXXXXXX, but the sender's name <> YYYYYYYY
then move to the junk folder.
Can this be done? All I see are rules to look for a string - not look for
the absence of a string.
I use e-mail to transfer notes to myself and also transfer information
between mail accounts and computers, so I do send myself e-mail fairly
I'm using Outlook 2003.
Thank you for your time!
-...why does .eps graphics files show as transparent?
using office 2003, and can insert .eps formatted graphics, but all i get is a
transparant white box. is there a setting i must change? i have already made
sure that the .eps graphics filter is installed in office. any help? thanks.
dan m <dan firstname.lastname@example.org> was very recently heard to
> using office 2003, and can insert .eps formatted graphics, but all i
> get is a transparant white box. is there a setting i must change? i
> have already made sure that the .eps graphics filter is installed in
> office. any help? thanks.
Does the graphic show when you...Changing the order of a chart legend
I have a stacked column chart and would like to reverse the order of the
items in th legend table (my aim is to place the legend on the right hand
side of the chart so that the key lines up along side the appropriate point
in the stack).
...Sum Cumulative data in SubReport
I'm trying to generate a cumulative report for some demographic data. And I'm
Grouping the data.
The relevant fields of the tables are:
Events Table: Eventid, ProgramArea, ProgramName, (other data)
ZipData Table: Zipid, Eventid, Zipcode, count
Example Events data:
1, Program 1, Name 1
2, Program 2, Name 3
3, Program 2, Name 4
4, Program 1, Name 2
Example Zip Data:
1, 1, 90001, 5
2, 1, 90002, 3
3, 2, 90001, 4
4, 2, 90003, 2
5, 3, 90002, 4
6, 3, 90003, 6
7, 4, 90001, 5
8, 4, 90003, 7
The report is grouped on ProgramArea. The report should look like:
( other da...Problems changing x-axis with large data sets
I have relatively large data sets (for example 8 sets of 1500 x/y-values)
that I want to plot in one chart. So far all is fine. But if I want to change
the x-axis scale (to show the curves better, for example from 0-100 to
20-40), everything becomes very slow. Just to mark one curve or try to move
the chart within the sheet can take one minute! If I do the same i Excel
2003, there is no delay or problem. Is there a simple solution, or do I have
to stick with old Excel?
Excel 2007 is a notoriously poor charting performer, particularly if you
customize the scale of an axis. Excel 2007 SP...I want more!
I need to extend a form that aleady has some 100 lines. For instance, one
column has the date, but only until tomorroq. How do I create more lines
based on the same formula?
I usually select the last row in the range and copy it down a few rows.
If you're using xl2003, you may want to look at Data|List.
And if you're using xl2007, this feature has transformed into Tables.
(Data tab on the ribbon|Data tools Group|What if Analysis|Data table)
> I need to extend a form that aleady has some 100 lines. For instance, one
> column has the da...Crystal Purchase Order
Would anyone happen to a purchase order written in Crystal Reports that
they'd be willing to share? Just trying to save some time. It'd be greatly
I have a crystal reports Purchase Order for Dynamics GP that I would be
willing to email you.
> Would anyone happen to a purchase order written in Crystal Reports that
> they'd be willing to share? Just trying to save some time. It'd be greatly
...I don't want a page of the same label, I want one of each...
I can't find where to tell Pubisher that I want one of each label and not a
page of each label.
I'm using Publisher 2003 (Office 2003)
I see a post that says to enter "<<Next Record>>" but Publisher doesn't see
this as a field, just as text.
This can't be that hard, but I can't figure it out...
Any help would be appreciated.
I see that it prints correctly, but the print preview displayes it wrong....
I think I have it figured out...
"Kelvin" <email@example.com> wrote in message
news:OSpLwThUIHA.5508@TK2MSFTNGP04.phx....Referring to cells by range names #3
half way there.
now if i go to another page and want to refer to the cell "a john", bu
i want to use another cell to pull the "a" and the "john", how do i d
that? let us say that the matrix aboce is in the array a1:d4. th
theory here is that i want to create a report by typing john, mary o
pete into a cell (for this exercise, cell q5) and typing either a, b o
c into another cell (for this exercise, t3), and then typing a formul
in cell t5 that references q5 and t3 but returns the same value as if
had typed "a john
-----------------------...sort order flag hard to see
Retail Management System - Store Operations
This is a fairly minor, picky suggestion. However, it can be annoying.
The sort flag (the tiny triangle) used to indicate which column the lookup
is sorting by is too hard to see. It is just a shade darker gray than the
header where it is located.
Could the symbol be set in a different or more contrasting color?
My client has a number of employees who have a hard time seeing the flag.
Some of them are not the most computer literate people and they need all the
help they can get.
This post is a suggesti...Scatter graph, how do I show overlapping points?
I have a scatter graph with a number of points that over lap. How do I show
them so that the reader can tell there are multiple points.
On Mon, 9 Apr 2007, in microsoft.public.excel.charting,
KieranMoran <KieranMoran@discussions.microsoft.com> said:
>I have a scatter graph with a number of points that over lap. How do I show
>them so that the reader can tell there are multiple points.
a) "Jittering", which is the name for putting a small random variation
in the data to break up the exact values. Obviously you want it to be as
small as possible while still exposing t...Search Using Address Bar Does Not Work
I'm using IE8 and running Windows XP, SP3. I used to be able to type a word
or phrase into the address bar and it would go to a google search and give
suggestions. Now when I type something in it just says, "Internet Explorer
cannot display page." Any ideas on what's wrong and how to fix?
Why would you search from the Address Bar instead of from the Search Box?
"Angel Fire" <AngelFire@discussions.microsoft.com> wrote in message
> I'm using I...how do I populate a cell with data from another worksheet,
I have two worksheets, both with similar data. Say columns are Acc No, Acc
Name and VAT number. Unfortunately the VAT number does not correspond on
each worksheet. How can I populate 1 worksheet with the VAT number so that
the data is collected on one worksheet? I have tried VLookup, but I'm not
really converant with it so would appreciate any help.
...matching & combining data from seperate worksheets
Hi, I am working on a data import and need to get the opportunity name from
one data source into the appropriate row to matching shipments from another
data source, I have two matching fields in each database. customer id and
I need to search 2 columns of data by row on two seperate worksheets and
return a seperate column if they match.
Worksheet A: Shipment Data, Column C (customer id) & column F (Item Id)
Worksheet B: Opportunity Data, Column A (customer id) & column B (Part Number)
on worksheet A Column E, I need a formula that will search ...Text want wrap in text box
I can't get the text to wrap in a text box, word wrap is set to true, I put
some text boxes on a sheet today and the text will not wrap, I did this
yesterday and it worked fine, I can copy the ones from yesterday and paste
them on a new sheet and they work, any ideas? I have rebooted but this did
not help. Using Excel 2000 (9.0.6926 SP3) Thanks Paul B
If you're referring to a Control Toolbat text box make sure that the
MultiLine property is True.
"Paul B" <firstname.lastname@example.org> wrote in message
news:%23ovLUkuLEHA.2456@TK2MSFTNGP12.phx.gbl......graph, data lables value, dont show zero values
Re: graph, data lables value, dont show zero values
I suppose there's a question somewhere.
It sounds like you need to apply a custom number format. Whatever the format
is now (for example, General or 0.00), use it as the first piece of the
number format, then leave the other out. So the format will look something
More on number formats:
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"Madeleine" <...extracting data from a cell
I have this data that stored into several cells and each sell holds a
combined 20 data entries in one cell seperated by a space. I was
wondering is there anyway to extract that data with out having to rekey
the numbers. We are talking about a combined 2000 line items if
individually entered. An example is to store numbers 1-100 in to one
Use Data | Text to Columns and use the space as a delimiter/separator.
"msam137" <email@example.com> wrote in message
>I have this data that stored into...Row Height Adjustment
The row heights did not automatically adjust to display
all the text contained in the cell.
I can manually go thru the rows and adjust them to display
all the data; however, there are too many lines that need
to be done manually.
I have tried the 'auto' adjust feature, but it does not
work. In fact, if I have manually adjusted some of the
lines and use the 'auto' adjust, the lines I have changed
will revert back to only display some of the info.
Is there a limit of data that can be contained in a cell?
Has anyone else had this problem?
do you have merged cells i...Want to Add more Sub description Field
How I can add more sub description field like 1,2,3,4,5
You have only limit up to 3 fields in RMS 1,2,3 sub-description also you can
use the extended description and there is main description for the item. so
Altogether you have upto 5 description limit and I think that is enough. Let
me know if this won't fulfill your requirements else use the Item Notes for
Rate if like
"Saleem Suri" wrote:
> How I can add more sub description field like 1,2,3,4,5
> Saleem Suri
...deleting a record after copying data
I currently have code in a form called workorders to execute after update to
copy data over to a new form called Closed_Workorders. using two different
tables (tasks and closed tasks) How do
I write the code to delete the record once it is copied.
"Thanks for your Support"
Here is the code:
Private Sub Status_AfterUpdate()
If Status = "Completed" Then
Dim StDocName As String
Dim StDocnbr As String
StDocName = "Completed_WorkOrders"
StDocnbr = [Log_Number]
DoCmd.GoToRecord , , acNewRec
I am importing a file of doctor names into a MS Access 2003 table from a
text file. Once I import the names, I want to separate the names into
separate fields. Currently the full name is in one field. For example:
John Q. Smith, MD
Jane Doe, MD, PhD
Tom L. Smith, Jr., DO
Nancy Jones, MD
I want to separate the names into individual fields. For Example:
FIRST NAME MIDDLE NAME LAST NAME SUFFIX DEGREE
John Q. Smith
Jane ...need more infomation on scatter charts?
i tried to create scatter chart, but was not able to do becaues of lack of
options and assistance. could any one please help me
To create a scatter chart you need a minimum of a set of Y values.
Select the row or column of cells and using the chart wizard create a
xy-scatter. With only 1 set of values the chart will default to an
incremental set of x values ranging from 1 to the number of cells in the
If you have a set of x values as well then select both sets of data.
If you have your data in 2 columns the best layout for the chart wizard is