Re-arranging table using pivot-table?
I have a worksheet with data organized somewhat like this:
New York New York
New York Albany
California Los Angeles
California San Diego
I need to convert this to a list of states and each city in the columns to
the right of their corresponding state. Something like this:
New York New York Albany
Florida Miami Orlando Tampa
California Los Angeles San Diego
Any help is greatly appreci...Re-install Outlook 2002
I am trying to re-install Outlook 2002 for my palm pilot
after a crash. The installation will run until I get the
message - "another version is already installed and must
be uninstalled". The previous version was corrupt and I
was unable to uninstall it. Now when I go into the control
panel to add/remove the uninstall is no longer in the
...access file to exe file
May i know the procedures on how to make access file to an
executable file. I read a lot of Access books from 97 to
XP versions but i was not able to find any.
thank you very much and anticipating your response.
> May i know the procedures on how to make access file to an
> executable file. I read a lot of Access books from 97 to
> XP versions but i was not able to find any.
I tried a number of converters to translate Access into Visual Basic, all
with limited success. Even when I was able to get a form working it required
as much time to tweek it a...Outlook 2003 refresh feature
Client is WinXP (Sp1) and OfficePro 2003 outlook (sp1).
Using neither NAT nor firewall. Incoming messages are not
being displayed unless the user clicks on another folder
and back to Inbox (very frustrating, considering the user
gets dozens of messages a day 'cause of the nature of his
I have checked the KB for the problem but I have found
nothing specific about OL2003 and XP.
Other posted messages have either OL2K or XP or some other
combination of OS' but nothing that applies directly to my
Regards and thanks.
Was this one of the articles you read...enter network password in Outlook 2003
Using Outlook 2003. I have my email set up to
SEND/RECEIVE every 5 mins but i keep getting the ENTER
NETWORK PASSWORD / USER NAME dialog box up and its
driving me mad.
All my setting look ok so I cant see why this is
I use btinternet/yahoo as my isp. Have spoken to BT
broadband net help who advise me that they DONT support
PLEASE HELP me to sort this out
Do you have more than one account configured with the same server? Does it
work when you enter your password or does it continue to prompt?
For all Outlook versions on Windows XP (just ignore the par...Backup feature in 2007 Runtime
I have an Access 2007 database that i'm deploying with the runtime and would
like to enable the backup feature located in the file menu.
How can i call this feature or something like it so that the (novice) user
can specify the location and with a predetermined filename of the backup file
in the same sort of easy manner that the backup function uses?
(I'm planning to execute this at the OnClose event of a main form)
Thankyou in advance.
Never mind it can be added to the shortcut menu for the specific database
> I have an Access 2007 database that i...Re-Enable CRM User
I am trying to enable a disabled CRM user and I received the following error
message. Any thoughts or suggestions would be greatly appreciated.
String UserId) +0
Microsoft.Crm.Application.Platform.SystemUser.Activate(String id) +38
sender, DataEventArgs e) +127
eventId, FormState state, User user, String objectId,...RE:Excel will not open from a web link
When opening a link on a web page that has an Excel
Spreadsheet embedded in it, the spreadsheet will not open
up Excel but opens within another browser as an Excel
file. Programming on webpage is correct, opens up on
other machines just fine.
In the inventory form i have this formula to calculate products on hand:
=Sum(nz([UnitsReceived])-nz([UnitsShrinkage])-nz([UnitsSold])), but we buy
the same product from different vendors if one doesn't have it so product
number different for every supplier,
my question how do i bring all together to get units on hand or in stock?
thank you very much
Message posted via AccessMonster.com
Are you saying that you have a "part" that can be supplied by more than one
"supplier"? F...Word Template created in Word 2008 (mac) won't save on Word 2007 (vista)
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
I designed a Word template in Word 2008 (mac), but when I attempt to use and save in Word 2007 on Vista I get an error message that it can't be saved. <br><br>The template opens as a blank page. When I edit on Word 2008 for Mac, save it as a .docx and open it in Word 2007 Vista, it can be seen, but it still can't be saved. <br><br>I've saved the template as a .dotx file, as I should. So I'm confused as to why it won't work on 2007 Vista. They're the most current versio...How do i change my file from a 2003 office doument to a 2000 docu.
i have done this before with a word document but i dont seem to be able to
figure out how to do it with a publisher document.... can anybody help??
File, save as, files of type, expand the menu to Publisher 2000.
Mary Sauer MS MVP
"me" <email@example.com> wrote in message
>i have done this before with a word document but i dont seem to be able to
> figure out how to do it with a publisher document.... can anybody he...Outlook 2000 or XP on Exchange 2003 SBS
it appears that the only way Outlook XP and 2000 users can receive their
emails is when they highlight an email already in their inbox. For instance,
if they are in their Word program and they look into their Outlook, without
highlighting an email on their inbox, it would show that they have not
receive any emails. However, the moment they highlight an email in their
inbox, then they'll receive about 5 emails that appears to have been in some
type of queue. It's obvious that they were in there for quite a while
because of the time that they were sent.
Are these client run...Connect Windows 7 to SBS 2003
Spent the last eight hours trying to connect my W7 workstation to a fresh
install of SBS 2003 premium. When running http://server/connectcomputer/, I
would get as far as providing a username and password for setup when a popup
would inform me, "The list of users and computers could not be found. Make
sure that the Small Business Server network adapters are configured
correctly.". I have only one NIC, I can see the shared folders on my server
and even connect to them. My server is not running DHCP or DNS and I think
these might be my problem. I did run windows update and...Thanks Ken Wright but one more question RE saving data from circular references
Thanks heaps for that macro Ken Wright .
I have run it and it works.
However it loops forever. Can I set it up so that it could save dat
from a certain number of iterations?
Thanks again Michae
Message posted from http://www.ExcelForum.com
If you stayed within your thread and did not change the subject
Ken would see your reply as a reply to his reply and would see
it a lot faster than when you start a new thread. Ken would
probably see your post highlighted in RED. Also someone other
than Ken might have been able to help you. (not me I avoid
anything that hints of circul...Re: exmerge error
I am getting the following error when trying to use exmerg
can anyone please help
Microsoft Exchange Mailbox Merge Program, v4.00.02
Start Logging:February 27, 2004 20:04:3
[20:04:31] Logging Level: Non
[20:04:31] Reading settings from file 'C:\Program Files\Exchsrvr\BIN\EXMERGE.INI'
[20:04:32] Error 8007203a opening an LDAP connection. ('LDAP://EXCHANGE/rootDSE') (CADRoutines::GetNamingContextData
[20:04:32] Accessing Domain Controller 'PROFI...Ron Bovey re: "Trim Selection" in ExcelUtilities
Cells in my Excel spreadsheet appear to be empty. However, when I use
Edit/Go To/Special/Blanks, I get "No cells were found".
In the past, Ron Bovey suggested going to the WWW.APPROS.COM website,
download ExcelUtilities and then use the "Trim Selection" utility to
remove the characters that are making the cells not empty.
Since then, I've gone to the WWW.APPROS.COM website and downloaded the
ASAP Utilities. However, I can seem to find the "Trim Selection" nor
any utility that will do the same thing.
Try going to Rob (not Ron) Bovey's site:
Does anyone know when the sunset for Access/Office 2003 is?
I'm thinking about going straight from Office 2003 to Office 2010? Does
anyone have any info on the stability of Office 2010?
Thanx in advance!
Sunset? Hum... Considering I still am supporting client using access 97, I
wouldn't worry too much.
Also, I wouldn't rush into any new software, including access 2010, until a
good year after it's initial release to allow, in this case, microsoft to
resolve the bugs that will most certainly occur. You also have to realize
that most compan...Simply Identifying the location (in My Documents) of the Access Database that I have open
I am often working in an Access Database, and need to know in which
Folder the Database exists. In other Msft applications, I can find
out by simply selecting file > Save as. But in Access, this is not an
So is there another way to identify in which folder the Access
database is located?
"Dave K" <firstname.lastname@example.org> wrote in message
>I am often working in an Access Database, and need to know in which
> Folder the Databas...Transfer files from money 99 to money 2003
We have a new computer with money 2003, old computer has
our records in money 99. We tried to import export but
the records to not come across correctly. What should we
You shouldn't have to export or import. Just move across your .MNY data file
and open it with the newer version. See http://umpmfaq.info/faqdb.php?q=68.
"Michelle" <email@example.com> wrote in message
> We have a new computer with money 2003, old computer has
> our records in money 99. We tried to import export but
> the...How do I get invisible lines & borders to re-appear?
In Publisher 2003, table grid lines, text box borders and autoshape borders
have become invisible on-screen, although they do print out. Any ideas on how
to remedy this?
Recently installed Adobe PDF Maker which seems to have precipitated this,
although it could be entirely co-incidental.
Try updating your video drivers.
MVP Microsoft [Publisher]
"Ackerman & Co" <Ackerman & Co@discussions.microsoft.com> wrote in message
> In Publisher 2003, table grid lines, text box borders and auto...OL 2003 install over OL2002
I'm currently running OfficeXP(2002). I don't see any compelling reasons to
upgrade to Office2003, except for the Outlook piece. Can I upgrade Outlook
2003 without screwing up the other OfficeXP components?
Yes, but you won't have the option to use Word as your e-mail editor
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Create an Office XP CD slipstreamed with Service Pack 3
"Bruce" <firstname.lastname@example.org> wrote in message
> I'm currently...change default font size for all fields in outlook 2003
I want to change the default font size for all fields in outlook.
I can inly fin a way to change one view at a time.
...import .pst file into entourage 2008 no access to pc
Operating System: Mac OS X 10.6 (Snow Leopard)
my pc just broke I have my outlook 2007 file saved in a .pst file, I don't have access to a pc, what I can do to import in entourage? <br>
It seems that for mac office the compatibility is essential but not for all!!!
On 4/7/10 6:53 PM, email@example.com wrote:
> just broke I have my outlook 2007 file saved in a .pst file, I don't
> have access to a pc, what I can do to import in entourage?
There are some third party option that can help with that.
Check out the options on...re re re ????
What is the column in the register that has the heading of
a red exclamation mark? Some of my entries have an image
of an envelope and a question mark in that column. What
does this image mean?
This is Money 2003 Deluxe running under Windows 2K.
Thanks in advance.
See http://umpmfaq.info/faqdb.php?q=6 and
http://umpmfaq.info/faqdb.php?cat=6. From online help:
There are two icons that indicate different conditions for downloaded
When you see ? in your account register, no match has been found for this
downloaded transaction. It is marked as a possible new transaction.