Trying to write a formula that changes which worksheet to used
I am trying to write a formula that uses a different worksheet in the current
workbook depending on the value from a lookup result and/or the direct entry
of a worksheet name in one cell.
For instance, if my lookup result is November, I want to pull information
from cells on the November worksheet, if December, information from the
December worksheet, etc.
This way, all I have to do is change the lookup value and/or the entry to
get different results based on the appropriate worksheet. This is useful in
repetitive activities using the same layout but different numbers.
Any help would...service calendar in MS Dynamics 4.0
Does anyone knows how we can achieve the following requirement with MSCRM 4.0
In the service calendar in MS Dynamics 4.0 you are able to create new
appointments and service activities. Appointments and Service Activities
which are created will be present in the Service Calendar.
To see all details of such a record[Subject(default Value)] you must open
it. But by moving your mouse on the concerning appointment or service
activity, a text-box-view appears with primary information.
With appointments the content of the following fields is displayed:
'show time as', 'subject...Controling queries displayed when clicking Load from Query button?
I want to be able to control the queries that are displayed when the Load
from Query toolbar button is displayed. Can anyone tell me how the filter box
list gets populated?
Anybody know how to load e.g. bitmap into resource dynamicaly? The bitmap
file will be downloaded by application itself , so it has to be somehow
inserted into resource and displayed.
What do you mean by "into resoure dynamically"? Do you want to load a
..bmp file and display it? If yes, take a look at GDI+, which is by far
the easiest way to achieve this.
I misspelled this, yes I'd like to load new bitmap
on the fly. But resource file looks like is static.
I use ATL/MFC applicatation.
"Ajay Kalra" <aja...Dynamic sum in Chart
So I've got this pivot chart that I've created, and it's great, EXCEPT
when I select different categories to show up, I want to show a SUM of
the categories, not the values of each category. I would appreciate any
help/advice you may have.
In the pivot table you can select different thing like count and SUM
etc. If you right click in the upper left vacant square and chose field
settings, then select what you want to see in your data section.
> So I've got this pivot chart that I've created, and it's great...Tab seq dynamically...
I have a button which added dynamically to a property
sheet. Now for setting the tab sequence with this new
button, Am using SetWindowPos() method. Now tab sequence
THE PROBLEM IS
Through the arrow keys, I could not navigate to the last
button for which I called SetWindowPos. where as through
tab keys I could go to the last control. I will appreciate
ur help in this.
I have three buttons (OK,Cancel, Help)on the property
sheet. I added a button "Default" to the property sheet
and positioned between Cancel and Help. I set the tab
sequence as ...Error in query referring to Combo Box
I am very new to using VBA to build forms and am having a problem. I
trying to embed a query within a public sub routine. The goal of this
query is to use an alphanumeric code entered into a combo box on the
form to retrieve an associated ID within a table. The bound column of
the combo box is text. I have used the following code:
Public Sub GetSturID(intSturID As Integer)
Dim rsSturID As ADODB.Recordset
Set rsSturID = New ADODB.Recordset
rsSturID.Open "SELECT tblSturg.SturgID FROM tblSturg WHERE
(tblSturg.PIT = '" & cmbPIT.Value & "')" _
&...SharePoint Alternate Access Mapping to my Dynamics GP BP site
If I have posted this question in the wrong forum please let me know!
I’m looking for some guidance on changing the Alternate Access Mapping for
my Dynamics Business Portal site. So I can implement Single Sign On via ISA
Server which is supported on one web listener.
Default Zone: http://geneva:222
I would like to add:
Internet Zone: http://dynamicsbp.proclub.com
I presently have another SharePoint Collection (The Main Portal)
http://geneva configured which listens on Port: 80. I tried to add the
Alternate Access Mapping http://dynamicsbp.proclub.com...dynamic charting #2
I have to update a weekly spreadsheet
With week numbers in column B x series and three y series percentages
in G,H,I columns.
Could someone please help I need these to update automatically. If
someone can explain in detail I would appreciate
39 2097 2165 68 1770.7 97 96.86 118.43
40 2443.15 2201 -242.15 1548.93 97 111.00 157.73
41 2162.83 2259 96.17 1600.78 97 95.74 135.11
42 2163.08 2241 77.92 1545.1 97 96.52 140.00
43 2137.5 2271 133.5 1664.6 97 94.12 128.41
44 2160.67 2298 137.33 1455 97 94.02 148.50
...Need a method to Dynamicly change the X axis Scale on a chart. #2
I dynamically change the amount of data on a chart. This causes the X axis
Scale to either to either show too few values or too many values ( a solid
black line if too many). I would like a method to dynamically change the
scale values in relation to the data span.
Do you want to limit the number of points displayed?
Or do you want to link the axis scales to something you calculate in the sheet?
----...Dynamically populate a drop down list
I'm trying to dynamically populate a drop down list in MS CRM (1.2)
based on certain parameters. I suppose I could do it using a SQL
stored procedure, but I would prefer to use standard/supported CRM
customizations. Any assistance in this would be greatly appreciated.
You can do it in 3.0 pretty easily based upon an example in the SDK... Here
are some pretty pictures...
I have not tried it with 1.2, but it could probably work...
"Dave" <email@example.com> wrot...CRM Integration with MBS/Dynamics products
Anyone know anything about the integration between CRM 3.0 and ...say....
I'm thinking sharing of customer data and such....
There is nothing available yet. You would need to build it.
MVP - Microsoft CRM
"Jeppe Jespersen" <jdj curly jdj dot dk> wrote in message
Anyone know anything about the integration between CRM 3.0 and ...say....
I'm thinking sharing of customer data and such....
...Query to conditionally handle duplicates
I'm creating a Bill of Materials using a one-to-many relationship table
between InternalPN and ExternalPN. So the query sometimes returns more than
one record when an InternalPN is specified, because there are multiple
External PN's. I would like to alert the user to this in my query by
substituting the word "Multiple" for the ExternalPN.
I can find multiples easily enough with the Query Wizard & so have created a
separate query called QryPNMultiple.
I'm trying to refer to that query in a dlookup statement in my BOM query.
I've tried this:
Expr1:...Dynamics GP 10 and Dynamics AX 4.0
just a half year ago, our company has started to work with Dynamics AX 4.0.
Now i am doing some programming in X++ and almost customizing reports.
Accidently, i stumpled on Dynamics GP 10.0 and i am wondering what s the
difference between AX and GP? What stands GP for? Maybe GP is to replace AX,
and our company backs to wrong horse? Does GP 10 contains AX 4.0? I have
learnt lot of X++ programming, would it be possible to using X++ in the GT 10
Great Plains (GP) is another ERP system that Microsoft acquired a few years
ago when it acquired the company of the same name. GP ...Averaging across worksheets
I have a bunch of worksheets showing rental income data across four
different cities. Within each city there are about eight (8) different
real estate types (ie 1 bedroom, 2 bedroom etc.).
How can I calculate an average (in a new worksheet) of a specific real
estate type across the four cities when the respective data ranges in
each city do not appear in the same rows in each worksheet? However,
the ranges will be in the same columns across each worksheet.
Furthermore, in a different column on each worksheet will be the name
of the 'real estate type' which is consistent across all ci...BP
Suggestion: Make all find and queries case sensative or none
We've discovered that the queries are not case sensative while the find
functions (for example, the find function in the requisition vendor applet)
tend to be case sensative. This creates a lot of confusion for the end users
and a lot of "I can't find..." support calls.
Consistency is a good thing, especially in a user interface.
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
I have the following two dynamic ranges
Note: there will be two ranges
namecount & namelist
The formula which would be using the above range is
Big question!!!, can I join these ranges together in to one statement.
if so than how ???
If I follow what you want:
Named range: List
Refers to: =OFFSET(PBR!$A$1:$B$1,,,COUNTA(PBR!$A:$A))
=IF(MAX(INDEX(List,,1))<ROW(1:1),"",VLOOKUP(R...Business Card query
I wish to produce my own business cards for a self catering flat with
details on one side and a picture on the other side.
So far I have produced the details and the photograph in Word but now want
to match the two sides so that when printed they coincide.
I wondered if Publisher has this facility.
What is on the right on the front will have to be on the left for side two.
Might do better with either two pages or two separate publications.
Mary Sauer MSFT MVP
"Blair" <Darrach@aol.co...How to run a date based query for many months
I have one query based on a parameter "MyDate".
I enter a full date ( dd/mm/yyyy french format but no matter )
and the query result is expressed by the month ( yyyy_mm)
eg : i enter 25/12/2009 and the result is expressed in
I have to run this query for n months before the entered date and 2
months after this date.
Is it possible to get a SQL code for this ?
Can you help me ?
Thanks by anticipation.
It would help if you posted the SQL of your query. Also, your requirement as
stated is a bit vague.
If you enter 25/12/2009 an...How to return to current worksheet in a macro
I'm trying to make a macro that copies a few lines from worksheet1 into the
current worksheet2. The problem is that the name of worksheet2 can change so
I can't use
to return the focus before doing a paste.
How do I do this please?
normally no need at all for select / activate.
use something like
"CWatters" <colin.watters@pandoraBOX.be> sch...dynamic menus
I want to be able to create a hierarchy of menus under the view menu. I
don't know at design time how many items will be under each submenu.
I have been able to access and add to the view menu itself. By I have not
been able to add anything under that added menu. I know it shuold be a popup
menu. but when I make it a popup, I get an assert when I try to open the
view menu. Here's what I have so far (some experimentation still remains):
m_pWndMenu = GetMenu();
//int count = m_pWndMenu->GetMenuItemCount();
//m_pWndMenu->GetMenuString(2, string, MF_BY...Link in Outlook to an excel worksheet
I would like to no how to create a link in an outlook email to a worksheet in
an excel workbook.
Equivilent to Insert/file as hyperlink
However, I want the path to specify the worksheet name so the paticular
worksheet will be activated when the workbook is opened.
Any help would be appreciated..
you could write a simple Auto_Open macro to select the sheet you want
There's plenty of help on Auto_Open macros on exceltip.com or via
HiArt's Profile: http://www.excelforum.com/mem...Dynamics Workflow windows in Dynamics
I have installed Dynamics Workflow for Dynamics version 10 successfully. I
have created a simple Purchase Order workflow. I have clicked the Activate
Workflow button in this company. However when the users capture a Purchase
Order it does not have the additional workflow compnonents on the Purchase
Order window e.g. Submit etc. I have logged out and back in again.
What am I missing?
The workflow functionality in GP 10 requires the deployment of MOSS 2007
(Enterprise Edition). Not a trivial thing.
> Hi there
> I have ...Querying Dates
I am looking for some advice on how to tackle querying some data.
I have two tables, table one with around 10,000 records per month and
columns that give me (for each record) a start date, start time, end date and
Table two details a percentage for each hour and day of the week (so 24
hours * 7 days = 168 records). This has three columns, the day of the week
(Mon to Sun), the hour (00:00 to 23:00) and a percentage.
What I want to do is sum the total of the percentage column in table 2 where
the day of the week and the hour of the week fall within the st...Creating a dynamic chart
I posted here a few days ago and was given some ideas on how to do this.
However, I seem lost. I have a main worksheet which is updated from several
worksheets by using code. On this worksheet is approximately 15-20 columns
something like this.
trimester year RW RW% WIW WIW% etc
1st 2001 80 89% 79 75%
2nd 2001 90 89% 84 87%
3rd 2001 87 88% 92 89%
1st 2002 88 88% 90 88%
What I would like to do is create one chart and by selecting the title of
the column from either a combo box or by using a bu...