Formula problem #13
I am trying to come up with a formula for the following:
I have a range of five cells in a column which are store numbers. The 5
cells represent Monday thru Friday (the labels of Mon thru Fri are in a
separate column and won't need to be a part of the formula).
Monday 452 (c1)
Tuesday 453 (c2)
Wednesday 453 (c3)
Thursday 452 (c4)
Friday 453 (c5)
This is a schedule showing which store numbers a person is supposed to be in
on these days. The person above, however is assigned three stores: 452,
453, and 454. In the blank cel...Problems with Columns
Attempting to change existing text to two columns but sections in wrong order
when changed to columns. What could be causing this?
...Exchange 2003 problem #2
We got problem with email, so I tried to check the
Exchange 2003 server, all clients cann't resolve the
exchange server which they using msoutlook xp. I tried to
ping from client the server that can able to resolve the
I already try to reintall ADC and Exchange 2003 but
still thesame problem. From event viewer I got error event
id 9175, 3015 and 3018.
I format the server and reinstall everything and thanks
god it works but suddenly the problem back again in
We have norton firewall, symantec anti virus system and
I also install symantec antivirus/f...Microsoft Money 2005 Report Problem
I am trying to get a transaction report of all withdrawals for the
previous year from my checking accounts and the only thing that is
reported is deposits.
I had previously printed this report without any problem. Now it
doesn't. I tried reinstalling the program and upgrading it but it
What am I doing wrong???
i have a microsoft access 2000 database. Now, i have to install it on
the pc of our customer. The customer has installed 2003. I can export
all data, but i can not open the reports of this database.
I will get the message ( if i got some) an active x or ole object is
not installed. But i don't know which on can't be used. If i will
create an equal database which the same references, it is not the
problem. The only thing which i can not use on this pc is "insert a
After this, we have installed a access runtime 2000, but the same
Have somebod...Problem with CArchive
I am saving and loading a CArray using CArchive.
CStdioFile file(fileName, CFile::modeCreate | CFile::modeWrite);
CArchive arc(&file, CArchive::store);
CArchive arc(&file, CArchive::load);
mPad is declared as CArray <Song, Song&> mPad; where Song is my own data
I'm using CStdioFile because I want to use ReadString.
It was working fine, until I increased the size of the array slightly (but
still much less than 4k) - then it loads about half the array and the rest
is blank, ...Font problem
I am trying to change the font in an Owner Drawn list box. The list box
consists of a series of buttons with an icon and some text underneath the
icon (still on the face of the button). The problem is that I am creating a
font and selecting it into the device context but if you resize the window
it sometimes changes the font. Is there any way to prevent this? I want
the font to remain consistent even when the window is resized.
The code to create the font is:
8, // nHeight
0, // nWidth
0, ...IF(ISNUMBER.... problem
I can't seem to figure this one out. I am trying to make either a
checkmark, someones intials or a check box (reall doesn't matter which
but check mark would be best) appear in a cell when three other cells
in that same form contain data. The cells that need to be searched
woutl only contain dates but the accutall date entered is irrelevant to
the check box so I would assume that it only needs to search for
generic data. The dates are entered as 05/01/06. Using online help I
have been trying and trying with "=IF(ISNUMBER(SEARCH("/",AND
(G5,H5,I5))),"checkmark...sales Tax Problem Help!
i Justa changed the Sales Tax on Store Manager using administrator user and
pasword , then item by item Aplied sales Tax on each
when i use the pos with tailer User and Password tax do not apear but if i
use the Administrator user and password it apear
any way to extract user stats with ex2003, Messages sent
messages received etc...
"who cares" <firstname.lastname@example.org> wrote in message
> any way to extract user stats with ex2003, Messages sent
> messages received etc...
...Microsoft SQL Analysis Services
Operating System: Mac OS X 10.6 (Snow Leopard)
On Excel 2007 you have the option of connecting to SQL Analysis Services, something I cannot find on Excel:Mac 2008. Is this a planned feature of Excel:Mac 2011 or is this a reserved feature for Windows versions? <br><br>Thank you in advance, <br><br>Valerio
On 3/11/10 5:07 AM, Valerio@officeformac.com wrote:
> Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor:
> Intel On Excel 2007 you have the option of connecting to SQL Analysis
> Services, something ...sql problem
i have an update querry that should pull number out of a string.the strings
are standardized(same). i thought it would be good to pull out the start
position of the nummber and the end position of the number.
here is the code for start position:
Public Function isPocetakBroja(ByVal IngFactor As String) As Long
Dim pocetakBroja, krajBroja, drugipocetakBroja As Long
'assumes that the FactorSum value is a number, and is a Long Integer.
Select Case Left(IngFactor, 8)
Case Is = "dov. zal"
pocetakBroja = InStr(10, IngFactor, "dana (", vbTextCompare) + 6
drugipocetakBroja =...Date Format problem #13
Hi, I am trying to use a box where notes & a Date are kept.
Looking for the best way to setup, not good at dates
cell formated as general, If a date is present it will be as:
:yymmdd or 060510
had cond. format eq like:
where T9 is the text cell working in, for future date is within 5 days of a
cell where was trying to put todays date $T$7, e.g.: 060101
Is there a text variable have to apply, guesse would rather not have to use
a separate cell for todays date. PS the face you see in my equation is not
It...Routing group?? problem
Sorry I can not give you the real name, but it's a true situation.
We have two exchange servers like bellow.
ExchangeA---PIX A-----Internet--------PIX B----ExchangeB
Let's say we have two users, UserA--it's mail box is hosted by ExchangeA,
UserB--it's mailbox is hosted by ExchangeB.
I created two routing groups, GroupA and GroupB, ExchangeA is in GroupA, and
ExhcangeB is in GroupB. I created a routing group connector called AB.
The only configuration for connector AB is remote bridgehead. All others are
default. And let Exchange System Manager create another conn...Loan problem
Hi, I have a loan setup that last for another +1000
payments, it was working fine showing the breakdowns of
interest versus principal and consolidating downloaded
transactions that matched until December, 11th.
As of then it has died, the transactions are still
downloaded but are not referenced in the loan account.
Anyone have any suggestions what to look for and how to
put these payments to the loan so things are back on
In microsoft.public.money, Ted wrote:
>Hi, I have a loan setup that last for another +1000
>payments, it was working fine showing the breakdowns of
&...Problem importing PST File
Am trying to import a PST file to a laptop. I created
the original on my desktop PC and saved to a CD. The
desktop unit runs in XP Home with Outlook XP. The laptop
unit runs in XPPro with Outlook XP. Even after copying
the file from the CD to the Desktop AND removing the Read-
Only attribute, I still get the same error message -
Access denied . . . you do not have the permission . . .
Have you tried to rename the file to the same name and then OPEN it using
BTW - it is always best to Open a .pst file rather than import it as
importing loses several ...Outlook 2002 "connector" problems!
I am unable to resolve (in a timely fashion!)
a "connector" problem with Outlook 2002.
When I click on the icon, Outlook 2002 appears but I never
get the login dialogue box, thus no logon! OE and IE both
function correctly but after much time spent checking
everything I cannot get Outlook to generate (?) a login!
Has anyone else experienced this issue, and what was
What are you trying to log into?
> I am unable to resolve (in a timely fashion!)
> a "connector" problem with Outlook 2002.
> When I click on the icon, Out...Troubleshooting "Rules"
Hi, I am trying to cope with spam by creating rules from messages in my Junk
folder. I am hilighting the message and then selecting either the "From"
option or the "Subject" option. All seems to go well up to that point.
However . . .
After clicking OK and then selecting "run this rule in this folder now", the
only message that is deleted is the one that I am using to create the rule,
instead of going through the whole Junk folder, as expected.
Another problem that I am having is with the Search funciton. Again in my
failaing efforts to cope with over...Cannot install add-in Analysis ToolPak
I tried to put the add-in for MS Excel 2003 but I got the error:
"...Windows Installer error 1648"
Excel won't locate the file in my CD but popped the error right away. I
tried to reinstall MS Office 2003 but the Remove button in Control
Panel won't work. Nothing happened. What was wrong?
Is there anyway to fix this problem?
...Alternate recipient problem
We have a user with an Exchange mailbox that has an Alternate recipient set
with copy retaining by mailbox.
Problem is this - we are intermittantly getting emails that hit the exchange
mailbox that DO NOT get forwarded on to the Alternate recipient.
We know this is the case as we have checked the Alternate recipient's log as
well as our outgoing SMTP server's log.
Has anyone else experienced this or know of a fix?
Exchange 5.5 sp3 running on NT4 Server.
We have the Offline database set up and when we test the database connection
it is good.
After setting it up, we did a clerk reading and the offline database
synchronized with the master database OK.
But when the server goes down, the offline register syas data connection
lost. It's not autometically switching over to the offline database.
We get the following error:
Native error 11
Select Get Date() as CurrentDateTime
Any help would be appreciated.
It doesn't automatically switch. It will give you that error when the
DB goes down, and then you need to launch the ...Count function problem
I have a formula in a cell which reads:
When I created this workbook template, the cells from D13 to G13 were blank
until I filled them in, and this formula worked fine. However, I've made a
change to the workbook. Now I've made D13 through G13 equal to the values in
a range of cells from other sheets in the workbook (for e.g. D13 is
"=Sheet1!D13". The above formula is now generating the number from B43 by
default, even though the cells from D13 to G13 are blank.
The "COUNT" help in Excel says:
I am getting the following error message when I try to acces my email.
Please advise. Thank you.
An unknown error has occurred. Account: 'mail.bellsouth.net', Server:
'pop.att.yahoo.com', Protocol: POP3, Port: 995, Secure(SSL): Yes, Error
In your browser go to http://mail.yahoo.com and log in to that account.
Then clean out all the folders in your webmail. If you want to save
any messages, create a new folder and move those messages to the
new folder. Empty the spam and thrash folders also. Close webmail,
then try Windows Mail again.
Gary ...A problem difficulty for me but easy for you!
the problem is the fllowing:
1.Either a database or a table of it has so many records that it is wasting
time if we try to operate it in total any time .
2.I want to show some records page by page in the web page.At the same
time,maybe I have to sometimes list them order by some fields .
3.To do what 2 shows as quickly as possible,because users don't wait with
patience.how can I do?
"jifenghu" <email@example.com> wrote in message
> the problem is the fllowing:
> 1.Either a database or a table of it has s...Problem with starting Word 2007
I have a recurring problem with Word 2007. Every few days (I haven't
figured out a pattern yet) Word 2007 will not start. All that shows up
is the Word 2007 splash screen. In order to get past this I have to
remove the normal.dotm file and reboot. Then I can bring up Word 2007.
This problem started a few weeks ago and I have not installed anything
new on the computer. I'm runnin Windows7 and MSOffice 2007.
I've removed a few add-ons in order to pinpoint the issue but so far no
Has anyone seen this problem before?
Does anyone have suggestions of wha...