PO amount different on PO Entry screen from printed PO
We have a problem that seems to happen every month. In the Purchase Order
Entry window, the subtotal on this one particular PO is $590,776.35. However
if we print the PO, the subtotal amount on the printed PO is only
$472,451.66. The only seems to happen on random PO's and we can't figure out
why. It's starting to annoy our Purchasing department...
What version and service pack of GP?
Are there PO's entered manually or imported?
Is the PO report modified?
Are there typically a lot of changes to the PO's that this happens to?...How to change cell color based on content
Hi, hope someone can help me. I don't use Excel much, but I'm creating a
spreadsheet that keeps track of ticket sales for a charity I volunteer for.
Anyway, what I want to do is to make the cells stand out for those that
still owe money, either because a check is forthcoming or because they
ordered by credit card.
I want the credit card orders to show up with a different color (eg YELLOW)
than those who are fully paid.
I want the forthcoming check orders to show up in a different color (eg
So I have a column with payment type that is either Cash, Check, or Credit
Card....Multiple detail areas in one report
We are creating a database which uses several forms to input data into a
There are several categories for the data ex: Full Service Driver, Trade
Driver, Misc Receipts, Misc Payouts.
I need a report that breaks these categories out in detail like so:
Cashier Driver# Driver Name Full Service Checks Full
Service Currency Full Service Coin
Cashier Driver# Driver Name Trade Checks Trade Currency
...I want to print multi pages on one page.
I've tried going into set up and under page layout telling it to print 2
pages per sheet, but that doesn't work. Is there another way?
If, by "multi-pages" you really mean multiple worksheets on one page
that is not possible. You could add a 'summary' worksheet to combin
your data and print that with the "fit to page" option checked on th
Page Setup screen. Be careful with the 'fit to screen' as it can mak
the printout unreadably small.
swatsp0p...Time Zone Change
When I turned on my pc this morning I realized that
my "adjust for daylight savings time" option was not
checked off in outlook calendar options. However, when I
check that box, it changes all my appointments by 1
hour. For example, I have an appointment for 11am and it
moves it to 12pm. What can I do about this? Your help
is very much appreciated.
...Today Conditional Format
I have a column which calculated a date based on 3 working days from a date
input into a diff column. What I want to do I have the calculated date
appear bold if that date has passed based on the current date.
For example if I input 01/08/11 the next column calculates 04/08/11 (3
working days). I want the caluclated date to appear bold when I open the
spreadsheet on the 05/08/11 ro show the calculated date has passed.
I can use conditional formatting but can't get the syntax right
Win XP Pro
Andy Roberts presented the following explanation :
> I ha...Employees who change passwords on my system?
How do I get my passwords set so eployee's quit hacking my site?
From: UncIe Fester
Cryptic Illusions wrote:
> How do I get my passwords set so eployee's quit hacking my site?
> From: UncIe Fester
Dear UncIe Fester,
Have the 'eployees' come into the office and then cut their hands off.
If they were physically present, they'd be 'inployees' and you'd have
more granular control over their actions.
* -343-* FDNY
I know there should be an easy way to do this, but I have yet to figure it
out. I have a 183 page report on school districts. I want to print all the
information for one school district per page (or possibly two because a few
of the larger districts might take up two pages.) On the report, I have one
district per page or two and I could just print the whole thing but I don't
want to. Is there a way to print a certain district? I don't want to just
print page 42 and wonder what district that is. I want to print, let's say
Spring School District, and only that page prints. Th...when I open excel file,changes was undid-excel 2007, compatibility
I have a file that was made in excel 2007 working in compatibility mode and
when I change format in some cell (for example font size), then I save
changes and after reopen this fiel the changes was undid.
Can some help me?
Sorry for my english isn't very well
...Two Condition Vlookup?
I am currently trying to create a function that searches through an
array for two exact column values which allows me to retrieve a third
column value. For example:
Type of Fruit Date Packaged Amount of Fruit
Apples June 100
Oranges June 50
Apples July 75
Grapes July 50
In this example, I would be looking to retrieve the Amount of Fruit
(Apples) that was packaged in July. I would be putt...Change case of text
I have Word 2007. In earlier versions of Word under the Format tab there was
a change case option that made it easy to change selected text to all upper,
I cannot fund this function in Word 2007. Where is it?
Thanks for your help - jjk98
Home tab, Font Group, Change Case "Aa" icon.
Also, does Shft+F3 toggle the text, from no caps - initial caps - all caps?
Hope this helps
> I have Word 2007. In earlier versions of Word under the Format tab there was
> a change case option that made it easy to change selected...Query condition by date range
I'm trying to create a query to base a report from. I need it to return
records within a date range that needs to be specified, as in specifying the
beginning date and having the current date as the end date. A field is
included in the query that has listed dates in the format mm/dd/yyyy. How
would I write the criteria? I have part of it ready - [Please enter starting
date:] . I know that's how you get the little question window.
On Tue, 4 Dec 2007 14:51:00 -0800, silva wrote:
> I'm trying to create a query to base a report from. I need it to return
> records within a...Changing case #4
Is there a way to change case for several cells. In Word,
you go to Format, Change case, and then you select all
upperlower, lower, Title, etc.
Does anyone know if there is a way to do this with Excel
In Excel you need a macro if you want to change case in the same cell
See this webpages
Here are three macro's for changing text cells in the selection
Dim selectie As Range
Dim cel As Range
On Error Resume Next
Set selectie = Range(ActiveCell.Address &am...Changing the Administrator password
I know that this has probably been asked many, many times and there is
probably a set procedure for it but I still have not been able to
In the state that I work, the education field has taken a pretty big
hit as far as layoffs for teachers and support staff are concerned.
Hence my upcoming problem!
At the end of this month, I will have an urgent need to change the
administrator password for our district network since several people
from within my department will be leaving the district that know the
I know that the administrator password can be ...Need help with conditional formula (Excel 97)
Can anyone give me the correct syntax for the following formula:
if A1 is blank, and B1 is more than zero, then display B1, otherwise
display nothing (blank cell)
met vriendelijke groetjes
"Jake D" <JakeD@djhtend.com> schreef in bericht
> Can anyone give me the correct syntax for the following formula:
> if A1 is blank, and B1 is more than zero, then display B1, otherwise
> display nothing (blank cell)
> Thank you
> ...2007 excel autofilter change back to 2003?
Is it possible to change the autofilter in excel 2007 back to the way excel
I see you have a response to one of your other posts -- in a different forum.
> Is it possible to change the autofilter in excel 2007 back to the way excel
> 2003 worked?
...OWA changing password problem
When I log onto OWA to change my password, th
Internet Service Manager pops up just like it should
And all the fields are empty except for the ACCOUN
The problem is that the first letter is missing
Exchange2003 on win2003 DC
I have the exact same problem. I believe it to be an AD issue since I've seen the same thing with other products. Anyone have any ideas?
> When I log onto OWA to change my password, the
> Internet Service Manager pops up just like it should.
> And all the fields are empty except for the ACCOUNT
> The problem ...Change Password in OWA on Exhange 2003
Were having a problem with the change password in OWA. I have enable the
button on the front end server and on the back end server. I have setup
the IISADMPWD virtual directory in IIS. When I click the change password
button from OWN I get 404 page not found. If I go directly to the page
it works just fine. Were running exchange 2003 on windows 2003, I have
noticed that the change password files now have a asp extension instead
of the normal htr as found on windows 2000 and NT 4.0. Also the
options.js file in the exchangeweb/controls directory points to the
var szURL ...Printing list of emails in Oulook Express
I am trying to find a way to print, an entire list of email reciepts, so I
don't have to keep them. Can anyone help?
>I am trying to find a way to print, an entire list of
email reciepts, so I=20
>don't have to keep them. Can anyone help?
These Newsgroups address issues regarding MS Office
Outlook. Outlook Express is a component of Windows/Internet
Explorer. Post your question where the OE gurus hang out:
...Conditional formatting if condition of an if statement is true and a string value is displayed
I got a nested 'IF'-Formula in an excel cell that returns nothing if
the condition is false.
I would like to conditionally format this cell with grey shading if
the condition is true and a string value is displayed.
How can this be achieved using excel conditional formating
Help is much appreciated. Thank you very much in advance.
Let's say your doing this conditional formatting in cell K17. In
conditional formatting (xl2003) choose the FormulaIs: option and enter:
choose your formatt...Outlook 2003: Attachment Icon doesn't print
All users in a subsidiary office share this attachment
icon problem: they see the paper clip in the attachment
field prior to opening the e-mail message, and they also
see the icon in the opened e-mail (sometimes located below
the subject line in the heading, and sometimes located in
the body of the e-mail). When they print the message, the
icon fails to appear.
It will print when you print the message in Plain Text. For HTML it will be
fixed in SP1 which is coming soon!
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Backup and Restore
-Create an O...<= changes to <?
I have an Access application in which I invoke a report or a form with a
where clause. In all cases the where clause is of the form:
ServiceDate >= #01/01/2007# And ServiceDate <= #09/25/2007#
This runs just fine. I transmitted the MDB file to a client using FTP.
when he received it, the <= in all cases had changed to <? in the compiled
code ONLY. The source was still correct. I had to go into each code module
and force a source change so it would recompile.
Any ideas on how or why this happened?
I wonder if you may have more luck...Cannot change to an installed font
I am running Vista Home Premium and Office 2003. I tried to work with a
document in which I used a font called Stam College. I tried to add a word in
the same line. Instead of the letters appearing in that font, the font
automatically changes to Times New Roman and the appearance does likewise.
All my other fonts work, just not that one. And it worked fine for a long
time, just not today. I tried deleting the font and re-installing it, with
the same results. I tried deleting unnecessary fonts from my Fonts folder
with no different results. I tried changing printers but no cigar. ...Conditional Field in Queries
Is there a way to make a field in a query conditional so that it only
displays the value if the value is equal to something specifically
> Is there a way to make a field in a query conditional so that it only
> displays the value if the value is equal to something specifically
> set? Thanks.
Explain "the value is equal to something specifically set".
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
...change GAL #2
Yes it is. We did a rebuild on the original default OAB and the new OAB.
Still, even today after someone does a Send/Receive -> Download Address Book
it's still showing people from the other OAB.
I also previewed each OAB in ESM to make sure it was accurate, which it is.
Any ideas? The one thing I want to avoid is deleting the original Default
Address Book and recreating it.
"Pierrot Robert" <mcthepro_at_hotmail.com> wrote in message
> In the properties page of your mailbox store, is the new OAB listed in the