2 Questions on Pivot Tables
Any assistance appriciated. (Excel 2003)
1) I have a simple Pivot table showing 6 groups with their totals and a
Oz 22 etc.
Grand Total 125
I want to Pivot Graph this data, no problems. I want however an extra line
to show the total on the Secondary Axis. I have almost got it by placing
the column in a second time as a Running Total and then as a Line on my
chart, hiding all the values until the last point.
However I would like if possible the Total as a horizontal line across the
2) I h...Any word on CRM 1.2 release date?
Has anyone heard a firm release date yet for CRM version 1.2?
And will CRM 1.2 work with SBS2003 that was just released?
"Jim" <email@example.com> wrote in message
> Has anyone heard a firm release date yet for CRM version 1.2?
This depends on where you are based. I've just got home
from an MS course, and we told that in Australia it will
release to the partners at the conference late next month,
and will be released to customers on 12/1/04.
It was also confirmed that it will run on SBS2003 - it
will ru...Page set up #2
I want to use the paper size of A3, but cannot find it in the paper options.
Anyone know where I can find it?
Check your printer properties and preferences. If the printers you have
installed won't handle A3 you won't have it. And you will need to
"install" something that will. Even a "PDF" file printer will do.
Alan Badgery wrote:
> I want to use the paper size of A3, but cannot find it in the paper
> options. Anyone know where I can find it?
I've just a home use computer, but the intention was to use the work book
between and home and work, w...Monitoring Exchange 2003 #2
We are planning to implement MOM 2005.
However, we are also concerned about implementing auditing for changes
made within ESM.
Will there be a tool that will allow management to know a change was
completed by a specific UserID? When a mailbox store is dismounted - who
When a change is made to the RUS - who made the change?
MOM does not have the ability to monitor this in the shipped Management
You can enable AD auditing on the domain controllers:
http://support.microsoft.com/default.aspx?scid=kb;en-us;314955&sd=tech. ...smtp addresses #2
I have 2 smtp addresses under recipient policy.
smtp: firstname.lastname@example.org (set as default)
These were created automatically when we migrated from exchange 5.5 to 2000.
local.domain.com is our internal domain.
domain.com is our Internet address.
I unchecked local.domain.com address, and "Apply this policy now", but it
did not remove them from each users AD account.
So I deleted the local.domain.com address, and "Apply this policy now", but
it still did not remove them from each users AD account.
We are getting NDR's b...SRM 3.0 for SBS
Trying to "test" install CRM 3.0 for SBS on a SBS 2003 Premium R2 server.
Installation gives option to install a sql Report Server or use existing.
The one it tries to install is SQL 2000 and the screen says it is not
compatible with other versions of SQL. So will the install allow you to
connect to the SBS 2003's SQL 2005 Workgroup Report Server?
Can;t find this answer anywhere!
In answer to your first question, yes. You have to install SQL 2005
Reporting Services, then connect to this during CRM setup
"KBB" <email@example.com> w...Exporting emails from Outlook 2003 #2
I have a folder that contains over 500 threads on technical matters on a
I have tried to use Export to Exel but this does not transfere all the
information over including not giving all the text in the body of the email.
A similar problem is saving an email to a folder outside outlook it doesn't
show the date so you may have a huge list of items all titled but not dated
in the title
Please can anybody help?
why do you want to export the emails. What is the target/reson to export the
Share Outlook without Exchange (Vista Ready): Publi...Drop line on only one data point in series
Is it possible to add a drop line to only one data point in a series? If so,
how? I believe attaching an autoshape line to a single data point would also
meet my needs. I would like to be able to have a single data point marked
with a line that doesn't require repositioning every time I add new points to
the end of the series, which is daily. Any ideas?
An autoshape would move anytime a heavy truck drove by. You could add custom
negative error bars to the series, where the range containing the values
contained zero for each point except for the one you want the drop line for.
Easie...Entering amounts in the register
I used Money several years ago as my personal finance software. Back then,
when entering transaction amounts, I didn't have to manually enter the
decimal. The software entered it for me. There was a setting option that
allowed me to select whether or not I wanted to manually enter it or not. I
have noticed that with the current version, this option is not there, and I
want to know if I have to manually enter the decimal when typing in
"Jefferson Lee" <JeffersonLee@discussions.microsoft.com> wrote in message
news:7955C431-94B9-47B9-AADF-E63C3...Pulling data for a report from a form
I have a product report list that want to show the on hand qty. so i have
this formula in a report field:
but when i preview the report it shows #name? instead.
Message posted via AccessMonster.com
To refer to a textbox on another (open) form, use:
Arvin Meyer, MCP, MVP
"josros60 via AccessMonster.com" <u56159@uw...training #2
Is there a class offered on Publisher and if so will it
ever come to Ohio? Thanks
Lots of good training articles available on the Office site.
Where in Ohio?
Mary Sauer MS MVP
"Cindy Taylor" <firstname.lastname@example.org> wrote in message
> Is there a class offered on Publisher and if so will it
> ever come to Ohio? Thanks
On Tue, 4 Jan 2005 19:06:21 -0500, "...Event ID c0072030 #2
We have an Active Directory Organizational that contain
all of our contacts. I have run the delegation of control
wizard and given a user full control over the contacts OU.
When I log on with that users account and try to update to
add an SMTP address to a contact I receive the following
There is no such object on the server
...Outlook not opening #2
I recently installed Outlook. When I try to open it, I get
the error message "Outlook requires Outlook Express 4.01
or greater". I do have OE 5.0 installed. Why am I getting
...List Boxes #2
Can someone tell me how to correct the following code so that both
columns in the listbox will be updated? Only the first column
ReDim MyArray(mycount, 1)
usrGLDist.lstOutput.ColumnCount = 2
For i = 0 To rst.Count - 1
MyArray(i, 0) = rst.Value("descr")
MyArray(i, 1) = rst.Value("pcamt")
usrGLDist.lstOutput.List() = MyArray
Richard wrote :
> Can someone tell me how to correct the following code so that both
> columns in the listbox will be updated? Only the first col...How can I line up 2 columns with similar information?
I have 2 columns with names in each and I'd like to line them up next to each
I think we'll need more information, Kathy. I don't understand what you're
trying to do. Can you give exactly what's up?
"Kathy" <Kathy@discussions.microsoft.com> wrote in message
>I have 2 columns with names in each and I'd like to line them up next to
Column A has employee number, Column B has the same employee numbers but has
addi...Lost Product Key #2
Wanted to install my publisher deluxe 2002 onto my new computer. I've lost my
product key. What can I do? How do I do it?
Whistle Britches wrote:
> Wanted to install my publisher deluxe 2002 onto my new
> computer. I've lost my product key. What can I do? How do
> I do it?
Have a look at the following KB article:
(823570) How to Obtain a New Product Key
for Office Program Setup
return e-mail disabled
...RMS POS 2.0 SP1 fails to install
We are running RMS 2.0, and when I tried to install POS SP1 I get the
following error" The expected version of the product was not found on your
system" I have searched kb and found nothing that may address this.
Any ideas would be appreciated.
Sounds like you got the wrong service pack. POS is a different product. You
need RMS 2.0 Service Pack 1.
"Davidjc52" <Davidjc52@discussions.microsoft.com> wrote in message
> We are running RMS 2.0, and when I tried to install POS SP1 I get the
&g...How do I make a particular column required in Excel? #2
Our NPO is creating a reimbursement chart in Excel. We're trying to make it
so that if employees do not fill in one particular column entitled
"Projects," they will get an error or will be unable to have a final sum
Is there any way I can make this particular column required so that if it is
not filled in, the chart will not complete properly?
Thank you in advance for any advice or help--I'm a bit of a novice to this!
...help with lookup formula (sheet 2, not a double post)
I need to make a formula using a lookup. The first spreadsheet is a
inventory (ALO INVENTORY JP). The second (P&G 103) is a chart tha
tells number of gallons of alcohol per foot/inch/fraction.
On ALO INVENTORY JP I insert the # of feet, inches, and the fraction i
cells R5 and T5. I want these numbers to lookup the number of gallon
off of the P&G 103 worksheet.
For example: P&G 103 (on inventory sheet) is 26ft 4 1/2 inches, i
should look-up to be 34572 gal. for the 26'4" and 55 gal. for the 1/2"
These two numbers should be added together and multiplied by the numbe
...One Record Per Page Printing-Access 2007
Report for daily appointments for senior transportation drivers. Report is
grouped by Driver. Keep together is selected.
Detail band: Keep together-Yes; Force New Page-Before Section; Can
Grow-Yes; Can Shrink-Yes
Goal: Report generated so each driver has his/her own appointments.
Orientation: Landscape, paper size 8.5 x 14, column width: 13.5729"; column
When previewing in Print Preview one record per page is appearing rather
than all appointments for a driver for a given date. I have the bands as
narrow as I can make them. I am missing somethi...Reporting Bugs to Microsoft
I have found a bug in Exchange 2003, does anyone know how I report this?
Whats the bug?
Microsoft Exchange MVP
"fatiefats" <email@example.com> wrote in message
>I have found a bug in Exchange 2003, does anyone know how I report this?
I attempted to uninstall Exchange server. I need to do this because the domain controller was incorrectly installed.
Anyway I am getting this message:
Setup encountered an error while checking prereq...Outlook 2003 Adding several Emails to Block Sender list at One Tim
I just upgraded to Windows 2003 SP 2. In the older version of Outlook, I
could highlight several emails and add them to the junk senders list by
selecting: Action/Junk Email/Ad to junk senders list
With 2003, the option to “Add Sender to blocked senders list” is grayed out
and I am not able to select it. What can I do to be able to use this? It is
available when I select an individual email.
...Outlook prompts a errorr report
my Outlook2003 always prompts :"! tasks"Microsoft Exchange Server" report a
error(0x8004010F):"operation failure. can't find a object.
But My outlook2003 send/receive email is normal.It can send and receive
Then how can I solve this problems .thanks.
!����Microsoft Exchange Server�������˴���0x8004010F):"����ʧ�ܡ��Ҳ���ĳ������
Nothing you can do from the client side as this message could mean that one
or all key system folders on Exchange server are not being
replicated/populated with information. The system folders I refer to are:
Offline A...SMTP Security #2
Does any know what is the Best Practice for Securing SMTP is? and More
importantly do you have the documentation to implement it?
Austin Morgan wrote:
> Does any know what is the Best Practice for Securing SMTP is? and More
> importantly do you have the documentation to implement it?
You could configure SMTP mail rel...Restricting SubForm to One Record Entry Per Parent: Access 2007
I have a one-to-one relationship between two table. I have successfully
added the subform, but I get the option to add additional child records in
the Datasheet View. This means that when a user tabs to the next row and
enters data they get an error--and they should.
Question: How do I restrict the subform to show only one row in Datasheet
I hope I was clear. Feel free to ask for clarification.
Thank you in advance for your assistance.
You have two options here. If the records are already added to the source of
the subform you could set the &qu...