how can text be set up to generate a number?
i would like to a word generate a number, i.e.> enter "apples"in one cell and
excel generate "352" in a different cell for items like inventory.
You will need to set up a 'Lookup' table somewhere with
In two columns. Complete this for all entries and then if you are going to
enter 'Apples' on another sheet in A1 then in A2 enter
Microsoft MVP - Excel
"jwmaes" <firstname.lastname@example.org...Changing Resource and fields on a subform
I have a subform with fields on it that are present when i first open the
form. But when I click on a status button, I'd like the subform to change
the fields that are present.
For instance when i first open the fields are formid, lastname, firstname,
subject, date, range
But when i click on formstatus button, i'd like the fields to show: formid,
subject, range, product
I know how to use recordsource to change the recordsource, but then the
fields that I am not using show up as #name?
How do I get the subform to change field names so that the fields I am not
using, doesn't show ...Paste links, changed filename
I have created 3 exel 97 Files. Each File has approx 30
sheets. One of them is a source file. The other 2 use
file1 data using paste link(paste special). At some stage
I have changed the names of the files and now when I open
them it asks the usual question " do you want to update
linked information", Iclick "yes" ~ then the computer
wants me to select the source file. Before, it just
started straight into the file I wanted ~ how can i
resolve this( with as little effort as possible)?
Try hitting no, then do Edit / Links / Change Source, save the workbook and hopef..."Change Credit Details" button does not appear
I would like to update my interest rates and credit limits monthly, but the
"Change Credit Details" button does not appear when I go under the accounts'
In microsoft.public.money, mar11974 wrote:
>I would like to update my interest rates and credit limits monthly, but the
>"Change Credit Details" button does not appear when I go under the accounts'
See if http://support.microsoft.com/kb/281109/en-us helps.
I've no idea if it helped the original poster, but it seems I have the same
issue, and it didn't help me.
I'm ...Change height of row
Excel seems to limit the height of the row to some presets. Is there a way
to set height of row to any height? Am trying to make spreadsheet line up
with a pre-printed form.
i think the limit is 1 pixel
"Pam MacT" <Pam MacT@discussions.microsoft.com> schrieb im Newsbeitrag
> Excel seems to limit the height of the row to some presets. Is there a
> to set height of row to any height? Am trying to make spreadsheet line up
> with a pre-printed form.
...can i change the read receipt
This is a multi-part message in MIME format.
The read receipt by default set by outlook can be changed if yes pls. =
let me know how ???
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META http-equiv=3DContent-Type content=3D"te...how do I set-up a interveiw outline
how do I set-up a interveiw outline
"brazal" <email@example.com> wrote in message
: how do I set-up a interveiw outline
make a bulleted or
numbered outline via
DatabaseBen, Retired Professional
- Systems Analyst
- Database Developer
- Veteran of the Armed Forces
- Microsoft Partner
~~~~~~~~~~"share the nirvana" - dbZen
"brazal&...Changing name from Arabic to English
I, m registering all new recruitment employees so always I'm writing the
employee name by Arabic and English. So there is any code to change
automatically the person name for Arabic to English
...How do you turn off "Save a copy/Overwrite changes" dialog box
I have created a (password to open) workbook using Excel 2003 SP1 on a
shared network drive which when I try to save by using Ctrl S or
clicking the Save icon gives me an irritating dialog box which asks:
"The file 'filename.xls' may have been changed by another user since
you last saved it. In that case what do you want to do?"
-Save a copy
Please can someone tell me how to deactivate this annoying dialog box
as I have been unsuccesful so far in my efforts :confused:
Many thanks in advance
-----------------------------...Deleting a posted message
Is there a way I can delete a posted message OR at least
take my email off.
I have mistakenly given my email and have been receiving
spam like anything. It would be really helpful if the
admins of this group can help me delete that specific
Use the .NET serializer to turn it to a string .
Use the .Whatever in 2005, asking for MS for Permission
to post an 'unmanaged' question.
"Neo" <firstname.lastname@example.org> wrote in message
> Is there a way I can delete a posted message OR at least
> ...how to change business address
I can't seem to figure out for the life of me WHERE OR HOW to change my
business address so my NEW address prints on my invoices now that I have
moved. Can anyone help me with this? PLEASE?????
In microsoft.public.money, LGleim wrote:
> can't seem to figure out for the life of me WHERE OR HOW to change my
>business address so my NEW address prints on my invoices now that I have
>moved. Can anyone help me with this? PLEASE?????
Is there a Tools->Settings->BusinessInformation place?
YES!!! You did it! Thank you so much!
"Cal Learner-- MVP" wrote:
...Changing info from one worksheet to the next
Hi all. I have linked my 55 sheets to one which is great.
What i need to know now if possible.
Each sheet has the same question over 11 columns
Each row is dated and a numeric number from 1 - 10 in each row
Now on the master sheet where everything is linked, is there a way that
If i changed the date on the master sheet it would reflect the answers from
the row with that date?
At present the answers showing is for 01/03/10, but i would like to look at
the totals for 08/03/10 and show the answers from each sheet for that date.
I could have a sheet for each week, but im hoping there i...deleting pages in publisher 2002
When deleting p.5 (or any page) of my 19 page document, last page deletes
instead! What's happening here? How can I delete my page? I'm using "edit"
delete page. Also, I am not in Master Page mode.
On Thu, 23 Feb 2006 22:39:35 +0000, KLeDrew wrote
(in article <CA87F080-CAF5-4A38-956C-FDF8896CA92A@microsoft.com>):
> When deleting p.5 (or any page) of my 19 page document, last page deletes
> instead! What's happening here? How can I delete my page? I'm using "edit"
> delete page. Also, I am not in Master Page mode.
> ...Permission for account change
I have my domain as abc.com I have another domain xyz.com
for which i have created a separate account for the users
so that they can send the email with both the domain by
using from filed.
i have one user user1 who is facing problem i have
created userxyz for with the default email address of
but i am facing strange problem as the permission of
sending email is reseting.
Kindly suggest what can be the problem.
What version of Exchange and how/where exactly it is resetting?
> Dear Friends
> I have...change the size of Font for reading incoming mail
I'd like to change the Font with incoming email in my outlook2003.
my operation is in the following.
click options on the Tools menu,
and then click Mail Setup tab,
So I change the Font in this items:"When composing and reading plain text"
but I can't find the font to take any change when I read incoming email.
What my question is how I can change the Font size in the incoming email.
is the incoming mail plain text and the change isn't working or is the
incoming mail html?
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://ww...How do I change mailbox owner in AD?
How do I change a mailbox owner in AD? Can it be done?
The mailbox is linked to the user account. You can grant an additional
user(s) "owner" access by granting Full Mailbox access on the Exchange
Advanced Tab of the user properties.
"Thomas Houseman" <email@example.com> wrote in message
> How do I change a mailbox owner in AD? Can it be done?
Verify that you have mailbox retention enabled. ( right-click mailbox
store/properties/limits). This is extremely Important!
...SetFont does not set font
Yet another problem I am afraid and I would once more like to call upon a
little external wisdom. I am having a major problem with CFont and the
SetFont. Mainly: It doesnt want to work.
I am using the CreatePointFont method on a CFont object defined in global
scope at the top of my dialog.
I then attempt to try and use SetFont on a dialog, and on a button, and on
anything else for that matter and the effect it has is zero. I am using it
in my InitDialog routine yet I still get nothing when I paint text to the
window, or when I view the buttons on the dialog.
Has anyone g...Icons changed in Favorites since update
Just updated windows latest update - and now the icons in my favorites have
changed to a "square with a star" - at least 80% are like this - what
Thanks for anyhelp
...Publisher should allow the deletion of multiple pages
I wish publisher would allow for the deletion of muliple pages much like the
options available when printing pages.
lejianzhong <firstname.lastname@example.org> was very recently
heard to utter:
> I wish publisher would allow for the deletion of muliple pages much
> like the options available when printing pages.
Suggestion: Try here:
How to Contact the Microsoft Wish Program
Ed Bennett - MVP Microsoft Publisher
...Worksheet Change Event log for multiple cells
I have a spreadsheet that is available here:
(although I scanned it for viruses please make sure you do it again prior to
opening it as I cannot guarantee it's worm free).
I would like to create a log file in an additional sheet (hidden probably)
that would record every activity from column E after clicking a button
assigned to a cell in that column and show these records in a worksheet
Totals in a specific row.
For example: Column A from a worksheet „Totals” corresponds with column A in ...prnmngr vs delete all network printers
I wish to use PRNMNGR.VBS script file to install my network printers but
before installing those printers, I need to delete all previous installed
Is it possible to delete all already installed printers in one command line
with PRNMNGR.VBS script ?
Just a little thing I forgot:
Delete all NETWORK printers...
"Normand" <email@example.com> a �crit dans le message de groupe de
discussion : uvD4MyItKHA.4752@TK2MSFTNGP04.phx.gbl...
> I wish to use PRNMNGR.VBS script file to install my network printers but
> before...changing defalt from OE to Outlook
When I move into a folder and want to send a picture or
file attachment to someone, I right click the mouse and
use the mail option. The only problem is the attachement
loads up express and I'm using normal Outlook. How can I
change the defalt to be normal outlook and not express.
I'm on windows 98.
Go to Internet Explorer. Tools | Internet Options | Programs. Change the
default mail program to Outlook.
Ben M. Schorr, OneNote-MVP
Microsoft OneNote FAQ:
**...New personal finance resource website open #2
New Personal Finance Resource Website Open
Free articles and information on personal finance
*** Free account sponsored by SecureIX.com ***
*** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com ***
...OWA 2000 change password feature doesn't work
I cannot get the 'change password' button to work in OWA. I'm running an
OWA front-end server running Exchange 2000 post SP3 rollup on Windows 2000
Server SP4. I have it configured for require SSL only. My Exchange 2000
backend servers are Exchange 2000 post SP3 rollup on Windows 2000 Server SP4
as well. My domain controllers are Windows 2003 Servers in 2003
native-mode. All are in the same domain. I have even created the virtual
directory IISADMPWD and pointed it to the \winnt\system32\inetsrv\iisadmpwd
directory. The directory has .htr files in it. The last thing I try wa...Keep Deleted Items for (days) settings..
I want to set up the ability for users to be able to recover their own
deleted items for x number of days. However, I also want to make it so that
certain people, after they delete something, would not be effected by this
setting under Servers/First Storage Group/Mailbox Store. Hence, when they
delete, it's gone (unless it's recovered by tape backup).
Is this possible?
On Tue, 4 Apr 2006 14:17:48 -0400, "Galvanon" <firstname.lastname@example.org>
>I want to set up the ability for users to be able to recover their own
>deleted items ...