Reference cells from another worksheet problem
Worksheet call MAIN
Worksheet call OTHER
In a cell on the OTHER worksheet I have =MAIN!A1. The value in A1 in the
MAIN worksheet is space, but it appears as 0.0.0000 in the cell on OTHER
which has a format of general. How do I get rid of 0.0.0000.
Recheck your formula. I tried what you wrote and it worked for me. You
might want to Right click the cell in question and try Number/Text.
Hope this helps
keithl816's Profile: http://www.excelforum.com/member.php?action=getinfo&am...onenote add-in cannot connect to onenote
Help me please!
I just reinstalled Office 2007 and I get this message when trying to send an
email to OneNote from Outlook
onenote add-in cannot connect to onenote. Make sure OneNote add-ins are
enabled (they are) in the Add-Ins category of the OneNote application options.
How can I fix this??
...Is an array the best option for me and if so how ?
I am trying to set a comparison of shipping costs
possibly using a pick list and/or an array but I cant get my head
around all the different option
I want to be able to choose a county and this gives me the zones for
each carrier and from this it would calclate the
shipping cost for each carrier
I have created apicklist of every county in the world so I though
I next need to give each country a zone number whch if defferent for
so if a choose Ireland I need the rules to show each code
CARRIER = TNT CITY
UPS ...Problem with Mercury Gift Card Balance Function in POS
I was wondering if anyone had come across this issue using POS. The
function (a button that is set up in POS) is used so that a cashier
can swipe the Mercury Gift Card after being prompted to do so, and the
card's balance is returned. The problem we are having is that nothing
comes back from Mercury, even though it appears it is running. If the
card number is manually entered, then a balance is returned. We
haven't had any problems with using the swiper for credit card and
gift card sales, so I'm thinking that there is something wrong with
the function itself. (I have already ...Access Security Options
I would like to store some information in my database but it is information
which needs to be protected by password so that only specified users can view
and change it. Ideally, I would like to store this information in a subform
within a form which can be accessed by anyone.
Is this possible?
Thank you very much for your willingness to help!
Go to the subreport or create a subreport. Open the properties of the
subreport. In events find onclick. There will be a box to the right of
onclick. Click it and use code builder. Type the following in where the
Dim stpassword as...ODBC Connection Not Connecting
I am using the below code to 1) automatically connect to a Microsoft ODBC for
Oracle connection called "FIN_CUR" and 2) run an query on a linked table in
The issue i am having is that the ODBC connect part of the script appears to
be working, but when it goes to try to run the query I still get the popup
prompting for user name and password to make the connection to the ODBC. I
have verify that the user name and password are correct, but don't know what
I am missing.
Here is my code
Public Sub OraConnect()
Dim strErr As String
On Error GoTo...Erratic Connections to Email Servers
I use Outlook2000 for all email activity. I connect to
several different email servers daily. Everything works
fine except for one account (hosted by register.Com).
After connecting to the email server, incoming mail works
fine, but outgoing mail is "strange". Mail in my Outlook
Outbox created in a previous session goes out fine. But
mail in that same Outbox created during the current
session "just sits there". The workaround is to close the
session after completing new and replies and restart
Outlook. Register.com support admits that there are
problems wit...Problem resolved
Thanks to Andy David and Ben Winzenz for the helpful suggestions. Using the
Exchange CD did the trick to uninstall Exchange off of the front end server.
Thanks again guys!
...Exchange 5.5 to Exchange 2000 connectivity
I need a hand because I don't know how to do this and was hoping you could
We have put a new install of exchange 5.5
on a win2k member server to replace an old
storemail1 computer which ran under Winnt 4.0 server.
The name of the old storemail1 computer is storemail1.
The NT domain of storemail1 is storemail
The exchange 5.5 site is storemail.
(server storemail1 in site storemail).
The host name in DNS tab of tcpip properties
of storemail1 is storemail.
the domain in DNS tab of tcpip properties is dunhamshq.com.
The old storemail computer is attached to the same netw...Problem with OnClose causing a crash w/ CDocument
I'm trying to shut down my application from an SDI frame.
In CFrameWnd, the program crashes as stated below:
if (pDocument != NULL && pDocument->m_bAutoDelete)
BOOL bOtherFrame = FALSE;
POSITION pos = pDocument->GetFirstViewPosition();
while (pos != NULL)
CView* pView = pDocument->GetNextView(pos); //dies at this point
if (pView->GetParentFrame() != this)
bOtherFrame = TRUE;
// allow the document to cleanup before the wi...Internet options and ports set up for CC/Debit processing
Even if I'm not an IT guru, I could set up the RMS by myself.
However, I got a big obstacle.
I've installed RMS SP3 and Windows XP SP2. After that I set up
the RMS for credit/debit card processing. However, when I tried
to test my system with my cards, I got connection fail errors.
I tried several changes of internet options, but all in vain.
I'm using CitiBank/Vital processor that is imbedded in the RMS.
Is there any specialist to help me? Expecially for how to set up
port 443 (credit) and port 5003 (debit) to make them bi-directional.
I don't know where are these options for ...Outlook 2007 problem
I ran into the problem that Outlook 2007 would not open (Vista). I ran
scanpst and it repaired the file but then Outlook would not open at all. I
created a new profile but of couse, all my saved email, addresses, etc. are
How do I copy the back up pst to my new email account? Please help, I'm
pretty distraught that this happened at all on a new computer and need pretty
Thanks for any help.
Creating a new profile does nothing to your data. It is perfectly intact.
Just open and use the data file you were using before.
&...Problem in converting double to String useing fprintf()
I found a problem in converting a double number to string by using fprintf.
Please see the following code:
double myDouble = 393.525;
fprintf( mystringDouble, "%.2f", myDouble );
// After this line mystringDouble will be "393.52"
myDouble = 394.525;
fprintf( mystringDouble, "%.2f", myDouble );
// After this line mystringDouble will be "394.53"
I wonder why the 2nd part of my code can rounding myDouble correctly, while
the 1st part fail?
Any method can round double correctly in MFC?
Any of the printf func...Problems with sharing a workbook
We've got a weekly accuracy check spreadsheet that's on another drive and
accessible to me and another co-worker. Normally, we work on it at
different times of the day, but this week we decided to make it accessible
to both of us for simultaneous editing.
The data was first filtered to hide duplicates, then sorted by Employee ID
and Date. I then went to Tools>Share Workbook, checked the box for sharing,
and saved the workbook to our "G" drive.
Then, the trial run: we both accessed it, I had him color-fill the last row
and save. I then saved it on my computer. ...Custom number format problem
This is a multi-part message in MIME format.
Using Excel 97, I've created a custom number format mm/dd/yyyy to =
display dates to look like 01/04/2004, for instance. I've applied that =
format to a number of ranges within the worksheet. The dates get =
The worksheet gets posted to a network drive so others users can access =
it as well. If I then open the worksheet on the network drive from the =
PC that created it,...Linker Problem
I've got a solution that contains a .dll project and an application
project. The app is dependent upon the .dll, and I have that set in
the solution settings.
In Debug version, if I edit the code in the .dll and rebuild, the .exe
project does not re-link with the newly built dll .lib file. (It says
the project is up to date)
The Release version doesn't experience this problem.
I'm using the project settings option page to link to the .lib in the
app project, as opposed to using a #pragma statement somewhere in the
Any ideas why a project wouldn...HQ Client connection scheduling
Hi, Can anyone recommend a method or (free or cheap!) third-party tool that
will allow a shop's HQ Client to connect more frequently than just once every
Could you not just change the connection method in the store properties at
HQ to 'connect every X minutes within the hour? (X being the number of
minutes you would want to connect, so 5 would connect every 5 minutes)
"Tara" <Tara@discussions.microsoft.com> wrote in message
> Hi, Can anyone recommend a method or (free o...New 5.0 SmartPhone Exchange Access Problem
I have users with a new Cingular 2125 (Windows Mobile 5.0) phone and
an unlimited-use data plan. Users can use Pocket IE to browse the web
fine. We run Exchange 2003 SP2. The Exchange server is the only one in
the network, and it has an internally-generated (ie, not a Verisign)
certificate on the OWA web site, and the site is running on a high
port (not 443). The Exchange server has public folders for contacts
and calendar that the phone should be able to get to. The Exchange
server should also push mail to the phone, but only from certain
Is there a step-by-step document with detail...back up problem
I can't figure out how to get Money 2002 to back up to the cd/rw drive. We
just changed computers dell 5100 to a new dell 9100 and what used to work
without any problem is now apparently impossible. I even tried routing it to
the dvd/rw drive. I am the administrator on the computer and it keeps
telling me to see the administrator that I don't have rights to save to that
place (both the cd/rw and dvd/rw). HELP! I am computer challenged and I
have hit the wall on what to do.
...No Internet connections in Network connections!!!
Hi im new to this forum and really need help.
Yesterday I decided to set up my computer again (It had been in the
garage because I wasn't using it for a while). Anyways, when I first
started it up it worked fine and the internet connection worked as well.
Later on it began to shut off unexpectedly if i tried to remove a
program through task manager that wasn't working, so since it didn't
have any important data, I decided to reformat my hardrive and reinstall
microsoft xp. When I started up my cpu again, I noticed that there were
no connections, even though I had not unp...Quickbooks RMS integration problem
I am trying to figure out how to integrate Quickbooks 2005 Premier with RMS
1.2. I have 2 PCs, a POS/Server up front and a backoffice PC with
Quickbooks. In Manager on the backoffice PC I have selected File,
Configuration, Accounting Tab, selected Quickbooks 2003, Retrieve and it
says it has successfully connected with Quickbooks. However, when I try to
set up the GL Accounts by going to Journal, GL Account Setup I get the
account mapping table but I am unable to select any accounts (all cells are
empty and I cannot manually pick the accounts from a list, there is nothing
there). What am I mis...Connecting to outlook
How do I connect to my suddenlink internet provider using outlook?
EggHeadCafe - Software Developer Portal of Choice
WCF Workflow Services Using External Data Exchange
"LaVerne Abraham" wrote in message
> How do I connect to my suddenlink internet provider using outlook?
Outlook doesn't care how you access the internet.
I presume, you mean "how do I set up my suddenlink email account in
If th...VS C++ 6.0 hanging problem in Windows XP ...
My VS C++ 6.0 has worked fine for 4 years. Recently I upgraded my os
from 2000 to XP. Now my VS C++ 6.0 sometimes just hangs forever after I
make a build command. From the output window I know it's linking.
Nothing happens if I stop the building (ctrl-break). If I exit, it says
that I have to stop building before exiting. Eventually I have to go to
the task manager to kill the process. This situation takes place for
any of my projects. Not always, but often enough to affect my work. Do
you have any idea what is happening or is there any resolution? I have
already rein...Time problem
I would like to create a formula that does the following:
A2 - Time from
B2 - Time to
C2 - Break duration (mins, hours)
D2 = A2 - B2 - C2
The problem is that I can't find a way to subtract the duration (C2).
"Jon" <Jon@discussions.microsoft.com> wrote:
>I would like to create a formula that does the following:
> A2 - Time from
> B2 - Time to
> C2 - Break duration (mins, hours)
> D2 = A2 - B2 - C2
That should be B2 - A2 - C2, assuming that "time from" is start time and
"time to" is end time.
> The problem is that I can't find ...Field Comparison option on SmartList Search window
I've been trying to use the Field Comparison option on the Search window on
SmartList so it will report based on the values in two fields. This never
works for me, is there a special trick I need to use to do this.
PartnerSource doesn't show anything on this, maybe it isn't used that often?
Thanks in anticipation
I'm on V9 and wanted to compare date fields on the PO lines. It recognises
the field as date fields and only offers other date fields to compare with
but this view then produces no results when it is expected to. I was hoping
to use it on the new...