Not able to see all data but can see on another computer
I am using SAP application and if i retrive the excel file from SAP i can
see only 48 lines where as i should see 110 lines but if i opened that same
excel file in another computer then i can see all lines (110 Lines) i don't
know why its happening.
Can anyone help on this? Thanks in advance.
We have a 3gb HQ db with 6 stores. Whenever a 401 needs to send a large
amount of data to HQ, the following happens:
HQ spikes all 8 CPUs at 100% for about 40 minutes then completes
Store HQ client times out, never registers that the 401 completed
Next time the store connects, same thing happens again until I delete the
401 in question.
This is a major problem, because when we do a physical inventory, we need to
do all sorts of gyrations to ensure that the data is uploaded and the
offending 401 is then removed.
It's really not all that much data, what is it with the RMS db design t...Bringing sub totals from Sub Report to Main Report
I've read posts that come close to solving this but I can't get it to work.
I simply have a report that reports on towns, the farmers that live in that
town and the acres they grow of different crops. I want to summarize the
total acres that each farmer grows and the total acres of each town.
-------------WHEAT 100 Acres------
-------------CORN 300 Acres------
-----------------FARMER1 ACRES 400 Acres------
--------FARMER2--------...I cant see emails coming in anymore.
I used to push send/receive and a box would come up telling me 'Receiving 8
of 40 emails' with a green bar going across the centre. Once the emails are
received the box goes. If I push send/receive nothing happens. If I push it
say, 10 times, again nothing happens. Once all the emails are thru the box
that used to come up, than flashes up 10 times, but by than its a little
late. Does anyone know how to get the box back? I would really appreciate
it... KR Mick.
I send this message using the forward procedure to somebody of the group
My problem is likely the same as a lot ...Query to Access : does'nt see tables
Office 2000 SP3 FR
From Excel / MS Query, I want to read data in Access tables.
I choose the mdb file and so MS Query displays this error message
"This data source does'nt have any visible table".
Original in French : "Cette source de donn�es ne contient aucune table
I transfert my data to a new mdb file : it work's few times (!), then the
error message appears again.
How to resolve this problem ?
MS Query does'nt accept a file name with 2 dot inside !
MyFile.mdb --> Ok
My.File.mdb --> "...YTD Totals
I have a spreadsheet table that lists each month and the totals at the end
for the past 5 years. Is there a simple formula to put in to give me the YTD
increase or decrease. The formulas I have tried give me incorrect totals.
What formulas are you trying?
It is a simple Current YTD - whatever Prior YTD you are comparing it to =
increase or decrease
"Judy" <Judy@discussions.microsoft.com> wrote in message
: I have a spreadsheet table that lists each month and the totals at the end
: for the past 5 years. Is ther...Totalling Yes or No Answers
Can someone email me a small sample database that reflects a yes or no
answer to a group. like if i want to know how many 35, 36, 40 yr olds
are married, which is answered by a yes or no.
Can some one help
How do you want to do this, in a query, on a report?
> Can someone email me a small sample database that reflects a yes or no
> answer to a group. like if i want to know how many 35, 36, 40 yr olds
> are married, which is answered by a yes or no.
> Can some one help
&...How to see my mail queue?
I have a Exchange 2000 running on Windows 2000 server.
Could you please tell me how to monitor my emails in my mail queue? I can't
find a location on the Windows to see the mail queue status.
Thanks in advance,
To view the mail queues follow these steps:
1. Open system manager, Navigate down to the following location
Your organization --> Administrative groups --> Your Admin group -->
Servers --> Your Server --> Protocols --> SMTP --> SMTP virtual server -->
You should then see all the smtp queues and monitor mail.
...Account totals missing in Portfolio Manager after switch to Money
When I switched from Money 2005 to Money 2006, somr of my investments no
longer have a Total Account Value. The line is just blank. This leads to an
incorrect total at the bottom of the page. How can I get Money to calculate
the totals accurately?
...I see you
Well, not really, but I used Google Earth to zoom in on the Flatiron
Building. You can get so close you can see the utilities on the roof,
the hydrants on the street, the little parkish area across 5th Avenue,
etc etc. Cool! Now tell me where your office is (like where is Peter's
window, what floor and facing what street). Google Earth lets you zoom
in all directions so I'll be able to turn the map to see that window.
Silly I know but still a connection on some level.
Pats looked good but not great last night. I didn't watch much more of
the game. I'm not sold on ...To See or Not To See
I have copied a few tables of text from a web page into Excel. Some of the
information contain word that are hyperlinks or email addresses. Is there a
way to change those columns of information to reveal the web address or email
So is it just displaying plaintext currently?
Have you seen this information from the Help Menu?
When you make changes to the Hyperlink and Followed Hyperlink styles, your
changes apply to all hyperlinks (hyperlink: Colored and underlined text or a
graphic that you click to go to a file, a location in a file, a Web page on
the World Wide Web...E12 unable to see storage groups through EX MMC
We've been running E12 in a test environment for about 1 month and just today
ran into a situation where the storage groups for a server are no longer
visible from the console on that machine. If we view the server from a
console on a different EX server we see all storage groups and stores.
Any help is greatly appreciated
can you list the storage groups and stores from the shell (EMS) on that
did you try restarting EMC?
MVP - Exchange
NEW blog location:
&quo...Nice seeing all of you hopefully I see you in the other forum
really I just wanted to get the last post in prior to it closing today :)
...How do I get the total of a range of cells that are in another she
I have two sheets in the workbook and I need to get the total of a range in
sheet1 into a table on sheet2. How do I go about this?
note the ! after the sheet name
bob777's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28504
View this thread: http://www.excelforum.com/showthread.php?threadid=487937
...Can I see My Calendar as others see it
Can I view my calendar as if I am viewing it by someone with whom I share?
no. Your permission levels are greater.
Why do you want to be able to?
in Canberra, Australia
wrote in message news:46AD6AD8-5B97-4D06-9F73-2D212B626E05@microsoft.com...
> Can I view my calendar as if I am viewing it by someone with whom I share?
...Totaling Sums for Price and COMM
I am trying to find a way to total Sums for two Fields, Price and COMM.
This must be an easy fix, just haven’t done this in a while and I think I
forgot a step.
In my Report, I have the following:
Page Header, I have TDATE (for TradeDate), CUST (for Customer), B/S
(Buy/Sell), C/P (for Call/Put), Quantity, Symbol, Price, and COMM.
In CUST Header, I have CUST
In Detail, I have TDATE, CUST, B/S, C/P, Quantity, Symbol, Price, and COMM.
In TDATE Footer, I have =Sum([Quantity]), =Sum([Price]) =Sum([COMM])
Now, I’m trying to figure out how to sum those last two values; Sum all ...How do I count words line by line and see them on the left colum?
I need to have a cumulative line-by-line word count, reflected within my
document, on the left hand side.
Word does not provide any built-in way to do this, and I don't believe it
would be feasible even with fields or macros. You would have to do it
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"MimiT" <MimiT@discussions.microsoft.com> wrote in message
>I need to have a cumulative line-by-line word count, reflected within m...Cannot see posts again
My posts from the Ng do not appear on the NG. I have to go to google groups
to look them up. Cumbersome. How can I solve the problem?
This newsgroup ?
Is WLM configured to use newsgroup community features(if so disable it)
Are any of the missing messages present in the Storage folders/Recovered =
items folders(and appearing as if sent to you instead of=20
"Ben Stevenson" wrote in message =
My posts from the Ng do not appear on the NG. I have to go to google =
grou...Moved Outlook Express folders to new machine, but cannot see them
Here's what I've done, copied all the .dbx folders from old machine to
disk, copied them to desktop of new machine. Opened new account/ new
Outlook Express on new machine. Then selected File, Import, Messages,
chose OE 6, imported by browsing to the desktop folder I created..I've
even received the message"YOUR DATA FROM MICROSOFT OUTLOOK EXPRESS 6
WAS SUCCESSFULLY IMPORTED"..
but I still cannot see them within OE....
I have also tried the move by physically copy & pasting the .dbx
folders into the 'identities folder' and pointing the store to it and
can't ...how do I keep a running total of my bills?
I am trying to make a spreadsheet with my monthly bills and don't know how to
get a running total can someone please help me?
use this in b2 & copy down
"TEK" <TEK@discussions.microsoft.com> wrote in message
> I am trying to make a spreadsheet with my monthly bills and do...Co-worker sees pictures on top of text
I have a Word 2003 document with many pictures inserted. On my computer the
text wraps around the pictures. When a co-worker opens the same document the
pictures are on top of the text. What setting could be different?
Got It! Renamed Normal.dot and let Word recreate Normal.dot. Seems Ok now.
"Lee Zard" wrote:
> I have a Word 2003 document with many pictures inserted. On my computer the
> text wraps around the pictures. When a co-worker opens the same document the
> pictures are on top of the text. What setting could be different?
...Cannot see typing when composing
When typing text into the text field of a new email in
Outlook, I can see the cursor moving, but no letters
appear. When I misspell or introduce a typo error, the
spell checker underlines the invisible word. The text
body has a very faint grid as a background.
...Can't see Credit Card / Transfer category in drop down
I am trying to categorize my account transfers using a non expense/income
category. The user guide suggests that I use the Credit Card / Transfer
category below the Payee field but the category is not in the drop down. I
am using Essential Register. What can I do so these transfers don't get
recorded as expenses?
"JWH17" <JWH17@discussions.microsoft.com> wrote in message
>I am trying to categorize my account transfers using a non
> category. The user guide suggests that I use the ...See each of the steping through few rows to see how data gets appe
I have the stored proceure as bdlow.
However I would like to watch how each of the rows is getting inserted to
Is there any print statement or anything else that will let me see the
Any help is appreciated. Thanks
ALTER procedure machine_hrs_sp
declare @test table (machine varchar(25), plan_date datetime, plan_hrs int)
declare @machines table (machine varchar(25))
select '01' union all
declare @days int
while (@days < 365)
insert @test select machine,dateadd(dd,@...Exchange 2007
I've been running the Exchange 2007 evaluation. On one of my configurations
my messages weren't getting through so I tried to look at the mailbox size
and the users connected. And I can't find how to do this in the graphical
admin interface. I've asked some of my collegues and they don't know how to
do it either.
Am I missing something here? One of the first things I do on when arriving
on a customer site is to check out the list of mailboxes and who is connected
and I can't figure out how to do it on Exchange 2007.
get-mailboxstatistics will get y...