Setting Page Breaks
I am trying to set page breaks in a worksheet. If I create a new worksheet, I
can set them but I can not set them in an existing sheet in the same workbook.
What settings could be the culprit?
What happens when you try?
How are you trying to do it?
If you change printers, does it work ok?
Ken Hudson wrote:
> I am trying to set page breaks in a worksheet. If I create a new worksheet, I
> can set them but I can not set them in an existing sheet in the same workbook.
> What settings could be the culprit?
> Ken Hudson
...Importing data from web page
I need some help. I don't know how to import the table from this page :
I put the address and select the table like this :
and then I have to put some parameters :
I don't know what to put. Please help.
Some...does anyone know how to expand the field on an axis
Please use the white space to give a fuller message. The term 'expand the
field' is unclear.
Bernard V Liengme
remove caps from email
"Theresa" <Theresa@discussions.microsoft.com> wrote in message
I am trying to add more fields to my x axis than the 7 allowed. My chart is
short fields needed, it is almost as if I need a secondary axis but I am not
using a pivot chart. All the information appears on the chart blank because I
am not able to load the info...Using fields within string functions?
First, let me explain what I am trying to do.
I have a field, a1:a1000, of email address usernames (e.g. the par
before the "@" symbol). I have another field, b1:b100, which is lis
of profanities, racial slurs, and all other kinds of bad words. What
need to do is flag each username that contains any of the bad words.
The flags can be placed in column C or whatever.
The SEARCH function works great if I'm only comparing two cells. But
I need to compare one cell with a field of cells.
COUNTIF will compare one cell to a field of cells, but it has to be a
exact match. It will ...No Field Edit capability
I have a large data file as the parent, left joined to a child table which is
many to one.
and the parent also joined to a sub query that counts the number of records
in the parent that match the child.
when I run the query it delivers all the data in a table but it will not
allow me to edit or change any of the records.
I have tried all the record locking options and also looked in the
Tool/options/Advanced tab for those settings and still I am unable to change
"WT" <WT@discussions.microsoft.com> wrote in messag...Create A Search Field on a Form
I have a form that allows the user to add a new record. Now I want to allow
the user the capability to change a record in the database, when necessary.
I want to create a search (or filter) on my date field. Do I need to create
a new form or can I use the same form for adding? Also how do I create the
Summing multiple fields on a form wrote:
> I have a form that allows the user to add a new record. Now I want to
> allow the user the capability to change a record in the database,
> when necessary. I want to create a search (or filter) on my date
> field. ...text field to date field field
I have a database that has a text field called "visit" it has been
filled with data ie., " 6/22/07 - not good, " the field may also
be blank or it may contain random text after the date. In some cases
no date at all just text. I would like to create a new field called
DateVisit that contains just the dates that were entered in the field
it has been a struggle and I have made no progress
From your description, the field might contain a date, or a date and text,
or text, or nothing.
How would you explai...Check box appearing only if there is info in field to the left
We are working on document and would like to have a checkbox appear only for
the people that have information to the left. There would be 1 to 4.
Thank you in advance for your help.
See the section - Repeat a block of formatted text and form fields based
upon the content of another form field (and possibly the two methods for
adding a row to a table) at http://www.gmayor.com/word_vba_examples.htm
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.c...Using text field to display images on a form or report
I was going to use attachments to do this instead of a text field but after
rummaging around here I have nod decided to use a text field.
Access knows where it started up from. Can this information be used in a way
that the image file can be accessed relative to where access started up in
order to be able to move the folder or copy the database to another computer
without breaking the qualified path and having to recreate all of the path
names to display the images? If this is possible then how is it implemented?
Thanks in advance
CurrentProject.Path will give you the path to...Page breaks for printing
Does anybody know if there's a way to have Excel
automatically set page breaks whenever there is a change
in the data in, say, columns A or M (I will have the
spreadsheet sorted by A, then M)?
Not automatically, but you can apply the subtotal functionality in the tools
menu. You have to apply it twice without replacing the second time to work
with two columns.
"John" <email@example.com> wrote in message
> Does anybody know if there's a way...In excel, repeat the titles in chart on every page
I have a chart in excel with headings across the top (not headers). I want
them to appear on every page.
not certain what you're asking for her but try file-->page
setup-->sheet-->rows to repeat at top.
"LAURAO" <LAURAO@discussions.microsoft.com> wrote in message
>I have a chart in excel with headings across the top (not headers). I want
> them to appear on every page.
...Eliminating Blank Fields from reports
Using the "+" to peform a "null propagation" as outlined in
by Sal Ricciardi does not seem to work when the data is numeric. Is there a
work around for this?
=Trim([chrDataAlways] & ("; "+[chrDataSometimes]))
where chrDataSometimes is text data. This works!
=Trim([chrDataAlways] & ("; "+[intDataSometimes]))
where intDataSometimes is numeric data. This produces an error).
Thanks for any help.
Use Str() around the numeric fi...SaveData Field
Is it possible to insert a SaveDate field in an Excel worksheet footer?
Not really. The best you can do is to use a VBA procedure to
enter the property value. In the ThisWorkbook code module, use
code like the following:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Me.Worksheets("Sheet1").PageSetup.CenterFooter = _
Me.BuiltinDocumentProperties("Last Save Time").Value
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"PCGrammy" <firstname.lastname@example.org> wrote in message ...How make Field_label shrinkable dependent on field value
How code to make Field_label shrinkable dependent on field value in report?
Field value set to "can shrink" takes no vertical space in a report. How
code the Field_label to also take no space when the field value is null?
Right-click the label, and Change To | Text Box.
Set the Control Source of the new text box to an expression like this:
=IIf([City] Is Null, Null, "City:")
replacing City with the name of your field.
Set Can Shrink to Yes for this text box (substitutes for a label.)
Providing nothing else overlaps these controls vertically, they should...How can I get several graphs on one Excel page?
I'm trying to get four graphs of equal size on one page of Excel. I want them
to display in the four quarters of the page. When I try to make the second
graph match the first one, it comes out tiny with a big space around.
Resizing them is then subject to hit-and-miss. Is there any way to get this
to happen neatly and automatically? Thanks.
I assume you're placing the charts onto a worksheet. You can line the
charts up with the cell boundaries if you hole ALT while moving and
resizing the charts.
If you think ahead, you should make the first chart, and get it all
formatted the...How do I insert a non-break space?
Sometimes when typing in word, I do not want a line to break between two
words. For example, Word automatically does this:
This is the end of Chapter
But I want this:
This is the end of
I do not want a break between "Chapter" and "1".
How can I do this? I seem to remember in older versions of word you could
insert what was called a non-break space between the two words, but I can't
find out how to do it in Word 2002.
To insert a nonbreaking space, just press Ctrl+Shift+SpaceBar.
Microsoft Word MVP
Is there a column that you can insert that shows how many days into a task
you are? Also one for cost?
For example if I have a person at $500/day on a task for 10 days. Half way
through his task the cost will be $2500; is there a column that shows this?
I want to see daily the accumulitive cost.
You want to use baselines and earned value to get our "Planned Value". In
earned values terms this is called BCWS (Budgeted Cost of Work Scheduled).
Assign Costed Resources to detail tasks
set a baseline (Tools/Tracking/Set Baseline)
set the status date (Project/Project ...What are the proper Criteria for a Field?
I have a Table created for membership to a club. There is a Field with the
Data Type: Text, and using an INPUT MASK is: 0000\LLL\00;0; that reads:
ex. 2005 Mar 20. It was created this way because the user
inputting the data was making too many mistakes. In the Table using Text
Filters I am able to filter all the years that I want but the months and days
are NOT in proper order. I have the same problem when I create a Query using
a criteria. I know there is a blank between the year, month and day. What
can I do to create a criteria that would fix this p...how do I sum fields down through a fixed field value.
Hey, I am trying to fill fields down by auto sum fields down. Ie. selecting
A10 through 20 where I am inserting value from cell B10. What happens when I
auto sum is that it calculates each field down, i.e. A10, A11 and so on.
What do you mean by "auto sum fields down"?
And "inserting value from B10"
You want to add the value of B10 to each of A10:A20?
Copy B10, select A10:A20 and paste special>add>ok>esc.
Gord Dibben MS Excel MVP
On Mon, 23 Nov 2009 13:45:01 -0800, rgisla
>Hey, I am ...splitting fields
I have one field that has the first and last name separated by a space. I
would like to split the field into two fields one for the first name and one
for the last name. The names are all different lengths. I am unable to find
any command to do this. Like the reverse of concatenate.
Use Data - Text to columns. Be sure there is an empty column to the right
of your column -- more if there are more than one space in any of the names.
"Randy Patterson" <email@example.com> wrote in message
news:2PbKe.3682$zr1.998@newssvr13....A Bug & A Solution: Date field imported correctly into SQL, displays as one day short in GUI
There seems to be a date related bug in CRM. If I import data from an
XL spreadsheet through the SQL server where I have a Date field (no
time, date only), it gets imported into the SQL server as the correct
Date, and with the Time showing up as 00:00:000. So my data is okay in
the SQL server. However, the CRM GUI displays it as the previous date!
, one day short of what I input. This error can be sidestepped by
importing the dates as date+time and with any time equal to or greater
I'm not sure but couldn't this just be associated with that time zone the crm
user is...How can I break a graphic into pieces to put it over 2 pages?
Our church secretary needs to take a music score and break it into 2 pieces
so she can put it over 2 pages in Publisher. How can she do that?
Other than the fact that I answered it once. Ed also answered it about a
week ago. (I thought the question seemed familiar.)
MVP Microsoft [Publisher]
"Barb Andersen" <BarbAndersen@discussions.microsoft.com> wrote in message
> Our church secretary needs to take a music score and break it into 2
> so she can put it over 2 pages in Publis...Excel Multiple Pages
I have a machine that tests parts and plots then in an Excel document.
There is too much data for one page so it creates another and puts th
rest on that page. After all the data is collected it gets put into
graph, but only the first page shows on the graph. Is there any way t
link the data from the second page on to the graph
basstracker87's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2852
View this thread: http://www.excelforum.com/showthread.php?threadid=48182
AFAI...Capturing info on multiply pages
I don't know how to word this well
Is there a way to link data and create a chart
if the data occurs every month in the same cells on an
excel spreadsheet in a monthly report and each monthly
report is complied as an individule spreadsheet in the
Workbook has 12 spreadsheets each one labled for a month
Jan, Feb, March etc
On each spread sheet in column A line 2 is
Jan. Total Usage or
Feb. Total Usage etc
and Column B line 2 is the numeraic amount:
Is there a way to link those monthly reports and capture
the info to reflect on a chart?
J...Outlook 2003 and "Send page by email" behaviour
As a long time Outlook Express user, I've become accustomed to be able
to send links or webpages from IE using File-Send-Page/Link by email. A
message window will popup, I type in an address and press send. The
message is sent immediately, even if OE is not running.
However, using Outlook 2003, the message is not sent right away.
Outlook closes, and the message is left in the outbox until the next
time I fire up Outlook.
I found this knowledge base article, but it applies to attachemnts.
Even if I select (from IE6) Tools-Mail&News-New Message... without an
attachemnt, the message is...