Is this do-able?
A user has created a 'select' query in MS Access.
1/ runs the query (the user is prompted for an 'end' date / filter)
2/ switches to 'pivot table view'
3/ exports to MS Excel
We would love to do this in one step.
* I know how to link to external data in MS Excel, and could then refresh
the raw data in Excel. However, the number of lines in my resulting
spreadsheet varies so my pivot table would have to be recreated or the range
reset, I believe.
Thank you for any ideas.
(** Is there a better newsgroup to post thi...Viewing Hotmail message on web vs. WLM
Let's say I'm viewing a message from Hotmail's website (as opposed to viewing
it in Windows Live Mail), and the message contains a 1 meg attachment. If I
click on that attachment in order to view it, has it been downloaded at that
point? (i.e. would it count as a meg of transferred data?)
Depending on your connection speed and the type of file, the file will start
downloading to your browser's temporary files. A pdf file will display
before all of a large file is downloaded.
If the file has downloaded and you want to keep it, File, Save as, change
t...Viewing pst file
Is it possible to see the contents of a PST file without
going through Outlook? Are there any tools available to
I know in Outlook Express that there are tools that can
view the contenst of the dbx file without using OE.
Any help would be appreciated.
Yes, there are pst-viewers like http://www.mailnavigator.com
Also note that Exchange is able to import pst-files
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Backup and Restore
-Create an Office XP CD slipstreamed with Service Pack 3
"Fennis" <anonymous@discussions....Tree and List view
Hi , i am developing an app. which works as follows:
1. Enter IP of a system
2. Connect to that system
3. Open a windows-explorer like window displaying the drives on the leftside
and corresponding files and directories on the right.
would really appreciate any ideas, suggestions...
Create a SpliterWindow with TreeView and ListView then populate the
and keep the treeview and Listview in Sync. You could find some
samples in MSDN related to it.
"Kapil Patry" <email@example.com> wrote in message news:<uLHWH60iEHA.3876@TK2MSFTNGP...Class view or Resource view not available
When i open my .vbw file (VC++ 6.0). Sometimes i can't view the "Class view
or the Resource view". It also takes a long time to open the app. Any ideas?
...Publisher 2000SR1 won't open Publisher 2 file. Is there a viewer?
I have a Publisher 2 file I'd like to open to view, but my copy of Publisher
2000SR1 says it can't open a file created by another version of Publisher. Is
there a viewer for Pub 2 files?
No viewer... Publisher 2.0 files are tough to open because of a security update.
Error message when you try to open a Publisher 2.0 publication in Publisher
2003, Publisher 2002, or Publisher 2000: "Publisher cannot open this file"
I have Publisher 2.0, if you send the file to me I will convert it to 2000 for
...Wise Dimensions 3D Viewer
I'm trying to contact the guy. But get no response to email
Is he still in business? Anybody have an alternative email address
that they can forward me?
He does a pretty good job of taking the money via an intermediary and then
"SteveM" <firstname.lastname@example.org> wrote in message
> I'm trying to contact the guy. But get no response to email
> Is he still in business? Anybody have an alternative email address
> that they ...How can set up Excel to be able to print checks?
I wish to be able to build a template so I can print checks from an excel
This file might be a help:
It's in the "Accountants" section on page:
It contains the "SPELLNUMBER" function, which can be used in your
spreadsheets, two methods to convert numbers to words and two cheque
The code is open and commented.
Andy Wiggins FCCA
Excel, Access and VBA Consultancy
"catherine" <catherine@discussio...View List of Connected Users in Business Portal
Prior to rebooting or applying patches to Business Portal server, we need to
view and see list of connected users in Business Portal so we can ensure we
do not accidentally disconnect them while they are working. I understand we
can view who has what databases open in SQL server hosting the Great Plains
database where we can view activities. However, it would be nice to view
within Business Portal server who is connected and have ability to notify
those users to disconnect or that server is going offline.
This post is a suggestion for Microsoft, and Mi...removing marketing/sales from account view
Is there any way to remove marketing or sales from the account create or
update screens? I can get rid of either on the main sidebar with the sitemap
but there doesn't seem to be any entry for either in the account nav bar
there or in the isv.config file where I expected it to be.
There's an excellent post on Ben Vollmer's blog about how to do this
Hope this helps!
"Simon" ...winxp not able to join domain
hi! recently, i've some issues in a small grp of clients about 5% of the
total 1000 PCs. We're not able to join these PCs into our win2003 domain.
I've to rename the PCs before i can join to the domain. I've checked in the
AD, the computer name is not there and all the dns, gateway and etc are
correct. I didn't see any related msg in event viewer as well.
for some of these pcs i've to re-join the domain for the user to login again.
has anyone encouter this before? pls advise. thx
Are the machines created from a not sysprepped image? Did...Page breaks are different in Windows 2000 and Windows XP
I have a worksheet that prints page breaks differently in Windows 2000 and
Windows XP seems to sometimes print one or two lines less per page than
Windows 2000. This causes different users to get different results when
I tested on one W2K and one XP system. Of the two systems I tested, both are
running Office 2003 at the same service pack, all Microsoft updates applied,
same HP 8150 printer, and same printer driver versions.
I have checked printer settings on both systems, and I cannot find any
settings that are different between the two installations.
Has anyone ...Running Sum on a Continuous View subform
This is a slightly different question than my last.
I have a Continuous View subform designed to look like a Datasheet View
subform, with the following fields:
The "Tax" field is a calculated field from the "Subtotal" field:
The "Linetotal" field is also a calculated field from the "Subtotal" and
"Tax" fields: =[Tax]+[Subtotal]
There's typically several records in the subform, and I would like to have a
Running Sum of the "Linetotal" field, and ha...two-sides pages
How do I create two-sided pages for a recipe book?
On the Tool bar, select Insert, Page
Don - Publisher 2000�
"Cheryl" <Cheryl@discussions.microsoft.com> wrote in message
> How do I create two-sided pages for a recipe book?
...2nd view class in SDI
I have a book that describes how to add a second view class to an SDI
application, & toggle views via the View menu. It doesn't say how to create
the second view class. I right clicked on the Class view to add a view based
on CListView, but had to manually add Afxcview.h to stdafx.h to get it to
compile. Is there a more efficient way of doing this?
> I have a book that describes how to add a second view class to an SDI
> application, & toggle views via the View menu. It doesn't say how to create
> the second view class. I right clicked on the Class view t...should be able to print ATP
I would like to be able to print out the Available to Promise information.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=2d089892-1a1b-4a8a-9e3e-16757d015fff&dg=micros...Draft view missing from view menu (Mac Word 2008)
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC
Does anyone have any idea why the "Draft" view would suddenly go missing from the View menu? <br><br>Now I only have 5 options in the view menu: Web Layout, Outline, Print Layout, Notebook Layout, and Publishing Layout. This is the case for existing documents and new documents. There's no way for me to switch into draft view! <br><br>What's even crazier is that if I open an existing doc that was last saved in draft view, it displays in draft view, but draft view ...Folder List View Save?
Using Outlook 2003 on Win 2k Server.
I prefer to use the Folder List view for my Personal Folders. I'm having a
problem with Outlook remembering which folders were expanded when I close
and later reopen Outlook.
For example, if I have this folder hierarchy under Personal Folders:
Let's say that I don't want to take up the screen space to show the
subfolders under "C". I collapse that folder, and it now looks like this:
I then exit Outlook, shut the PC off and go home. The next day, I start
every...Not able to modify another users shared tasks with owner permissio
Some of the users here have started using tasks and they have shared their
tasks. Here is the senario.
User A has some tasks and has given User B owner access to their tasks list.
User B opens the shared tasks of User A and cannot change the names or due
dates of any of the tasks.
We are using outlook 2003 with a exchange 2003 server here. I have looked
all over for a reason for this but havent found an answer any help would be
What *kind* of access? Haven’t tried it, but I’d bet the delegate permissions need to be set to “Ed...Page Numbering reflecting Chapters/multilevels setup in document
My manager wants to create unique pagenumbering for each chapter and section
inserted into a large document. Multilevel heading have been established
using styles within the document in Word 2007, but he wants page numbering to
be automatically created . For example: page 1 has Chapter 1 Section 1 so
he wants it numbered 1-1-1. The second page is still Chapter 1 Section 1 so
he wants it numbered 1-1-2. Page 3 is Chapter 1 Section 2 so he wants it
numbered 1-2-1. any suggestions on how this can be done??
Have you tried Format Page Numbers - Include Chapter Number - Heading 2...View|Toolbar Vanishes
Running Outlook 2000 SP-3 with Windows XP SP-2.
When I first start Outlook after booting Windows, Outlook toolbars and
View|Toolbars are normal.
Then if I shutdown Outlook and later re-start it, the View|Toolbars displays
only a blank 1/4" square.
However, all the toolbars are displayed and working except for the Norton
Anti-Spam Toolbar which has vanished.
If I want to get back the Anti-Spam toolbar I have to re-start Windows.
I tried re-installing msouplug.dll with regsvr32 but it didn't solve the
Also renamed outcmd.dat...no help.
I don't think it is a Norto...2003 Inbox view showing calendar
I'm trying to figure out if it's possible to configure Outlook 2003 to
display the calendar/to-do list in the Inbox view.
Office 2007 allows for the "To Do Bar" in Mail or Folder List views --
and you can include the calendar as part of the To Do Bar.
Is that possible with Outlook 2003? I'm happy to lose the "Reading
Pane" if I can replace it with calendar or the To-Do Bar.
"pcajordan" <pcajordan.4am54a@invalid> wrote in message
Is it possible to make a link direct to a special view in CRM. It's possible
to do it to a special account, contact etc. But we need to do it to a view
from a intranet site.
Check out following. Thanks to Michael;
PLEASE do click on Yes or No button if this post is helpful or not for our
uMar Khan :: CRM Freelance Consultant
Email :: imumar at gmail dot com
Blog :: http://umarkhan.wordpress.com
"Help needed" wrote:
> Hi !
> Is it possible to make a link direct to a special v...opening new pages no minimize button
When I try to open a new page in MS Word an entire new page with title bar
comes up. This is not a seperate page opening within Word but a new Word open
.. Verses Excel when you open aa new page, it comes up within the program.
I noticed when the new page is up-there is not a miminze button on that page.
Are you using Word 2007? If so, click the Office button, and then click Word
Options. In the Advanced category, clear the "Show all windows in the
Taskbar" option (found under "Display").
If you are using Word 2003, the corresponding option ("Windows in ...view images in folders
Hi I've just bought Office. In Outlook Express, I used to be able to see
images people sent to me in my outbox, and images I sent to people, in sent
folder. Now, I need to click on the attachements, which in my case opens
fireworks, which of course is a terrible way to view images people send to
How do I configure Outlook 2003 so I can automatically see images in my
I can't believe this is so hard and I need to ask for help. Poor design
Sorry INBOX - I used to be able to see images people sent to me in their
e-mails right in my inbox.