Question on defining a name
If I select <Insert><Name><Define> I can define something
e.g (=0.95) as, say, discount rate.
Is there a limit to how many defintions you can make? For
example, I have made 13 definitions in the define dialog
box but cannot make anymore. They simply do not appear.
Am I to assume that 13 is the limit?
All help welcome.
As far as I know, there is no limit on the number of names in a
workbook. I've done several projects with many thousands of names
each. I don't know why you are having the problems you describe.
Microsoft MVP -...Customer Returns
I'd like to know if there someone has written a RMS report that shows the
customer account number, customer's name (last, first), and other customer
statistics that INCLUDE pieces purchased and pieces returned.
Or, if someone with more knowledge of SQL would care to share their coding
expertise to accomplish the same, it would be appreciated.
How do I select from a drop-down list, and have a second drop-down list
change based on my selection of the first drop-down list.
see this site....
> How do I select from a drop-down list, and have a second drop-down list
> change based on my selection of the first drop-down list.
there are several ways to do this - - one way is say your drop down is A1 and
your choices are Canada / USA. were ever you make a list for your second
dropdown list = Ontario / Alberta / Quebec etc. in t...Return-Path: <> from Postmater
I got Exchange 2003 SP1 on Windows 2003 in Native Mode and when I receive
bad mail the response is made from email@example.com but the
return-path field is blank. With some anti-spam filter this Email is Junk.
Anybody know how to specifeid a return-path to the NDR mail?
On Fri, 4 Nov 2005 12:48:04 -0800, "Sebas"
>I got Exchange 2003 SP1 on Windows 2003 in Native Mode and when I receive
>bad mail the response is made from firstname.lastname@example.org...Site for SOP Returns
Is it possible to have a different default Site ID for Returns than Standard
Yes. You must make sure to change the site when performing a Return
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and check out our books at
"Everton Raymond" wrote:
> Is it possible to have a different default Site ID for Returns than Standard
Sorry, I did not see the word "default" in your post until after I r...changing extension names
I did try that. I can't remember the exact complication
but it did not work.
Want to quote your original post?
Tips of the month:
-Create an Office XP CD slipstreamed with Service Pack 3
"Cap't Bob" <email@example.com> wrote in message
>I did try that. I can't remember the exact complication
> but it did not work.
...Query regarding A,B,C char. width values returned in 16-bit and 32-bit OS
I am trying to retrieve individual character widths of a string
(from a TrueType font) and I tried using GetCharWidth (which weirdly
works for TrueType fonts too tho' MSDN says otherwise) and/or
GetCharABCWidths to retrieve the A,B and C spacings. Please
note that I have selected the TrueType font (hFont) into the Device
I used GetCharABCWidths. Problem is this: GetCharABCWidths returns
correct A,B and C widths in Win 98 and incorrect (much lesser A,B and
C widths such that the characters OVERLAP) in other 32-bit OS (NT,
The effect is seen across all TrueType fonts, th...Report for Returns
Anyone know a why to report on frequency of customer returns -- so we can see
if any customers are making habit of this?
Thanks and regards,
Try running a detailed sales report filtered to only negative sales
"hitman" <firstname.lastname@example.org> wrote in message
> Anyone know a why to report on frequency of customer returns -- so we can
> if any customers are making habit of this?
> Thanks and regards,
...Store the full path and document name in a hyperlink
I need to create an Access database to track a number of documents
that are created and stored during the tendering process. I have
created a number of tables with hyperlink fields that will store the
information eg Tender proposal document (a Word doc); Tender budget
document (an Excel book) and company profiles (pdf) from companies
submitting tenders. To create the hyperlink to each of these
documents in the form, at the moment I right click, choose Hyperlink,
Edit Hyperlink and navigate to the required document and select it.
The path and filename is then stored in the field, which is ...Returning the Beginning of the week
Returning the beginning of the week.
e.g. if the date == 02/03/04 (Friday 2nd March 2004)
the beginning week for that date == 01/03/04 (Thursday 1st March 2004)
Hows does one go about achieving this?
Rizitsu's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15840
View this thread: http://www.excelforum.com/showthread.php?threadid=314968
This formula will take a date in cell A1 and give the start of the wee
* assumes that monday is the start of the week, so i...File Names
What is the name of the Sent file in Outlook. I
accidently deleted it and want to retrieve it.
There is no file specifically for a Sent item. All data is stored in a
pst-file. Is it no longer in your Deleted Items folder?
Microsoft Office and Microsoft Office related News
Also Outlook FAQ, How To's, Downloads and more...
Tips of the month:
-Create your own fully customized Toolbar
-Creating a Classic View in Outlook 2003
Subscribe to the newsletter to receive news and tips & tricks in your
(I changed my reply add...Outlook fails to shut down... error message not listed in MS KB
Every time I use Outlook and close it, the Task Manager process list still
has Outlook listed. If I forget to check, several listings of Outlook will
show in the processes list. Then when my backups are supposed to run
(pfbackup) I get the error message "outlook has failed to successfully shut
down. Please restart and then exit Outlook again."
I cannot find any info on this and would appreciate any experienced help
trying to troubleshoot this.
Some common reasons why Outlook will not shut down completely when you click
either the X or Exit:
1. PDA synchronizatio...Invalid object name "ECDSMTP"
We are receiving this error message when tryin to merge parts with
Preofessional Services Tools Library:
[Microsoft][SQL Native Client][SQL Server] Invalid object name "ECDSMTP"
When you click OK the following error message occurs:
The stored procedure TACallITem Combiner returned the following results:
DBMS: 208, Dynamics: 0
I have searched the Knowledge base and have not found any help with either
We use Dynamics GP ver 10 SP1
The reason you usually won't find anything in the KB for these kind of
problems is due to the first part of the e...return
Capability of the system to automatically change the status of the PO to
change order, and add line items that have been returned.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
I'm using the following xpath in .net
to test if there is a Board element with NO "finish" attribute.
If there is, I need to get the @title of the WI element...but haven't
been able to figure it out yet (and yes, I do user XpathVisualizer!).
Also, how can I test if the above xpath results in no/null nodeset? It
doesn't seem to work for me unless I first set an attribute.value
string to test (e.g., Dim unfinished As String =
n1.Attributes.GetNamedItem("start").Va...Alpha sort names/numericals
I have 2 columns. 1st column has names, 2nd has numerical values relevant to
the names. How can this data be alpha sorted and keep the same name/numerical
"dane" <email@example.com> wrote in message
> I have 2 columns. 1st column has names, 2nd has numerical values relevant
> the names. How can this data be alpha sorted and keep the same
Please state clearly what the problem is.
If you sorted and got the names sorted and the numbers did not...Handling MRU File List
I have an SDI style app that has a list of recently used files on the
FILE menu. How do I handle what happens when one of those filenames is
selected from the menu ?
> I have an SDI style app that has a list of recently used files on the
> FILE menu. How do I handle what happens when one of those filenames is
> selected from the menu ?
MFC's processing of an MRU selection is a subset of the processing of a
File Open command. So you probably don't have to do anything to support
the MRU list. For both a File Open and a...Listing email groups in address book
Is there any ways that i can compile a list of email groups in exchange 2000
server. The list should also include the members and the owner of the group.
R u referring to the address list in the AD? If so, guess you can use
ldifde.exe included in Windows 2000 to dump the info.
"Marcus" <Marcus@discussions.microsoft.com> wrote in message
> Is there any ways that i can compile a list of email groups in exchange
> server. The list should also include the members and the owner of the
...File Name Problem
I created a spreadsheet in the usual way, when I use the spreadsheet the file
name adds a :2 following the name.xls. When I close the file the :2
disappear. This is not causing me any problems I've not seen this before and
curious if it's something I've done.
check <Window> and see if there is a "...xls:1"
you may just have two windows for the same file showing if you close one of
them and save the file the :2 should go away.
> I created a spreadsheet in the usual way, when I use the spreadsheet the file
> name ad...Return
When returning an item, can you return the item by selecting the matrix
rather than the individual item and changing the quantity to -1?
Normally this won't work as it works in sale where for each matrix type you
can put the qunatites. HOWEVER when you select the matrix item it bring the
matrix window but allow only one item at a time to be returned and make the
-1 qty automatically in return document type. It work but one by one.
> When returning an item, can you return the item by selecting the matrix
> rather than the individua...Returning Multiple Values in a Single Cell
I posted this same question a couple of weeks ago but forgot to
mention a key point. My question was as follows:
I have read a few posts regarding this subject but am still somewhat
lost. I have a two sheet workbook (Excel 2000). On the first sheet
is a list of projects that my department will complete during the
year. A description of each project is given, a start date, an end
date, as well as which crew will be completing the work (Crew 1 or
What I am trying to do on the second sheet is to be able to type in
any date, and have the description of the project on that da...Returns immediate function
I know that the function CeRapiInitEx returns
immediately. No wait for processing.
I want to implement such a function. Returns immediate.
How do I implement such a function?
You might create a UI thread that do the work, launch it in the "non-wait"
function and return immediatly to the caller.
When the thread done it's works, you can post an application message to
return the results....
"PPC DEV" <firstname.lastname@example.org> ha scritto nel messaggio
> Hi all...Using a named range in a Sumproduct comparison
Lets suppose I have in a worksheet of 500 rows of data with 4 columns.
I want to apply sumproduct for determining count with certain conditions.
Now one of the columns (column A) have data such that it is always only one
of the following 6 possible values. "UK", "US", "IN", "AU", "FI" and "PA
Now one of the conditions in the sumproduct is that column A has to be "UK",
"AU" or "FIN".
For one other column the (Column B) there are 4 possible conditions like 56,
78, 89 or 44.
Now the next condition for ...Multiple display names for one user?
This is a multi-part message in MIME format.
Is this possible? We have a few people that I like to call "special" =
who seem to have some identity problems. These people have a first =
name, middle name and a nick name. Well they don't like the fact that =
their email shows up as their legal name, but they still want it there =
incase people use it. So what we have ended up doing is creating =
multiple logins and email accounts th...Acess to my computer from the folder list
Could somebody tell me how add my computer in the folder
list and able to acess different dirves. I have Outlook