IBM SurePOS 500 & MS RMS 2.0 Printing Problems
I'm currently trying to put together an IBM SurePOS 500 & MS RMS 2.0 system
consisting of the following hardware and software:
IBM SurePOS 500 - Model 4846-545 Intel Celeron 2.53 GHz 512 MB 80 HDD with
15" Touch Screen (inc. IBM Cash Drawer)
IBM CANPOS Keyboard
IBM SureMark Dual-Station (Slip & Receipt) Printer 4610 - TG3
Epson TM-L90 Label Printer
Symbol LS2208 USB Scanner
Operating System - Microsoft Windows XP SP2
Application Software: Microsoft Retail Management System (RMS) 2.0 (inc. MS
SQL Express 2005 as a back-end database)
I’ve i...Football League Table Spreadsheet #2
That is exactly what I am after. I have downloaded the file but I can'
seem to locate the additional maintenance tab on the toolbar fo
gracust's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1591
View this thread: http://www.excelforum.com/showthread.php?threadid=27395
When I loaded it I looked under tools in the menu and there was an
additional item at the bottom 'League results' with other options from
If you...How do I break the value (Y) axis in an Excel chart ??
I'm trying to shorten the Y axis on an Excel chart by breaking it. Is there
a way of doing this outside of pasting a text box and inserting two diagonal
lines (which don't stay attached to the chart when you move it!)?
Jon Peltier has instructions, and links to a couple of other techniques:
> I'm trying to shorten the Y axis on an Excel chart by breaking it. Is there
> a way of doing this outside of pasting a text box and inserting two diagonal
> lines (which don't stay attached to the cha...Passwords #2
I want users to have to put in a password when they open outlook. I have
selected the check box on the outlook settings to have it prompt for a
password. When it prompts for the password it wants to authenticate to the
exchange server and not with active directory. Am I forgetting something?
You can't authenticate to Exchange - Exchange doesn't have the capability to
do so. You may see the Exchange server listed, but rest assured, the
authentication is taking place with Active Directory.
"Tbaker" <Tbaker@discussions.microsoft.com&g...color of oval shape prints square
I have oval shapes that are color filled, and look fine on the screen. When
printed to an HP LaserJet 2820 the color for the ovals spills over to fill a
rectangle that contains the oval.
...Add-on software for Excel charts?
Are there programs that add attractive features to Excel charts, such as
shapes of bars, or new patterns and colors?
You can apply some of your own formatting:
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
"Ed" <Ed@discussions.microsoft.com> wrote in message
> Are there programs that add attractive features to Excel charts, such as
> shapes ...Office Mac #2
Does anyone think microsoft will put a database application like Access in
In article <E6E68FF4-3832-4404-9914-0AD0B345A39B@microsoft.com>, Glenn
> Does anyone think microsoft will put a database application like Access in
> office mac?
It's a shame when cousins marry.
Where is the business case for it?
1) There are any number of perfectly good "database" applications for the
Mac. We don't need another.
Excel is available, and makes a very good flat-file database. MySQL works
I WANT CELLS TO CHANGE CERTAIN COLORS WHEN I ENTER DATA. IT TAKES TOO MUCH
TIME TO MOVE MY MOUSE TO THE CELL COLOR BUTTON EVERYTIME I CHANGE SOMETHING.
IT WOULD BE EASIER WHEN I HAVE TO MAKE MY WORK SCHEDULE FOR 30 PLUS PEOPLE.
Take a look at Conditional Formats. I'm guessing that should do what you
> I WANT CELLS TO CHANGE CERTAIN COLORS WHEN I ENTER DATA. IT TAKES TOO MUCH
> TIME TO MOVE MY MOUSE TO THE CELL COLOR BUTTON EVERYTIME I CHANGE SOMETHING.
> IT WOULD BE ...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...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....Perserving secondary axis in pivot chart
I have a Pivot Chart with two series of data, one of which is plotted on the
secondary y axis. Every time I refresh the chart, it defaults back and I
lose my secondary axis. I then have to manually change this every time.
This is a know issue.
XL2000: Changing a PivotChart Removes Series Formatting
> I have a Pivot Chart with two series of data, one of which is plotted on the
> secondary y axis. Every time I refresh the chart, it defaults back and I
> lose my secondary axis. I then...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...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...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
> ...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...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
...How do i use Conditional formatting for 3+ conditions ?
I have a text box in a report which highlights in colour current members in
a list of past and present member names. I have six types of current members
that I want to highlight, but with conditional formatting I can only use 3
conditions in the members [Type] field. I have tried [Type]="Full member" Or
"Life member" but the "Or" doesn't work ! Is there a way to do this ?
thanks .. Roger
CF is limited to 3 contitions, but you can use OR in those expressions.
If you set Condition1 to Expression, you can use:
([Type] = "Full member") Or (...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
> Gene...chart scale
I have a chart that shows pay per hour and pay in thousands. On the chart the
pay per hour bars do not display, and you can only see the year salary in
thousands. The range of the chart is 0-140,00. I need to expand the 0-30
range without throwing the rest of the chart off whack. I can not figure it
You could plot one series on the secondary axes. Double click the series,
and on the Axis tab, choose Secondary.
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
"Gia" <Gia@discussions.microsoft.com> wro...Help with Conditional formatting with Dates
I have a spreadsheet in which I have to monitor various dates which are in
different columns (i.e. (1) Date Tender Released, (2) Date Company Selected,
(3) Date Draft Contract Forwarded, (4) Date Contract Signed etc...).
Would if be possible to Conditional Format and have diffirent ROWs
highlighted for each individual Contracts (I have 300 running contracts
running) every time a date is filled in these different columns:
Initial Step (1) = Yellow (Call for Tender released)
Step (2) = Blue (Company Selected)
Step (3) = Brown (Contract under Process)
Step (4) = Green (Contract Si...Validation #2
I currently have this macro to check whether certain cells are
populated before allow the document to be emailed.
Private Sub email123()
' email123 Macro
Dim Cell As Range
For Each Cell In Range("mandatory_fields")
If Cell.Value = "" Then
MsgBox "Please complete all mandatory fields."
MsgBox "All mandatory fields have been completed. Will now send
ActiveWorkbook.SendMail Recipients:="intended email address",
Subject:="RFC : " & Range("b9")
However, my range...Data Migration #2
I have to migrate data from MSCRM 3.0 to MSCRm 4.0. To achieve this
can I use Data Migration Manager of MSCRM 4.0? or is there any process
to achieve this?
I believe your only option is to perform an in-place upgrade from 3 to 4.
<email@example.com> wrote in message
> I have to migrate data from MSCRM 3.0 to MSCRm 4.0. To achieve this
> can I use Data Migration Manager of MSCRM 4.0? or is there any process
> to achieve this?
>...Conditional null value
Wondering if anyone can suggest a way to simplify the following code, which
I’m using in the OnFormat event of a report.
If Not IsNull(DLookup("[ICD2]", "EntryICDs", "[EntryNum] = " & Me!
Me![Field192] = Replace(DLookup("[ICD2]", "EntryICDs", "[EntryNum] =
" & Me![PtAcct#]), ".", " ")
If Not IsNull(DLookup("[ICD3]", "EntryICDs", "[EntryNum] = " & Me!
Me![Field194] = Replace(DLookup("[ICD...Area chart, help needed.
Can anyone help me with the attached chart?
The first chart is how it currently looks, if you look at the small
black section you can see it tapers off.
however i would like it to look like the second chart and end abruptly
in a straight line.
Im using a combination of Line and Area charts.
the data is in a 3 rows.
Won: this only shows data in the past. (also cumulative)
Forecast: only shows data in the future. (also cumulative)
month 1 | 2 | 3 | 4
Won: 800|1,600| 0| 0
Forecast: 0| ...linking to access #2
I have a spreadsheet containing links to an Access database.
For some reason, the edit/Links buttons is not enable.
And all the option under DATA/Import External Data/ are disable also. Even
if I select the pivot table based on the link.
How can I change the link. I made the mistake to rename the query I used in
Access to link to this pivot table, and now I have 2 pivot tables pointing to
the same query but using a different name, so I'm stuck. Is there anything
else I can do, other than deleting my pivot table and recreating it? (which
is not a good thing to do because I have power...