Large amount of cell text
We have a case where we have received records from a
Hotmail subpoena. Microsoft has put the records in an
Excel spreadsheet with all emails for a six month period
being contained in a single column and tens of thousands
The problem I am having is that some of the cells that
contain the text from the email messages are very long,
and makes reading of the cells difficult. An attempt to
save to or publish to a different format for easier
reading causes truncation of the text in those particular
cells. Word Wrap, Autofit, nor simply double-clicking on
the cell margin d...Convert Cell Text to Matching Hyperlink?????
We have an Excel spreadsheet that contains information to scanned
images being populated into our engineering database. In the
spreadsheet there is information as to the creation time and date,
size, title and other related information. One of the columns is the
name and location of the actual TIFF image file. This field is just
text. What we would like to do is convert the cell from just text
stating the location and filename to a hyperlink pointing to the
For example, the cell contents state : G:
We would like to still have the tex...Microsoft Betrayed Yet Another Customer Base 08-23-10
Microsoft acquired a company in 2008 that have been making a 3D modeling and
animation software for more than 20 years, and discontinued it a year
latter. No more updates, nada.
The software has a huge following, including in Hollywood. Microsoft made
the software free, but for the many who already paid for it there are no
updates and no guarantees that the software would work on future versions of
Windows, and their graphics assets are stuck in the current version.
Nobody wrote this again :
> Microsoft acquired a company in 2008 th...merge MSN Bill Pay & Checking Acct
I want to merge my checking account with MSN Bill Pay but only see that I
can merge MSN Bill Pay with my checking account (i.e., you lose all of your
checking account information).
Does any one have any suggestions?
...Sorting Items in a Combo Box...
I have a Combo Box that is sub-classed. I want the items in the list to be
sorted by the lParam of the item and then alphabetically (upper and lower
The dialog control being sub-classed has the Sort property set to true, but
it isn't sorting them, or if it is, it is doing so in reverse of what I want.
For example, the list contains "r, D, .s, .., and ." which is the order is
displays them in from top to bottom, but I want the reverse ("., .., .s, D,
I tried setting up the CompareItem(), but it doesn't seem to be called.
- The Co...How do I create Check list
1.I am new to excel and want to create a simple check list. I would like to
have the first column check boxes and then the following columns discription
and notes. Can someone give me a step by step on how to do this. I have
created spread sheets but am not familiar with check boxes.
2.Also, Can someone tell me the difference between Access and Excel?
1) Not sure what you're aiming to do with the checkboxes, but if you right
click on the toolbar area, you will get a list of available toolbars. You
want either the 'forms' toolbox or the 'controls' toolbox. Genera...Control printing according to list box options
I have two list box's that control the report that is going to print. Text20
is the list box that displays the shed number, and the drop down list varies
depending on what sheds are in the table. if a shed number is added or
deleted, it is also added or deleted in the list drop down box.The row
SELECT DISTINCT [98MatingRecords].[SHED #] FROM 98MatingRecords ORDER BY
The second is Text22, this list box has the sections in it and the sections
are controled by the shed number, some sheds have 1 section some have 6 and
some have 3 or 4, so the dro...Authorizing checks with RMS
I recently removed PCCharge and setup my syetm to work with a preferred
merchant provider to allow native processing of credit & debit cards. Since
check verification/authorization was handled by PCCharge to Telecheck, check
authorization is now not being done.
How is check authorization accomplished using a preferred provider?
Unfortunately, it's not. PC Charge is the only option for check processing
in RMS as far as I know. TPI or some other vendor may support it through an
add-in, but RMS as shipped has no way of doing both checks and debit...
Gle...Check names not working for multiple address books / contacts
I have upgraded from outlook 2003 to outlook 2007, my contacts are stored in
pst. I used to be able to search for a name via check names and it displayed
me all the results from global address list and from my contacts, but now it
only does one. It does not matter which one I set in the checking order,
whichever is top will be the one that provides the result. I would like it to
show me both results, how would I go about to set that up?
More accurate and complete information would be helpful. The Global Address
List is only available to those who c...Check text field value against underlying table or query of combo box
I have a form on which the user can enter new records or update
If the user enters a new record on the form, I would like to have an
'After Update' event on one of the text fields, which is the item# to
check if the value entered already exists in the underlying table,
tbl_item. How can I call the table from the 'After Update' event of
the text field and check for that value in the table?
Thanks in advance.
>I have a form on which the user can enter new records or update
>If the us...Preventing multiple check boxes from being checked
I have a worksheet with over 20 rows of check boxes with 5 check boxes in
each row. (from the forms toolbox) I would like to prevent the user from
checking more than one box in each row. Is this possible?
BTW, this forum has been a great help. I'm so glad that expert Excel users
are so willing to share their wealth of knowledge.
Put them in a group box, again from the forms toolbar.
Drag the group box onto the sheet, then drag the checkboxes in.
(remove nothere from the email address if mailing direct)
"Jae" <Jae@discussions.micro...No Programs are showing up in the ADD/Remove program Box
XP Home to XP Pro Upgrade - clean install.
Interestingly enough System Retore is disabled/stopped and I can not restore
Tried Regedit and looked for prog names >63 char, but none found under
"Matthew" <Matthew@discussions.microsoft.com> wrote in message
> XP Home to XP Pro Upgrade - clean install.
> Interestingly enough System Retore is disabled/stopped and I can not
Using a newsletter created by Publisher 2000, opening the
newsletter in Publisher 2002 and saving as a web page
some of the text lines are over writen by the next line
and the text that fills a column in the newsletter leaves
a lot of white space at the bottom of the column.
Is there any way to fix this problem or do I continue to
use Publisher 2000 and give up on Publisher 2002?
Thanks for any help any one can give.
...How do I turn off the text to speech facility in Exccel?
I am trying to turn off the text to speech facility in Excel. Please help.
On Sat, 4 Jun 2005 01:29:26 -0700, "David Boas" <David
Boas@discussions.microsoft.com> wrote in microsoft.public.excel.misc:
>I am trying to turn off the text to speech facility in Excel. Please help.
On the Speech toolbar, click Speak On Enter, the rightmost button. See
also Help: "Turn off speech playback" where it says:
Turn off speech playback
Do one of the following:
To turn off all speech playback, click Stop Speaking on
the Text To Speech toolbar.
To turn on or...Printing Checks
I'm having a problem printing checks from Money 2003.
I have three accounts that come up in one .mny file. Two of the accounts
use 3-on-a-page checks and I want the name and address printed on them. One
account uses voucher checks and needs to be nudged a little south. When I go
to print checks I have to be aware of what account I'm in and change the
settings by hand to make sure the checks print correctly.
How can I make the check-print settings stick with the account I'm using.
It's a pain to have to remember every time. I'm frequently forgetting and
screwing up a pag...why can't i type in plain text control boxes?
I am building a template in Word 2007. In the content controls I have the
option of using rich text or plain text. When I choose the plain text and
protect the document to filling in forms I can not type in the content
control box. Yet when I use Rich text I can't tab over to the next content
control box as it tabs within the control box. All I want to be able to do
is type in the control box and be able to tab to the next.
Did you by any chance set the text controls so they cannot be edited? Undo
that and you should be able to tab from text control to text control with ...Employee Check Format-Graphical
Does anyone know of a TK that shows how to convert one of the employee check
from a text report to a graphical report?
We do not have Direct deposit, I looked in the Report Downloads from Great
Plains and did not see one there either.
There's no secret here. Just un-check the "Text Report" option in the Report
Definition window. And then modify the report so it looks like you want it.
This will take some time. The reports don't transfer from text to graphical
> Does anyone know of a TK that shows how to convert...Simple hack to get $500 to your home. 06-04-10
Simple hack to get $500 to your home at http://dailyupdatesonly.tk
Due to high security risks,i have hidden the cheque link in an
image. in that website on left side below search box, click on image
and enter your name and address where you want to receive your
cheque.please dont tell to anyone.
On 6/4/10 12:58 PM, kajol wrote:
> Simple hack to get $500 to your home at <URL DELETED>
> Due to high security risks,i have hidden the cheque link in an
> image. in that website on left side below search box, click on image
> and enter your name and address where ...Check Names = "Exchange Server computer is busy..."
Here's what I got:
Active Directory on Server 2003
1 Domain Controller also running DNS and WINS
No other DNS or WINS servers (I know, I know)
Static IP Addresses...NO DHCP
Exchange Server 2003 on a member server
Client running W2K SP4
Outlook 2000 SP3
Exchange has 4 mailboxes set, but nobody is using it. I'm still testing
When I try to connect to Exchange via my Outlook 2000, I get the following
"The function cannot be performed because the Microsoft Exchange Server
computer is busy. Try again later"
I've tried it from 3 different client comp...SFO client install error 02-03-05
i have got a problem that the shortcuts and the crm icon in the mail box
will not show out when i install the SFO client software and I got the error
"Setup has failed because of an error. Setup unable to install the .msi file
for Microsoft CRM SFO"
I have tried to uninstall the software many time, even i changed the Domain
but the problem still happened.
does anyone get the idea how to resolve it?
Be sure you followed all of the pre requisites before the install is
Make sure the web client is operational.
Indexing services are in...Printing MICR checks
We are having an issue printing checks on the Select Payables Checks
window. When we try to print the checks we receive the error message below:
"Warning: You have MICR but are not in a MICR screen. To use MICR, abort
this screen and set up security access."
The user has access to this screen but I'm not sure what this error message
means. There was nothing related to this in the Knowledge Base either.
Has anyone else received this error message before and if so how did/do you
The user has the third party mekorma check writing module ...File name list in the open dialog box.
In the open dialog box, how to delete the list of files appearing in the file
name drag down menu in excel 2007?
Not sure where you are finding this list.
Do you mean the Recent Documents you see when you click on the Button?
You can clear that by setting your MRU list to 0 under Button>Excel
If you mean the list you see when you go to Button>Open then you will have
to set a new default file path to a folder that is empty.
Gord Dibben MS Excel MVP
On Thu, 4 Mar 2010 09:10:01 -0800, Acs <Acs@discussions.microsoft.com>
...CRM Import Wizard 11-29-05
I have a user who is getting a message that "Microsoft Outlook Cannot be
Started". I have double checked that the ActiveX settings are all set to
allow the plugin to run.
Try getting the user to open the the following link:-
Replacing "crmserver" with name of your CRM server
Note:- the ActiveX control for the Import Wizard is installed as part of the
same install as the Crystal Viewer ActiveX.
Worth a try anyway
...Check off boxes
Publisher 2003 in use.
I am creating a questionnaire that will be included in a newsletter. I am
using the publisher software to make this form.
Somewhere, in the past, I saw a keyboard shortcut to inset checkoff boxes,
however, I cannot remember the key strokes.
Any help along this line will be greatly appreciated.
Thank you and enjoy your day.
Mike Reshetar wrote:
> Somewhere, in the past, I saw a keyboard shortcut to inset checkoff boxes,
> however, I cannot remember the key strokes.
Use Wingdings and the � or q characters.
Ed Bennett - MVP Microsoft Publisher
h...Exchange Connector 08-15-05
We have recently moved CRM from a 2K box to a new 2003 box. Since
uninstalling and reinstalling the Exchange connector we have been getting the
below platform error. Exchange is 2003 and on a seperate box. Any help
would be greatly appreciated!
Event Type: Error
Event Source: Microsoft CRM
Event Category: None
Event ID: 2
Time: 3:03:53 PM
MSCRM Platform Error Report:
Error: <description>An unexpected error occurred.</de...