Case 'Actual Duration' not getting updated in SQL
Knowledge Base article 913391: The "Actual Duration" field displays an
incorrect value when you view the "Resolve Case" dialog box in Microsoft
Dynamics CRM 3.0
This article corrects the time when you resolve a case by adding some script
to an onsave event.
Here is where it doesnt work:
Lets say you go back and change the time from 2 hours to 4 hours on a
Service Appointment. The form shows your updated time by running the onsave
event but when you resolve the case, you original time displays and not the
updated time. I looked in SQL and the ActualDuration and Sc...How to change .attachedtemplate from VBA in Word 2007
I have a template that I created in Word 2003. It has a number of macros.
One, which allows the user to save a copy of the active document assigns
Normal.Dot as the ActiveDocument.AttachedTemplate before saving, so that the
macros from the working template are not saved in the copy. The problem now
is that when I run this macro in Word 2007, the
ActiveDocument.AttachedTemplate takes place immediately and breaks the macro
code that was assigning the template and saving the document. Is there a way
to keep the ActiveDocument.AttachedTemplate action from happening
immediately...lookup link for customer address on account, case, address search
The way the address associations are handled today create tremendous gaps in
the structure of CRM records compared to the structure of integrated
backoffice financial systems records. What should be trivial integration
tasks lead to a LOT of workarounds and customers frustration. Here is how we
Abandon the idea of hardcoding first 2 address records on the account form.
Add 2 address lookup fields on the account (relationships) that could be used
to select any of the account addresses and expose them on the account form
(still show individual address fields on the accoun...Combo box list selection based on earlier selection by user
I have a form that has a combo box 1 (Product) that reads a the Product
table and has a unique id attached to each product (RO#). There is a second
combo box 2 that is RO#. Now what I would like to do is when a user selects a
Product in combo box 1, the system should lookup the Product selected from
combo box 1 and upload the corresponding RO# in the combo box 2 list. Now I
am using both combo boxes as Unbound and in the combo box 2 I have the two
columns Product and RO# - in the Criteria row of RO# I have the following:
Like IIf([Forms]![xa_f_lookup]![RO#]=" ",[Forms]![x...Run report on multi selected records.
I try to make a report for a custom entity that works like the Account
Summary: let's say that it's Customer's Inquiry Summary for entity Customer's
I made the report so that I'm able to run the report on Customer's Inquiry
But when I select multi records in the list of Customer's Inquiry and run
report, only one record is show in one page of the the report.
I would like to have the selected records appear in the report with each
record on each page.
How can I do this?
...Go to special page in HTML help, how to change the left view in HTML help?
Made one .chm file.
In a c++ program, launch the help file and go to the special page by
It worked. The right window did display the help_internet.htm, but the left
window, which has a lot of book icons in it, changed nothing.
How to change the left view at the same time?
> Made one .chm file.
> In a c++ program, launch the help file and go to the special page by
> files\file.chm::/help_internet.htm...Can't select objects in Excel 2007
I'm trying to create a form in Excel 2007, and although I can manipulate,
copy & paste controls (check boxes, etc)
I can't select multiple objects to align them, etc.
I've checked on-line help (and have followed the instructions), and other
websites, but no one seems to have indicated a problem.
It is extremely cumbersome and I need a solution. Any ideas?
Thanks in advance,
I know this is about a year too late, but it may help others who have stumbled across this page looking for similar help.
On the Home tab, in the Editing group, click Find & Select....OL2003: No Categories on Recurring Events generated from Contacts (e.g., birthdays)
OL 2003 SP2
Windows XP Professional (Dell OEM factory installed)
I categorize my Contacts using my own custom Categories, which are
included in the Master Category List.
Having migrated to OL 2003 (on a retail Office 2003 Professional CD) on
my desktop for about a month, I just noticed Recurring Events in
Calendar generated from Contacts info such as Birthdays, Anniversaries
have been regenerated without any Categories being assigned. I deleted
all of these Recurring Events (including the original ones with
Categories) and resave the Contacts entry, but the new Event still has
...changing incoming mail server
I have set my incoming/outgoing mail server to pop3 but apparently it is not
the correct one. Can you assist me into changing it?
Ask your ISP. Their web pages will have instructions for setting up your
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
How to ask a question: http://support.microsoft.com/KB/555375
After furious head scratching, Suki asked:
| I have set my incoming/outgoing mail server to pop3 but apparently it
| is not the correct one. Can you assist me into changing it?
...Lot Selection not Showing when I select PO on Receiving Entry
Usually, the Lot selection screen would pop up when I select a PO at the Line
Detail of the Receivings Entry, now it does not! And GP will let items post
without a lot number! It seems as if a setting has changed. Any ideas
Any help is appreciated.
Are you sure the item is marked to track lots? This wiould be set item by
item on the Item Maintenance Options window.
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and check out our books at
&q...Select contact then hangs
Hi, please help. I have a user that when she selects a
contact using To: in a new email, after selecting 2, it
closes outlook??. Spec is W2kSP4\office2k with all
windows updates and office updates installed. Profile has
been deleted and re-created, plus i have set up personal
folders and moved contacts into there, and set that
folder as a default, but makes no difference.
...CListCtrl: Changing the Column Header Layout
I'm using a CListCtrl and I need another layout of the column header,
- 2 lines of header text
- changed background and forground colours
- changeable y-Size
I that possible? I cannot find any information about.
Thanks in advance
You should be able to get the header control and do anything with it you want. Go to the
MSDN, look under the topic "ClistCtrl class", and about 17 subitems into it there is a
topic called "header controls" which explains all this. GetHeaderCtrl is what you are
On Thu, 26 Aug 2004 13:58...Exchange 5.5 svr w/ Contant Event 2018 in app log
I have an Exchage 5.5 server with sp4 that keeps getting this informational
log several times a day. It started happening about 3 weeks ago.
Cat: Transfer out of gateway
The generation of a delivery report or a non-delivery report for gateway
/o=Horizon House/ou=Norwood/cn=Configuration/cn=Connections/cn=Internet Mail
Connector (mailserver) has failed due to error 0x80004002.
I was doing some reading and the culprit could be the increasing size of
Internet Mail Service mail box. This is in the Exchange Administration
program under the pro...Selecting rows from various sheets
I have several sheets with a few columns in each. One colum
in each sheet has a unique value. Most of these unique values are th
same in each sheet but not all. Is there any way that I can set up
new sheet that will have the unique value in column 1 and th
corresponding column values frommeach sheet beside it. For example
aa 1 1 1
bb 2 2 2
cc 3 3 3
aa 4 4
cc 5 5
aa 1 1 1 4 4
bb 2 2 2
cc 3 3 3 5 5
shav's Profile: http...select text in Calendar
I'm working on a calendar in Publisher. I'm adding text into a cell by
spacing down 1 point, then typing in 8 points. Doing fine until April. At
that time, I can only select cells (whole days). It will not let me select
the text. Help is no help. Any hints out there. Did I accidentally select
something to do this?
Have you added a picture to the cell or a shape? If you have send it to the
back, make the cell no fill and try again.
Mary Sauer MSFT MVP
"GoBonnieGo" <GoB...OWA Logoff/Change Password
I am running Exchange 2000. When users select the log off button to close an
OWA session, the get a "Page cannot be displayed" error. Also, when I go
into "Options" to try and change password, there is no change password
option, even though in the Constant.inc file it is set
I recently re-applied SP3, and still no luck.
...How do I change the elements displayed in the message list
How do I change the elements displayed in the message list. For example, to
list "To" or "From"
edit the view - to change just one folder, click on the row of field names
and choose custom. To make all folders the same see
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips: http://www.outlook-tips...macro to filter data based on selected data
Hi, I am looking for a macro that requests input of a reference code and then
a date and then filters the data in my spreadsheet based on this criteria. I
am using excel 2007. Any help with this will be greatly appreciated.
You can probably record a macro while doing it manually and then clean it up
and add input boxes to ask the question or input your variable in a cell and
use that. If all else fails,
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the ...Triggering an event in Windows service every 1 hour.
I want to create a windows service that will send a mail to a mailing list
every 1 hour.
How do I program so that the mail event automatically triggers every 1 hour.
(If I use timer and the service starts at odd 12:33, then it will fire event
at 1:33, 2:33... . But, I want it it fires at 12:00, 1:00, 2:00 irrespective
of when it starts.)
How do I do this?
On 21.02.2010 16:43, Biranchi Narayan Panda wrote:
> I want to create a windows service that will send a mail to a mailing
> list every 1 hour.
> How do I program so that the...Link select with a blast
I have Win 7 Home Premium, x64. Quite often, when I select a link, a mouse
pointer changes to a palm with a blast. I understand, the palm is the
standard mouse pointer for link select, but what is the blast? What it
Fort Myers, Florida
I suspect that this is being caused by a tracking program.
Run something like Ad-Aware and see if it indicates a tracking company.
If so, you can delete it, however, it might prevent you from accessing that
"Ilya Zeldes" wrote in message
news:7A6FF9B1-5512-44...Chart tabs changing by themself
I have an Excel 2007 spreadheet (.xlsx) file with about 40 charts all in
their own sheets.
Every one of those sheets used to have their own descriptive tab name. Excel
does not seem to like that, however, as sometimes after closing, it just
deletes all of my tab names replacing them with a generic Chart3, Chart4,
Chart 5 etc.
This is highly frustrating of course. I once edited every one of those tab
names back to their original names, wasting a lot of my time in the process,
hoping it would not happen again. Alas, it sporadically happens again and
Any ideas/solu...Select Case in a Change Event
I am trying to use a worksheet Change Event to trap changes to specific
columns. depending on which column is chnaged by the user, the value in
another ciolumn will be altered; so, changes in either column O or P will
update column Q, changes in either column T or U will update column V and
changes in column Z or AA will update column AB.
What I can't figure out is the Select Case bit (where I've got the shouted
question below). Here's what I've put together, any comments would be much
Private Sub Worksheet_Change(ByVal Target As Range)
...Changing Area Codes
Is there an easy way to change area codes for a large
number of contacts in MSO? Our local area code has
changed, and I'd like to update my contact information,
especially so I can use my phone dialer effectively.
PATRICK REED [Outlook - MVP]~~~~~~
-Microsoft Certified Professional (MCP)
-Have you checked http://www.slipstick.com?
-Please post your Outlook version!
"kvhhed" <email@example.com> wrote in message
> Is there an easy way to change area codes...Select Records based another table...
This may be very elementary, but i can't wrap my brain around it. I have
tried to dummy it down as much as i can for myself, with plans of adapting it
into something working. I have three tables that look like the following:
ProdID A B C
1 $1 $2 $3
2 $4 $5 $6
3 $7 $8 $9
[tbl1 ProdID] ------ [tbl2 ProdID]
[tbl2 RmNum] ...Outlook changes my permissions...on it's own!
I keep running into problems with Rules and Permissions for folders. I
have rules to send certain email to folders, which works for some
number of days, but for some reason, Outlook will arbitrarily block
the rule, saying I don't have permission to do that to a folder. I get
a message to check with my system administrator, who I guess would be
me. The administrator choices are grayed out so I can't change any
settings. I've used 'detect and repair' even to the point of resetting
my defaults, but nothing works. Any ideas would be very welcome. I'm
using Outlook 2003.