Inches not an option in page setup
I want to use inches not points to set margins, but that option is no longer
available. Don't know when or how it changed. But I'd like get back that
option. Can anyone help me change the page setup default to go back to
In all versions there is an Options setting to select units of measurements,
but the location depends on version. It's on the General tab of Tools |
Options in Word 2003 and earlier; in Word 2007 I think it's buried somewhere
in Office Button | Word Options | Advanced.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Ty...word page view: can't resize window + blank at bottom
I fairly often get glitches when viewing Word doc's in page view mode.
What is most irritating is that I am not allowed to resize the window;
plus, there is a little blank rectangle at bottom that takes up ~1/5 of
the page. When this happens, pagination is not shown at bottom as
well. Any recommendations on whether I should e.g. trash certain files
and retry? (I trashed prefs, to little avail.) It also seems to be
related to specific doc's emailed to me, generally from Windows
machines, but not exclusively so.
Really, haven't a clue. This sounds very unfamili...List Control Box in MFC
I am working on making a control box with MFC and I have a CStringArray
in which I have all the file names stored.. Can anyone help me with
where i can find code for making the controlbox.
thanks in advance
Do you mean a ListBox? What code? Why not use the resource editor to
insert a ListBox. You can populate it using CListBox::AddString in
OnInitDialog(if its a dialog app).
> I am working on making a control box with MFC and I have a CStringArray
> in which I have all the file names stored.. Can anyone help ...Cannot access User Group properties
version 2003- recently when I go into properties of a user, I get the
following error message: Could not prepare property pages because: Interface
not registered. It then opens the property page.
...How to save an Exel-sheet with over 10,000 list-/validation-field.
I need to build a Exel sheet with much mor than 10,000
list-/validatin-fields, but when I try to save this I get the message:
Microsoft couldn't save all data and formats you added to ******.xls.
Is there any possibility to change something in a registry or a variable or
something else to get exel to save larger sheets?
...Counting yes/no fields with differrent names
I have a database that contains the following fields, some of which (all
fields starting with Page_) are selected via check marks;
ID, Date_Received, Site_Number, Subject_Number, Subject_Initials,
Page_1, Page_2, Page_3, Page_4, Page_5, Page_6, Page_7, Page_8, Page_9, Page_10_A,
Page_10_B, Page_10_C, Page_10_D, Page_10_E, Page_11_A, Page_11_B, Page_11_C,
Page_11_D, Page_11_E, Page_12, Page_13_A, Page_13_B, Page_13_C, Page_13_D,
My intentions are to provide a total page count for each subject. My
problem is that I am not really sure on how to accomplish this.
Is it possible in some way to fix the structure of a pivot table in excel or
even in Access so that I have a familiar layout even though the data may
vary from differences in the data. By implication, thefore to show empty
colums/rows somehow. This is very important to my situation.
I couldn't think of any way of changing the format of the
However to solve your problem, you could have your own
format in a different sheet (within the same file) and
link the pivet table using VLOOKUP( formula to get the
numbers to the right place.
You could use refresh data to upda...Page Count
I thought Excel used to display the number of pages with data on the bottom
status bar. I that option gone or is it only in Word?
Excel has never, in my memory, given that information on the status bar.
Perhaps you once had some code that gave you a page count.
Gord Dibben MS Excel MVP
On Wed, 11 Jan 2006 15:01:02 -0800, "pkferret"
>I thought Excel used to display the number of pages with data on the bottom
>status bar. I that option gone or is it only in Word?
...Copy page from one Publisher document to another Publisher documen
I want to copy a series of pages from one Publisher document to another.
Better yet, I'd like to link them, so I only have to maintain one file for a
subset of pages. I do this in Excel...why not Publisher?
Publisher is a DTP program and it functions well for what it was designed to do.
Word maybe a better choice for you. Long documents are easier to manage and can
You can copy/paste Publisher pages from one document to another.
There is a method here as well.
Mary Sauer MSFT MVP
...How do you print Exel gridlines on the entire page ?
I am trying to create a form in Excel. I have the heading & column names.
But I need the gridlines to appear where no text has been entered.
Then you must add borders, or put some content in the cells.
"ndwilsonnorwin" <firstname.lastname@example.org> wrote in message
>I am trying to create a form in Excel. I have the heading & column names.
> But I need the gridlines to appear where no text has been entered.
Or just set the print area (FIle/...Outlook Repeatedly asks for user name and password
Help! I've been all over the net trying to find a fix for this.
I am using Outlook 2002. Windows XP. I have five POP email accounts set
up. One of the accounts repeatedly asks me to enter my username and
password - it will not retain it.
Does anyone know how to fix this? It's driving me crazy!!
Take a look here, it may help:
"someonelikeyou" <email@example.com> wrote in message
> Help! I've been all over the net trying to fin...Modifier fields missing?
In V7.5 many forms contained hidden checkboxes for 'SaveRecord' and
'DisplayExistingRecord'. I'm not seeing these in V9.0. Without them, how do
I know when a record being loaded or saved?
They are still there on version 9.0. Go to the Layout menu from the
Modifier form and click Show Invisible Fields. With Dexterity it's difficult
to remove fields or resources without affecting integrted products so
Microsoft won't to through the process of removing those items.
Consulting Technology Lead
The views or opinions expressed ...Duplicate pages #2
Hi Every body!
I'm trying to make a web site... where I want the same body design in all of
them, but when I'm tryin to modify the other duplicated pages, instead of
changing just one page, it changes all the rest.
How do I make possible to modify the rest of the duplicated pages, without
modifying all of them!?
I'd really appreciate any suggestions!
Thanks in advance!
...Return to the last accessed cell in a multiple paged file at reent
I have an Excel file at work that I did not create, with multible tabs
(pages). Hyperlinks from the main page take me to the sub-pages. Some of
the sub-pages open to the last accessed cell on that page, some take me to
the top of that page. What can I do to make all pages open to the last
...Page numbers when I have 2 section breaks in 1 page
What do I do with my page numbers when I have 2 section breaks in 1 page.
-(Page) at (SectionPages)-
Right now it says 1 to 1 beacause of the section breaks. I would like it to
be 1 to 5 ex.
My problem is that I have a title which is framed in 2 section breaks. Im
doing this because I write in columns and i dont want the title to be in
columns-format. The problem is so, that it counts the title of an independent
section and confuse the page number. How do I get it to count for a single
Instead of using section breaks around the title, I would pro...How do I set a custom page size in Excel
I have the US version of MS Office 2003, but I'm now living in Japan where
they use metric size papers. This is fine if I want to use B5/A4/A5 size
paper, but what I'm looking for is B4 or A1 or some of those other sized
papers. Why won't Excel let me set custom page size dimensions since it
doesn't have a preset for these sizes?
I usually set my current printer to one that has the paper siz
required, then the sheet size is simply selected from there.
Ben Swift Wrote:
> I have the US version of MS Office 2003, but I'm now living in Japa
> the...MS Publisher
If I create an A4 page in Publisher but then deside that
I wanted to actually print it on A5 paper, the pictures
and text boxes do not automatically resize when I
change "Page Setup" from the file menu.
MS Word does this automatically - it seems long winded to
have to manually change the size of each text and picture
frame to make it fit.
Reduce it on a photocopier or scanner.
Some printers have the option to do that in the printer driver settings.
Most quality printers like Canon and Kyocera have that feature.
Hi Mike Harris (firstname.lastname@example.org),
i...calculated fields in a report
i have a database which measures the level of toner cartridges we have
A report shows the printer, cartridge, opening stock, ordered,
allocated, total in stock, reorder level and a calculated field to
give =[Total In Stock]-[reorderlevel].
This all works fine.
I want to display a check box that is true if the number calculated
field result is 1 or less and false if it is 2 or more. I want the
source of the check box to be the calculated field
The calculated field name is [balance] and the check box is [re-
I know this can be done with code but i can't work it out.
t...Making a large field
I need to make a set of 175,000 numbers. Is there a way to avoid pulling the
cells to get this great set of numbers. I would hope that I could just type
first no. & last no. & specify the range? Thank You in Advance.
P.S. The advice re: the dashed no.'s. worked perfectly!
What do you intend to do with these numbers. The maximum number
of rows on a worksheet is 65536, so you can't store them all in a
single column. If you want them in a VBA array, use code like
Dim Arr(1 To 175000) As Long
Dim N As Long
For N = 1 To 175000
Arr(N) = N
Cord...Create multiple owner fields?
Is it possibel to create multiple owner fields in a form. We need to
track the users who is working with an account. I know only own owner
field is supported, but is it poosible to have one owner field and
custom fields using the lookup dialog to map more users?
Have you looked at creating a custom entity. Then have a Many to One
relationship to user and a Many to One relationship to Account.
> Is it possibel to create multiple owner fields in a form. We need to
> track the users who is working with an account. I know only own o...pivottables
I created a pivot from a dataset. This was no problem at all. In a
later stadium I changed the recordset where the pivottable is based on.
For example i replaced all the records containing pete into mike in the
column <NAME>. When refreshing the pivot it now contains both mike and
pete. Pete is redundant, because i no longer exists. How do I get rid
Just drag the field out of the Pivot Table, then do a Refresh, then drag
it back again
"lennert" <email@example.com> wrote in message
news:1140180768.525075.3081...Does anyone know the PivotTable Refresh Event? #2
Thank you Debra it worked fine for me
JohnD'Elia's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1531
View this thread: http://www.excelforum.com/showthread.php?threadid=26930
You're welcome. Thanks for letting me know that it worked.
> Thank you Debra it worked fine for me.
Excel FAQ, Tips & Book List
Operating System: Mac OS X 10.6 (Snow Leopard)
How do you create multiple pages in a word document without using columns. Example: putting 2 pages per sheet or using book fold. I can't seem to find it on the mac version of word. I know I have used it on PC.
I find it easier to get the printer software to do this. Check the
detailed settings of your printer driver to print this way.
On 18/03/10 17:43, firstname.lastname@example.org wrote:
> Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) How do you
> crea...PM Field
I am doing some work with PM30200, the Payables Paid Transaction
History table. The table contains a field called CNTRLTYP (Control
Type) that contains an integer. It appears to be used when say an
invoice and an unrelated payment have the same voucher number. I
believe that this happens when the voucher number and payment number
are identical even though the transactions are not related, as when
both numbering sequences have the same starting point, ie.. 000000001.
It appears that a similar field, by the same name, is used in numerous
tables throughout GP.
Can anyone confirm my assu...how do i create hoizontal areas on a page in publisher
Draw some lines?
Seriously, use the big white space to explain what you want. I cannot
gain any clue from the 11 words you have posted as to what you want.
Ed Bennett - MVP Microsoft Publisher
The OP could just create a vertical area and rotate it 90�.
MVP Microsoft [Publisher]
How to ask a question
"Ed Bennett" <email@example.com> wrote in message
> Draw some lines?
> Seriously, use the big white space to explain what you w...