Can the isv.config be used to launch Workflow rules
We use several workflow rules and would like to customize the menu bar to
include a button which can quickly launch certain workflow rules. Is it
possible to do this by editting the isv.config file? And how?
it seems to be possible as you can of course go to actions then run a
workflow so one way might be to find the source code that does this. Another
way might be to have the menu item or button call an external asp.net page
which calls back into the platform and runs the workflow. I have not tried
this or heard of anyone doing this so have no idea if its possible.
When I try to enter a date on a form I keep getting the following error
message; "You tried to assign the Null value to a variable that is not a
Variant data type (Error 3162). The help for this error recommends declaring
the variable. The only problem is I do not have any modules created for the
form. What can I do to stop this error message from happening?
The form has a code module. Perhaps you mean you have not created any code
in the form's code module? If you used a wizard to create, say, a command
button there will probably be code in the form's module, so ...Displaying Multiple Excel files, Not plotting zero values
I have two questions:
1) How ccan I display more than one Excel workbook in different window? When
I open more than one Excel workbook, I want to display them side by side to
make some comparisons. When I open one other closes. Is there a way to open
many Excel windows?
2) I have a data set with lots of zero values. I use scatter plot. I want to
only display non-zero values. How can I do it?
1) With both workbooks open, choose Window>Arrange
Select an Arrange option, click OK
2) Create a chart from all the data.
Apply an AutoFilter to the list (Cus...Picklist A to determine value of Picklist B
Dependant on the value in Picklist A, I would like to display different
values in Picklist B. For example:
Picklist A = Fruits, Color, etc.
When user select Fruits, Picklist B should display: Apple, Pear.
When user select Color, Picklist B should display: Red, Green.
Many thanks in advance.
If you look at the SDK samples, there is an example on how to do this.
MVP - Microsoft CRM
"Dix" <Dix@discussions.microsoft.com> wrote in message
Dependa...Can Excel change numbers in a cell upon printing?
I have to print my blank Purchase Orders out of Excel. Is there a way to have the P.O. Number add one to it for every page printed? Now I manually change it and print one then change it and print one.
Sure it can.
An InputBox would probably be the best way to go.
Try the following code:
Dim HowMany As Integer
Dim StartNum As Integer
If Range("A1").Value = "" Then Range("A1").Value = 1
HowMany = InputBox("How many Invoices to print starting at " &
StartNum = Range("A1"...How do I stop excel replacing numerical values with the date?
I have switched off the auto correct function on Excel, but it still replaces
numbers with any given date!! How do I solve this problem?
format the cells as 'General' or as 'Number'
"Becca C" wrote:
> I have switched off the auto correct function on Excel, but it still replaces
> numbers with any given date!! How do I solve this problem?
If plain numbers are being displayed as dates, change the format to
XL's parser will, independently of autocorrect, always interpret a
string like x/y or x-y as a date if it can. To...Dynamics Picklist Error: originalPicklistOptions
I am using the dynamics picklist functionality and continue to get the error
"Error: 'originalPicklistOptions' is null or not an object. This is placed
on the onChange event of one of my fields. I can't seem to figure out what
the issue is. I have this working on a different set of fields but for some
reason cannnot get this one to fire correctly. Below is my code. Any
input/suggestions you have are greatly appreciate!
var oBillingFreq = crmForm.all.new_billingfrequency;
var iStartIndex = -1;
var iEndIndex = -1;
switch (oBi...Finding Value of a Cell in a Range
In cell C1 I want to place a formula that will return a value of 1 if the
value of cell A1 is contained in the range of cells B1:B127 and a value of 0
is the value of A1 is not found in the range of cells B1:B127. All values
or use your b1:b127 instead
"Wendy L" <firstname.lastname@example.org> wrote in message
> In cell C1 I want to place a formula that will return a value of 1 if the
> value of cell A1 is contained in the range of cells B1:...VBA to change format of a linked cell
I apologize if this is really simple, but I've been searching around
on the web and haven't found what I am looking for.... Maybe I am not
searching for the right thing.....
I would like to know the VBA syntax that I could use to change the
font format of a linked cell to be the same as the cell it is linked
A simple example:
on sheet2, in cell b13, is the value 2.
It is colored blue and is bolded.
on sheet2, in cell b47, is the value 5.
it is formatted in the default manner
cell A1, on the sheet named sheet1, contains the formula ='sheet2!b13'
cell A2, on the sheet ...Conditional Value
Column A = Job Status
Column B = Date Completed
What I would like to have is if Column A = Done and Column B has no value, I
need to have a warning or a pop up of some kind stating that Column B needs
to have a date value when column A = Done.
Thank you in advance.
in a separate column?
(remove nothere from the email address if mailing direct)
"Michael S." <MichaelS@discussions.microsoft.com> wrote in message
I have been workign with GP for a while, but am, not really clear on the
difference between Originating Price and Price, Originating Cost and Cost,
etc. Can anyone clue me in, I haven't been able to find a good explanation.
I believe this has to do with Multicurrency. 'Originating' is the
originating currency. If you are not using Multicurrency the Originating
field will be the same as the other field. If your making any changes to the
windows using Modifier be careful because these two fields are 'stacked' on
top of one another.
"Chris Hornun...Change toolbar programmatically
I have a custom toolbar with an assortment of command icons; Save,
Find, Form Search, Seach by Selection, Sort, Form and Datasheet view -
to list a few. The most used are Form and Datasheet view. I want
Datasheet view icon to be available only when a filter has been
applied to the form.
The reason is when clients look up records, they are naturally
inclined to use datasheet view. When you have 25 people scrolling
though 1500 records at the same time, I believe, it causes the
database to become corrupted. This corruption happens about once a
week - way too much!
Is there a way to turn off t...Hyperlink Picklist
I run Excel 2000
I have a list of names with each one of them having a hyperlink to an email
These all work fine.
What I would like to do is one of two things.
Have a drop down list that lets me choose one of the names from the list and
have it retain its hyperlink properties. I tried using data validation but
the names dont retain their hyperlink properties.
Have a formula that is based on an entry to another cell that returns the
name from the list but retains the hyperlink properties.
Example (in cell G1)
=IF(D1="SUPPLIER 1",HYPERLI...Margin Measurements keep changeing
I have been using various forms of Publisher since 1997? I have just started
to use 2007 and I am going crazy.
I enter a margin say top, it then takes a few seconds and previews I tab to
the next repeat repeat repeat so this takes a 1-2 minutes (I am not in print
prewiew) then the new bit number of copies ie 4 per page so now times this by
the number of sheets it generates a preview and my margins have shifted it's
only .003 of a cm but this is not good enough. I have to repeat this several
times, waiting for preview to do its thing then I can finally this has always
been a little ...Verifying Picklist Mappings
Just posted this on my blog, hope you will find it usefull. Please leave me
a note if you experience difficulties with it.
Merijn van Mourik
When you need to maintain a large number of picklists, it can be time
consuming to keep the mappings between entity picklists consistent. This is
because every picklist item has a label and a corresponding number. And this
number is not visible when working with Microsoft CRM. When you map a
picklist to a picklist in another entity, you should verify whether the
underlying numbers are ok.
So I cr...Undocumented Workflow feature.....
Just wanted to share something I found out today.
There is the ability today to use "slugs" in workflow today. This is not
supported, but I just tested it and it works.
For example, I setup a rule on Account to create a follow-up task. I set the
subject of the task to the following:
The resulting task that was created replaced the &account.name; with the name of
the Account. There is obviously no built-in support for entering these slugs,
so you need to make sure you use the correct table & column names.
Remember, this is technically not a s...lettered columns changed to numbers
Somehow the columns labeled with letters changed to numbers. How do I get
them switched back?
Tools, Options, General, uncheck "R1C1............"
> Somehow the columns labeled with letters changed to numbers. How do I get
> them switched back?
>Somehow the columns labeled with letters changed to numbers. How do I get
>them switched back?
Tools|Options|General|R1C1 Reference Style (un-check the box)
Tools > Options > General then Uncheck R1C1 reference style
In Perth, the ancient capital of S...Hide Picklist based on value of other picklist.
On the accounts form i have made a new picklist named Partner.
In the picklist Customertype i have made a new entry called partner.
When someone opens the form i want the picklist named partner to be hidden.
When someone selects Partner in the Customertype picklist i want the
picklist partner to be visible. If an other value is selected the fields
needs to stay hidden.
I know i have to make some code on the onchange of the field customertype
and i need to make code on the onload of the page.
I have tried multiple codes but i cant get it to work.
Can someone please help me out please.
Hi,...default cell value
I'm trying to develop a timesheet form and am having
trouble with a "comp time" section. It seems to be a
simple problem but I can't find an answer. I've got a
(K5>0,SUM(K3+K4)-K5,0))) but if k3, k4 or k5 doesn't have
a "0" then I get #VALUE! I'd like to have "0" (zero) in
each of these as a default value since this section won't
always be used by everyone. How can I have "0" or "---"
show by default and not have #VALUE! show if somebody
deletes...vlookup and match first value greater than
I need to lookup a product id and return the date of the first value greater
a b c d e f g
1 Date 4/12 4/19 4/26 5/3 5/10 5/17
2 Product A 0 11 35 0 0 125
3 Product B 35 50 75 100 25 36
If I lookup Product A in the spreadsheet and want to get results from
columns e through g I would want to see 5/17 as the result.
I have this formula which works against a fixed row reference but have been
unable to incorporate a lookup value into this to return the same result.
INDEX($e$1...Change View in Outlook 2003
My Inbox in Outlook 2003 has changed from "Today", "Yesterday",
"Wednesday", "Last Week" to a single cascade under "Older". All my
emails are under this banner, as I receive them. There is no breakdown
Microsoft site said:
1. On the View menu, point to Arrange By, point to Current View, and
then click Define Views.
2. In the Views for folder folder name box, click the view (view:
Views give you different ways to look at the same information in a
folder by putting it in different arrangements and formats. There are
standard v...How do I drag a point to change the shape of a curve? (excel 2007)
In Excel 2003 I could plot points as markers, and then plot a second series
as a smoothed line (no markers), and then drag the points in the second
series to make a curve go where i wanted it to. How do I drag points in the
second series in Excel2007?
The ability to drag points was removed in xl2007.
Andy Pope, Microsoft MVP - Excel
"dnjan" <email@example.com> wrote in message
> In Excel 2003 I could plot points as markers, and then plot a second
&...Reset value to False in Checkbox when closing form
I have a split form with a Checkbox called "Select" it's default value is
when I close the form I want the field value (if changed) to be reset to
In my form I have an event procedure under On Close:
Private Sub Form_Close()
Dim ctl As Control
For Each ctl In Me.Controls
If ctl.ControlType = acCheckBox Then
ctl.Value = False
When I close the form I get an error message: Run-time error 2448 "You can't
assign a value to this object."
Any ideas where I've gone wrong?
n...How to set XY values using MSChart control
I'm using the MSChart control to set plot a set of XY values.
I have set the type to XY_Scatter, but am unable to figure
out how to set values. Could someone please explain or point
me to some link to do this.
...Counting a Range of Values
Who likes a challange?
I have a workbook that has multiple worksheets. A number of th
worksheets are identical and are used by multiple users to input thei
own data. I need to extract a set number of rows from 2 of the column
on each of these given sheets. To make matters more interesting, I onl
want to extract the row if there is information in it. If the field i
blank, leave it! I want these to be extracted into another worksheet i
the same workbook.
After I perform a calculation on each of these rows that were exported
I will get a new column which will contain a time. (ie: 8:45) I ...