Novice trying to create zip code look-up
I know that it is possible to create a situation where a zip code is typed
into one column, and the city identified with that zip code pops up in
another column, but cannot figure out where to start with this. Can anyone
give some guidance?
Use a 2 column combo box. (ex. cboZip)
First Column for Zipcode and second column for City.
Set the combo's ControlSource (bind it) to your ZipCode field.
Since this combo control will capture the ZipCode, it is not necessary
also "capture" the City value in another control... just "...Pivot table question #9
I recently had a problem with values not showing properly in my PivotTable,
until it was poited out to me that I was using Text in some cells instead of
Ideally, I would like to include text. Is there anyway at all that I can?
My data comes from an Access Table by the way
the data in the pivot shows scores overall of several years competition, and
each meet has 2 reserves, who can step in for an excluded competitor.
However, the reserves might not compete, but still need to be recorded as a
competitor at the event.
Rather than showing zero (0) as their score, I'd r...How can you customize the left Menu?
I would like to display only "Opportunity" in the "Sales" area.
How can do that?
Thanks in advance.
I know you can add items to the menu through the ISV config option. If you
can't remove items you may have to develop a small application to just show
How e-commerce is done.
"Alan" <Alan@discussions.microsoft.com> wrote in message
> Hi all,
> I would like to dis...Can Microsoft Outlook import email sent to AOL?
AOL 9.0 permits members to save email on their own computer, but clicking on
that file to open still seems to link back to AOL as if still on their
server. Will Microsoft Outlook retrieve my email from AOL so that I can read
it offline and truly save to my computer?
can you copy it back to the aol mailbox? if so, connect ot the mailbox using
imap to get it into outlook.
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 Ti...csv-files with '+' in field -> treated as formula
When I make up a CSV-file (from our oracle-database) we
have to fill in a line like this:
When opening the file in Excel, the 4th field (+BE) is
treated as a formula, but that is not an option.
Anyone have an idea how to write it in the CSV-file so
that it is treated as a text-field but without showing any
quotes (so I would like to see +BE and not '+BE)
Tnx already in advance!
found something myself: just add a space before the + and
if anyone has another idea: post it
>When I make up ...Lost Subject Field
I don't know how I did it but somehow I managed to delete
the subject field in outlook so now when I go to create a
new email to send to someone I only have the TO: line
I am unable to enter a subject!
How do I get the subject back????
Go up to VIEW | MESSAGE HEADER.
"Rockets" <firstname.lastname@example.org> wrote in message
> I don't know how I did it but somehow I managed to delete
> the subject field in outlook so now when I go to create a
> new email to send to someone I only have the TO: line
&g...2 Subforms, can't change link fields for one
I have two subforms on my main form. The second is a copy of the first, but I
want to link it to separate fields on the main form.
When I open the main form in design view, the first subform shows in design
view, but the second is just a blank control. The controlsource field is set
to the same as the first.
When I try to change the link child/master fields, it says: "The expression
you entered refers to an object that is closed or doesn't exist." and blanks
What am I doing wrong?
...Creating a closed Phone activity in a single step
I have looked absolutely everywhere for a solution to this. As many of our
processes are still outside of MS CRM much of our outbound sales/prospecting
calling is driven by external processes.
(example 1) our receptionist (who has no CRM access) gets a call from an
existing customer interested in purchasing product from us. The account
manager gets the message, looks up the record in CRM and immediately calls
them. We need the sales person to record a phone activity to say they've
'touched' this account, however this isn't a to-do item, it is already
closed. ...MoveCopy, unable to create test msg
I have a user running Office 2002 SP2 on Windows XP.
Recently he began receiving the following message when he
opens Outlook for the first time each day.
"Server-Requested client action - MoveCopy, unable to
create test msg"
I can log in at that PC and setup Outlook without issue.
does this appear to be a profile issue? I would
appreciate any assistance on this.
...Can someone help me to understand schema locations?
I have this xml:
And, I'm trying to read it... without success. I'm using code from this
KB318545 (http://support.microsoft.com/kb/318545), but not having much luck.
That its not working is probably because I don't understand how to map the
info above to the parameters needed ...can't send messsages in window mail
I keep getting an error code (0x800cccD) and yet i can recieve mail in the
Please post the error message in its entirety. You can left click on it to
highlight and then right click to copy and then paste it into this thread.
Imperial Beach, CA
"Lonnie" <Lonnie@discussions.microsoft.com> wrote in message
>I keep getting an error code (0x800cccD) and yet i can recieve mail in
> sme ppage
I tried moving all mess...Can not scroll down
I was able to scroll down in my spread sheet before but know I am not able to. I don't have a clue how to correct this problem.
One possibility but only if you're zooming instead of scrolling:
Tools > Options > General
Remove check from "Zoom on Roll with Intellimouse"
Norman Harker MVP (Excel)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
=?Utf-8?B?RmVsaXBl?= <email@example.com> wrote in
news:3E6A8F9A-6FCA-4542-A...Can't Clear Check
In Money 2002 I have two accounts, checking and credit
card. The check written to pay the credit card won't
accept the mark as c entry, nor will it from the credit
card account. No change to this entry can be made at all,
date, amount, memo, etc. The program displays, "This
transaction could not be entered." or "Money could not
write to your Money file. The operation cannot be
performed or another application finished this task before
you." Money doesn't crash, all other functions work (so
far). I've used both the Salvage and Super Salvage and no
...I can't print my incoming e-mail. Jibberish is printed instead.
Is this a new issue or has it always happened?
"Digger" <Digger@discussions.microsoft.com> wrote in message
...Formulas for birth year and age in user defined fields
I'm using outlook 2002. I want to create 2 user-defined fields in my
contacts, but am having trouble figuring out how to do it:
1. Year of birth field, based on the value entered in the birthday
field - I created a new user defined field, with the Type set as
Formula, and the formula set as: Year ([Birthday]). The year is
displayed, but formatted as a number (1,957) rather than a year
(1957). How can I get the number to be displayed without the comma?
2. Age, based on difference between birthday and present date - Is
there a simple formula to accomplish this?
I haven't been ab...Can exchange2000 delay large messages?
I have taken over the administration of an Exchange2000/PD server.
Some of the network users are sending stupidly big files over email
during the middle of the day, and this is filling up the internet
link, so I want to delay them to be sent after hours. If I can't do
that, can I limit the size altogether? Can I define what is a large
I am not really an experienced Exchange admin, coming over to it from
the land of linux and postfix.
Assuming you are going to continue to let them send out these large
messages, you can do this with a SMTP connector.
...can't send replies to msgs
Try to send a reply to a received message and computer
freezes? Whats up?
We'd need a lot more info to help you - version of Outlook, SP level, type
of email account, how big is your PST file?
> Try to send a reply to a received message and computer
> freezes? Whats up?
...can I have a multiselect option for a list box in excel 2003
I am working with Excel 2003, I created different list boxes for different
fields but I wanted to know if I could select more then one answer by using
CTRL command? Is that only available for later versions?
Yes, you can.
Depending on what type of listbox it is and where it's located, the instructions
to modify the settings would be different.
If it's a listbox from the Forms toobar placed on the sheet, then rightclick on
it and choose Format Control, then Control tab and choose Multi.
If it's a listbox from the Control toolbox toolbar placed on a workshee...Can I just reinstall Pub 2000 when it is part of Office 2000
Having just upgraded to Office 2003 I am tearing my hair out with Publisher
2003. I just cannot get it to work with my web site files made in Pub 2000.
My site is now out of date and I haven't got time to learn Front Page! Can I
un-install Pub 2003 and re-install Pub 2000 even if they are part of Office
2000 and 2003? Help!!
You can install Publisher 2000 as a standalone application. Create a separate folder
on your hard drive and install it there.
Mary Sauer MSFT MVP
"Maudie" <Maud...Outlook From Field Disappears
The from field for the inbox disappeared. When I try to
re-add it, Outlook crashes.
Office XP Service Pack 3 on a Windows XP Pro workstation.
AppName: outlook.exe AppVersion: 10.0.6626.0
ModName: outllib.dll ModVersion: 10.0.6515.0
I have uninstalled Office, ran regclean and reinstalled
to no avail. I also tried replacing the dll from another
install of Office.
Any ideas? Please email me if possible.
...at least one recipient does not have an e-mail error
This error message continues to show up after our upgrade from CRM3 to CRM4:
At least one recipient does not have an e-mail address or is marked as "Do
Not Allow" e-mail.
It happens in emails and appointments that I've noticed so far. It can
happen to an appointment when only one user is both the required attendee and
the regarding person. I have looked for any missing emails in the user
records, and the email is there. The user is capable of receiving emails. I
have looked for inactive and active contacts, and open and closed leads to
see if there is another object wi...Fields... what's going on
Sorry, I expect this is really basic.
I'm trying to write fields in Word 2000 with the IF command. The
problem is that, suddenly, when I try to write them (CTRL+F9), I get
the braces fine, but can only input the letter "I" - nothing else. 1
character, and it can only be a capital "i". Can someone tell me why
this is, and how to stop it?
It worked fine until 1/2 hour ago. *sob*
Thanks in advance
This newsgroup is for discussions about Microsoft Access, a relational
database program. A Word newsgroup would be a better choice for your
"Cr...Size of file with pivot table
I have a file that was 8MB when I started. I created a pivot table pulling 7
fields from a worksheet. Now the size is 20MB. Any ideas why this one pivot
table would cause the file to be so large when the 8MB file already had pivot
table sin it?
When it was 8MB, it had 6 pivot tables.
Now it's 20MB and it has 7 pitvot tables.
Why is this one table so much larger?
Were the 6 PivotTable independent, or did they all use the same cache?
If you build PivotTables that use another PivotTable as reference (for when
you're reference the same raw data, just taking a different...tables in PowerPoint
I have made a 25"x25 " banner. I want to add a grid that will display on the
banner when i print it. I put a 25 x 25 cell table on it, and I can make it
fit horizontally but I can't compress it vertically. How can I do that?
Atlernatively, is there a better way to put a grid on the banner? I have a
picture underneath that I want to show through the grid.
Change the internal margin of the cells to 0 for top and bottom. You may
need to change the font size to something like 2 point (or as small as you
can go) also.
Echo [MS PPT MVP] http://www....Exporting data from a table to blogs
Hi, i have seen the sharepoint function offered by MS Excel. Would like to
check with you whether this could be performed and exported into a blog?
I've used sharepoint, but am not sure what you're talking about. Can you
give some specific info on what you want to do?
> Hi, i have seen the sharepoint function offered by MS Excel. Would like to
> check with you whether this could be performed and exported into a blog?
As in i have some data in MS Excel which i would like to export it and
publish into a blog. Is it possible and is sharepoint ...