select case from combobox and option group
I have an series of actions that need to be executed from differnt types of
controls on 2 different forms
one control is an option group, the second is a combobox (limit to list =
the commands had already been moved to a sub, SetPresetOptions(frm as
Access.form) <call SetPresetOptions(me) > , which is located in the same
module as the option group (and can be moved to a differnet module if
the code reads something like this:
Select Case optSetPresetOptions
case = 1
case = 2
case = ....
Ho...Activities and Workflow
I'm not sure I understand the logic behind not allowing activities to
trigger workflow rules.
I would like to do a couple of things that the designers of the product
apparently felt I shouldn't be able to do:
1. Create appointment activities in a workflow rule
2. Create other activities as a result of an (appointment) activity status
a) Automatically send a templated "appointment reminder" email before
b) Automatically send a "thank-you" email after the appt.
Does anyone know how these might be accomplished?
...Are attribute values case sensitive?
I know that elements and attribute names are case sensitive, but are the
actual attribute values case sensitive when referred to from within an
xsl stylesheet for example?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
"Kathy Burke" <firstname.lastname@example.org> wrote in message
> I know that elements and attribute names are case sensitive, but are the
> actual attribute values case sensitive when referred to from within an
> xsl styleshee...When does commission data move to history tables?
We've recently started using commissions in GP. Commissions are payable when
the invoice is paid. Our reps are not employees so we pay them through
After running the commission transfer routine I've found that some of the
invoices for payable commissions (i.e. fully paid invoices) reside in the
open table (RM10501) and some reside in history (RM30501). This makes it
difficult to pull paid commission data for import into payables (via
Does anyone know what causes commission data to move from open to history?
It would seem that this would ...Create a Macro in Manager
Is there a way to create macros in manager? I would really like to cut a
lot of the keystrokes out of printing labels.
...Assigning Campaign Activities to multiple users based on Criteria
Is there any way to have the assignment of campaign activities done on the
basis of certain criteria? (i.e.; on postal code of the account, assigned to
TM working on the corresponding region).
If not: is there any way to have the distribution of multiple activities in
a queue done on the basis of certain criteria? (i.e.; see above example).
Sounds like that you can leverage the CRM 4.0 Workflow to accomplish
your task. Please look into workflow and if you have any questions,
feel free to post it here.
Darren Liu, Microsoft CRM MVP
http://www.crow...Word2007 content management
I have a question,
I use MS Office 2007,
I work with documents and often the same document is often repetitive text,
how to develop the fields, where one exchange of any other adjustment
contained in the document? I have about 40 phrases in a document repeated
I thank you in advance.
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
...Does every one else have to micro manage MS$?
Just wondering if I am alone on this but it seems like with this app the
longer you use it the more things come up that are just baffling.. For me it
is duplicate transactions showing up, things not matching from the bills area
back to the account register and the latest is ever transaction from my bank
comes by default with NICOR as the payee and marks it as a utility. I know
allot of the problem is the different banks and companies the software has to
work with but common these discrepancies and constant need of babysitting
almost makes it a wash for any efficiencies gained.
I wen...mail box management
Can anyone tell me how i can get exchange to delete all e-
mails from everyones deleted items folder once a week, ie
In what version ????
Sorry! exchange 2k. we are also using group policy but i
cant find anyting in here. I do know there is a client
setting but i would really like to run it from the server.
>In what version ????
In ESM, create a new Recipient Policy (type Mailbox Management) make sure the LDAP filter you uses includes all and only all (not Public Folders etc .. by mistake) user m...GP 10 for Events Managment company
I've recently started a project for a client whose core business is mainly
events management. We'll be re-implementing GP 10 for financial reporting
purposes - however I have a few questions before we start setups, namely
1. What is "best practice" for a COA (chart of accounts) structure? Since
the company will be planning multiple events throughout the year, I dont
think its wise to build each event into the COA structure. Is my thinking
correct? Furthermore, the co's budget is not being inputted into GP by event
which further signifies to me that I may not ...Case Lookup 04-21-06
Is there a way to prevent resolved cases from appearing in the case lookup?
Create an email in Outlook. Click the 'Track in CRM' button.
Click the 'Regarding' button. Change the 'Look For' to Cases.
Currently this lookup displays all cases with no restrictions. I would like
to restrict this to only show active cases.
Thanks for the post. I will have to take a look at this to see if there
is a way to filter the view. A quick glance at the issu...Project Server 2007 Manage Users Page Missing Show Options
Today it appears that my Manage Users page has become modified. The "Show" options" (All Users, Specific user) are no longer visible. Note: I have 2 instances: Production and Train. This issue is occurring in the Production instance only.
When I launch Manage Users, all I see is the Search option, and aside from that, the page is blank. I can search for users, and if they have an account, it will find them. But the listing of users I always see is gone.
I have made no configuration changes. I do not even know what would cause this to happen. Can anyone out there hel...Letter case problem
I try to use a lowercase letter i in a cell, just as a bale for a list
of items, all by itself, and Excel insists on changing it to an
uppercase I. It does not make any difference if I specify that the
cell is text. In fact, nothing I have found solves this problem.
Does anyone know how to make Excel behave in this case?
"docbnj" <email@example.com> wrote in message
>I try to use a lowercase letter i in a cell, just as a bale for a list
> of items, all by itself, and Excel insists on changing it to an...Business Manager Crashes Outlook 2003
Outlook will open, but if I try to perform any function,
even open an email, I get the massage "Business Contact
Manger has encountrered a problem and needs to close. We
are sorry for the inconvenience."
Dependin on the function I try to perform, sometimes I do
not even get the message, the progem just closes.
...How can I use fill hand to copy the fomula in this case?
Here is my fomula:
Is it possible to use fill handle to copy the fomula automatically in my
case?, If so, how? Thanks.
I assume that B4 should read = sheet2!A10
with a help column in sheet1
enter the first function in B1 and fill that down the column
enter in C column a series of 1<><>2<><>3<><>and extend that down th
do a sort on C column
delete the surplus rows
> Here is my fomula:
> B1: =sheet2!A1
> B2: =sheet2!A4
> B3: =sheet2!A...change lower case text to upper case text
is it possible to change lower case text to upper case text in microsoft
Yes, in an empty column enter
=UPPER(A1) and copy down, in that column Copy > Paste Special > Values to
lose the formulas, then Cut > Paste back to the original location.
If you want to use code, see you Jimmy here,
"rotty" <firstname.lastname@example.org> wrote in message
> is it possible to change lower case text to upper case text in microsoft
> excel 2000
I'm new to CRM and trying to customize it. I've got some question. I hope
there's someone to help me out...please...:(
1. How can I rename the case status: Active and Resolved to Open and Closed?
2. I need to customize My Active Case View. When the user select the view,
is there any way to show the shared cases?
Thank you in advance,
...Mailbox Manager #2
After upgraden our Exchange 2000/Windows 2000 to Exchange
2003/Windows 2003 our clients get no e-mail anymore form
the Mailbox Management process.
In the Event viewer I get the following message:
Event Type: Error
Event Source: MSExchangeSA
Event Category: Mailbox Management
Event ID: 9313
Microsoft Exchange Server Mailbox Manager failed to send
the following message:
Subject: The Microsoft Exchange Server Mailbox Manager on
EXMAIL completed processing successfully.
For more inf...Schedule a Macro with Windows Task Manager
I am trying to do so, but it is not working.
My .bat file:
C:\Program Files\Microsoft Office\OFFICE11
E:\IT Dept\Access\database name.mdb /x Marco Name
Is this correct?
On 03.03.2010 20:44, lindag wrote:
> I am trying to do so, but it is not working.
> My .bat file:
> C:\Program Files\Microsoft Office\OFFICE11
> E:\IT Dept\Access\database name.mdb /x Marco Name
> Is this correct?
You need to specifiy the Access executable, e.g.:
Set ACCESS = "C:\Program Files\Microsoft Office\Office10...Loan Management
I am looking for an add-on product for Dynamics GP that will allow for Loan
Management. I have thought of using Scheduled Payments, however I need it to
be more specific to Loan Management to handle if the payments aren't made and
assessing late fees.
...Viewing Queue in Requisition Management
I am new to managing Business Portal - Requisition Management.
I have a buyer that is getting an error when he clicks on the vendor in his
queue. I am wondering if there is a way for me, as administrator, to view
what PRs are open and in the queue?
We're using GP 10.0 with WSS 3.0
Thanks in advance!
Sr. Microsoft Dynamics GP Applications Consultant
Certified Microsoft Dynamics GP Specialist
...Foreground locking error in integration manager
I have a scheduled integration setup that first runs the login to GP, then an
integration group (2 AR integrations). I have them set at 5 minutes apart.
The TK article for this particular error says that the error is becuase
"Great Plains is still in the process of launching when the Integration
Manager starts running." However, I then increased the time to 15 minutes
apart and finally at 30 minutes apart, but the first record of both
integrations still fails with this error "could not set foreground locking
value to 0."
How can I get rid of this error? It only ...Find Cases by Case No
Our Tech Dept wants to find quickly a Case by typing the Case No, but the
default Search field for CRM searches by Title, which is not always easy to
guess. Can we do something to change it, either unsupported or no? There is
also the Advanced Find Utility, but can we make a shortcut for our Tech Dept
which will have pre-selected the Case Object and, ideally, the Case No
contains xxx row?
Any ideas will be appreciated.
...new activity not in the appropriate queue
I installed the Rollup 3 for MS CRM 4 and since then all created activities
are redirected to the users assigned folder in queue and not in progress(my
current activities) folder!
It's not logical because a new activity is not yet assigned to a different
user to be in the assigned folder !!
I can't believe this is on purpose and I DON'T have a workflow on this.
Can someone tell me how to fix this?
...Receivable Management wih Integration Manager 10
I have to integrate following two files to RM in Dynamics 10 by using
Integration Manager 10, the current integration is ok but it cannot give me
the detail of tax transaction after integration.
File 1 - Header.txt
DOC TYPE,CUSTOMER ID,DOC NO,DATE, AMOUNT ,tax id,tax amt
File 2 - GL_Distribution.txt
DOC NO,ACCOUNT,DIST TYPE,DEBIT,CREDIT,SALESPERSON ID,COMM AMT
After integration to RM by using these 2 files, I can see the transaction in ...