Testing my ability to Post.
...Making Zeros look like no entry
I have a spreadsheet that makes some calculation in a column, based on
multiplying numbers entered in 2 other columns. However, for some of the
rows, there is no "input" data, and so the calculation simply indicates the
answer is zero. This gives me a column with lots of zero's in the cells. I'd
prefer there simply to be a blank cell, whenever the result of the formula is
zero. Is there a way to achieve that?
you didn't give enough info to write a proper formula so i'll have to make
...How to post process specific NDR's 2?
Boy, I started a thread before with the same subject, but forgot to ask
about the primary issue...heh!
We have some "automated" bulk email messages going out every now and then to
all the students at our college.
Some of the students have not provided a legit email address, which of
course bounces back to us.
We are trying to keep a clean MS network, but have gotten suggestions about
these non-delivered messages, to setup a unix/linux box with some kind of
proc. mail server that actually can process these specific messages and have
a script or something automatically process t...Why my posting are not posted!
I am not sure why sometimes my postings are not posted! do you know why?
Perhaps because you are using Microsoft's unreliable web interface to the
newsgroup? Better to access the newsgroup directly, using a newsreader.
"LABKHAND" <LABKHAND@discussions.microsoft.com> wrote in message
>I am not sure why sometimes my postings are not posted! do you know why?
"LABKHAND" <LABKHAND@discussions.microsoft.com> wrote:
> I am not sure why sometimes my postings are...2nd time posting this problem, pls help
Dear Kindly solve my problem
table t1 has fields pictures, name
in design view pictures field is ole object and
name field is text.
now in table, i have inserted some jpeg pictures in field pictures,
written some name in name field
if we open table t1 to view.
now i have written a small query as
select t1.pictures from t1 where name = x;
x is given in run time, like any thing as n1 /n2/n3/n4 /....
let say x is n2 now.
i a...captech e3 news post test
captech e3 news post test
Willst du schnell viel Geld verdienen ohne Risiko???
(Tut Mal Wat) verdient euch mit wenig Aufwand was dazu
Willst du schnell viel Geld verdienen ????
Sagst du Ja, dann lies dir den Brief am besten schnell durch
und befolge meine die Tipps! Viel Gl�ck eure Sandra.
(vom englischen ins deutsche �bersetzt)
DAS HIER K�NNTE DEIN LEBEN VER�NDERN WENN DU ES GELESEN HAST!
Ich habe diesen Artikel Im Internet gelesen und ich entschied mich, dass
Vor einigen Tagen habe ich die Zeitungen durchst�bert und stie� dabei
auf einen Artikel, �hnlich wie diesen h...Postings
In the newgroups, every posting has a "Subject", a "From"
entry and a "Sent" entry.
The "Sent" entry contains a date and a time. Whose "date"
and "time" is that; is it the submitter's, Microsoft's or
That time is PST. Pacific Standard Time. The time that the
message is posted by the MS servers on the west coast of
>In the newgroups, every posting has a "Subject", a "From"
>entry and a "Sent" entry.
>The "Sent" e...xsd tool/serialization problem...wrong xml ?
I was trying to deserialize my xml file (I enclose it below ) into a class.
So I generated an xsd file given my xml using the MS xsd tool; then I
generated the corresponsing C# class (using the MS xsd tool): the
UserSecurityData class. When I try to execute my app to deserialize my xml
file, my application crashes causing a strange FileNotFoundException when
invoking the XmlSerializer constructor (second line of my code fragment). Is
there anything wrong with my xml file ?
Thank you for yor help
U...Post-Windows Update Black Screen Issue
Can you provide an update on the status of this:
> Can you provide an update on the status of this:
Can who provide it ? There is no official MS presence here, only
As far as I'm concerned this "story" is an Urban Myth or this newsgroup
...My post/s not appearing in the NG...
....but a recent one did show on the relevant MS Discussions webpage.
I am reluctant at present to sign up for Windows Live, as I much
prefer the format of newsgroups, so any help resolving this, if
possible, would be much appreciated. I have tried unsubscribing,
deleting the .dbx and then re-subscribing, but my earlier post still
did not appear. Maybe this one will...
Win XP Home SP3 and IE6.
> ...but a recent one did show on the relevant ...End notes material not showing up in index
I thought I posted this question a few days ago but I can't find it, so I'm
trying again. Forgive me if this is a duplicate.
I am creating an index of authors cited in a work. There are about 50 pages
of end notes, and I marked the authors listed there as well. But none of the
end notes authors are listed in the index. Is this something Word doesn't
do, or is there a way I can get those references into the index as well?
...Double posting on the GL from the AP subledger
We do a reconciliation every month between the AP subledger and the AP GL
account. Very often the cause of the difference is double posting of AP
transactions on the GL. For example a check will post only once in AP, but it
will create two, sometimes three or more GL entries.
Does anyone know what is causing this and how to avoid it? For now I am
using a report to track down the double postings, but I would like to avoid
Are you also having problems with an excessive number of Stuck Batches? I
just found a user that would go into Series...Posts not appearing on discussion board
I'm not sure where to post this...
I posted a question in Excel on Friday (11-13-09).
I searched for all of my posts today, and that post isn't listed.
I then searched for all posts about concatenating (the subject of my
question). Again, my post wasn't there.
SO... I figured I must have done something wrong on Friday & reposted the
question earlier today.
Still can't find it.
The first thing I did was clear the cache & try again - but that didn't work.
Where are my posts?
This happens very often on this site.. Anyway post your question a...Finding replies to past posts
Is there a web site that stores all the posts that I can go to as I think I
may have missed some replies?
"rob nobel" <email@example.com> wrote in message
> Is there a web site that stores all the posts that I can go to as I think
> may have missed some replies?
You can use google (maybe a few hours behind) to search for stuff you've
posted (and find the replies, too)
h...Comparing like for like with a 53 week year
we report data on a weekly basis, with the week ending on a Tuesday.
We chart the data to show like for like comparisons with same weeks
previous years. How do I enter the data to show a 53 week year (Leap)
to compare with a 52 week year?
The difference between a Leap year and a regular year is 1 day (365 vs
366) not one week.
> we report data on a weekly basis, with the week ending on a Tuesday.
> We chart the data to show like for like comparisons with same weeks
> previous years. How do I enter the data to show a 53 week year (Leap)
> to compare with a 52 we...replying to posts
I have received two e-mail messages that relies have been posted to my
question on MAC PowerPoint 2003. When when I click on the link I am taken to
a blank page (both on Mac and on PC) I can't even see my post on the post
page. Any ideas?
No offense but I believe you're having difficulty because;
A- There is no Mac PowerPoint 2003. 2003 is a Windows version,
B- You're not returning to the same groups to which you're posting... As
mentioned in my reply to your post to the Mac PPt group. This is the *3rd*
different news group you've posted to on this same issue, an...Outlook Profile dialog appears although Lotus Notes is default
My Visual Basic program sends an e-mail through the user's default
mail client. For a few users, an "Outlook Profile" dialog appears,
asking them to choose between Outlook and Lotus Notes. However, their
default mail client (Internet Options -> Programs -> Email) is Lotus
Notes. Why is Outlook involved, when Lotus Notes is the default? (this
also apparently occurs with Outlook Express)
Not sure if this is important: When Lotus Notes is selected in the
"Outlook Profile" dialog, the e-mail only appears in the Lotus Notes
"Sent" folder, but without...Tool Bar In Excel With Macros
Im trying to create a toolbar that takes you through a large report, it
contains a 'Home' button which returns you to the index tab (Thats an easy
on!) a 'Last Sheet' button that returns you to the previous tab and a 'Next
Sheet' button which takes you to the next tab.
What's the easiest way to get this to work, and how woul i go bout writing a
script to make it work?
Assigne these macros to two buttons:
On Error Resume Next
Worksheets(ActiveSheet.Index - 1).Activate
On Error Resume Next
Worksheet...PM transactions disappeared after posting
We just upgraded from v 7.5 to v 9 of Dynamics and from MSDE to a full SQL
database. The first batch of transactions that we posted in payables
management posted to the general ledger but "disappeared" from PM. When we
went to select the checks, there were no transactions to select from. What
caused this and how do we fix it?
...SOP transactions not posted/posted???
I have a weird sort of Error in the SOP module of Great Plains version
The smart list shows an Invoice as unposted, but when go do to the
Sales Transaction entry screen and enter the invoice number, a pop up
displays a message that the inovoice number is posted???
i have tried to run check links, but it shows no errors... so how can
this be resolved...
thanks in advance
...Convert 2 per page post card to a 4 per page post card
I have created a post card using a template, but when I look at the print
preview it shows 2 post cards per page, the paper I am going to print them on
is 4 per page. How do I conver the document or change the layout?
What version Publisher are you using?
If you are using 2007 use one of the Avery US Letter postcard templates,
copy/paste your created postcard to the new page setup. Make a note of the
color scheme, you may have to re-set it after the paste.
If you are using an earlier version, you should be able to go to page setup
and change the copies per sheet.
"HptRdsRealtor&q...correction to my last post
i meant everything was retained including my files
...Disable Customize option next to a tool bar from VB
We use excel for our reports and for security reasons, we do not want to
give 'Open' option to our users.
We are able to disable the 'Open' menu option programmatically from VB. We
also want to eliminate the usage of 'Open' tool bar command. To do this, we
need to hide the standard tool bar, by default, when the excel file opens.
What is the way to do this from Visual Basic 6.0?
Thanks in advance
To hide the toolbar, try:
To hide and disable the toolbar, try:
Application...Posting to vs. posting through
What is the system behavior and impact controlled by the following system
Post to General Ledger
Post Through General Ledger Files
Post To means that when you post a batch from the subledgers the resulting
GL journal transaction is created in General Ledger but not posted. The
transaction will remain in a batch in GL until it is posted.
Post Through means that when a batch is posted in a subledger, the resulting
GL journal entry will be posted in General Ledger, thereby updating GL
account balances and transaction history.
Note that if you post a transaction in a ...How do I setup a post office?
I am using windows 2000 O/S but office 97. I am trying to
setup a post office on a LAN but cannot find any info on
how to do so.
Chris Gardner wrote:
> I am using windows 2000 O/S but office 97. I am trying to
> setup a post office on a LAN but cannot find any info on
> how to do so.
> Please help.
What is a "post office"?
Do you mean a mail server for sending/receiving mail?
If so, you need to setup a server running the various "post office"
protocols, e.g. POP3 and/or IMAP and SMTP. Any number of ways to do
this, but requires ...