Word documents should contain an embedded dictionary
When I write documents with many proper names, I add the names to the custom
dictionary to permit Word to spell check the names throughout the document.
That said, I would rather not keep proper names in my custom dictionary where
I keep what I consider to be "global" or cross document language additions
like acronyms etc. Also, when coworkers view my document in Word on their
machines, it flags the names as misspellings since my custom dictionary is
stored on my machine (needless to say it's not real pleasant trying to share
and manage a document and external cust...Median in Excel 2007 pivot-tables
I am working on pivot table for data analysis, where I need to show the
median. While working on this I found that "Median" is not supported in
pivot tables. Is there any way I can use median function in pivot tables?
AFAIK, you can't alter pivot tables, but you can certainly copy/paste special
(perhaps a new sheet), and then do whatever you want to it (perhaps in an
If this information was helpful, please indicate this by clicking ''Yes''.
...Graphs in Other Files do not Update
I have a main file with graph (AP.xls) and several sub files with graphs
that are linked to the main AP.xls file.
The columns of the main file are in months and I often have to add new
columns for a new month. I find that if I add new columns using copy =>
Insert copied cells (the column is inserted to the left of the column being
copied), the graph within the AP.xls files is updated with the new
column/month. HOWEVER, when i open the other sub files, they aren't updated.
HOWEVER, if the sub files are opened together with the main AP.xls file, and
I insert the new column, t...UPDATE and SET w/ CAST (String Replace)
I have a text field column in SQL 2005 that contains HTML code. I
would like to update certain references in this HTML code throughout,
but am having problems. I know that I can't do a string replace with
the text data type, which is why I would like to cast it as
nvarchar(max). Any help would be appreciated. Thanks.
SET (Cast(HTMLData as nvarchar(max)) =
WHERE HTMLData like '%detail.cfm%'
"Daniel Reardon" <email@example.com> wrote in message
news:firstname.lastname@example.org...disable snap-to while dragging tab stops?
How do I drag a tab stop to arbitrary position without it snapping to the
tick marks on the ruler?
I tried holding down shift, ctrl, alt. None of them works. I even turned off
everything in the arrange->snap menu.
Set the tab to about where you want it, zoom to 200%, open the tab dialog and input
the number where you want the tab positioned, click set. The tab button can be
dragged to your toolbar by customizing. This is the best that Publisher can do...
Mary Sauer MSFT MVP
"p...update a date cell only when worksheet is edited
Hi. is there a function that updates the date cell automatically only when
the worksheet is edited or something to that effect. thank you
This might help
Joe Black wrote:
> Hi. is there a function that updates the date cell automatically only when
> the worksheet is edited or something to that effect. thank you
...Replaying audio in word document
Operating System: Mac OS X 10.6 (Snow Leopard)
I recorded an interview in word. Now that I replay it, it sounds as if being reproduced in slow motion and is incomprehensible. Does anyone know how to play it at normal speed? Thanks
...suppress decimal point combine print word and excel
When I use word to combine print (office 2002).
some excel numberic value is long than I expect, I want to suppress decimal
point only two digital .
for example 20.22233222424 trans to 20.22
how can I do ?
in Word you can apply a format to imported fields or round your data in
the Excel file with ROUND
> When I use word to combine print (office 2002).
> some excel numberic value is long than I expect, I want to suppress
> decimal point only two digital .
> for example 20.22233222424 trans to 20....stops responding
A few days ago while trying to balance one of my accounts, Money would start
hanging and I had to kill the process and created a LRD file. My file is
only 12MB and it has been fine until recently. I am using Money 2007.
I should have put my system specs. I have a P4 3.8GHZ w/ 2GB RAM running XP
Pro. When I have Money open, I typically only have Messenger, a browser, and
sometimes Acroabat Reader running also.
> A few days ago while trying to balance one of my accounts, Money would start
> hanging and I had to kill the process and created a LRD file. ...blue stop screen 0x0000007E
stop error code after windows installs drivers. this is new hdd and mobo but
problem persists.oxoooooo7e (oxf748eobf oxf78da2o8,oxf78d9fo8....was doing it
with last mobo and hdd...help please!!!
thanks one and all for your helping hands
> stop error code after windows installs drivers. this is new hdd and
> mobo but problem persists.oxoooooo7e (oxf748eobf
> oxf78da2o8,oxf78d9fo8....was doing it with last mobo and hdd...help
That *is* a driver issue. You are installing the incorrect drivers or need
to contact the manufacturer of said ...blocking specific text in Word
I am creating a document for a client. There will be certain areas that will
be locked and certain areas where my client will need to input information.
They wanted to know if there is a way that when their team types in their
information that they can block out specific words so they wouldn't be able
to type them in.
For example, they have a long list of products and only want the client to
be able to input certain product words but block out other ones. Is there
anyway to do this?
I don't know of any way to block specific words, but they could us...recipient policy stopped working
I'm seeing an issue in my Exchange 2003 environment where an admin will
create a new account and the recipient policy does not populate the users
email address. This just started happening a few days ago here in the US...
It happened in our UK office last week but I thought that might have been
user error on the admin. We are in mixed mode with Exchange5.5, which we have
been for almost a year. I did how ever remove some old 5.5 servers but the
last one I removed was almost a month ago, so i don't think it would be that.
I know you need to ask this question so yes th...How do I stop a cc email to myself from going to deleted folder
Sometimes when I send an email, I want to keep a copy ofr myself. When I
enter my email address in the cc part, this always goes straight to the
deleted folder, even though I have my email listed as a safe sender. Any
On 13/03/2010 01:53, technochallenged wrote:
> Sometimes when I send an email, I want to keep a copy ofr myself.
Outlook automatically keeps a copy of every email you send in the Sent
There is no need to cc yourself.
"technochallenged" <email@example.com> wrote in
message news:D4...3197: The microsoft Jet Database Engine stopped the process because you and another user are attempting to change the same data at the same time
I have a fairly large (For Access - its slated to be transferred to
MySQL) backend that allows the user to use the database's front end
normally to store and retrieve data. However when I try to open the
database I get the Error "The microsoft Jet Database Engine stopped
the process because you and another user are attempting to change the
same data at the same time".
This isn't true because I have it on my local computer.
I've tried importing to a new DB file and I get the same error. The
original DB will not open to allow import (show table list) and show
er...Quicken can't find my 2007 Money file
I recently attempted to install "Q" 2010 but it won't import from my 2007
Money file. It says it can't find it.
I tried using their "chat" support but chickened out when the rep wanted me
to import Money 2008. My Money file is nearly 20 years old and contains my
complete financial history for that time period. I am paranoid about
Anybody have any thoughts about why "Q" can't find my file?
It isn't imperative that I convert now ....or in the future probably.... but
I thought I would test the water.
If Q can't find i...Stop all macros
I have a button on a form, which should do different things depending on
1. The data contained within the current record;
2. Whether the current record is a 'new record';
3. Whether the current record is the first record in the form.
On click, an embedded macro is initiated. Each step in the embedded macro
has a condition and a corresponding 'RunMacro' action.
All the conditions are mutually exclusive, and each sub-macro has a final
step of 'StopAllMacros'. So the embedded macro should trigger one, and only
However, it appears that what is act...Crosstab query and Lookup field problem
I'm trying to create a Crosstab query that shows a Class of Business on the
rows, Status along the columns and a total number of Projects as the values.
The trouble is, the Project Status field is a lookup from another table, so
though the Crosstab query works, along the top it shows 1, 2, 3, 4 etc as the
column headings instead of Investigating, Estimating, On Hold...etc.
I can't seem to find a way around this, can anyone help?
That's just one of the many reasons why many of us "seasoned" developers shun
lookup fields. If you want to ...calender updates
Any suggestions as to how I can update the calender in outlook 2002 xp to
show bank holidays for years 2007/8/9pls ???
Dale <firstname.lastname@example.org> wrote:
> Any suggestions as to how I can update the calender in outlook 2002
> xp to show bank holidays for years 2007/8/9pls ???
See if this helps: http://www.outlook-tips.net/howto/missinghol.htm
...Stopping the scroll bar
Hi all, this is my first time. I don't know if this is the right place
for this problem but here I go. I have created a template of an
invoice the size of an A4 and would like to stop the scroll bar moving
both horizantally and vertically in normal view just as if it was in
print view. Is that possible through VBA and if yes what is the code
that I would need to achieve such task.
Thanks in advance
Message posted from http://www.ExcelForum.com/
Not too sure what you are after but you can remove the scrollbars with
<Tools - Options> and then in the View tab, at the bottom,...Update dynamicly a query field formula
Hi All,Is it possible to update a query formula by vba code?for now i found a solution by just building a dynamic query,but iprefer to have an option to update just one field with new formulafrom time to time,is it posible?...Stopping a Campaign Temporarily
My client has executed the campaign in Jan 1st 2006 and the end date is Dec
31st 2006. But he wants to stop the campaign temporarily from 15th July 2006
and again start it from 1st Aug 2006.
So what is that I need to do for this thing, i have never come across this
kind of situation before.
Thanks in advance.
...Money 2004 and automatic portfolio updates
I have Money configured to automatically download statements from my
brokerage account for my 401(k). It downloads the statements correctly and
notifies me for review. When I click on "Update my positions", though, I'm
expecting it to record the new positions as purchases. Instead, it just
increases my positions and decreases my cash holdings in that account, so in
my monthly report I have an "Unassigned Expense" for the cash deduction,
even though it's not really an expense.
This also screws up my overall performance metric since it's not properly
adjusting my...Word document opens different when using XP and Vista
I completed a document on Word 2007 on a XP computer. I then opened the
> document in Word 2007 on a Vista computer and some of the styling and spacing
> was different? Is there a way I can fix this?
Probably not - see http://word.mvps.org/FAQs/Formatting/TextReflow.htm
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> ...Would you stop for a moment?!
Would you stop for a moment?!
O...man...Haven't you thought-one day- about yourself ?
Who has made it?
Have you seen a design which hasn't a designer ?!
Have you seen a wonderful,delicate work without a worker ?!
It's you and the whole universe!..
Who has made them all ?!!
You know who ?.. It's "ALLAH",prise be to him.
Just think for a moment.
How are you going to be after death ?!
Can you believe that this exact system of the universe and all of
these great creation will end in in nothing...just after death!
Have you thought, for a second, How to save you...Printing business cards: wrong size
I am using Publisher 2007 SP1 on Vista Ultimate x64.
The printer is HP Office Jet 1140xi.
I want to print business cards on Sigel LP798 2x5 cards per page.
Publisher "knows" that the size of a card is 8.5 x 5.5 cm.
However the printed cards have h=5.3 cm, the cards in row 5 are only
partially printed living a bottom margin of 3.2 cm.
This happens also when I print in PDF.
When printing from other programs the bottom margin is under 1 cm.
I modified the height to be 5.7 cm.
Result: it prints only 2x4 cards.
What am I doing wrong? Thank you very much,
Are you sure of your printer...