What does it mean if you see ####### in a cell
Column too narrow. Widen the column:
Double-click on the right hand column border in the column title bar or drag that border to the right
Microsoft MVP - Excel
"Summersway" <Summersway@discussions.microsoft.com> wrote in message news:0762CB39-EFA8-4B33-B7C9-8EAF88FB1643@microsoft.com...
| What does it mean if you see ####### in a cell
It could mean a few things.
1. The columnwidth is too narrow to show the number.
Widen the column or change the font size of that cell. Or change the
Can someone help me with the formula below. I can't figure out what I'm doing
IIf(IsError([Label43] / [Text91]),"-", IIf(([Label43] / [Text91]=0,"-",
[Label43] / [Text91]))
Label controls don't have values. They have captions.
If you are attempting to fix divide by 0 errors, the general syntax is:
=IIf([SomeValue] = 0 , Null, [OtherValue]/[SomeValue])
BTW: do yourself a favor and rename your controls to values that provide
Microsoft Access MVP
> Can someone help me with the ...Help Me
I have 4 store and I HQ based on Windows 2003 Server. Last week I updated
2003 Server. After that, RMS Not worked with store client. for example, I
approved style 206, 260, 307 but no RMS client server interact with RMS HQ
Please help me
...CHtmlView and OnChar
I created an SDI app with CHtmlView as my view class, but cannot recieve
WM_CHAR messages, or any keyboard or mouse messages for that matter. I tried
routing them thru both the View and Main Frame class but it still doesn't
work. Could someone please tell me if there is a way to use these messages
Thanks in advance.
Trap WM_CHAR in PreTranslate method.
This particuler ActiveX control that is hosted in CHTMLView does not work as
you expect with PreTranslateMessage or trapping WM_CHAR etc. There are
couple of ways to do this. One is to automate the control and li...DISTINCT ROW help needed
I have a code in the OnCurrent of a form that inserts the ID of the
company for that record into a table. The purpose of that table
(LastVisitedRecord) is a history of sorts. On that form, I have a
combo box that uses the following sql as row source -
SELECT DISTINCTROW ProspectTable.Company
FROM ProspectTable INNER JOIN LastVisitedRecord ON ProspectTable.ID =
ORDER BY LastVisitedRecord.lvID DESC;
The problem is, if i visit company Acme, Inc. a second time, it still
shows the first instance (at the bottom of the list) and I want it to
show the last instance as t...need advice on Edit control
I am using MFC application VC++.Net 2003,. I have a dialog based
application. I want to show some text to the user in my dialog control
like "ABCDEFGHIJKLMNOP". the user should be able to click on any of
these characters , and that clicked character has to be captured.
I am actually confused how should I do it if I use an Edit Control? or
Is there any other way I can do it.
By "captured" do you mean copied to the clipboard or just identified? If
you mean identified you may want to use something like radio buttons or a
drop dow...HELP!!! #3
First, I was unable to display my Outlook folder. I
couldn't go to Detect and Repair because I couldn't open
Outlook. I proceeded to scanpst.exe to repair the
problem. Now I've lost all my email messages. Did I lose
everything? How do I restore the messages? I checked the
box to save it in a file but where is that file? Please
help quickly. I run a small business out of my home and
need to find this info fast.
...Help with CMainFrame and Views
I need a bit of help. I am getting mad just trying to print something in the
I have a MDI aplication and I want to update the StatusBar with the mouse's
coordinates of any view. In the format: X:%d Y:%d.
The variables int m_x and int m_y are declared public on the MainFrm.h.
My only question is: When I try to get a pointer to the CMainFrame class
from any of the views my program get mad. I just want to update the values
of m_x and m_y. How can I do it? I have tried the following:
m_pWindowFather= (CMainFrame *)GetParentFrame(...MSScriptControl.ScriptControl help
Her is my powershell code:
$vbsCode = Get-Content "c:\scripts\CreateMailbox.vbs"
$vbs = New-Object -ComObject MSScriptControl.ScriptControl
$vbs.language = "VBScript"
#$vbs | Get-Member
Here is my vbscript code:
oExchsrv = Server
sDispName = User
Set oUser = GetObject ("LDAP://cn=" & sDispName & ",ou=New
WScript.Echo sSamAcct & " mailbox cr...Help?
This is pretty detailed, I hope you can follow my train of thought. Normally I would attempt to do this in Access, but since the participants in this project do not have the program or the ability, we will need to do it in Excel. I can't get my brain around where to begin or what tools to use on this one. I think I'm just overwhelmed. We have manually placed in formulas and such to get us through #2. I'm just not sure where to go from there that would be easy for me to get to work and for the end users who have limited skill working with Excel. Also, once this is programed to give ...Help With Macro Modification
I have this macro which will copy a group of non-contiguous cells to
another sheet. What I would like to know, is it possible to also make it
when it paste to new sheet, paste it as a "paste link". I need to be able to
change info on original sheet, but udate cells on other sheets as a paste
Dim SelAreas() As Range
Dim PasteRange As Range
Dim UpperLeft As Range
Dim NumAreas As Integer, i As Integer
Dim TopRow As Long, LeftCol As Integer
Dim RowOffset As Long, ColOffset As Integer
Dim NonEm...Need help using COM control
My projects are all VC++ 6.0, MFC. I have in the past imlemented
third-party ActiveX controls in various projects. I now need to interface
with another company's product. Their developer has given me a DLL he
developed with Visual Fox Pro. He's given me an Excel VBA example that
How do I make the DLL usable as a control in my MFC project?
Thank you for help.
Tom S. Lee wrote:
> My projects are all VC++ 6.0, MFC. I have in the past imlemented
> third-party ActiveX controls in various projects. I now need to interface
> with another company's p...HELP!!!! Can't figure problem out
hello... and thank you in advance to anyone that can assist me with my
I'm running Outlook 2000 on XP connecting to an internal Exchange 2000
server... When some of the workstations start up Outlook they get the
"Your Microsoft Exchange Server is unavaliable
You can retry connecting to the server using the network,
or work off-line and connect using dial-up networking.
The network did not respond in a timely fashion to
determine the existance of an Exchange Server, you
may retry and continue waiting for a responds or work off-line"
If you se...CHtmlView
We have a CHtmlView with two fames in a MFC application.
<frame name="menu" ...>
<frame name="detail" ...>
on the menu frame there are some links.
when you click the link, we use Navigate2() to request a .jsp page and put
it in the detail frame.
I know CHtmlView::GetReadyState()==READYSTATE_COMPLETE means the view is at
I want to know when the detail frame is ready. I tried GetReadyState().
It didn't work. It always return me READYSTATE_COMPLETE ...Dynamic Filtering...Need Help
Using Version Excel 2003
I have a report that retrieves different data based of data validation. In
each case there are rows that have no data and I want these hidden when the
user selects another data set based on their validation selection. To do
this I am using the auto filter function. The issue I am running into is
that each time a user selects a new report view they have to re-filter. Is
there a way, without using a macro, to have the filter re run based on the
users new selection withough having to re-filter?
I am a contract System admin for a company. They decided to fast track their
program and move their CRM server which we currently host inhouse to a
datacentre(hosted on VMware).
The person who does their IT work is on a vacation - and he told me that I
would need to do AD replication. But i dont understand WHY.
How i understand it is - i would need to replicate it IF the CRM server was
on a DIFFERENT domain, correct? and then I would need to replicate and sync
with that domains PDC?
Please help. Iv spent the last few weeks trying to find info on CRM and AD
replication but no...? Both Help Box AND Minimize Box in Title Bar of MFC Dialog App
I assume that this question has been asked before but since I can't find
How can you put both a question-mark context-sensitive help button AND a
Minimize/Maximize Box in the title bar of a Dialog mode MFC app?
I had an outlook pst file of about 1gig on my desktop and using a backup
program backed it up and then imported it into my laptop (for the first
time) which took over an hour. I cleaned up (deleted) some emails in my
inbox (from about 4,200 emails to 3,700) I then exported the file from my
laptop and then imported that file (still about 1 gig) back to my desktop.
The import did not reflect the email deletions I made on the laptop though
but the pst file size jumped from 1 gig to 1.8 gig. I don't see any
duplications in my emails or contacts. I'm using Outlook 2003. I would like
to get ...Help with batch production and Solver
Hi and a happy new year!
I still got problems with an production optimization. In the attached excel
file you will find demand data, maximum and minimum stocks, production
capacity and stocks for 13 months
I need to satisfy demand each month by the use of stocks, new production or
purchase. The use of stocks is the cheapest alternative and purchase the most
expensive alternative. The sum of provided quantities times costs should be
My problem is the following:
The production should happen in batches of at least 500 pieces (if capacity
is sufficient) or should be zer...scrolling
How do i scroll in two workbooks at the same time?
Sort of mirrored scrolling for two open spreadsheets... in Excel 2002?
...Read Reicept Help
I am getting this error, when trying to respond to an
email in outlook espress, when it requests a read reicept.
outlook unable to send reicept
Unable to send read reicept.
...Help! charts disappearing, new charts crashing powerpoint
When i open a presentation the charts vanish...i have restarted, they come
back. I try to edit a chart, and it crashes powerpoint after a few clicks.
What can I do...whole afternoon going crazy!
If you are using v 2007 there is a hotfix which is meant to cure some chart
john ATSIGN PPTAlchemy.co.uk
Free PPT Hints, Tips and Tutorials
> When i open a pres...Macro That doesn't work
I have a macro which converts urls in a column to the words "Tax Record" but
the macro will not work. When I run the Macro it prompts for Column and then
prompts for sheet name as expected. When valid inputis given to both
questions the Macro ends without error but does not convert the urls in the
column identified into the words "Tax Record"
I would appreicate any help I can get. The Marco is:
' chngelink Macro
' Keyboard Shortcut: Ctrl+z
Dim MyCol As String
Dim MySht As String
On Error Resume Next
MyCol = InputBo...I need a better way to stop an application.
My program needs a utility program to be running. So when my program starts,
it does a CreateProcess to start the utility program.
When my program terminates it does a ::FindWindow to get the utility
program's window. It uses the utility program's title bar text. It then does
a PostMessage of a registered message which the utility program then
Also when my program thinks the utility program has stopped working (for
whatever reason), it does the same stop proceedure and it then restarts the
utility program by doing a CreateProcess.
Usually the code works. But ...Importing Contact
I've recently installed MS CRM standard edition. I've got database of
contacts (from goldmine, which i can export to excel as well). Any idea how
to import the basic contact information like Name,address,phone,fax and the
like to the CRM application?
From the Tools Menu goto Import --> Contacts
It easily imports Text files and it lets you match up
your fields to the fields in CRM. There might be an
easier way to get your data in, but this is how I've done
it. Export the goldmine data to an excel file. In
Microsoft Access import the excel file and cr...