How do you enter Unicode characters that don't have a Alt-nnnn shortcut?
I have a need to enter a range of non-English names into a combo box on a
form in an Access 2003 application. Sometimes this requires the use of
accented characters that do not appear on a UK keyboard. If I refer to the
Windows XP Character Map facility (charmap,.exe) then I can see that many
such foreign characters have been allocated an Alt-nnnn code that is
displayed at the bottom right of the Character Map acreen. This makes it
easy to enter these characters.
However, many other characters have not been given an Alt-nnnn keyboard
shortcut. They only have a U-FFFF code, displayed at...how to create a tournament bracket in excel
I want to create a tournament stlye bracket (like the NCAA tournament) for a
pool that I'm running. I am using excel 2003. Any help will be appreciated .
Here's 2 links to try out:
Downloads: Tournament brackets2.xls
(A template file for you to fill-in)
Downloads: NCAA men's bracket 20042.xls
(A completed file ..)
The above 2 links / files was sourced
via a simple web-search wh...Excel VBA Wookbook Routines
Does anybody have the order of running event processes when an Excel
I have a data collecttion running when the workbook opens and I want to
review status of an database refresh after a WorkBook opens and gets the
latest data on open. What event process do I use to review data after the
woobbook refresh data from the database? I see events under Woobbook like
Open, Activate, Sheet Activate, Sync, etc... What is the order of these
events in which they activate when you open a sheet?
Thank you in advance fro your help!!!!
Take a look here:
http://ww...Exchange 2000's reliance on fsmo DC
I'm trying to figure out why every time my dc that runs all 5 of the fsmo
roles gets rebooted, my Outlook clients loose the ability to connect to
exchange. I have a second dc that is a GC. Can anyone shed some light on
this for me?
Windows 2000 native mode, Exchange 2000, Outlook 2003 clients.
is the second dc listed in exchange as a directory server?
and why have all 5 fsmo roles on 1 dc anyway?
"Chris" <Chris@discussions.microsoft.com> wrote in message
> I'm trying to figure out w...The Notes tab does doesn't "proforma" when you convert lead to cli
Why is this? I consider the notes and files attached to the notes essential
data that would be required for quick viewing. To have to click back to the
"Originating Lead" is a pain and the whole purpose of CRM is to make tracking
customer data easier.
Microsoft Small Business Specialist
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in...Accelerator key not working
Using Visual Studio 2005 + Codejock Toolkit Pro.
There are all the usual keys already defined in my accelerator table - Shift
+ VK_DELETE for example does ID_EDIT_CUT. I want VK_DELETE (with no
modifier - shift, ctrl etc) to map to ID_EDIT_DELETE - an option I have on
my Edit menu and also on a toolbar. I have added the accelerator key to the
list and it looks very similar to the ID_EDIT_CUT line with the Modifier set
to None instead of Shift, but nothing happens when I press Delete. The menu
option is enabled and works when selected from the menu or toolbar button,
so what else do I n...How can I recover a deleted Excel workbook?
I've spent a long time making a new spread sheet in a new workbook and just
deleated it. Is ther any way to recover my work or must I start over?
Check your Recycle Bin.........select the file and do a Right-click >
Vaya con Dios,
"John W M 3" <John W M email@example.com> wrote in message
> I've spent a long time making a new spread sheet in a new workbook and
> deleated it. Is ther any way to recover my work or must I start over?
When you say you...Does anyone have a dashboard gauge (speedometer style) for Excel?
I am trying to create dashboard charts from Excel data and would love other
templates not available in Excel today - speedometer charts, multi-dimension
comparitive charts, charts that build information overlays.
I regularly create these in a manual way for executive and customer
summaries but would appreciate the ability to automatically generate these
types of charts allowing for real time viewing of "what if" scenarios.
Steve, there are tons of these things out there to review, few better than
Andy Pope has put together...Excel #27
i am doing a worksheet and need to know what a page in a spreadsheet is called. it begins with W. x
EggHeadCafe - Software Developer Portal of Choice
Self-Updating Service Command Pattern MSMQ Invoker
I'm fairly certain that it was explained on the first page of your
> i am doing a worksheet and need to know what a page in a spreadsheet is called. it begins with W. x
> EggHeadCafe - Software Developer Portal of Choice
> Self...How do I change the Header area's width in Excel?
I want to insert a picture as a header, but it is wider than the Header's
defult size. I tried to change the mergins of the page, but it does not
affect the Header and Footer areas.
You're right -- you can't change the margins of the header. You can scale
the picture down. In the header, put the cursor in the &Picture code, and
click the format (last) button.
"Lisa" <Lisa@discussions.microsoft.com> wrote in message
>I want to insert a pi...Character code for ALT-ENTER
I am extracting data from excel and I need to know if the data has been
wrapped by setting the cell properties.
I have been told that excel uses ALT-ENTER to put a soft break in a line.
Can anyone tell me what character code this will equate to?
Peter Longstaff wrote:
> I have been told that excel uses ALT-ENTER to put a soft break in a line.
> Can anyone tell me what character code this will equate to?
The character is still the Enter key, but it's sent to the application
via WM_SYSKEYDOWN and WM_SYSCHAR messages.
Tobias G�ntne...service reference not working
I've a web site that contains a remote service reference (binded to a tcp://
I can add the reference, I can see endpoints and interface and select them,
and VS creates the service referce. No error.
Bun no object proxy is available on my namespace! I cannot refer to the
remote service in any way... :(
I've create a blank new project and added a reference to the same service,
and all is ok :(
> I've a web site that contains a remote service reference (binded to a
> tcp:// WCF service).
That can only happen on...Linking Custom Tabs to Pick List/Pull Down Menu
1) I have made a custom Tab called 'End User' on my
2) In the General Tab the 'relationship type' field is a
Pick List/Pull Down Menu.
I would like my custom tab 'End User' to only be visible
when a specific selection from the 'relationship type'
field is made.
So, when some one makes the relationship type in the
general tab of an account equal to value 'x' (in this case
the value is called 'end user')... only then do I want
this custom tab to be visible.
Is this kind of link possible?
...Date sorting not working?
I am working with a 5 column/35 line spreadsheet and need to sort th
contents by date (column E). I have made sure that the column i
formatted for date (ex format>cells>DATE>03/01/05). When I select th
columns go to DATA > SORT > Column e ascending it sorts up until lin
30 or so then it just does the willy nilly thing. I cannot figure ou
why this simple function is giving me more greys. Any ideas?
sarjak's Profile: http://www.excelforum.com/member.php?ac...excel not open in my computer.
I try to copy a excel file to a floppy, but the file not
copied into floppy. But on that minute the excel not
functioning. Whenever I try to open Excel shows the
following error messeages.
1.THE SYSTEM IS DANGEROUSLY LOW IN RESOURCES. WOULD YOU
LIKE TO TERMINATE THE APPLICATION?
2.EXPLORER CAUSED A GENERAL PROTECTION FAULT IN MODULE
USER.EXE AT 0003:00009042
3.EXCEL CAUSED AN INVALID PAGE FAULT IN MODULE KRNL386.EXE
4.A FATAL EXCEPTION OE HAS OCCURED AT 0167:BFF9DFFF. THE
CURRENT APPLICATION WILL BE TERMINATED.
I reinstall win.98 SE, reinstall Office 2000, rep...Hows do I get rhe recently usef file indicator in options to work
I cannot get the gray area in general options to highlite. I would like to
have all of my recently used file to come up.
Have you installed tweakui in windows, if you have turned off document list
there is no file list in excel either
(No private emails please)
"bubblehead" <firstname.lastname@example.org> wrote in message
>I cannot get the gray area in general options to highlite. I would like t...Autocomplete not working
Although Autocomplete is checked in Excel "Options", it is not working.
If I have written 'abcxyz' in a column, and I write the letters 'ab' or even
'abc', in the same column, Excel doesn't suggest the word 'abcxyz'.
I'm using Excel 2003 SP2.
Have you run through the suggestions in Help ("Microsoft Excel doesn't
always display the AutoComplete list" topic).
From what you posted, I'd guess that you're trying to autocomplete
outside the current data region.
In article <e57uAzTEGHA.3064@TK2MSFTNGP...EXCEL #20
Can anyone tell me how to change the color of the active
cell in a workbook?
I'm Not quite sure what you are asking. Do you want the color of a cell
to change automatically depending on whether or not a certain condition
is met (conditional format) or do you just simple want to select a cell
and change the background color to something other than white?
Look at the buttons across the top of the Excel Window on the toolbar.
There should be a button that has a small paint can icon on it with a
yellow stripe underneath it. Click there and choose the color you want
to change to. The but...CPropertySheet and hiding some tabs
I am using CPropertySheet and CTabCtrl to make an application
I have some property pages and I want to hide or show tabs during run
I tried keeping the pointers to the property pages to a list and
remove all and add all property pages that are marked as visible
But the property page is destroyed when it is removed and this causes
Is it possible to achieve this using TCITEM attributes or something
...Search Using Address Bar Does Not Work
I'm using IE8 and running Windows XP, SP3. I used to be able to type a word
or phrase into the address bar and it would go to a google search and give
suggestions. Now when I type something in it just says, "Internet Explorer
cannot display page." Any ideas on what's wrong and how to fix?
Why would you search from the Address Bar instead of from the Search Box?
"Angel Fire" <AngelFire@discussions.microsoft.com> wrote in message
> I'm using I...ALT+... and CTR+ALT+DEL
I know this question has been asked many times, sorry for asking again.
How can I block CTRL+ALT+DEL, ALT+F4, ALT+SPACE, CTRL+SPACE and virtually
all combinations that could, for instance, call some of Windows UI features,
like CTR+ESC? I would like to do it "legally", i.e. without using
undocumented methods - application should work fine on Win XP, Win 2K and
Win 98 machines as well. First of all, is it possible without using
DirectInput from DirectX libs? I'm working on MFC application that should be
strong enough to block students (this is a kind of testing/teach...Send To in Excel
Since upgrading to Windows and Office 2000 - when select
Send To from Excel and Word, our Global Address list is
not displayed. Asks to select Recipiants from Main
Contacts or Shared Contacts only. This previously worked
with NT and Office 97.
In Outlook 2000 what order are your Outlook Address Books set to appear, ie
is the GAL even listed and if so can you move it to first and then give it a
<email@example.com> wrote in message
> Since upgrading to Windows and Office 2000 - when select...How to Tell a tab control which tab to have open from the ON_Load
Hi, I have a form with a tab control with lots of tabs. In the on_load of
the form, based on where the user came from, I want to be able to tell which
tab is "open" when the form is drawn.
Examine the Value of the tab control.
It is equal to the PageIndex of the chosen page.
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"SteveInBeloit" <SteveInBeloit@discussions.microsoft.com> wrote in message
news:DBF790EE-DE33-...2 variables in 2 quadratic equations in excel
Dear ms excel user/programmers:
I hope this question is not repeated before. But anyway
highly appreciate anyone can tell me how (or hint) to use ms excell
and/or visual c/c++, basic, or octave(emulate matlab) to solve:
(12-x)^2 + y^2 =15^2,
(by programming or using its built in function)?
that ^2 mean square.
looking to any excel user, mathmatician, and/or programmer's help,
The brute force way (requiring the least mathematical analysis) is to
calculate the left hand side as functions of two reasonable first guess x
and y inputs...SP2 & OWA only IIS direct login works
I installed SP2 over the weekend and the only way to log into OWA is to go
into IIS and select the Exchange folders and say browse. This will browse
the Administrator account just fine, but if you try to log in as any other
user it starts to load OWA but it does not look right the Fonts are wrong as
well as button placement then it gets stuck saying loading and says there
are errors in the page.
Any ideas would be great
On Tue, 27 Dec 2005 12:39:09 -0800, "Heith" <firstname.lastname@example.org>
>I installed SP2 over the weekend and the only way to lo...