I want to print just one page of my money file. Is there any way I can tell
what the page number is of what I have on the screen?
"one page of [your] Money file." I presume by that you mean one screen's
worth of register view or something, not one page of a report??? You are
going to need to do something like copy it to the clipboard (Alt+PrtSc) and
then paste it into Word or WordPad. If you mean reports, then I'd check out
Adobe Acrobat or some of the work-alike PDF file generating print drivers.
The print your reports to a PDF file. From there, look at the gener...boolean result format TRUE/FALSE or 0/1
Using a boolean expression in Excel 2000 normally (I
think) gives a result with the format TRUE or FALSE.
However, sometimes I get the result 1 or 0.
I cannot change this by normal formatting facilities, nor
I can find a sheet option that sets this format.
Can anyone tell me what sets the output format of a
boolean and how I can control this
Thanks in advance
It would be interesting to see an example that returns 0 or 1. The only way
I know to get this is by mixing Boolean operations with arithmetic ones. So,
for example, while =A1>3 will return TRUE or FALSE, =(A1>3)*1 will ...CPropertyPage data
How is the data gathered when the last page of a CPropertySheet (wizard
mode) class fires the OnWizardFinish button event? The member variables
in each page appear to have valid data in them but I cannot figure out
how to make use of it when the finish button is clicked.
Mark F. wrote:
> How is the data gathered when the last page of a CPropertySheet (wizard
> mode) class fires the OnWizardFinish button event? The member variables
> in each page appear to have valid data in them but I cannot figure out
> how to make use of it when the finish button is clicked.
The usual wa...Sending web page as email
Hi, running Win Xp and Office XP. When trying to go to file, send, page by
email (to send web page) PC locks up. It is possible to ctrl alt del to
close outlook, but it seems unable to send web pages as email without
locking up. Is there some setting that is not quite correct? I've looked at
Q197092, but that just relates to the difference between sending as
attachment and sending as a page within the email.
...Not Printing Hidden Pages
I have a worksheet that has pages hidden that are revealed by using a macro.
These pages end up printing as blank pages. How do I get them to not print
if the macro is not used to reveal them?
How did you hide the "pages"?
Gord Dibben MS Excel MVP
On Fri, 8 Jan 2010 09:09:01 -0800, Trish711
>I have a worksheet that has pages hidden that are revealed by using a macro.
>These pages end up printing as blank pages. How do I get them to not print
>if the macro is not used to reveal them?
...about transfer order
I created a transfer order "TO666", transfer items from store01 to store02,
the system automaticly created a TO No."00001_TO666 ". And the strange thing
happend: the items in "TO666" is so different with the items in "00001_TO666
where is the problem?
with a lot of thanks.
Try creating another order with the same items, if the problem still exists,
most probably you have a problem in the IDs of those items.
What HQ does is to map the items in the created order in Store1 to the
corresponding items in HQ, then map them again to Store2 and th...Hover in Web Pages
When I create a Visio digram - I can add some hover data that is displayed
when the user hovers over a shape. However, when I save the page as a web
page and then hover over the same shape I only get "ctrl + click to view
details" rather than my hover data. What am I doing wrong ?
I am using Visio 2003
Nigel Price (Technical Architect)
I want to transfer all my messages from one PC running Vista to another
running Win7 which I have Windows Mail running on. However, I have two
1. On transferring some of the transferred folders contain the full message,
some only contain what you might call place holders e.g my transferred Inbox
has 'From' with a list of 30 or so messages but just shows an envelop and
the date and time but no message
2. Is there away to transfer attachments too?
"Ron O'Brien" <firstname.lastname@example.org> wrote in message
news:uBH3g6UjKHA.218...Import data from Access to Excel containing VB code
I am trying to import data from an Access database to an Excel
spreadsheet. I have imported several queries from Access into Excel
already. However the last piece of data that I am wanting to import
into Excel has VB code in the query doing a calculation automatically.
So when I go to Excel to import that piece of data, those queries that
contain the VB code don't even show up as import-able. Is there a way
to import these queries from access into my excel worksheet? I am
using Access 2003 and running on an XP OS. Is it possible to do it in
Excel 2007 if not available in Excel 2003?
I...Data Load Performance
Running SQL 2008 SP1
I am comparing a data load into a Heap Table and a Clustered Table. The
schema from each follows:
CREATE TABLE dbo.HeapTable(
HeapTable_UID int NOT NULL,
Col1 char(25) NOT NULL,
CREATE TABLE dbo.ClusteredTable(
ClusteredTable_UID int NOT NULL,
Col1 char(25) NOT NULL,
PRIMARY KEY CLUSTERED (ClusteredTable_UID, Col1) )
CREATE NONCLUSTER...How do I make 2 pages into 1 page?
I've used WP and it had a 'make it fit' that would change fonts and bring the
page down. How can I do this on Word 07
Use the Shrink One Page facility in the Print Preview Screen.
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"kangaroo" <email@example.com> wrote in message
> I've used WP and it had a 'make it fi...Working in Page layout view
When I click on a single cell anywhere in the worksheet, Excel selects as
well the adjacent cell to the right on the same row. This doesn't happen
when I'm working in Normal view
This a bug in page layout view in 2007
Move your Zoom setting up or down a few points.
Should clear it up.
Gord Dibben MS Excel MVP
On Wed, 24 Mar 2010 14:22:04 -0700, Tyro <Tyro@discussions.microsoft.com>
>When I click on a single cell anywhere in the worksheet, Excel selects as
>well the adjacent cell to the right on the same row. This doesn't happen
>...VB code to insert/get data
Hi where can I find information and examples about inserting data to
databse and getting from DB to excell ?
As far I know I need to use VBA code ?
you can also query a database via data / get external data / new database
query option ... and use MS Query to set criteria etc - unfortunately i'm
not aware of any websites that have a write up on this.
"Piotr" <firstname.lastname@example.org> wrote in message news:email@example.com...
> Hi where can I find information and examples about inserting data to
> databse and getting from DB...How do I e-mail only part (page 1) and not other pages on the sam.
A single worksheet may contain many pages. How do I e-mail just one of these
pages and not the whole worksheet
You can mail a selection or range
Look for a example on my SendMail page
Regards Ron de Bruin
"David H" <DavidH@discussions.microsoft.com> wrote in message news:85AC80F5-1CEF-41C7-8C34-BFEE3955867D@microsoft.com...
>A single worksheet may contain many pages. How do I e-mail just one of these
> pages and not the whole worksheet
> David H
...Summing Data based on Its Category
I have a spread sheet that has data on buldings set up in such a way that the
rows are different room types and the columns are Floor Type and Sq.
Footage. At the bottom of the sheet I have a row that gives total square
footage for each floor type of all the rooms combined.
Right now I am using the Sum() function but I have to go through and
individually select sq footages for the respective floor type. For example
if 3 rooms have a cement floor I look down the sq footage column and sum the
ones that have "cement" in the floor type column, and same with capret, etc.
respec...HR Position Transfers
Is there a way to import a mass amount of position changes in GP HR?
We are getting ready to effect changes for our upcoming fiscal year.
There are numerous changes to our departments, positions moving from
one department to another and some of the departments are altogether
new. Is there a tool to import Position Change/Transfers? If not,
does anyone know all the tables I would need to hit if I need to
import the data?
...Can you create and send e-newsletters longer than one page?
While Publisher lets me create an e-newsletter longer than one page, it won't
let me e-mail it in the body of the e-mail. I'm not looking to write a book,
but three stories is a bit too limiting. Any ways to trick the technology
into letting me have my way with it?
MVP Microsoft [Publisher]
"kRo" <kRo@discussions.microsoft.com> wrote in message
> While Publisher lets me create an e-newsletter longer than one page, it
> w...Seperate Page
I have 12 pages in my newsletter created with Publisher.
I want to send page 2 to a friend as a PDF file.
How can I send her page 2 without sending the
entire 12 pages?
Only output the selected pages to the pdf writer (it's in the print dialog)
"garnettmcd" <firstname.lastname@example.org> wrote in message
|I have 12 pages in my newsletter created with Publisher.
| I want to send page 2 to a friend as a PDF file.
| How can I send her page 2 without sending the
| entire 12 pages?
View, clea...Windows Easy Transfer
I am having trouble with Easy Transfer from an XPhome to XPhome installation.
Actually it is the same computer after re-installing XP. I ran the Easy
Transfer to back up the data onto an external drive. When I run it now on the
new build I don't get the "Continue transfer in Progress" option. It does not
ask if this is the new or old computer. I haven't used it before so maybe I
am not using it as intended. I have user the XP File settings and transfer
program for a situation just like this with no problems.
Computer is a basic HP Pavi...Spending Tracker on My Money Page
I have a strange problem after I have upgraded to MS Money 2006 Deluxe from
MS Money 2005 Standard.
On the "home page" or the My Money Page, I have the "Spending Tracker: This
Month" window displayed. I have included four categories by going to the
"Change the spending areas you watch closely" link in the window, but when I
go back to the My Money page five categories appear - the four I chose and
one additional one. Prior to the upgrade, I had four categories showing by
design - I deleted one and added one more. The one I deleted still shows -
in addit...Data Shifting Between Records
Has anyone ever had experience with data moving from one record to another?
I have a form in which I'm using the FMS rich text control ("Total Access
Memo"). Several times when there has been an error (such as the user unable
to print, or other error), the user finds that data in one or two of the
rich text fields are actually data that had previously been saved in another
record. This has happened two or three times in the past few months. And,
while not a frequent problem, it is especially troubling when it happens.
I've checked the FMS web site, and haven't seen...Non English page numbering
Hi everyone. I would like to know how to display, save and print my page
numbering format in non-English language like Hindi numbering or
farsi(persian) format. How?
On Mon, 24 May 2010 22:48:01 -0700, Milad <Milad@discussions.microsoft.com> wrote:
>Hi everyone. I would like to know how to display, save and print my page
>numbering format in non-English language like Hindi numbering or
>farsi(persian) format. How?
You can simply rename your pages into the appropriate language.
You will, of course, have to know the Hindi/Farsi for Page-1 etc or whatever you want ...Transferring an order to an invoice...
We are transferring over to GP 10. I have a question about invoicing that
I hope someone here can help me with.
In GP 8, there was a transfer button on the Sales Order Transaction screen
to transfer the order to an invoice. In GP 10, the transfer option is in a
pull down menu. Can we make the transfer option a 3rd button on the screen?
If someone could let me know, I would appreciate your help greatly!
yes you should be able to do that if you wish using a button and a bit of
This posting is provided "AS IS" with no warranties, a...System does not auto create Transfer In during Inter-store transfe
my customer running 2 stores and both store having the same interstore
transfer option setting. my problem is 1 of the store does not auto generate
Transfer In doc
1. store A - Transfer Out Doc store B - auto generate
transfer In Doc
store A uploaded 2 HQ message to HQ & store B received 2 HQ message.
2. store B - Transfer Out Doc store A - NOTHING GENERATED
store B only uploaded 1 HQ message to HQ & store A received 1 HQ message.
anyone got ideas how to solved this?
Did you set the HQ Configuration options to auto gen...Cut not Copy Appended Data
In this great Macro, created by Micky (MVP), is there a way to cut and paste
the data from all the columns instead of copy and paste? I just want all the
appended data in Column A".
Application.ScreenUpdating = False
LR = ActiveSheet.UsedRange.Rows.Count
LC = ActiveSheet.UsedRange.Columns.Count
Ind = LR + 1
For C = 2 To LC
For R = 1 To LR
If Cells(R, C) <> "" Then
Cells(Ind, 1) = Cells(R, C)
Ind = Ind + 1