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...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 ...spelling #2
the spelling tab is missing on my outlook 6.0!
...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...Copying Between Databases Without Linked Servers?
I have a SQL Server 2005 machine called "Dest" and a 2008 machine
called "Source" and a 2008 machine called "Console". Each has the same
SQL account with appropriate permissions and rights on all 3 to do
Without using a linked server, how can I sit at "Console" and execute
a "select into" fromthe "Source" database to the "Dest" database?
"SnapDive" <SnapDive@community.nospam> wrote in message
>I have a SQL Server 200...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 ...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...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...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...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 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...Printing multi copies
I want to print 2 pages per sheet of paper. I have selected Multiple pages
per sheet. I indicate that pages I want and preview if find for one copy.
If I then indicate that I want 10 copies of the Multiple Pages, then the
preview reverts to two pages of the same page. It just duplicates one page
twice and I lost the second (different) page I want.
This is a printer issue. I've tried to duplicate this, but I cannot with my
printer. Might try converting to PDF and then printing.
There are free converters around. www.primopdf.com is mentioned here often.
http://msau...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...Copy-Paste Value based on user defined range
I am trying to create an option such that, the user can input a default
value in one cell, enter a start year, and the number of years he wants
to assign this value for.
A B C
1 Value Start Year # of Years
2 500 2005 5
Apply 500 starting in 2005 for the next five years including 2005.
I am working in Excel2000. Thanks for your help
...solution for database larger than 2 G
I know that MS Access has size limitation for 2 G.
I would like to know are there any solution for size bigger than 2 G.
Split the database in 2?
Does it mean that i export the old data to a database and change the query
to union 2 tables from different database?
Change to SQL server?
Does SQL server have any limitation for the size?
Does it mean that I can have myDatabase2008, MyDatabase2007?
It will have issue that generate report for a date range between 2007 and
any other solutions or product to do this?
Your information is great appreciated,
SQL Serve...trouble copying and pasting
After working up a good workbook, with column sizes changed and margins
changed and page breaks changed, I tried to then copy and paste it into
sheet 2, however, all the formatting I changed, was changed back to the
default excel settings.
My question is how do I copy and paste so that all my formatting remains
Windows 98 se, excel 2000
In order to copy the column widths, you need to copy the entire column
before pasting. I don't think you can copy margins and page breaks. Can
you make a copy of the whole sheet, then paste the new data into the
- ...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