smaller scale for a semi-log graph possible?
I need the x-axis scale on a semi-log graph to focus in on a smaller area
other than 1, 10, 100, etc. When i plot my data, its practically a vertical
line and would not have enough meaing to my clients so they would be able to
read it. So, we currently manually draw the graph. My data only covers a
max of 20 units, usually smaller (ex: 18-29 interval for x values).
You can adopt Tushar Mehta's Flexible Log Axis Scale technique
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://Peltie...Microsoft Picture Manager
Operating System: Mac OS X 10.5 (Leopard)
Does Microsoft Office for Mac include Picture Manager? I can't find it in my Applications folder anywhere! I am so accustomed to that program, I couldn't stand not being able to use it! *cry*
Microsoft doesn't provide a version of Picture Manager for the Mac, but
there a number of excellent alternatives such as iPhoto which is included
with OS X.
On 3/22/09 3:43 PM, in article firstname.lastname@example.orgR9absDaxw,
"email@example.com" <er...Active Tasks in Outlook Today
Is there a way to only display active tasks in Outlook
...Internal e-mail activities are adding up
As people begin to use CRM and send internal e-mails regarding a particular
entity we are seeing a HUGE number of activities adding up. It would be nice
in the future if all internal e-mails regarding the entity would be summed up
into one activity.
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 ...Recurring Service Activities / Items -- CRM 3.0 -- No capability?!
What's the rationale behind *not* having the ability to schedule recurring
activities and service items?
Have I missed something in workflows or some such?
On May 25, 3:16 pm, David G <David G...@discussions.microsoft.com>
> What's the rationale behind *not* having the ability to schedule recurring
> activities and service items?
> Have I missed something in workflows or some such?
Has anyone responded to your question? We are having the same issue
and I'm hoping there is a solution avail...Activity views 09-26-05
When viewing the activities on an account or quote, there appears to be no
obvious way to include the date of the activity in the view so it is
difficult to determine when the activity was done - resulting in us having to
open each and every activity to find the relevant one - and this is time
The current release of Microsoft CRM does not allow you to customize the
activity views at least in a supported fashion.
If you scan the archives of this group at groups.google.com for activity
view you will find some unsupported methods.
Microsoft CR...Notified Office is Not Activated, but it is Activated
When my boss opens any of his Office 2007 products it notifies him that his
copy of office is not activated. It has been activated and when I check it
through Options it shows that it is activated, but the dialogue pops up each
time the programs are opened. I have used the FixIt from KB 919895 to delete
the Opa12.dat file which fixed a communications error in activatation, but
the product still doesn't think it is properly activated when it is.
...Error Code: 0x80246002 01-26-10
Error Code: 0x80246002 .Try to install the update again 6 times no response
Windows version? What update?
You receive a "0x80246002" error code when you use the Windows Update or
Microsoft Update Web sites to install updates:
> Error Code: 0x80246002 .Try to install the update again 6 times no
...Cannot log off users in GP 7.5
For some reason, even when I restart the server, when I go to the login
screen, it shows 2 out of 4 users logged in. How can a get these users off?
I tried to restart the whole server but i get the same message.
Delete the user activity:
Quickest way to do this is go to SQL Query Analzyer - Select the DYNAMICS
database and type the following command:
Make sure you do not have any user currently using GP otherwise they will
lose the connection to GP as well.
"David Chang" <DavidChang@discussions.microsoft.com> wrote in ...Email to Activity in queue
I have created a queue and I don't get any email activity from incoming mail.
I have this configuration:
- CRM Server: CRM 3 (CRMSERVER)
- SQL Server: SQL 2000 sp4 (SQLSERVER)
- Exchange Server: Exchange 2003 sp2 Cluster environment (EXCCLU1,
I have installed the CRM-Email Router in both nodes
And I have created the queue in two steps:
- Step 1: AD Account with Exchange Mailbox
o SELF Allow “Associated external account”
o CRMEmailEnabled (Custom Attribute...Set Default View to Active Accounts
How do I set the default view to be Active Accounts for all users? I thought
I had set it by going to Settings>Customizations>Customize
Entities>Account>Forms&Views>Active Accounts>More Actions>Set Default. I
logged out and logged back in and the default view was still set to My Active
I hope you published the entity after making the change.
Try an iisreset...
Innovative solutions for your SME ERP/CRM products
&qu...The value become wrong when get value by using AppleScript while other worksheet is active.
Operating System: Mac OS X 10.5 (Leopard)
I just want to send a bug report.
The value become wrong when get value by using AppleScript while other worksheet is active.
1. Create an AppleScript file with below script.
tell application "Microsoft Excel"
set OriginalWorkbook to workbook "Workbook1"
set OriginalData to string value of column 1 of row 1 of worksheet 1 of OriginalWorkbook
2. Launch Excel 2008 and create a Workbook called "Workbook1".
3. Enter time data "11...Commissions to sales managers
What is the best way to configure GP so that sales managers receive
commissions off their reps customers invoices? I know that you configure the
territory and the reps % on the salesperson maintenance screen but don't see
a place in the GP 9 documentation for where I would create the rollup for the
manager of that territory. Splitting commissions by order would be a bit too
Can you please point me to the right document or customer source entry that
can lead me in the right direction?
There is really nothing in GP to handle this. If you are able to devise
...activate, window activate?
Hi, I want code to fire when I deactive excel and select another program and
then run again when I active excel again...
Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
Range("v3").Font.ThemeColor = xlAutomatic
Tried several, what am I missing?
Try this. Hope this helps! If so, let me know, click "YES" below.
Private Sub Workbook_WindowDeactivate(ByVal Wn As Excel.Window)
Range("V3").Font.ThemeColor = xlAutomatic
> Hi, I want code to fire when I deactive excel an...Prefill Coding Error
I have a form that I have a few data entry fields prefill the last text
entered. For example, there is a field for Zip Code. Once the zip code is
entered, and the record saved, the after update command retains the zip code
entered. I use the code of
Private Sub Zip_AfterUpdate()
Me.Zip.DafaultValue = Me.Zip
My problem is I have one of the fields that is not retaining the data
entered. Here is the code I'm using
Privagte Sub AssignedChap_AfterUpdate()
Me.AssignedChap.DefaultValue = Me.AssignedChap
In the data entry field on the form,...Making a cell only ecept an X and protecting code
OK here what I got I need F22 and F23 to only
except an X. At this point it only triggers the red if you
enter an X but the cells does let you type in anything and
that will be a problem. Then Id like to protect or hide
the code some how so people don't mess with it. So if you
have a minute or two I would be most great full.
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Rem Put an X in cells F22 or F23 makes Cells F14 AND F16
Rem _____________________AREA WORKS_____________________
Rem YOU CAN ENTER ANY TEXT, BUT ONLY AN X TRIGGERS THE RED
If Target.Address = ...Resolution Activities
I am trying to pull resolution activities and whether they are won or lost?
Which field stores this information?
The Opportunity has a 'state' and 'staus reason' field - you should find
that the State field is what you are looking for the 'status reason' is the
'why' (i.e why you won/lost).
"EricaUW" <EricaUW@discussions.microsoft.com> wrote in message
>I am trying to pull resolution activities and whether they are won or lost?
> Which field stores this information?
...Changing default from printing Entire Workbook to Active Sheets
In Excel 2007, is there a place to select the data to print? I have a user
that when she goes to print a document, the 'print what' section of the
print box defaults to 'entire workbook.' She wants it to default to 'active
sheets.' Is there a setting in Excel or the Registry that I can edit?
...How to use a text formula as code formula
Hello. I have this formula loaded from a text field on a form:
val([field10])+val([field20]) and I would like to use this as a code formula.
I mean, if I use that in VBA code it works, but If I load from a text field
it doesn't work.
I need that my form use that formula stored in a text field to calculate
Regards in advance,
responded to in another newsgroup.
It's rarely necessary to post the same question to more than one group. If
it is necessary, select all the relevant newsgroups in the "To:" or
"Newsgroups:" field. That way, folks who...Using VBA code to change Chart Data Series
On a worksheet, I have a List Box Control (lbProfitICSales) with a
ListFillRange named "Profit_Ind_Cd_Sales". When selecting an item in the List
Box, I want to change the x and y data series in the single chart on the
"Profit-Ind Cd Sales" worksheet. I don't understand why the following code
does not work- I always get an "object does not support this property or
method". Help lookup indicates this code should work.
Private Sub lbProfitICSales_Change()
Dim strwksht As String
strwksht = Application.ActiveSheet.Name
'Worksheets("Review").U...Can't open help of System Manager
If i go into System Manager and click on Help>Help topics the System
Managercloses immediately with the following message. Microsoft Intelligent
Message Filter has encountered a problem and needs to close. We are sorry
for the inconvience caused and it ask me to send a error report or not. Why
is this happening
On Tue, 27 Mar 2007 12:56:25 +0200, "MSExchange2003Student"
>If i go into System Manager and click on Help>Help topics the System
>Managercloses immediately with the follow...Need help in coding outlook
For Each oMailItem In oInbox.Items
The above codes are part of my code.
The issue is when the inbox item is not mail item the code will be error.
When the inbox item is a report item (delivery failure notification) the
code will be error.
How to fixed that?
You can use the .Class property to determine what kind of item it is, before
you invoke the properties and methods of a particular type of Outlook item.
FYI, there is a newsgroup specifically for general Outlook programming
issues "down the hall" at microsoft.pu...help with code on event call
I am unsure how to code the following
the table I am working on is Baan
I am selecting the record using the orderNo field
but depending if the field IcyDate empty or not I will open different forms
the code I have in the event call at the moment is below and where I have
put the ***** is where I need an if statement to see if the field IcyDate is
empty or not
Private Sub But_SelONo_Click()
On Error GoTo Err_But_SelONo_Click
Dim stDocName As String
Dim stLinkCriteria As String
Dim intcount As Integer
intcount = DLookup("[Count-O-N]", "[Qu-cmm-countor...Windows Update Error Code 8001AA7?
Have been trying to apply a number of update today but they keep failing at
reboot telling me "updates could not configure correctly reverting changes"
and when i look at the error codes they are all the same "8001AA7" i have
tried looking this up and can't find out what it is or how to fic it.
Can anyone help?
Mistyped the code its 80017AA7
> Have been trying to apply a number of update today but they keep failing at
> reboot telling me "updates could not configure correctly reverting changes"
> and whe...Outlook 2003 w/ Business Contact Manager
I have an Office 2003 Professional cd. Is it possible that I have a version
of Office 2003 Pro that doesn't contain Outlook 2003 w/ Business Contact
Manager? Or am I way off and BCM is an Outlook 2003 add-in? In any event,
I would like to use the Business Contact Manager feature. How can I get a
copy of the BCM installer? I really do not want to purchase another copy of
the Office 2003 pro suite just for this feature.
You need to install this from the cd using Add/remove programs. I think it's
under Office Tools, but look at everything on the cd to find it and other