I have two worksheets with a common unique identifier for each employee. One
worksheet has the date of employment, and the other worksheet has a list of
training courses that have been completed by each employee. I need to
identify employees hired within a date range and check to see if they have
all completed their courses. This would be fairly easy if I could merge the
spreadsheets and sort by date of employment. I've been told that the best way
to handle this is to do a comparative analysis using vlookup, but I can't
find any info on that process.
As...Scheduled tasks dont work but look like they are
We are having intermittent problems with Windows Task Scheduler.
1. Everything will work fine for a few weeks, then suddenly tasks that used
to work ok will complete as normal, but task scheduler does not know they are
finished, and so the tasks status sits as running.. even though the program
and executable have closed and gone away.. this stops future instances of the
scheduled task from running.
2. Tasks that are scheduled to run, and have run for weeks without issue,
suddenly just stop running. They sit waiting for their scheduled start time,
the ...Potential customer field in Quote
Is there a way to make the Potential customer field in Quote entity as
Thank you in advance for any suggestions,
The entire sales process from opportunity up to the invoice requires a
customer. If you don't need the field, create a dummy account and set the
customer id to this dummy account in OnLoad.
Michael H�hne, Microsoft Dynamics CRM MVP
CRM Blog on http://www.stunnware.com
"crsb" <firstname.lastname@example.org> schrieb im Newsbeitrag
news:76d7f1b1-c86f-470b-bbec-0329d9d29f...2003 Form fields losing formatting in 2007
I have some forms, created in Word 2003, which when opened as a .docx, all
form fields revert to Times New Roman font but if they are opened as a .doc,
they are in the correct font of Arial.
Anyone got any ideas why and how I can fix this?
Thanks very much.
This doesn't make any sense. Documents always open in the format in which
they are saved. What *exactly* are you doing?
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
...Grid Pane Field Expressions
Ordinarily, I would put field expression code in the
OnFormat_Detail event section. However, if it's possible
to build the expression I want directly into a query
grid pane while in grid design, I would prefer to do
that in the current instance.
Current case: I have a field "Title" (happens to be
the title of a classical music piece.) and I also have
the cataloging system and values in separate fields,
CatSystem and CatSystemVal, e.g., "Op.", "78".
So, if the current piece has a chronological catalog
value, I want the query to return it appended to the
title ...Field with running count of records
I have a query with fields such as date, Item Number and Quantity. I want
to create an additional field called Count that will act like an autonumber.
It will assign a value of 1 for the first record, 2 for the second number
etc. Can someone tell me how to do this?
There are tons of posts on how to create a "ranking" query. You must have a
field or fields that uniquely identify the sort order. If you provided
significant table and field names as well as your desired sort order, someone
could create the SQL for you if you can't search for and fi...Set form field on double click
I am using MS Access 2003.
I have a continuous form that is run off of a query "srbScientific Review".
The query's criteria is set to [Enter Last Name] in the LastName field. That
part works fine. I get my continuous form that shows LastName, DocID, and
Title of Document.
I would like to double click on the DocID and have the following happen:
1. Open another form "publications"
2. Set the SRBId field to the DocId field that I double clicked on.
PLEASE help. I think I need to bookmark, clone.... I'm very confused.
As a kick in the right ...Letter Writing Assistant Error #3
When we try and print a letter in the letter writing program we receive a
Header Record Delimiters error. It is asking for a field delimiter and a
record delimiter. How do we correct this error.
This was working correctly a couple weeks ago, and it works correctly on
other machine sin the office, any thoughts or suggestions on how to correct
Anybody have any thoughts or suggestions?
Is there a way to have excel auto-sort (cutom) by criteria in 3 columns?
I think it might be easier to explain by viewing the workbook
The picture shows how I need it to sort. I found some information on
auto-sort in help and also on the net, but I don't know how to
incorporate the multiple criteria or if it's even possible. Any ideas?
Pools's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35961
View this thread: ht...FRx Forecaster Allocations do not work
We recently installed FRx Forecaster to use with Great Plains and FRx.
After inputting all of our budget data, we had our reseller set up some
allocations for us. They do not work.
We are trying to take the total expenses of several building cost
center (that contain the costs to operate the building) to the cost
centers have employees in those buildings. Next we are trying to
allocate the total expenses of a few support cost centers (IT,
Training) to all cost centers except the support, administration, and
building cost centers. Then we are trying to allocate the total
expenses of one adm...Custom MS Excel Charts
What technologies do I need to be able to develop custom charts for MS
Excel, are there any nice friendly APIs/libraries.
...Custom print comments in Excel 2007
There are two ways to print comments in Excel, either the WYSIWYG way
(little stacked boxes over the actual worksheet) or as separate pages.
Problem with the separate pages way: the comments get printed as
Comment: User name:
Now, the cell number is not necessarly the easiest way to locate a
specific cell. My question: would it be possible to replace the cell
number with, for example, the content of the cell or the content of the
I'm not an expert in VBA programming, but if someone could point out
where I should start to customiz...Customization guide #2
Anyone out there want to give up a copy of the developers guide? My store is
on a very tight budget, and has a hard time calling support everytime we want
to see what can be done with RMS. If you want to email it anonymously, I
won't say anything.....
Is there a developer's guide?
Every time I called MS about development information all I get is routed to
a salesperson or told we can put you in touch with "a partner" I even went
thru the route of trying to become a partner in order to have more dev
No luck so far.
"New RMS User" <N...Merge address in XL to Word letter template
Here is the basic situation. I have about 10 excel sheets containin
addresses of thousands of contacts. They are written like this:
[prior title][first name][middle name][last name][en
title][street address line 1][street address line 2][street addres
line 3][city, state zip]
Not all cells, like titles, contain data for all persons. Anyway, wha
I need is a way to insert, automatically, these addresses into th
proper address space in a prewritten letter and on an envelope. I kno
how to merge to create address labels in word, but not merge them int
a completed letter, as in:
Word Fil...How to disable Contract Template window?
Can we disable the pop up window to select Contract template, which comes up
while creating a new contract?
That means, whenever we crate a new contract, it always opens a pop up
window to select contract template, can we disable that window not to pop up
and takes a standard value for contract template?
Thanks in Advance.
Not in a supported manner. You could probably edit the underlying ASPX page
though to remove the call. However, no telling what this might impact.
MVP - Microsoft CRM
-----------...Work Order Deposit In Drawer
Hi I have this issue.
Let Say I have cashiers that work on the registers, and if they do work
orders, deposit ammount is not shown in any detaild sales report.
I understand that it is not sale yet that's why it does not appear, so I
will have to go with work order's but on other hand , my customer wants to
just generate one report with all the information needed. like there will be
total daily sales, let's say 1000, and work order deposites let's say 200 ,
so "total sales" will bes 1200.00
any ideas ?
...Email Template in Campaign Activity not available 04-24-06
If I create a Campaign in CRM and decide to communicate via Email with
my marketing list members by using a Campaign Activity with "Email" as
channel, I dont seem to be able to personalize the activity?
One would expect to be able to leverage from Email Templates from
...Junk Email Filter with IMAP Not Working
The Junk Email Filter in Outlook 2003 has never worked for
me. I am using an IMAP account, and according to Microsoft
the Junk Filter DOES support IMAP accounts.
Apparently you need to download whole message not just the
header so I have enabled 'Download Complete Item including
Attachments' instead of 'headers only' in Send Recieve
But still no joy!
What am I doing wrong? Are there any other settings that
need to be set to get it to work?
I have set the Junk Filter to high, also added email
address's to blocked senders list but still messages are
not...Opportunity Close Form Customization
Has anyone found the ability to modify the Opportunity close form? I
have modified (with success) the attributes - but, I cannot locate the
actual form that pops when you close the Opportunity via the Action
CRM 3.0 w/rollup 1
...creating autofill fields
So I need to create an automatically generated record in a table when the
previous fields time goes into the next day. For example. If a employee
input his time as 9Pm-2am on 1/1/08, I need to automatically generate a
record that has the time from 00-2am with the next days date:1/2/08 I also
have to cap each days time at 12 midnight. I am not sure where to start with
this entire sequence, can someone give me some guidance? Thanks. Christie
You've described "what", but not "why".
You've described "how", but not explained what having this kind...Merge Outlook Calendar with BCM 2007
Can I merge my appointments from Outlook Calendar 2007 into my Business
Contact Manager as contacts?
"Skipster" <Skipster@discussions.microsoft.com> wrote in message
> Can I merge my appointments from Outlook Calendar 2007 into my Business
> Contact Manager as contacts?
How can calendar entries be considered contacts?
Brian Tillman [MVP-Outlook]
...Call to Tape Archive Customers.
The Data Protection Manager Team is looking for customers who are using DPM
2010 Beta build (or any of the TAP builds). The engagement would be to gain
feedback and validation. Kindly send a mail to (dpmarch AT microsoft DOT
com) in case you are using the tape archive feature and are interested in
Pranay Prabhakar [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights
...Date 1 Field
I inserted the "Date 1" column into the Gantt Chart view & populated the
cells, however when I switched over to the Resource Usage View & showed the
Date 1 column, it didn't carry over any of the information I had populated.
Does anyone know why & how if possible to get this to work?
The issue is that you have two different tables: Task and Resource. There's
a Date1 in the Task table and a Date1 in the Resource Table. Those are two
different and unrelated fields.
Perhaps you could try using the Task Usage view and some grouping?
...Excel 2003 using a letter to define whether to multiply
Ok, let me explain subject line. I have a spread sheet where I want to be
able to put in T in a cell which represents if tax is paid, what I would
like is that by having a t in one cell the cell with the formula for tax is
used. i.e. if cell B1 has a T in it, then cell J1 will run the tax cell for
B1 and add the tax.
Is it possible to use letters in this way? Currently I am using a 1 for tax
and 0 for no tax which does work.
Any input welcome.
You'll have to use a function like EXACT, to differentiate between the upper
and lower case:
=IF(EXACT(B1,"T"),"Yes&qu...After Restoring 2007 DBs
I restored my test databases from domain 1 to domain 2 - a production
environment. I restored the databases, updated the resource domain
information in MSP_Resources. Then I provisioned a new instance of PWA and
pointed to the 4 restored DBs.
I can connect... everything seems to work except:
(1) the Project's queue doesnt seem to work. I cannot effectively check-in,
save, or publish project plans
Check your logs for errors. Check the services on the server to see what's
running, and what's not.
> I restor...