not all months have 31 days
I'm trying to create a "floating bar" chart that has the "# of Techs" as my
catagory axis, months as my value axis. The chart displays the # of techs
required to perform the job in each month (1 year). However, my months are
all 31 days in my chart so my data gets a little skewed as the year goes by.
I have created a formula to correct this, BUT only if the information in my
"start date" column are consecutive, which they may not always be.
My series data consists of the "start date" as series 1 and "# of days to
complete" as series...Create a Loop for create a phone call
Excuse me for my bad english
I am developing a workflow, which must create automatically phone calls and
assign them to certain users of the following way: it must create the number
of 10 calls and to assign them to user 1, to create 5 calls and to assign
them to user 2
the data of the phone calls is in a database
I am trying to create a loop but I have not found like
I am thankful for your help
You will need to do this using the CRM SDK/web service. Do something like :
CrmService service = new CrmService();
// Setup the CrmService class here
foreach (U...Is there a way to disable quick create
The quick create screen is very annoying, is there a way to force only the
use of full forms when clicking new from the lookup dialogue.
Anyone? Is this possible system wide?
I did find one thing regarding the web.config file but it doesn't seem to
Adding the following to web.config under <appSettings>
<add key="RenderQuickCreateControl" value="Off"/>
Any advice would be good. I don't want end users to be able to create using
the quick create funtionality.
"Simon W3st" wrote:
> The quick create screen is very annoying, is t...monthly view of calendar
Help, I do not want to see ending and beginning days of the previous and
coming month in my calendar view. Also it will not sync correctly with my
cell phone the way it corrently is.
Also How can I see a 12 month/year view for the year?
Version of Outlook? You're saying the lack of the previous and next month
affects the ability to sync to the cell phone? What sync software do you
Outlook doesn't have a 12 month view but you can show 12 months of the
navigation calendars. See
Diane Poremsky [MV...Converting a year date into a specific day date
I am bringing in a date into my excel spreadsheet as a year e.g., 1997. How
do i 'tell' excel that the specific date is actually 31 Dec 1997 and not some
random other day in the year 1997?
DOnt worry I see the answer is to use the DATE () function
> I am bringing in a date into my excel spreadsheet as a year e.g., 1997. How
> do i 'tell' excel that the specific date is actually 31 Dec 1997 and not some
> random other day in the year 1997?
...Excel 2000 hangs on opening a large folder, every other time.
Client has a large folder with a lot of spreadsheets and subfolders: 3685
sheets in 172 subfolders. The top level folder and subfloders reside on a
windows 2003 server.
If, he opens excel 2000, and then does a file/open in the top level folder
the first time, Excel hangs. The end result is a "not responding" from task
manager. If he blows excel away and then restarts excel and does the fame
file/open, the folder/file list inside the top level folder is presented
Windows explorer has no problem opening the top level folder and displaying
the subfolders undern...Share a common Calendar
My wife and I each have our own computers. Each is running Office
2007. I want to share a common calendar. If either of us opens
Outlook I want each of us to see the same calendar and be able to add,
delete or modify entries to it. Is this possible with Outlook 2007
and if so can anyone give me instructions or point me to an article?
...Create timesheet for multiple users
I have a timesheet I wish to create. Below is the format I wish to sen
it out in. I need ot be able to sort final data by (employee
department, project, activity and date)
I would like to collate in a central worksheet for a number o
employees so I can interrogate (i.e. using pivots).
How am I best to achive this?
From reading other posts I imagine one workbook per employee with 5
sheets each. Each can complete per week and it will populate a summar
sheet in each workbook. I can then use some code to extract the summar
from each workbook every week into a central file for collatio
(rond...Turning off chart events
Does anyone know of a way to turn off Chart Object events, much like
you can with Application Events?
...Creating Dynamic Userinterface.
Is there any way to create the user interface (Dialogs/command
buttons,combo) dynamically from the File(may be config file)???
My app is a pretty straight forward MFC EVC++ 4.0 app..i will have menubar
and dialogs in which the button will take us to createprocess();
any ideas will be extremely usefull
"eRiva Systems" - Where Technology Meets Life, Every Minute.
> Is there any way to create the user interface (Dialogs/command
> buttons,combo) dynamically from the File(may be config file)???
...Email box not getting created
I am using windows 2000 with exchange 2000 installed on it. All these days
it was working fine. Suddenly now when i tried creating a new user under
active directory & also enabled the option for creating a email box. It says
the user got created successfully but when i click the Email Address Tab
under user properties, i dont see any email address created for that user
under our domain.
Any suggestions on this is issue is highly appreciated.
Thanks in advance
Not sure if 2000 is the same way as win2k3. If it is check RUS.
On Jan 27, 7:05 am, Thameem <Tham...@discussions....Outlook 2002 appointment sent to public folder calendar gets puts in someone elses calendar instead
Andy Fenton sent an all day event to IT shared calendar for 1 February.
It does not appear in the IT caledar, but it does appear in Richard
Brown's. It was an all day event and is showing as tentative, but
because it appears in Richard's calendar it looks like he is busy the
whole day - it appears he can still make appointments in it though.
My manager regularly works from home and puts the days he does this in
advance into the IT Shared Calendar, which is in the public folder, and
to which everyone in the IT department has publishing editor rights. He
places the appointment into his ...Creating a basic phone followup
I am very new to this CRM product. I have set up a letter campaign to a
small group of potential customers and I'd like to create a phone call
tracking list for my phone follow ups. What is the quickest/best way to
...Enter event in textbox control?
Is there a way to determine if/when the Enter key is
pressed inside a textbox control?? I only have
one textbox control on my userform....so, if a user
types in text they will usually press the Enter key to
indicate they are done typing. That is why I need to
determine when/if Enter is pressed.
Check the value of Keycode in the
TextBox1_KeyDown event when the Enter key is pressed.
"Robert Crandal" <email@example.com> a �crit dans le message de news:
> Is there a way to determine if/when the Ent...Create Hyperlink
when i right click on a cell to create hyperlink it doesn't appear.
How about Insert>Hyperlink? Available or not?
Could be the workbook is Shared.
Unshare it to get the feature back.
Could be the worksheet is protected.
In Excel 2002 or newer you can choose "Insert Hyperlinks" when protecting the
Gord Dibben MS Excel MVP
On Thu, 5 Apr 2007 02:22:03 -0700, Mohamed <Mohamed@discussions.microsoft.com>
>when i right click on a cell to create hyperlink it doesn't appear.
...creating a church directory in publisher 2003, using data from acc
Am trying to catalog merge a query created in access to create a church
directory. The snag I'm hitting has to do with keeping the records for a
particular family from being printed in the next listing(there's 2 families
per page). I had to use subforms in access in order to input the variable
number of children names and birthdays. In doing so, the member's name and
record number had to remain the same while the children's names and record
numbers kept incrementing. Kinda scratching my head on this one. Any help
would be appreciated. I'm almost positive the d...how do I create an invoice from a spreadsheet
I have a simple spreadsheet and I want to create an invoice from the data in
the spreadsheet can anyone help?
You could try:-
then modify this template with your own data. This is probably as easy as
creating your own invoice.
Hope this helps.
"perry" <firstname.lastname@example.org> wrote in message
> I have a simple spreadsheet and I want to create an invoice from the data
> the spreadsheet can anyone help?
...Creating Document in MDI app
In my application I wish to be able to export certain data to another file.
In one of the functions in my view I need to create a new document, call
some functions on it then save and close the document.
I am struggling to find how to do this.
I have only one Document template in my app.
The code I have so far is:
POSITION p = GetApp()->GetFirstDocTemplatePosition();
CDocTemplate* pTem = GetApp()->GetNextDocTemplate(p);
CBob_photoDoc* pDoc = (CBob_photoDoc*)
CBob_photoDoc is my document class.
I can now...Folder created and I can not delete it?
Somehow I created a folder, but do not see this same folder listed in the
tree unless I attempt to move an e-mail to a 'x' folder. I looks like a
v-card. I would like to know how to delete it.
So you created a contacts folder? If you use Folder list view (ctrl+6), do
you see the folder?
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
EMO - a weekly newsletter about Outlook an...Help in creating website
I am creating a website for my riding club. I have basically "no" computer
knowledge but so far it is coming along OK. I keep different files in
Microsoft Word and Excel that I would like visitors to the website to be able
to just click a word on the website and have it take them to that file. I am
able to do this on other people's websites and want to be able to do this on
mine. Remember I don't know anything about HTPL or any of that other stuff
so when you answer consider yourself talking to someone as old as your
grandmother. I know probably less than her.
Th...creating flash cards with Publisher
I am assisting my wife in preparing new tools for Special Ed classroom work
with Learning Disabled kids
Part of the system that she has created requires the creation and printing
of Flash Cards (not 3x5 card size unfortunately). I am interested in knowing
if anyone has used Publisher for this purpose, and if so has created
templates that can be used for this project?
I need to generate about 100 card sets, 4 sets and would like to do this in
the least costly way possible so any and all suggestions are appreciated.
What size paper (or card stock)?
Will you cut the paper (or c...Insert Holidays Into Publisher Calendar
How do I insert holidays into my Publisher Calendar?
It is a manual operation.
Mary Sauer MSFT MVP
"Darrin Erb" <Darrin Erb@discussions.microsoft.com> wrote in message
> How do I insert holidays into my Publisher Calendar?
...link a mail message to calendar or to do
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: imap
Hi, <br><br>I like that todos created from mail are linked back to the original mail message when I deal with them in the Entourage calendar. But when that todo is ticked as done, It seems that that link is lost. Is there a way to preserve this? Even though the task may be completed I often want to refer to it and it is a neat way to find an email containing some info. (I have been doing this between Apple Mail and iCal.) So I want to be able to quickly search Entourage for a comp...How do I create a double y axis BAR CHART (not bar + line)?
How do I create a double y axis BAR CHART (not bar + line)?
"Blair" <Blair@discussions.microsoft.com> wrote in message
> How do I create a double y axis BAR CHART (not bar + line)?
Same as for most other types of chart. Format Data Series/ Axis, then
select secondary axis
Columns on two axes (secondary axis bar chart)
Bernard V Liengme
remove caps from email
"Blair" <Blai...Button not bring up Macro I created
I have created a Macro and a button that is suppose to link to the Macro. The
button I created can't find the Macro. Does anyone know a good place to find
a how to for this? Thanks
Right click the button, on the dropdown click 'Assign Macro' The list of
macro's will appear, assign the appropriate one to the button,
"A.S." <A.S.@discussions.microsoft.com> wrote in message
>I have created a Macro and a button that is suppose to link to the Macro.
> button I created can...