Is is possible to find the ASCII characters in excel for a perticular
I mean to say that, I need to insert a smiley in excel. I need this :)
and :( in excel. If I need a happy smiley, I can as well use ALT+1. But
if I need a sad one, I am not able to find it. Is there any combination
of characters which can give me that.
Thanks in advance,
praveen_khm's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30364
View this thread: http://www.excelfo...spelling #2
the spelling tab is missing on my outlook 6.0!
...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 ...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...System Mailbox #2
My companies Exchange 2003 server has a System Mailbox
that has 300+ messgaes in it. How do you read these
On Mon, 28 Jun 2004 08:44:51 -0700, Dave wrote:
> My companies Exchange 2003 server has a System Mailbox
> that has 300+ messgaes in it. How do you read these
Normally you shouldn't worry about the content in the System Mailbox,
unless PSS told you to.
But below MS KB provides the information:
253784 - XADM: How to Log On to the System Mailbox on Exchange 2000 Server:
Henrik Wa...RPC over HTTP problem #2
I have configured an Outlook 2003 client to use RPC over HTTP over the
internet (DSL) with an Exchange mailbox that is over 15 GB in size. When I
tested out the connection with a much smaller test mailbox, Outlook launched
fine. When I tried to open the very large mailbox, the Outlook client tried
several times to connect, but failed. When I then tried to reconnect to my
smaller test mailbox, that failed as well. Thinking that something had
happened at the server, I went to another machine, I was able to
successfully connect the smaller test mailbox.
Does anyone know what is happening?...After Update = EmployeeID.column(2)
I have one field called EmployeeID and I show three columns, (EmployeeID,
Last_Name, and First_Name) from a linked table.
I would like to auto fill the Employee_last_name in my Employee_Last_Name
field when the EmployeeID is selected.
How is the employee id selected?
Dave Hargis, Microsoft Access MVP
> I have one field called EmployeeID and I show three columns, (EmployeeID,
> Last_Name, and First_Name) from a linked table.
> I would like to auto fill the Employee_last_name in my Employee_Last_Name
> field when the EmployeeID i...Message Queues #2
I want to implement some sort of message queue.
I have a client application and a server application. The
server communicates with radio modems and can only
communicate through a serial link. The client application
has to be able to send commands to the server and the
server must then send these commands down the serial link.
The server must be able to queue up the messages and then
send each one down one at a time.
Is there any tutorials, examples or help that anyone can
Thanks in advance !!!
Lots of mechanisms exist. Part of it depends on the degree of traffic.
The most ...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
> ...socket #2
I've made a class CMYSocket that derives from CAsyncSocket.
Does it matter when I call CAsyncSocket(nErrorCode) ? Before or after
calling receive(...) ?
Do I need to add my own check of the nErrorCode variable and stop the object
if there the variable is not equal zero ?
On a few occasions my OnReceive method has been triggered when no data has
acctually been sent. The GetLastError() method returned error code 10054
Connection reset by peer.
An existing connection was forcib...print to file #2
I'm all of a sudden getting a "Print to File" popup when I try to send a
print area to my printer. The print preview is fine and I can't figure how
to send it to the printer. I must have changed something.
Use menu commands File|Print
Look on right side of dialog box about halfway down side.
Uncheck Print to File box
Bernard V Liengme
remove caps from email
"Bob V" <Bob V@discussions.microsoft.com> wrote in message
> I'm all of a sudden getting ...Taking one value sheet 1 and apply to sheet 2
I have a workbook with 5 sheets. I do not know how to take the valu
from sheet 5 cell b26 and use that value to a formula to sheet 1 cel
Can someone help me out?
join_the_band's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3521
View this thread: http://www.excelforum.com/showthread.php?threadid=54975
Try a formula like
wrote in message
news:joi...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...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...how 2 make one cell change title when either of 2 other are > 1
i want to make a cell [heading 1] (that is a list of two headings) change to
[heading 2] if either one of two other cells are greater than 0 but revert
back to [heading 1] if not.
In the Heading cell:
> i want to make a cell [heading 1] (that is a list of two headings) change to
> [heading 2] if either one of two other cells are greater than 0 but revert
> back to [heading 1] if not.
If I understood your question correctly thy this:
in cell A1 copy and paste this...adding a watermark #2
is it possible to add a watermark to an excel page? if so how? i a
using excel 2002 on windows XP professional version 2002 service pack
mhillis's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=464
View this thread: http://www.excelforum.com/showthread.php?threadid=26196
check this link:
And see this sites also
Aaron Blood's website at
An alternative, if you're using Excel 2002, l...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...Same code 2 results
I use this code in 2 applications and the results are different:
bi.hwndOwner = NULL;
bi.pidlRoot = NULL;
bi.pszDisplayName = sRep;
bi.lpszTitle = NULL;
bi.ulFlags = BIF_STATUSTEXT;
bi.lpfn = BrowseCallbackProc;
bi.lParam = (LPARAM) (LPCTSTR) cs;
bi.iImage = 0;
pidl = SHBrowseForFolder(&bi);
csRep = szDir;
In one app, csRep =
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.
...Public folder #2
I have a public folder for advertisements and i want to limit the size of an email send to this folder. Is this possible???
We are running Exchange 2000 and outlook XP.
I'm in Mixed Mode (Exchange) and the Delivery Restrictions on Public Folders
is greyed out.
Hope that helps,
This posting is provided "AS IS" with no warranties, and confers no rights.
Please do not send email to this address, post a reply to this newsgroup.
Use of included script samples are subject to the terms specified at
"johnE" <a...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" <firstname.lastname@example.org> wrote in message
news:kateweb.1fictb@excelfor...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
...Reports Error CRM 1.2
i am facing a problem with how the reports on MS CRM 1.2... the issue is
that half the chart is displayed (it is not resizing to match the full
Thanks in advance
Is this a custom report or a canned one? Are you having this problem when
viewing the report online, or when printing the report?
"Emile Seferian" wrote:
> i am facing a problem with how the reports on MS CRM 1.2... the issue is
> that half the chart is displayed (it is not resizing to match the full
> screen display)
...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" <email@example.com> 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...2.0 Installation problems
Ok, here goes..
MSDE 2000 - fully updated
XPSP2 - fully updated
..NET 1.1 - fully updated
..NET 2.0 - fully updated
PERMISSION ERROR ON MACHINE 1
1-Installed RMS 2.0 under administrator and re-booted
2-Logged on as Administrator, launched POS and entered product key (like I
always do with MS products)
3-Logged off Administrator and logged on under the user account I normally
run RMS under.
4-Launched POS and got a run-time error 70, writing to the registry error, a
license violation error AND IE 7.0 has permission errors and would not
I know run-time 70 errors are permission rela...