custom size too large to print, can't remove extra blank space
Scanned framed text was added to Word which forced page to custom size. After
I formatted text there is a considerable amount of blank space I can't
remove. There is NOTHING in the space as I have selected view all formatting
marks and nothing is there, yet I can't remove. The spacing "resizer" at the
top of page does not affect it either. Any suggestions??
Perhaps the text was scanned as a picture? If so, you will need OCR to
render it editable.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
&qu...How do I add a copyright (c) symbol to Auto Correct
My windows XP does not include the copyright symbol in auto correct. How do
I add it to auto correct.
For XL2003 and earlier
Tools>Options>Spelling>Autocorrect Options>Replace (c) With �
Circular Office button>Excel Options>Proofing>Autocorrect
Options>Replace (c) With �
"Judy Southwest" <Judy Southwest@discussions.microsoft.com> wrote in
> My windows XP does not include the copyright symbol in auto correct.
> How ...How to add cash account to portfolio?
I'm using Money Small Business 2003. I have an ING savings account.
Is there a way to add this to my portfolio as a "cash" allocation?
What exactly is the "cash" asset allocation part of a portfolio? I
only have a Vanguard IRA which doesn't allow cash to sit in the
There are two approaches that depend on what the real situation is.
1) The cash is really a Money Market fund investment. Setup an investment
for it just like any other; call it a Money Market mutual fund. This sounds
maybe a little more like what you have when you refer to i...Calculated Fields in Pivot Tables
Hello from Vancouver BC!
I have a pivot table into which I have inserted calculated fields. I totalling paid insurance claims by month, grouped by year. The calculated field mutiplies the paid claims times an expense fee.
The monthly calculation is working fine, but the subtotal for the year is a mystery. I though it would simply add the sum of the monthly amounts like the uncalculated fields.
Can anyone assist?
Thanks very much,
Can you give an example of an amount you're getting as an annual total,
and what amount you expected to get?
> Hello from Vancouve...Puting all the null field to 0
Is there anyway to use code to make all the empty/null field update to
0?Thanks for help.
You can use an Update query to convert Null values to zero, e.g.:
UPDATE MyTable SET MyField = 0 WHERE MyField Is Null;
Before you do that, you might wish to consider why this is needed. If it is
just that you are having difficulty handling the nulls, see:
Nulls: Do I need them?
Alternatively, if you just need this for a particular situation, you can use
Nz() or IIf() as a calculated field in a query to substitute zeros for nulls
in that context.
...Show only unique records in duplicated field
I need to limit repeated (but not duplicated) records in a query. Here's my
This structure allows a company to be assigned more than one category.
I want to be able run a query searching for companies that belong several
categories, i.e. show me all companies that have category assignments of
either software or nonprofit. Something like TechSoup would come up twice.
I'm interested in viewing the company names, not necessari...USer Di & TImeStamp in Notes Field??
I have the following Code onChange for an Addtional Information Nvarchar Field
I am trying to put this at the end of the text after each time I save it, so
it can tell me the time of day and the User who entered it. But what it does,
is just give me the Date and timeStamp and deletes the text I typed in.
Any Help would be appreciated. Thanks
// To Get the System Date and Time
var d=new Date();
var curr_date=curr_day+"/"+curr_month+"/"+...fields in the RecordSource
I get a runtime 2465 error in attempting to
reference one of the fields in the RecordSource
of a report.
Dim intCount As Integer
intCount = Me.CountField
Access can't find the referenced field, "CountField".
Yet, using the "Me." autofill shows all the field
names in the RecordSource of the report.
What am I missing?
Which event is being used to run that code? If it's the Open event, the
report's fields are not available to the VBA code at that time. You more
likely want to use the Format or Print event of a section of the report that
might...Using variable in field name
I have a table whose fields are named boolType00, boolType01,
boolType02, ..., boolType19.
I need to make a loop and real all of the 20 fields. Something like:
Dim i1 As Integer
While i1 < 20
Is there a way to do it?
If you OpenRecordset, you can refer to the field in the recordset like this:
Debug.Print rs.Fields("boolType" & i1)
If you need help with using a recordset, see:
Lots of repeating fields like that usua...Create Formula
I need to create a formula where I add a set number of Networkdays to a
start date. Example:
Start Date = 1/2/07
Number of Networkdays = 21
End Date = Is calculated
If Start = 1/2/07 and 21 Networkdays are added, what is the retured end
I can only find example of Networkdays where I would be providing the
Start and End Dates, and it will calculate the Networkdays. I can't
find example where End Date is calculated based on the number of
networkdays from start date.
Can anyone help with a valid formula for this?
Look for =workday() in Excel's help.
(Also part o...time add
I want to add or subtract min & sec for race results & handicap. e.g.
04:16.997 - 18.2 to get min:sec Can't find a function to do that, any
If you've put bona fide times (you have to use the colon, etc.) then you
need only add or subtract the cells with formulas, like with any other
numbers. See Chip Pearson's site for details on date/time stuff.
"Murray" <firstname.lastname@example.org> wrote in message
news:ukkEbVOfFHA.3692@TK...Customizing Activities Views?
Been hunting for a solution to this for ages now.. Is
there any way of customizing the Activities Views in the
Workplace section. If you open the 'Activities' Pane in
Workplace, you have a list of predefined views (Open
Activities, Closed Activities, My Activities, All
Activities) - is there any way to customize or all new
views to this list?
The question stems from the Workflow section of MSCRM;
when you advance an opportunity through your workflow
lifecycle, a number of automated activities are created
which (given a number of opportunities) quickly clog up a
users Workp...installing add-in analysis toolpak
I need to use the data analysis in Excel.
I cannot install it, due to windows installer error 1635.
I don't have the key:
so it is not that.
What else can it be ?
select Microsoft Office
in office 2003 you need to check
Advanced customization of application
open the tree for Excel
select Analysis Toolpak
select Run From My Computer
| www...custom a list
In excel, I can type in a date and drag it. It will give
me a list of another dates.
For example: if I type in 11/1/04 and drag it, I can see
11/1/04 ( monday), 11/2/04, 11/3/04, 11/04/04, 11/5/04,
11/06/04, 11/07/04, 11/8/04 (monday).
I would like to have a list that will take out 11/06/04
and 11/07/04 because these dades are Sat and Sun.
May I use marco to create the list? or use custom lists
located on Tools---options.
Can I put a calendar on Excel sheet so users can select a
specific date? If you think that I can, Ple...PROFIT MADE BY CUSTOMER
ANY BODY CAN HELP IN CGRATING QUERY IN SQL SHOWING HOW MUCH MONEY I MADE ON
EACH & SET THEIS NUMBER AS CUSTOMNUMBER FIELD SO THAT WHEN I RUN THE QUERY IT
WILL UPDATE THE CUSTOM FIELD WHERE THE EMPLYEE CAN SEE HOW MUCH MONEY WE MAKE
OF A CUSTOMER
PLEASE I NEED THIS BAD
Maher I could use the same thing so I'm just going to add on to your post,if
you don't mind. BUT...I would also like to see "cost" "profit" per line item
as it is being entered into POS. Then totalled,but not printed on customer
receipt. My customer wheel's and dea...Newbee Q: How to make search field in excel sheet?
I am using Excel in a rather stupid way. I work in sales and have all
my company leads in here, so I can keep them in check. What I would
like to have though, is a field where I can type part of a company
name, and then the Excel ark goes to the first cell that matches...
It seems so simple, but I have almost never used Excel before, so I'm
Any quick tips out there?
Message posted from http://www.ExcelForum.com/
Have you tried Edit / Find?
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03...How do I refresh a PivotTable and remove outdated page field entr.
After refreshing a pivot table in Excel 2000, page fields values include
those that were in the old pivot table data but are absent from the refreshed
data. For instance, a page field button named 'Year' lists 1998, 1999, 2000,
2001, 2002 and 2003 as values. However, the data no loger includes any rows
for years 1998 and 1999. How do I remove these values without re-creating
the pivot table from scratch?
There are instructions here for clearing old items from a PivotTable
> After refreshing a piv...adding user defined fields in RM Detail Aged TB
Is it possible to include the fields entered in Sales User-Defined Fields
Entry window in the RM Detail Aged TB - Options report in report writer?
...find maximum value in range of fields
Could someone advise/assist with the following:
I have fields like the following:
Badge Date 1
Badge Date 2
Badge Date 3
etc... to Badge Date 7
What I would like to have happen is when a new badge date is entered
the badge dates would cascade -- dropping the oldest date and
cascading badge dates -- ( i.e. Badge Date 1 would be the newly
entered date - Badge Date 2 would be the date previously in Badge Date
1 - previously in Date 2 goes to Date 3, etc...)
The ability to pull the maximum ( most current date) from the Badge
Basically I want to keep the last 7 dates fo...How do I disable "Customize" on MS Publisher?
PUB11.ADM files is missing the capability to use "Disable Items in User
interface" which in include "Predefined" and "Custom". I did modify the
PUB11.ADM files but the application itself doesn't recognize the chamges. So
my question is how do I disable those feature on MS Publisher?
I have the same problem now, does anyone know a solution for this problem or
can i make a custom adm file...?
> PUB11.ADM files is missing the capability to use "Disable Items in User
> interface" which in include &quo...Sending mail to many users using the to-field.
I am using outlook2003/2007 and exchange server 2003/2007.
All users getting the mail sees all other users in the to-field. Is it
possible to hide other recipients without using the bcc?
Other than using the BCC field you can try using a mass mail tool to send
individual items to each of the recipients like the ones shown here:
"Tor-Magne" <email@example.com> wrote in message
> I am using outlook2003/2007 and exchange server 2003/2007.
> All users g...SQL Table for Customer Accounts Maintenance Screen
I can't seem to locate the table for the Customer Accounts Maintenance
Screen. Does anyone know where these accounts are stored in the database?
The Account Indexes for these accounts are stored in the RM00101 table in
the following fields:
Again these fields store the Account Index but if you want to know the
account number itself you would simply link/join in the GL00105 table which
stores both the Account Index and the Account String (ACTNUMST) in it.
I believe..."Too many fields defined" error message
I received a "Too many fields defined" error message when
importing an Excel 97 spreadsheet into SQL Server 2000.
There are 256 columns in the Excel 97 spreadsheet, all
containing data. How do I correct this in Excel 97?
It's a bug. There's a bit of information in the following MSKB article:
BUG: Cannot Import Excel 97 Spreadsheet with 256 or More Columns
> I received a "Too many fields defined" error message when
> importing an Excel 97 spreadsheet into SQL Server 2000.
> There ...Newbie Question : How do i add Elements into a existing XML File ?
I got one XML File like this:
<Item>Some Text 1</Item>
<Item>Some Text 2</Item>
<Item>Some Text 3</Item>
Now i would like to add a Element <Item> with the Value 'Some Text 4'
How can i add this Element without tuching the existing Elements ?
Thanks for one Example
Peter Treier wrote:
> <Item>Some Text 1</Item>
> <Item>Some Text 2</Item>
> <Item>Some Text 3</Item>
> Now i...query destination field
How do you change a destination field of a query in Excel? I have the data from the query being sent to cell A4 but need it to go to cell A1.
I tried the "edit query" option but with no luck
I think you can just delete Rows 1:3 and it will adjust accordingly.
MVP - Excel
Excel Blog - Daily Dose of Excel
"albert" <firstname.lastname@example.org> wrote in message
> How do you change a destination field of a query in Excel? I have the data
from the query b...