Missing search feature
Maybe. Just got a call from a user with Excel 11, who claims that once upon
a time, he had a search feature (not the Find feature) which would gather
all occurrences of a value into one "screen" as he calls it, instead of
stepping from one occurrence to the next (as with the Find Next button). I
use Excel 2000, so I have no idea if he's making this up. He is not savvy
enough to build such a thing using VBA or spreadsheet functions, although
it's possible that one of his customers has been sending him a tricked up
sheet, and then eliminated the trick.
Absent that last ...Workflow
To start with, I didn't have access to the Workflow manager and was
doing all my customizations using client side scripting. I set up the
sales stages using a picklist with the salesstagecode schema. I now
want to do these using the Workflow manager, and have the user manually
advance the sales stage (as they would if they were selecting the
option from the picklist). I'm so hopelessly lost with working out the
workflow manager. Ideally, I'd love the user to be able to change the
sales stage in the picklist, and have that change the sales stage in
the sales process. Do I have ...SQL Server 2000 Standard Edition vs SQL 2000 Personnel Edition
I am using SQL server 2000 standard Edition sp3 with Gp 9 Sp3, I am planning
to move GP with database to new server different hardware.
can I use sql 2000 personnel edition sp3 or should I use same old version.
I hope u understand my question.
Generally speaking, personal editions are not robust enough to support a
product like GP. I would stay away.
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
"MK KSA&quo...Checkbox validation rule
In form view, how do I do a very simple validation rule so that if a
checkbox is not ticked, it won't let me move on?
in the form's BeforeUpdate event procedure, add
If Me!CheckboxName = False Then
Cancel = True
Msgbox "Checkmark the box, please."
replace CheckboxName with the correct name of the checkbox control, of
"Jon" <JonMYates@gmail.com> wrote in message
> In form view, how do I do a very simple val...Editing Text when using Publisher as a web page...
I'm using Publisher to document the status of current taskings in the office.
I'm trying to ger Publisher to allow people that pull up the web-page to add
and edit text on the web page so we can keep everything up to date. Right
now, someone has to come to me and tell me the changes, then I change the
info in the Pub doc, then I have to repost the web-page. Is there a way for
people to edit the text on the web-page when they pull it up. I have text
boxes in there now that people can edit, but the text doesn't update when you
close the page and re-open it. Please Help if you ...Outlook Rules #29
I did this before with my old Office I think or was Outlook Express ?
Anyway, can anyone tell me how to do it on my Outlook 2003 ( Office 2003
( If it is possible )
I remember I setup a rule for Outlook NOT to download any mail
bigger than XXX kilobytes, in another words, if the mail is too big
DONT GET IT.
In OL2003 you don't do that with rules but with Send/Receive settings. Go to
the Tools menu > Send/Receive > Send/Receive Settins > Define Send/Receive
Groups > Highlight a group > Click Edit. You can set the size in that
dialog. Outlook will then ...un-group and un-constrain all the class diagram elements
Hi. I have an UML class diagram that I have to paste inside another
Visio diagram. The destination diagram is not UML, it's A3 printed
sheet formatted to match some rules (borders, table for description in
the corner etc).
I want to make class digram bigger and then make it better visually -
e.g. move some labels around and resize stuff. However there are
problems, namely (as in the original class diagram) I cannot move
connection end labels around and I cannot change block height.
I tried all kinds of options like disabling the protection, adding to
new layers etc, but nothing seems to ...editting auto recovery
is it possible to change the auto recovery directory just for one document
and is also possible to ensure that the auto recovery file is not deleted
after the file is closed?
AFAIK this is not possible. But you may consider using the following
(look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.)
> is it possible to change the auto recovery directory just for one
> document and is also possible to ensure that the auto recovery file
> ...BOM & Edit List
I created an Assembly transaction and printed it from the Assembly
transaction entry window before posting it.
In the posting journal that prints it does not print the Assemble cost,
extended assemble cost, Unit cost of the components and the extended cost.
But if i post the transaction then the same posting journal is printed with
Why does it not print?
Please let me know
It only pulls posted costs, like other Great Plains edit lists including
items. You will need to modify the report to include costs.
> I created...template edit question, add more? edit template?
Operating System: Mac OS X 10.6 (Snow Leopard)
i'm using a resume template and it's beautiful, but only allows four job positions before it moves one the education, etc. <br><br><i>guess theres a way to do it on the pc version, but with mac, how do i insert an addition formatted block? it will only let me work within the template currently.</i> <br><br><i>hope that makes sense, thanks for the help!</i>
Mac or PC makes no difference � it's a matter of how the template is
constructed. With...Missing Entries on Budget Reports on 2004
My main objective in using MS Money is to track spending vs. budget.
Have complete budget created and but monthly budget report leaves
budget column blank for several entries, therefore overspent.. What is
up with this???
...How to edit entitys attributes directly?
I messed up with entity mappings and ended up with errror: attribute not found.
How can I manually remove attribute from entity?
Tried export -edit -import but it seems not to be the right way.
You will first need to remove the "bad" mapping that you created. Since it
is referncing the field, you need to do that prior to trying to remove the
field. You also need to remove it from any forms & views that may be
The customization Import will not remove fields (as you have discovered).
That is done as a safety feature to rpevent accidental loss of data (ima...Editing
Could you please tell me how to remove a linked
transaction within the budget planner. For example, I
have a double entry under the debt category.
...CRM 4 Automated Workflow
I have a question around the new workflow in CRM4. I'd like to have a
process that runs daily, not triggered by an update in CRM4. Here's the
When a contract's end date is within 2 months of coming due, I'd like to
create a new opportunity to renew the contract. Also, it'd be nice to send
an email alert about the expiration of the contract.
Can the workflow configuration run and check conditions daily or something
to validate that the contract end date is within 2 months of the current
I'm not seeing an option quite like this, b...Macro to edit details
Hi, i am currently trying to create a macro regarding editing staf
details on a worksheet.......
therefore i recorded a macro and named it editstafflist, i highlighte
my headings...and then went to 'data > form' and then had to close th
form and then stop my macro. It wouldnt allow me to stop my macr
whilst the dialogue box was open. Anyways after stopping the macro
drew out a button and assigned this 'editstafflist' macro to it.
saved my sheet and then clicked on the button, but a error '1004' kep
occuring, can anyone please help me on this as i am rather stuck
...editing a drop down #2
that's not one of my choices.
kateweb's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16301
View this thread: http://www.excelforum.com/showthread.php?threadid=276931
what do you mean by this .. is it greyed out on the toolbar or shows "any
if you'ld like to tell me where you downloaded it from i can go have a look
"kateweb" <email@example.com> wrote in message
news:kateweb.1fictb@excelfor...Setting caret in edit control & activating it.
Does anyone have any example code for setting and enabling the caret in an
edit control ?
Take a look at the CEdit::SetSel() member function.
Check Abdoul [VC++ MVP]
"Nicholas Kingsley" <firstname.lastname@example.org> wrote in message
> Does anyone have any example code for setting and enabling the caret in an
> edit control ?
If you are asking how to create & use your own caret in an edit control then
check...Failing to find some contacts
I've lost the ability to find a contact when I make a new email. If it is a
contact that I've used fairly recently, then it isn't a problem but there
are some contacts that I can't send email to. For example, there is an entry
in my contacts for Dave Smith but if I put that name into the to box,
Outlook will complain that it can't find the contact. When the search box
comes up, it says that it can't find any contact at all.
One other little data point. A few months back, I had another problem that
was 'solved' (and I use the term loosely) by using the Hel...Data collection Form Edit
We have a form which will be used almost daily, for data collection, based on
a query. During the test we found a typo in one of the field labels where a
brief description is included. Is there some way to edit the form?
(recreating it with all the custom lables is just too long a task).
Another issue on this topic, every time the form is sent, the messge reverts
to the default "Please fill out the form and retunr it to me". Can this
default message be changed?
Nothing in the help functions. Any advice, or deirection to a learning
resource will be appreciated.
Thanks is adva...Where's the missing chart?
I have a wrksht, I created a chart. The chart is on its own pg. How do I
return the chart to the wrksht, or, at least, make it visible?
Right click the chart and pick Location.
You can then make the chart an object within a worksheet, which you pick
from the droplist.
Andy Pope, Microsoft MVP - Excel
"Boswell" <email@example.com> wrote in message
>I have a wrksht, I created a chart. The chart is on its own pg. How do I
> return the chart to ...Outlook 2003 & rules II
Is there a way to stop Outlook from adding "On this computer only" to every
My PST file is saved on a protable USB connected HDD and rules are always
created with this option activated.
Therefore I have to edit every new rule to deactivate this option. Every
Zadig Galbaras <firstname.lastname@example.org> wrote:
> Is there a way to stop Outlook from adding "On this computer only" to
> every rule?
Not for the conditions under which you use the PST.
...Checking New e-mails for missing subjects
I've done a Google search for this but have not found any tip or plug-in
that will answer this.
I'm using Outlook 2003 and would like it to warn me if I try to send new
emails without making a subject first.
Anyone know of a hidden setting in Outlook or a plug-in that will do this?
Wes. <email@example.com> wrote:
> I'm using Outlook 2003 and would like it to warn me if I try to send
> new emails without making a subject first.
This discussion has code to do that:
"..."Windows PowerShell Cookbook" by Lee Holmes second edition draft available for viewing and comments
O'Reilly Books has made the working text of the PS V2 second edition
of Lee Holmes' "Windows PowerShell Cookbook" available for viewing and
In message <exi7SKRyKHA.2552@TK2MSFTNGP04.phx.gbl>, Larry__Weiss
>O'Reilly Books has made the working text of the PS V2 second edition
>of Lee Holmes' "Windows PowerShell Cookbook" available for viewing and
> - Larry
Aw...CRM Sync Forwarding Rule
Using CRM 3.0 with Outlook 2003, I notice that every email the CRM forwarding
rule processes is marked as read. Is there a way to prevent this?
Has anyone experienced this?
> Using CRM 3.0 with Outlook 2003, I notice that every email the CRM forwarding
> rule processes is marked as read. Is there a way to prevent this?
...Having Insert button functionality while editing
I want to have the functionality of Insert button (on keyboard) in my while
application while editing in a cell or a edit box. For eg if i am editing my
text say "alpha" and my cursor is between "l" and "p" and I insert an
alphabet say "z", i want the "p" should be replaced by "Z" and the text
should become "alzha".
Thanks in advance.
CEdit does not support that by default.
Here is a good example of how implement this (Although I think UpdateCaret
should just be a method of CXEdi...