How can I change all the figures on a worksheet by a set %, witho.
taking a guess here as your question was truncated (always best to have a
short subject and put the details in the message) - type the percentage that
you want to increase your figures by (i.e. 110% to raise them by 10%) in a
cell somewhere and copy it, then select all the cells to increase and choose
edit / paste special / multiply and click ok
hope this helps
"magsgoode" <firstname.lastname@example.org> wrote in message
...Problem after Changing the Domain Admin password
After changing the password for the domain admin users cannot log into
outlook but can open WEBMAIL. If i change the admin password back and
restart the the Exhange services everyone can once again log into their
outlook. It is Exchange 2000 on a windows 2000 server. The exchange
services are set to use the local system account. Any suggestions.
...Value Change Event
I would like to know how to make a new event that occurs when a value
in an object changes.
Can you give an example of what you mean? If by "an object" you mean a text
box or other Access control, the control has an AfterUpdate event that you
can use. For ActiveX controls, it's not quite as straight-forward.
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
"Chipcom" <email@example.com> wrote in message
> I would like to know how...Queries about changing date format
I have a table that has a date in it and it also has the time. I need to get
rid of the time and leave the date. What is the best way to do this?
In a query? Just use format to return the date you want.
DateOnly: Format([YourFieldName],"short date")
Hope that helps!
"T Miller" <TMiller@discussions.microsoft.com> wrote in message
>I have a table that has a date in it and it also has the time. I need to
> rid of the time and leave the date. What is the best w...How to Change ITEM Average Cost in GP 10
How to Change ITEM Average Cost in GP 10 - while the feature disappeared from
utility --> Inventory on release 10.0???
Inventory Tile, then from the desktop Utilities->Adjust Cost
Or Microsoft Dynamics GP->Tools->Utilities->Inventory->Adjust Costs
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
"Mohamed Salah" wrote:
> How to Change ITEM Average Cost in GP 10 - while the feature disappeared from
> utility ...change address sender outlook 2000
I receive mails from multiple accounts in outlook, most of them using
But I can only use the exchange email address to send emails. Is there a
workaround? (I prefer freeware...)
...Could NOT change mail address after windows server 2003 sp1
Exchange Server 20003 SP1 on Server 2003 Enterprise
After upgrade to Win Server 2003 SP1 only users who are members of Local
Administrators Group (in Exchange 2003 server) can change an email address.
They can create new mail enabled users (with default addresses)
The error message is
An Exchange Server could not be found in the domain
Check if the Microsoft System Attendant service is running on the Exchange
ID no: c10308a2
Microsoft Active Directory - Exchange Extension
What errors do you see in the event logs (specifically the application log
and system log). That sounds rea...Stop "attachments of message have changed...do you want to save?"
How do I stop receiving this message for any message for which I have merely
opened an attachment, without making any change to it?
This greatly depends on your version of Outlook and the type of attachment.
For details see;
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more
Real World Questions, Real World Answers
"DaveHause" <DaveHause@discussions.microsoft.com> wrote in messag...Getting a number to update
I have a form with a button that when clicked I would like to have it go to a
file, get the number there, add one to it, and then save it back in that file
as well as display it in the field on the form. I created a table for this
number, but don't know how to program the button to do what I want it to do.
The users need a new number only some of the time, and would then click the
button. The number needs to be incremental by one. Would a query work best
or an update? I am at a loss, please help.
First BackUp your data
I assume that this table has only one record whi...Sepatate positive and negative numbers
Is it possible to automatically separate positive and negative numbers
(precedeed by a minus sign) from one column into two different columns ?
I'm using Excel 97.
If you have your list of numbers in Col A starting in Row 1
Put this formula in B1 =if(A1>0,A1,"") for pos #'s
Put this formula in C1 =if(A1<0,A1,"") for neg #'s
Copy the two formulae down as far as needed
Note that zero will not show in either col B or
Cutter's Profi...unsend or retrieving e-mails?
Hello there! Here is a nut for the pros...
Is it possible in any way to retrieve sent e-mails?
Sometimes - like right now - I am a bit (read: very very)
frustrated, because I have sent an e-mail to the wrong
person. Once in a while I have sent mails from my draft
folder, by mistake too.
Are there any ways to unsend such messages or perhaps
delete them before they are received on the other end of
I am not alone on this, believe me.
Only if you are using Exchange server and are trying to retrieve mail from
the same organization that has not been opened.
You can try using...How do I count the number of "yes" boxes?
I am helping plan a conference and would like to use Access to manage/track
the registrations and mailings. I have managed to get the names and
addresses for the people we are inviting entered into a table. I have also
added to the table a number of columns with yes/no options (examples: are
they coming, are they bringing a spouse, have they paid yet). I would like
to know how to get queries that will count the yes or no answers (examples:
how many people are coming, how many people are having Wednesday dinner). I
don't know much about Access so any suggestions will need to be r...formula to replace cell with over 8 characters with word LAN
I hope someone will be able to help. I need a formula that can check each
cell in column "D" and if it has over 8 characters in the cell, return a
value of the word LAN in column "F". Anything with 8 or under should remain
as is. There will be up to 600 row entries in column "D".
example of col: 799Z
I'm aware that with all the talent and expertise in the group, this is small
potato's, but it is greatly appreciated.
=IF(LE...Linked Excel table
Hope someone can help me. I have weird printing problem that I can'
seem to fix! Here's the story ... I am using Windows XP and Offic
2003. I link excel tables into a word document (paste special/as link)
There is color font in the excel table. The color always appears on th
screen, but disappears when I print it to pdf or printer, *but onl
from certain PC's* Hence, the problem! I've compared the settings o
Word and Excel between the PC that can print the colored text and th
ones that cannot. To no avail. Any help would be appreciated. Thanks,
Message posted f...round up the number
I have a table below:
A B C
1. 123.60 12
2. 178.40 8
How can I set a formular to get the following results:
C1 = 124 * B1 (A1's 123.60 round up to 124)
C2 = 178 * B2 (A2's 178.40 round up to 178)
thanks in advance!
"Lowan Chan" wrote:
> I have a table below:
> A B C
> 1. 123.60 12
> 2. 178.40 8
> How can I set a formular to get the following results:
> C1...Junk E-mail filter #2
The Junk E-mail filter I have learned does not work unless Outlook is
running in cached mode. I am not sure I understand why this is so. The
server does not provide any filtering, so unless we can put up with the
delayed access time in cached mode, we can't have any filtering? Is that
right? Or is there some other server-side filtering I'm not aware of?
Thank you for posting here.
You are right that the Junk Email filter feature only supports in Cached
However, on the server side, you may use the following suggestion to
1. ...Change Color Font on E-mail Signature
I want to select a line on E-mail signature to go red.
Even when I copy and past, it comes out black. Help
i dont know your version.
But if you go on your signature under
you could create a red line!
Ich habe nichts gemacht, gestern gings noch!
Bitte in den Newsgroup antworten damit jeder etwas davon hat.
"Ron" <firstname.lastname@example.org> schrieb im Newsbeitrag
> I want to select a line on E-mail signature to go red.
> ...Excell: Column Changes
The Excell program changed the Column labels from alpha characters to numbers. This makes it somewhat difficult to use formulas. Any ideas on how to changes back the numbers to alphabet characters ???
Tools|options|General Tab|Uncheck R1C1 reference style
> The Excell program changed the Column labels from alpha characters to numbers. This makes it somewhat difficult to use formulas. Any ideas on how to changes back the numbers to alphabet characters ???
Tools -- Options. On the View tab, under Settings, uncheck R1C1 style.
And...Incoming e-mails going to everyones e-mail account
I am running OfficeXP on a WindowsXP computer. I have set
everyone in my family up with their own profile to log-on
to our system. I then went into outlook for each profile
and set-up incoming\outgoing mail for each e-mail address,
in their profile so they can manage their own mail
accounts. For some reason all incoming mail can be seen
and read from everyone's mail account profile. And if I
delete mail it deletes from all profiles. It seems to be
putting all mail in a community inbox. What do I need to
do to separate mail accounts?
"email@example.com&qu...How do I block someone from sending me e-mail?
There is someone that keep sending me e-mail and I want to block them in
Outlook, please help.
Create a rule to delete the messages as they arrive. tools, rules wizard.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Join OneNote Tips mailing list: http://www.onenote-tips.net/
"Stargolf" <Stargolf@discussions...How to reopen and make changes to a closed contract
I have been reading the blog from ms dynamics team about opening and changing
a closed appointment:
I'm trying to do the same thing with a contract. the code I used is almost
I changed "Appointment" with "Contract" and the state and state Reason:
state code :
see also http://msdn2.microsoft.com/en-us/library/a...How to create a pie chart with 793 numbers? Possible?
Hi, I've been trying to create a pie chart with 793 numbers on one single
colum, the column consists of various numbers and i would like to take a
percentage of numbers on the column, for example there are 100 tens ranging
from cell A1 to A99 and 500 1's ranging from cell A100 to A699 and other
numbers, is it possilbe to create a pie chart with that many numbers?
-- Every time i tried to create the pie chart using the chart wizard, the
finished chart will always shown with so many different slices, any tips on
how to create the pie chart would be greatly appreciated thanks in adv...Need to insert x number of rows in a list of data
Operating System: Mac OS X 10.6 (Snow Leopard)
Greetings, <br><br>I am trying to insert approx 10 blank rows below each line of data in a spreadsheet. (The extra rows will be used for calculations for each original row.) <br><br>I hope my explanation is sufficient; please let me know if not. <br><br>I suspect my dilemma can be fixed easily, but I have searched online for a number of hours to no avail. Under a previous version of Excel, I could have created a macro to semi-automate this, but have no idea about Excel 2008 ...Message auto defaulted to 50% when using Word as the e-mail editor
I have a problem with Outlook defaulting the view to 50%
when using Word as the e-mail editor. Does anyone know
how to resolve this?
...Can't print bank account number on checks
I'm using Money 2005 and I can't get any of my
information to print on my checks (my bank name, address,
checking account number, etc), but I can get all of the
payee information to print...Can anyone help me?
Email responses here & firstname.lastname@example.org
In microsoft.public.money, Lee wrote:
>I'm using Money 2005 and I can't get any of my
>information to print on my checks (my bank name, address,
>checking account number, etc), but I can get all of the
>payee information to print...Can anyone help me?
See FAQ available at http://umpmfaq.info/faq.h...