Trim removes spacing in the beginning and end of word.
How can i delete a spacing betwee two words (name) ex "De Wit" > i want
You can use:
to remove all the spaces (leading/trailing/embedded)
if you really wanted lower case.
Luc Vandenhoeck wrote:
> Trim removes spacing in the beginning and end of word.
> How can i delete a spacing betwee two words (name) ex "De Wit" > i want
> THX Luc
...Why Can't I Access Internet Links
I use Windows XP and IE 7 and suddenly one day I was unable to access
internet links that were sent to me thru regular emails to my
Microsoft Outlook. Any idea how to fix it? Thanks.
What happens when you try? Any error messages?
Hal Hostetler, CPBE -- email@example.com
Senior Engineer/MIS -- MS MVP-Print/Imaging -- WA7BGX
http://www.kvoa.com -- "When News breaks, we fix it!"
KVOA Television, Tucson, AZ. NBC Channel 4
Live at Hot Licks - www.badnewsbluesband.com
"amirstal" <firstname.lastname@example.org> wrote in message
news:d7decb35-157c-4438-82bd-24a2536d347f@m36g2...in CRM Mobile, Can we assign / apply rules ?
Both in CRM Mobile and Mobile Express, I didn't see any function about assign
/ apply rules / convert ...
These functions are not available out of box.
You can however, create workflow rules that "watches" for some changes to
field records so it can be triggered wheneven those fields are updated by CRM
Mobile or Mobile Express.
Frank Lee, Microsoft CRM MVP
> Both in CRM Mobile and Mobile Express, I didn't see any function about assign
> / apply rules / convert ...
...Can't set Date Properties.
I am working with data that has dates set as text. So in a query I am using
a variable that sets the text to a date suing CDATE. At least I thought it
did. I notice that in forms etc when I try to set the date property to long,
medium etc, there is nothing to choose so presumably it is not a date after
Any idea what I'm doing wrong please.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.673 / Virus Database: 435 - Release Date: 01/05/2004
Sorted. I hadn't set the function as a date.
Well I am n...can't access public folders with OWA
I have Windows Server 2003 and Exchange Server 2003 Installed
everything works fine, except when trying to access Public folders via
Outlook Web Access, after going to the location its asks for username
and password - this works ok and the folder is displayed, but when
trying to add a folder or post a note or do anything I get:
You are not authorized to view this page
You might not have permission to view this directory or page using the
credentials you supplied.
I have tested on client machines, remote machine and the exchange
server as administrator with no luck.
does anyone have any...How can I default a lookup field to a particular value.
How can I default a lookup field to a certain value, but still allow
the user to modify the field if necessary?
you mean a drop down or picklist?
"Bob" <email@example.com> wrote in message
> How can I default a lookup field to a certain value, but still allow
> the user to modify the field if necessary?
> Bob Johnson
i have the same question in crm 3.0. i want a default value in a lookup
filed. i also want to create a lookup field by my self....How can you set up a form that the cursor only moves to cells tha.
I have set up a form. Now I want my cusor to move through the worksheet
only in certain cells. I want to be able to go from one cell that needs to
be filled out to the next cell that needs to be filled out automatically.
Example , move from cell a3 to c19 automatically. How can I do that?
You can accomplish that by setting sheet protection.
Select all the cells that you want to be able to navigate
to then goto Format>Cells>Protection tab. Uncheck Locked.
Now, goto Tools>Protection>Protect sheet. A list of
options will appear. Uncheck Select locked cells and check...Limitations to # of Decimal places for seconds (time)? #2
Bernie Deitrick Wrote:
> Are you really recording every 1/10 millionth of a second? And, yes
> limits you to three decimal places on the seconds
> Thanks a ton for your help, Bernie. I guess this is what I have to do.
And yes, the system does log time to the accuracy of 6 decimal digits.
Thanks and Regards,
Xprezons's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1505
View this thread: http://www.excelforum.com/showthread....Excel VBA
I have enclosed a timesheet which i want to break down the day
activities by a percentage, so if my sheet says an activity took a
hour then the day column would tell you percentage of a seven hou
Also i want the date column date to change each day. Currently it work
for one day but then the next day it changes all the above cells to th
I have attached the file
Attachment filename: book2.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=56396
Message posted from http://www.ExcelForum.com
...Public Folder Auto-reply #2
Is there any way that I can enable an auto-reply for emails that are going
to a Public Folder that is mail enabled. The emails will not only becoming
from inside th company but externally as well.
Thanx for the help
yes, you can...on the Administration tab, click Folder Assistant...but be
very cautious with this...it's very easy to get into a "mail loop" condition
that could conceivably crash the store...
Susan Conkey [MVP]
"Sulaiman" <Sulaiman@discussions.microsoft.com> wrote in message
For some odd reason thins morning when I start Windows Mail it claims
are 'No new Messages.WM is set to 'Send and Recieve at Startup.' Also the
Send/Recieve button is disabled.
When I go online and access my email account with my it shows several emails
I was using Windows Live Mail and had problems uninstalling it and
went and deleted the folder for Windows Live 'casue I don't use any of the
Somehow the account got removed.
I recreated it and it's ok now.
Jame...Can Excel generate a 3-D scatter plot?
I want to generate surface plots of the form (x,y,f(x,y)). Should I just go
buy MathCAD, or can Excel manage this?
Andy Pope has 'tricked' one:
But you probably go for MathCad :-)
"zzzfizz" <firstname.lastname@example.org> schrieb im Newsbeitrag
> I want to generate surface plots of the form (x,y,f(x,y)). Should I
> buy MathCAD, or can Excel manage this?
...outlook mobile access broken #2
I noticed this morning that my OMA was give ASP application error
reports when a device tried to connect.
I put it down to changing the installed .net framework at the end of
last week - using the aspnet_regiis.exe command located in the C:
\WINDOWS\Microsoft.NET\Framework directory, I changed from v1.1.4322
So I reverted back to v1.1.4322 hoping it would resolve the issue, no
all I get is a 404 page not found - even though there are files there
- now I'm a bit stumped.
What is going to be the easiest way to fix/repair/recreate this
Any pointers would ...Can not reset admin password under safe mode due to password policy?
I'll have to log into the default administrator account, because I can not
do anything under the current standard user account status. I went to the
safe mode, and tried to log into the admin account, but the password is
forgotten. I built the reset password USB disk under the account before. Now
I follow the instructions for resetting the password. However, the window
popped up, and it said "ineffective password, the password length is too
short, or ca not conform to the password policy. I've tried passwords of
different lengths, such as 3,6,8,16, 20. All tempt...Database Files Directory
I have created a database and everything is working fine. I just would like
to access directory contents and displayed then in a form. For example I
have records that I have saved/scan to a particular directory now I would
like to see then on the bottom of the form. Can someone help me with this.
Thanks in advance,
List files recursively - List files in a folder and subfolders
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than...Creating New Mailboxes #2
ANYONE KNOW WHY AFTER CLICKING CREATE MAILBOX FROM THE EXCHANGE TASKS ON A
USER IT TAKES UPWARDS OF 1-2 HOURS BEFORE THE MAILBOX APPEARS?
ADVICE/INFO GREATLY APPRECIATED.
Before the mailbox appears where, exactly? In the GAL? In ESM?
For Exchange news, links, and tips, check:
"PHIL MATHER" <PHIL MATHER@discussions.microsoft.com> wrote in message
> ANYONE KNOW WHY AFTER CLICKING CREATE MAILBOX FRO...Macro for checkbox (2) #2
Still does not work new message is Sub or function not
defined. I normaly just record macros so this is a bid
more of a chalange
If CheckBoxes(46).Value = True Then
Range("O54").FormulaR1C1 = "50000"
Range("T54").FormulaR1C1 = "4000"
Range("Y54").FormulaR1C1 = "4000"
Range("AD54").FormulaR1C1 = "4000"
Range("AI54").FormulaR1C1 = "4000"
Range("AN54").FormulaR1C1 = "4000"
Range("AS54").FormulaR1C1 = "...Outlook
We are on Exchange 2007, Outlook 2007 and Excel 2007. A users sends a
specific spreadsheet to multiple users 2-3 times a week. About once a week,
one of the users tries to open the file and it is corrupted. The original
file is 18K but after he attempts to open it, it reduces to 4K. If he tries
to forward the message, it goes out corrupted. If he saves the file first, it
is fine. But it still becomes corrupted if he tries to open from the
We all use the same anti-virus and this is the only Excel document he has
the problem with. He receives many from various source...PatchFactory 2.0 Released. Professional and easy-to-use patch building tool for Win9x/Me/NT/2000/XP.
Professional and easy-to-use patch building environment that can help
you to create instant patch packages for software and file updating.
Generated patch packages are small size self-extracting executable
update programs in a famous installer style with adjustable
user-friendly interface and multilingual support.
Enhanced with features like easy-to-use interface including a Wizard
mode, powerful patch engine, integrated compression technology,
adjustable multilingual user-friendly interface of the update program,
this program will most definitely become a valuable asset for softw...OWA reply shows broken link in the form area
This is a multi-part message in MIME format.
When I reply to a message from within OWA, I get a broken link in the =
areas where I would type. It's as if it can't find the form or =
something. It's not a signature file problem from what I can tell.
<!DOCTYPE HTML PUBLIC &q...merging pictures into a document template
I need help inserting a code on the data source for a merge that involves
photographs. The mini-project is to take data and picture unique to each
document. I did some instructions but I guess I"m such a newbie that I can't
figure out where to start in this process. I'll paste the instructions below
so somebody can tell me exactly, from the first step and every step til the
end, how to do this. For me, there isn't enough info for me to follow the
directions. I get stuck at #3. Specifically, "by nesting the merge field in
an IncludePicture field." Where ...Mail Merge Excel Data with Publisher for 4 up postcards
I have been browsing and searching for help on this issue to no avail.
What I am trying to do is mail merge a 2 sided 4 up postcard with my
Excel 2003 data. On the front of Publisher 2003I have the Address Block
which is no problem, however when I try to import the matching customer
data to the back of
the postcard it does not match up at all with the front. I have also 2
publisher files setup, 1 for the front of the postcard and 1 for the
I know the Excel data has to be in this format for the mail merge to
work correctly using this formula posted by Doug Robbins:
I have imported data into Excel. The left-hand column has merged cells
containing a reference number. The remaining columns contain varying records
associated with the reference number, a one to many ratio. I need to display
the worksheet so that the appropriate reference number is displayed in the
left-hand column for each of the records in the worksheet. There are hundreds
of reference numbers. Is there an automated way to do this besides unmerging
each section and copying the reference number into the now unmerged cells?
...beginning balances #2
This is a new client who is entering invoices and data as of 2006. There
are two open fiscal years--2005 and 2006.
We created 2005, as the client will need to enter beginning balances for 2006.
I just want to make sure that I have the correct steps down. In order to
enter beginning balances for 2006, they need to:
(1) In GL Transaction Entry, enter a debit or credit to the balance sheet
account and a debit or credit to Retained Earnings (or a suspense account) as
of 12/31/2005 and
(2) They need to close 2005 in the GL, so those beginning balances (BBFs)
will roll forward to...Variant #2
I have a VB6 Com object that I am attempting to use in VC++. One of the
methods returns a VB6 Variant datatype. When I look at the IDL for the object
that value is also defined as a VARIANT*.
The problem I have is I am not sure how to deal with this value on the C++
side. What datatype do I use to store this value. Unfortunately, I can really
be almost anything. Do I need to store it as a byte array?
Any help would be appreciated. Thanks!
>I have a VB6 Com object that I am attempting to use in VC++. One of the
>methods returns a VB6 Variant datatype. When I look at the...