How do I get excel to accept (c) as text and not change to copyri.
How do I enter the text (c) in Excel without having it changed into the
Tools | Autocorrect | Select (c) | Delete | OK
"daffyd" <email@example.com> wrote in message
> How do I enter the text (c) in Excel without having it changed into the
> copyright symbol?
Go into the Tools Menu. Look for AutoCorrect. In the bottom half of the
AutoCorrect Tab, look at the list for Replace text as you type. Delete the
entry for (c).
"da...ANN: C# Online.NET Spanish Project
FOR IMMEDIATE RELEASE
First Spanish-Language, Wiki-based, Online C# and .NET Reference at C#
Dallas, TX � A new concept in online references for Microsoft .NET
programming languages is being pioneered by C# Online.NET�a new
wiki-based, online C# and .NET reference. C# Online.NET offers
documentation, tutorials, and C# source code examples for .NET
languages beginning with the C# language. "Compared to Java," says
Will Wagers, founder of C# Online.NET, "there is a dearth of online C#
C# Online.NET is enlisting the aid of volunteer contributors to write
...Cannot log in using WindowsID (was able to before)
I just bought MS Money 2007 Deluxe yesterday. The install went smooth,
without any issues. I registered a new WindowsID and was able to successfully
log into MS Money.
However, today when I tried to log into MS Money, the messge apeared that
the "Money was not able to recognize your WindowsID" or something like it and
that "You will still have access to some functions but will not be able to
make online updates".
Now I'm not able to make updates. Any idea what this could be? Is the
authentication server for WindowsID down or something?
See the post under Mon...Can't use Merge feature
If I have a postcard file I've already made on the
screen, when I try to pull up the "Merge" feature under
Tools, it is shaded grey and I can't open it. It insists
that I either form a new database list of addresses or
edit the one that I want to merge. I don't want to edit
the one I want to merge. I just want to MERGE it.
If, however, I have just a postcard template on the
screen (without it having been made into anything), I CAN
pull up the "merge" feature under Tools. It is not
How do I un-shade the "merge" feature?
To merg...Saving User Settings in Outlook...
Does anyone know how to save the user settings for MS outlook 2003?
Thanks to all who reply,
The reason I would like to be able to save the user settings is so I'll be
able to restore these settings should I need to in case I had to do a clean
install of WinXP and office 2003 either on the same computer of on another
newly bought computer.
Thanks to all who reply,
"Ismael" <I_Tena@hotmail.com> wrote in message
> Hello everyone,
> Does anyone know how to save the user setting...the user authentication passed to the platform is not valid 09-20-06
Anyone receive this error message in the CRM Outlook Client?
"The user authentication passed to the platform is not valid."
...Restore Exchange 5.5 on 2000 using ArcServe
- Windows NT 4 Server SP6
- Exchange 5.5 SP3
- ArcServeIT 6.61 with Exchange Agent
I'm trying to restore the Exchange information (database, mailbox...
everything) on another computer.
That computer has
- Windows 2000 Server SP4
- Exchange 2000
- Brighstore ArcServe 9 (build 2020) with Exchange Agent
Now the situation: I need to verify that the backup was made correctly
(entirely) in order to confirm the total validity of the backup (to validate
my disaster recovery plan) and to update to SP4.
I tried to find documentation with both Microsoft (for Ex...How to use structured reference (ListColumns) in VBA
I want to do something simple...loop through a range retrieving values one at
time and taking action on that value. This range is an Excel 2007 table
column. Easy enough...BUT I want to use structured references to a table
column by NAME, not numbers. I don't want to define new names, just use the
table column headings. I've found ways of doing it with quotes, but that's
not structured....the names in quotes do not change if the table heading is
changed by the user.
The formulas change if the table column heading is changed, but I want it to
change in VBA to...Error- Project is used by another user -Please select another proj
Please see the subject line, when im trying to open a particular project.
it gives me following error.
I checked the current users, there are no users. Apart from me.
There are some non PA users,i tried to remove them from activity.
inspite of me removing them from activity, im geting the same error.
There is a stranded user in PA000001 table. You need to clear this
> Please see the subject line, when im trying to open a particular project.
> it gives me following error.
> I che...Save As using contents of Cell in Name
Can someone help with code that changes the "save As" file name to
combination of the original File Name + the contents of a cell, an
saves file in same folder as the original.
E.G. Original File Name= Timesheet
Cells B1= Location
Cell C1 = Date in format 3-5-2004
Cell A1 = concatenate(B1,C1)
Fle Name will therefore be "Timesheet Location 3-5-2004"
The other problem is with the date. When concatenating, how do I forma
the date to avoid it looking like "Location 38051"
Any help much appreciated
Message posted from http://www.ExcelForum.com
for c...User Defined Required Fields
I have set several field on sub window Sales User-Defined Fields Entry of
Sales Transaction Entry as "Required". If the user remembers to click
User-Defined, then they become required. But if the user never clicks on
User-Defined from Sales Transaction Entry, then they can still save the new
document without the required fields entered. Does anyone know what I can do
to fix this asside from continual user training?
Your answer is VBA.
You own Modifer, so you also have VBA enabled. You'll need to write VBA
code to open the window (literally, push the button) then set th...User Authentication Error
I am running CRM 3.0. I have the system administrator role. When attempting
to merge 2 account records I receive an error that states,
"The user authentication passed to the platform is not valid."
I cannot merge the records. If anyone can, please advise. thanks.
...Using Excel in Mac office 2004 with Microsoft/Mac 2008:Analysis toolpack
Although I am disappointed with Office 2008 for Mac because of the
Analysis toolpack, I figured things out quite recently that I can
install my Mac office 2004 and use the excel package that contains the
Analysis tool pack. How? ...... let me show you:
1. Insert your CD for Mac office 2004
2. When it open on your desk top, two options will be given to you to
download the software
(a) Office set-up assistant, and (b) Microsoft office 2004.
3. CHOOSE MICROSOFT OFFICE 2004 (Drag the icon onto your desk top) and
will start to run/download.
4. When done, this will appear as ...How to obtain enumerated attribute declarations from a DTD using MSXML & VB?
I have a VB (VB6, not .NET) application that reads an XML file (using MSXML
v3.2 parser); the XML file contains a reference to an external DTD.
The DTD has numerous enumerated attribute declarations like so:
MyAttribute (One | Two | Three) "One"
The VB code needs to generate dynamic pick-list for all the attributes that
appear in the DTD as part of a data-entry application; each dynamically
created pick list should contain all the allowable values for the attribute
as defined by the DTD (and presented in some kind of multiple choice control
like a comb...Using Excel spreadsheet as input to Access
I posted this in the New Users forum but only got one answer, so
thought I'd try here as well.
Like so many others, I am an Excel newbie. I was a mainframe COBO
programmer in another life, but that was a few years back
My manager would like me to write an app that will take tracking dat
from an existing Excel spreadsheet (generated by our system) but onl
use a select handful of columns as input to a new Access database tha
I will create.
I'm guessing that I can either a) create a new edited spreadsheet to b
used as input to the Access database or b) use the Import wiza...Using subtotals as single data entries
Sorry about the subject--I couldn't figure out how to describe it
I have a large file (16,000 records) of amounts billed by roughly
10,000 service providers. A number of these providers have multiple
office locations, so each record is unique to a specific office
location. In other words, a provider who billed from 3 different
office locations will have 3 entries. Each provider has a unique
provider ID number, which stays the same regardless of which office
location he is billing from.
I want to be able to subtotal the amount billed by each provider for
all their office locations...Using Risk+ with MSP 2007
We use Risk+ as a risk simulation tool. We have discovered that it works
approximately 20 times SLOWER in MSP 2007 than MSP 2003. Has anyone else run
into this problem. If so, is there a remedy?
My hunch this not a generic issue, but surely best that you consult with
the Risk+ people on this.
On 02/03/10 18:08, Tom Mc wrote:
> We use Risk+ as a risk simulation tool. We have discovered that it works
> approximately 20 times SLOWER in MSP 2007 than MSP 2003. Has anyone else run
> into this problem. If so, is there a remedy?
W...how to use roundup
how to roundup the number to hundreds example 1250101 to 1250200 , 1250901 to
1251000 , 1250750 to 1250800
"r4319hb" <firstname.lastname@example.org> wrote in message
> how to roundup the number to hundreds example 1250101 to 1250200 , 1250901
> 1251000 , 1250750 to 1250800
> thank alot
(remove nothere from email address if mailing direct)
"r4319hb" <email@example.com...Lock Out Users for Maintenance
Is there a way to temporarily lock out all but the "sa" user? This would be
very helpful when tasks such as Check Links is running.
I guess the easiest way is to revoke users access to the company.
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Mob: +962 - 79 -999 65 85
Great Package For Business Solutions
> Is there a way to temporarily lock out all but the "sa" user? This would be
> very helpful when tasks such as Check Links is runni...Using 'like' on a user prompt
I want to prompt the user for a value to use to filter a form. Here is my
command with the WhereCondition:
docmd.OpenForm "test", acNormal, , "LastName=[Enter a Last Name]"
I want to use the WhereCondition as a "LIKE" criteria. Variations on the
WhereCondition itself that I've tried include various combinations of
LastName LIKE %...%
LastName LIKE *...*
LastName LIKE [%...%]
LastName LIKE [*...*]
You get the idea...
No luck so far. Any thoughts?
On Thu, 27 May 2010 21:52:50 GMT, "RicDon" <u60397@uwe> wrote:
>I wan...SQL-Dynamics V10 Users
I have some messy stuff going on with Dynamics and SQL users. I have users
that are users in the databases, but not in Dynamics, and users in Dynamics
that are not in SQL.
Is there a script or anything to run to straighten this out?
Right now it is manual process where I have to go user by user, check in
dynamics and which companies they use, then go to SQL and check each
Why can't you do this through the user interface? Did you resore a backup of
Dynamics of something? As far as I know, the only way to create a GP login
is to do it throu...Using online services from Europe
I'm going to be temporarily stationed in Europe for a couple of months.
Are there any problems with my using M2002 to access my accounts, pay
bills, etc, from there just as I do from the US?
You should be fine, so long as you have a 128 bit encryption version of IE.
If you do have problems, please feel free to post here :-)
Glyn Simpson, Microsoft MVP - Money
for UK tips and fixes for MS Money. To send Microsoft your wishes or
suggestions, use http://register.microsoft.com/mswish/suggestion.asp
or email mnyukwsh...Can I use the same driver in all versions of Access or Sqlserver
Hello,I have got a question,I wonder if i can use the same driver as Access2000 to get the data from all versions of Access database,my code connected to Access2000 is as follows:
Is this code available for other versions of Access? If not,can anyone tell me the correct code for Access2002.Access2003,Access97?
my code connected to Sqlserver2000 is as follow:
m_pConnection->Open(Provider=SQLOLEDB.1;Persist Security Info=True;Password="+s.m_pass...Importing Excel named ranges using MS Query
I want to use multiple ranges (named) as the data source for a pivot table
using MS Query. When I import the workbook my options are only to select the
"tables" (which are my sheets referenced as sheetname$). I don't want to use
the entire sheet, just my named ranges in multiple sheets.
Names ranges should appear in the list of tables, unless they're dynamic
ranges. But if there's nothing else on the sheet, you can use the
> I want to use multiple ranges (named) as the data source for a pivot table
> usi...User defined fields #2
Entered user defined fields the way I wanted, however, the software has now
put it all in ascending order and there are no sort options available. Any
way to correct without having to do it all over?
Put in ascending order where?=20
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
and Microsoft Outlook Programming - Jumpstart for=20
Administrators, Power Users, and Developers
"Darcy W." <Darcy W.@discussions.microsoft.com> wrote in me...