Can I fade the edges of photos that I use?
I am trying to use photos in a publisher document that I want to fade the
edges of, is this possible to do with publisher?
> I am trying to use photos in a publisher document that I want to fade the
> edges of, is this possible to do with publisher?
Not really. You should use dedicated image manipulation software for
this, such as Photoshop Elements, Paint Shop Pro, or Microsoft Digital
Ed Bennett - MVP Microsoft Publisher
Are any of these programs typically come loaded on a computer?? I have
another question - ca...Pivot Table Cycling Through Page Fields Automatically
Hi. I am trying to cycle through a complete set of data in one of the
parameters in the "Page" field. For example, there are 500 investments, and I
want to compute the internal rate of return (IRR) for each investment based
on a series of cashflows for each investment.
The IRR is a function that is placed outside the pivot table. As each
investment number is chosen, the underlying pivot table cashflow data
changes, allow the IRR function to pick up these cashflows and compute the
IRR. However, if there are 500 investments, this becomes very time consuming
- especially if the...Excel, how do I get ALT F C to work the same as ALT F Enter C ?
The above is an example, but it aplies to any menu. Before, if I pressed say,
ALT F, the drop down menu would appear and I could press, say, C and get to
the submenu. Now I have to press Enter, before the C, which is a bother.
On my Windows 2000 version 5.00.2195 with Excel '97 and Excel 2003 the
Alt F C still works.
What version software / Excel are you using?
Bryan Hessey's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21059
View this thread: http://www....Trying to Get Subset of XML
I want to display a segment of an XML (see below) file in a datagrid. I want
to select a specific <EventID> and get
all of its children into a dataset so that I can bind a datagrid to those
values. I am trying an expression
as follows but I get an error "Value of type 'System.Xml.XmlNode' cannot be
converted to 'System.Xml.XmlNodeList'."
myNodes = xmldoc.ChildNodes("/Dataset/Events/[ShowName=Round 2]")
What is the correct way to "get" that set of nodes and convert them to a
================== Portion of XML File ===============...pivot table #21
I have a question on Excel. When I update a pivot table,
I used to be able to hold down the shift and ctrl keys
and highlight the area, but lately I found that I cannot
use this short cut method. Is there another short cut
method? Thanks for your help.
In step two of the Pivot Wizard, you should be able to select a starting
cell on the worksheet, then hold the Shift key, and tap the End key,
then the Down or Right arrow key, to select a range of cells.
Or, base the pivot table on a dynamic range, which will expand
automatically as new records are added. There are instructions here:...Can I delete my switchboard and make a new one?
I do not like my switchboard and would like to delete this one and start all over. But when I did delete it I couldn't make another one, because I couldn't delete the default. What should I do?Thanks,Dustin Just delete the form and the table that were created by the wizard, then start over.-- Rick B"Dustin" <Dustin@discussions.microsoft.com> wrote in message news:42F94A44-9352-4D02-9104-65593869B271@microsoft.com...>I do not like my switchboard and would like to delete this one and start >all> over. But when I did delete it I couldn't make another one, beca...Item Dynamic table size
I've been doing some cleaning in our HQ db on items that are no longer sold
in our locations. I've had success in deleting the appropriate items however
I noticed that our item dynamic table is quite large, over 2,000,000 rows. Is
there an sql script available to update the Item Dynamic table based on the
Items in the Item table? Thanks in adavance
This is a multi-part message in MIME format.
Bad idea to de...transfer inbox in table format to word
In my older version I could cut and paste the table
format in Outlook to a word file. Now I don't seem to be
able to do it although I can print the file in that
format within Outlook. When I export the inbox to word I
get the whole text not just the headings. Is it possible
to transfer the table format to a word file?
...want to do piovt table, where rows over 100,000
i have around 100,000 rows of data...
of cousres the worksheet i can only put 66000 or so rows per sheet.
i want to do a pivot table that combines the two sheets.
how can i do this?
Message posted from http://www.ExcelForum.com
if you have that many data I would suggest you store this data in a
real database (e.g. MS Access). With Excel's pivot table wizard you can
then access this database as datasource.
Another way would be to split the data in two worksheets and within the
pivot table wizard choose the 'non contigenous ranges' for the data
Reg...Workflow rule on (Order)Products and columns of related entities in advanced find view
Does anyone know whether it's possible to create workflow rules on
(Order)Products, since the entity Products isn't part of the standard
In my example I have added a new (expiry) date attribute on the
Now I would like to add a workflow rule on that datefield to create a
task when the expiry date is nearly reached; but the problem I have is
that i can't "reach" the fields on the OrderProduct form to put a
workflow rule on?
Another problem I have is that I've created an advanced find query in
which I query customers who have or...Add a specific Record to a Table based on a check box
I have a Table called ServiceTypes. Based on a User's input on a
ProposalForm, ServiceTypes need to be added to a ProposalServicesTable.
For instance, I have a Check Box on the ProposalForm. When a Check Box is
clicked Yes, Access must search the ServiceTypes Table, select a specific
ServiceTypeID, and add the ServiceType to the ProposalServicesTable.
How can I add the proper Service record from the ServiceTable to the
ProposalServicesTable based on the Check Box?
I wouldn't do it that way. I'd use a listbox (with multi-select set to YES)
that was sourced to the ServiceTab...pivot table -repeating "months or days" after grouping
I have data that includes the month, day, hour, min. When I run th
pivot table function to reduce the data to hourly I need the date t
repeat in the date column.
9/19/2002 0:00 2.7
9/19/2002 0:10 3.7
9/19/2002 0:20 3.8
9/19/2002 0:30 4.6
9/19/2002 0:40 4.8
9/19/2002 0:50 4.8
9/19/2002 1:00 5.6
9/19/2002 1:10 5.2
What I get when I group the Pivot table:
Sep 19-Sep 12 AM 2.7
- - 1 AM 3.7
- - 2 AM 3.8
- - 3 AM 4.6
- - 4 AM 4.8
What I want is:
Sep 19-Sep 12 AM 2.7
- 19-Sep 1 AM 3.7...how can I drag formulas with other cell references
cell A1 contains formula "=stdev(a2:a7)
cell a2 contains formula "=stdev(a8:a13)
Is it possible to drag the formula down so that cell a3 contains
"=stdev(a14:19) and cell a4 contains "=stdev(a20:a25) and so on for cells a5,
a6, a7 etc. etc.
It was easier to test and verify using SUM instead of stdev, but the formula is same
NOTE the formulas are in a different colu...How do I get excel files to open automatically from directories?
When I try to open excel files from the directory or from desktop I only get
a blank worksheet not the file. I have to then go through File Open to get
the file I want.
There must be a way to have them open automatically.
On Mon, 2 Jan 2006 21:22:01 -0800, Damian
>When I try to open excel files from the directory or from desktop I only get
>a blank worksheet not the file. I have to then go through File Open to get
>the file I want.
>There must be a way to have them open automatically.
Go to Tools -> Options -> Gen...can i have more sender in outlook setting ?
i using win server 2003 , exchange 2003 , i using exchange client in outlook
to send & receive , but my boss have more than one mail address , can i use
another AD mail address for send out mail , i have try to add a pop3 , the
sender also is computer user
...Fiscal Year Close
v7.5 Great Plains
There is a user that went ahead and posted a large number of transactions
(not posted to GL, but sitting in batches there - only posted in in POP/SOP
with a tie in to Inventory) that are dated _after_ the projected fiscal year
Are these recoverable? Or do they all have to be voided (with adjustments to
inventory) and re-entered from scratch?
I think your best bet is to delete the unposted batches in GL and enter
returns to negate the transactions in POP and SOP.
Charles Allen, MVP
> v7.5 Great Plains
> There is a us...Tab order for purchase orders and sales orders
Is there a way to set the tab order while entering items in a purchase order
and sales order. My client would like to be able to have the order taker be
able to be prompted for a quantity while entering in line items to purchase
orders and sales orders.
For POS, enter the quantity first, then the * key, then the ILC
So for 5 of 11212, enter 5*11212 <enter>
For PO's see if QuickScan works better for you.
"Marc Arbesman" <MarcArbesman@discussions.microsoft.com> wrote in message
Is there a w...Create interactive pivot table chart based on item selected
I'm trying to remember how to drag a chart object to the top left cell of a
pivot table thus displaying a charted image of the detail item selected. Any
...IE8 can't access Microsoft Office site when all other browsers can
When trying to access the Microsoft Office page using IE8 I keep getting the
"Internet Explorer cannot display the webpage" message. If I use any other
browser (Firefox, Opera, Safari, Chrome) I have no problem accessing the
page. This happens whether running in normal or No Add-on's mode. Despite how
many people keep complaining about all the problems with IE8, neither the
MVP's or Microsoft acknowledge that they exist.
Intel E8400 Core2Duo 3.0GHz
4 GB PC2-6400 DDR2
Windows 7 Ultimate (with all the latest updates installed)
NIS 2010 (all up to date)...I can't get rid of 1 "Payment to Send' Reminder-M07
On my Home Page in the Reminder section, I have a "1 Payment to Send"
listed there. But there is NO payment to send. I"ve opened up back-up
copies as far back as May and the reminder is there, but there is no
payment that needs sending. Does anybody have an idea how I can get rid
of this Reminder?
Just removing the Reminder from Home Page doesn't do it. When you put
the Reminder back on the Home Page, the "Payment to Send" is still
there. Clicking on the link just takes me to Bill Summary page.
...problem in changing the text of sentences before tables
I am developing a word automation application. In a method of mine, I change
the text of some sentences of an opened word file, but the problem is when I
change the text of a sentence which located before a table, it will be moved
to the first cell of the table. My code is as follow:
void myMethod( long startingSentenceNumber, const char *toBeSearched, const
char *replacement, bool replace )
Sentences sentencesList = m_document.GetSentences();
long sentencesCount = sentencesList.GetCount();
CString replacementCStr(...is there any way I can trap for the use of navigation buttons?
Is there any way I can trap for the use of navigation buttons, such as
Next, Previous and New record?
Probably. Trap what and when?
"Stapes" <email@example.com> wrote in message
> Is there any way I can trap for the use of navigation buttons, such as
> Next, Previous and New record?
On Wed, 16 Jan 2008 05:14:20 -0800 (PST), Stapes
No. And there shouldn't be a reason for that. There are plenty of
events in...Is store procedure always fast than Access linked table via ODBC?
I was assigned to upgrade one program from Access(using ODBC to connect to
SQL 2000) to ASP.NET(using store procedure in SQL 2000).
Finally, I tested them and found that ASP.NET is slower than Access.
The mojority job of program is select some data from SQL 2000 tables, modify
and then insert into some tables.
Is store procedure always fast than Access linked table via ODBC?
Message posted via http://www.sqlmonster.com
Stored procedures don’t add any overhead and they can save compile time.
It's the code in the stored procedure and the underlying tables / indexes
that ...how can I look into store.exe
I have an email sobig that i cant even download it on my
outlook express 6.0....
The adviced for is to locate it on the Queues in Outbound
or inbound messages on IMC, but if it is not in there the
message may be stuck up in Store.
How can I locate it and delete the massega in store.exe
they say I can use the MFCmapi but i'm a newbie how can
do this. Do I have to download the MFCMapi? what is it?
...can't change/delete bills and deposits
suddenly one day i realized that when i tried to change a
bill, i could click "ok" but nothing would happen. I
thought it was because i upgraded to 2004, so i deleted
the bills and rescheduled. about 5 of the bills will not
delete either. the error message is: "Money could not
write to your Money file. The operation could not be
performed or another application finished this task before
you. Please try again."
Now some of the newly scheduled bills will not allow me to
change the properties, i click ok but nothing happens when
i edit the series.
I have repaired ...