Autofit Row Height #3
I have a column on sheet 1 that is set to wrap text so that the row height
increases and decreases as more text is entered into the cell. This works
Users enter a number on sheet two where there is a lookup function that
returns the appropriate text from sheet 1. The problem is that when the text
is returned by the function, the row height does not adjust to fully display
all of the text in the cell. Is there a way of automating this?
Any help would be appreciated.
...RMS Troubleshooting and Basic Set up v4/3/2005
I have decided to post the information on the net because ms newsgroup does
not have a long message retention.
...Converting Crystal report from MSCRM 1.2
I have a client who has upgraded to V3.0 for CRM. They want to continue
using Crystal for their reporting engine because they have 40 custom reports.
Does anyone know how to easily accomplish this? I have created a new
connection to the new CRM Views in SQL, but I can't seem to figure out how to
easily replace all the fields that are currently in the report using the SSO
connection to my new connection.
Any help would be greatly appreciated.
many of the services such as rpttosql.com say they will only convert so
far. some even say they will only get the general lay...OWA
SBS 2003 SP1, Exch 2003 SP2, FBA w/ SSL.
If I add/delete a calendar event via OWA, I get a 5.1.7 NDR in my Inbox
(pasted below). The calendar item is added/delete, and I see it in OWA
I haven't seen any other posts similar to this, nothing on MS support.
Your message did not reach some or all of the intended recipients.
Sent: 12/21/2006 8:24 AM
The following recipient(s) could not be reached:
System Attendant on 12/21/2006 8:24 AM
The e-mail address could not be found. Perhaps the recipient moved to
a different e-mail organization, or t...how do I increase drop list font and box size I created
Font is small and you have to scroll through list due to box size
If the dropdown was created using Data Validation.............Font size is set
Dropdown box height cannot be changed.
For workarounds like using a ComboBox and using Zoom see Debra Dalgleish's site
on DV Lists.
Gord Dibben MS Excel MVP
On Fri, 4 Apr 2008 11:36:02 -0700, cdietz1 <firstname.lastname@example.org>
>Font is small and you have to scroll through list due to box size
...why can't I edit a document I created two days ago with same Word
Started using Windows 7 about two weeks ago. Now I can't edit files I just
created within the last week using the Word 2007.
I am really sorry that you are experiencing that. I am not quite sure yet
thatI fully understand your problem but from what I see it seems taht you are
trying to modify a read only file. Make sure taht when you save in word you
are not saving the document as "read only."
Let me know if this helps and if you have any additional info I would be
glad to help you .
> ...Disableing items in CLIstCtrl
Is there a way to disable an item in CListCtrl so that the item is gray
out and a user won't be able to select it.
At this point I think you have to go to an owner-draw list control and do it yourself. You
also have to prevent the selection from happening.
On Fri, 15 Apr 2005 11:03:17 -0400, "Ririko Horvath" <email@example.com> wrote:
> Is there a way to disable an item in CListCtrl so that the item is gray
>out and a user won't be able to select it.
Joseph M. Newcomer [MVP]...Contacts appear as mail items
Hi - Contacts from the Exchange server appear as mail items. WebDAV and
HTTP Keep Alives are enabled. Any other suggestions to correct the problem?
Amy Cottrell <firstname.lastname@example.org> wrote:
> Hi - Contacts from the Exchange server appear as mail items. WebDAV and
> HTTP Keep Alives are enabled. Any other suggestions to correct the problem?
This is a limitation in the current version of Entourage.
Note followups...there is an Entourage-specific newsgroup.
Adam Bailey | ...Number the Line Items on SOP
This is a multi-part message in MIME format.
I followed the procedure in=20
a.. How to Number the Line Items on a Sales Order Processing Order or =
(857285 - modified: 2005-09-01)
to generate the line no in SOP in GP 8.0 eventhoug the KB refered for GP =
6 and 7
But the problem i am facing is the no squence is not correct. It may =
appear 184.108.40.206.7,8.9...or 2,4,6,7,8,9 it is irregular
Please any one can help me to solve the problem
T...Protection Problem #3
I have a 3 sheet excel file with protection on all 3 sheets (let's call
them A, B and C). These 3 pages have formulas that link to each other.
Sheet A has a few checkboxes that link to sheet C. The problem is that
when I try to check any of the check boxes on sheet A an error box pops
up that says "The cell or chart you are trying to change is protected
and therefore read only". Is there a way to protect a sheet while being
able to check a box off that is linked to another sheet? What protection
options would allow me to do this?
Thanks in advance.
----------...Wild curser #3
> Your scroll lock isn't on ... is it?
No, it isn't- thanks! I've tried putting it on and off a few times
just to double check.
...Create MDI Child inside a thread?
I have attempted this through a CWinThread derived class but have been
unable to get the window creation to work correctly. This is what I have so
CRuntimeClass *pRT = RUNTIME_CLASS( CSecurityFrame );
CFrameWnd *pFrame = (CFrameWnd *)pRT->CreateObject();
ct.m_pCurrentDoc = NULL;
ct.m_pCurrentFrame = (CFrameWnd *)m_pParent;
ct.m_pLastView = NULL;
ct.m_pNewDocTemplate = NULL;
BOOL bSuccess = pFrame->LoadFrame(IDR_TRUSSVIEWER, WS_VISIBLE |
WS_OVERLAPPEDWINDOW | WS_CHILD...Unselect item in list box?
I have several multi-select list boxes on a form. Some of them have more
items than I have room to display on the form, but the scroll bar allows the
user to see all the list items.
I also have a button for the user to click to clear all the selections:
Me.lstElement = ""
Me.lstState = ""
This code works great unless the user scrolls the list box so that the item
selected is no longer visible. It is the strangest thing. If I can visually
"see" the item selected and click cmdClear, the item is no longer selected
(which is ...sending attachments #3
I downloaded all the security updates for Outlook 2000.
Now Outlook can't send attachments. The attachments
appear in the "send" directory, but the receiver of the
email gets no attachments.
The Outlook security feature blocks attachments that are potentially unsafe. This security feature provides an additional level of protection against
malicious messages. Although Outlook 2000 SR-1 or Outlook 2000 SR-1a blocks access to the attachment, the attachment still exists in the message.
For more information on resolving this issue, please refer to Knowledge Base art...Synchonization with SFO 3.0 performance
I would like to know if the syncronization of the Sales for Outlook has
better performance in release 3.0 ??
Is there a place i can find information on the way the new SFO is working ?
I was meaning 'Is there a place i can find information on the way the new
SFO is built' . Does it still use Cassini ?
> Hello everyone,
> I would like to know if the syncronization of the Sales for Outlook has
> better performance in release 3.0 ??
> Is there a place i can find in...Toolbox wizard to create Command Button
Windows XP Professional
I used the Control Wizard on the Toolbox to create a Command Button to
close the form.
When I try to use it it will not run and returns this error message -
The expression On Click you entered as the event property setting
produced the following error: Expected: list separator or ).
* The expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure].
* There may have been an error evaluating the function, event, or
Any ideas why? I'm at a loss.
Check to see if you haven't changed the name ...Creating an AD account don't make the mailbox in exch2K3
I don't understand what's happening.
When I create a new account in AD, it no longer creates the mailboxes in
It was working a week ago...
It asks me if I also want to create a mailbox, I answer YES and ... no
Please help me, I must create this mailbox quickly since a new employee
arrived and my boss doesn't understand why the mail is not set yet.
I believe that the mailbox is actually created only after the first message
is sent to it or there is a first logon. So if you are looking for it and you
do not see it, this may be the cause.
&qu...Publisher help #3
I created a website and i am able to upload it and view it in firefox but not
in any version of IE. Not exactly what i did wrong. But any help would be
Repost this question in microsoft.public.publisher.webdesign newsgroup and
add the URL to your problem website.
Microsoft MVP Expression
"Astroda" <Astroda@discussions.microsoft.com> wrote in message
> I created a website and i am able to upload it and view it in firefox but
> in a...Delivery Status Notification (Delay) #3
I have been receiveing several message stateing thet my message has been
delayed. Why is this happening and is there a way to configure this so that
the message does not become delayed?
below is a copy of the message that i receive;
This is an automatically generated Delivery Status Notification.
THIS IS A WARNING MESSAGE ONLY.
YOU DO NOT NEED TO RESEND YOUR MESSAGE.
Delivery to the following recipients has been delayed.
...create price list from excel sheet
I have been using Excel 2003 to manage a list of approximately 200 items.
This is a very simple list comprising of four or five fields one of which is
the price. I prefer to use Excel to manage this data because it then
becomes very simple for me to use formulas in order to calculate prices
after changes or additions to the items. I would like to produce a simple
A5 flyer listing all the items together with their prices. What will be the
best way to do this? I have explored the possibility of exporting the Excel
sheet into something like Microsoft publisher but I am looking for a fa...create a report using vba to select the names for the report
I need to create a report of selected Customers, I have gone as far as
creating a string with customer names in it. Whats next?
Selected_Customer_Names= [ABC], [test], [New], [A New One] ...... and so on.
Is this correct for the report and/or how do i open the report with the above
Message posted via http://www.accessmonster.com
On Wed, 28 Apr 2010 03:47:34 GMT, "trevorC via AccessMonster.com" <u44860@uwe>
>I need to create a report of selected Customers, I have gone as far as
>creating a string with ...rules created in Outlook 2003
I have a client who uses a lot of rules within Outlook
2003 to sort her mail. She is now getting this error when
she attempts to create a new rule:
"One or more rules could not be uplodaed to Exchange
server and have been deactivated. This could be because
some of the parameters are not supported or there is
insufficient space to store all of your rules."
Anyone have any ideas on how I can allow her to create
See this, e2k/e2k3 have the rules limit:
There"s...Integration GP 8.0 with CRM 3.0
Hi. i'm newbie in GP but i have been know CRM 3.0, i want to do integration
between GP and CRM using Microsoft Dynamics CRM Connector for Microsoft
Dynamics GP. After all installation and configuration, the integration was
work. I add an account in CRM then the account which i was added is display
in GP (as customer). But why the order between GP and CRM can't integrate? I
was follow the instruction in the integration guide. The guide book says that
the tax details, tax schedules, shipping methods, payment terms, unit of
measure, unit of measure schedules, price groups, price le...Multiple e-mail addresses #3
When a Contact has multiple e-mail addresses, how do I set
one of them as a default? Now, emails are going to ALL of
their addresses. Thanks-Rose
I have a dialog resource and have created CDialog and a CFormView classes
for this dialog.
If I right-click a control in my dialog I can create a variable for the
control, but how do I specify which class the variable belongs to, ie. my
CDialog or CFormView class?
I don't see how I can tell the add variable class wizard to which class the
variable should be added.
I'm converting a Dialog based app to a doc-view type app and am
experimenting with CFormView, which is why I have CFormView and CDialog
classes referencing the same dialog resource.
Thanks for any help.