Credit Card Number on Receipt
I have replaced the default credit card tendering window with my own hook
in. After the transaction is cleared it prints a receipt but it will not
print the masked credit card number on the receipt that I have swiped on my
Make sure you are updating the correct fields data in your application,
second check the TenderEntry table and verified that credit card number is
saved there. you need to use the SQL Query tool from administrator program
If the above information is verified now check the receipt.xml file and find
the credit card printing call procedur...Excel 2007 unrecognized file format in Excel 2003
2007 & 2003
Note to the file - so to speak:
Even if one changes Excel 2007's default file SaveAs format, when 2007
closes, it saves files like Personal.xls as a 2007 file format without
the new extension .xlsx
My point, I still must save files in 2003 for other's who do not have
If I copy Personal.xls in the Excel StartUp Directory to a 2003
platform, Excel 2003 does not recognize the file format. (The file
size is about 50% of the original 2003 file size - which is a strong
hint that the file is in the new XML format)
Therefore, I created a macro to save Personal.xls i...Importing email from Gmail to outlook 2007
I was previously using my gmail going through the web mail but then i stated
using Microsoft Outlook 2007 now then i only received mail which were new and
not the old email which were already there in my Gmail account please help me
out with this.
"Manish Rathod" <Manish Rathod@discussions.microsoft.com> wrote in message
>I was previously using my gmail going through the web mail but then i
> using Microsoft Outlook 2007 now then i only received mail which were new
> not the old email...File Size Limit??
Can anyone tell me if there is a limit to the file size
of an Excel 2000 document. We've got a guy here who has a
63Mb spreadsheet, and keeps wondering why he's
getting "Out of memory" messages every time he opens it.
I've put an extra 512Mb in his PC, but he's still getting
He's convinced that there are no limits to the size of
the file, but I'm pretty certain that there is...
The limit is memory.
"Jon" <email@example.com> ...Total Number of Hours
I have a tracking sheet and I entered the total number of hours spent on a project and then when I want the sume the total is 6.65 instead of 7.05 for 7 hours and 5 minutes. How do I fix this? The way I entered the time is 0.35 for 35 minutes. Do I need to enter the times a different way?
If you are in a place that use : as a time delimiter then you need to enter
35 minutes should be entered as
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
"celeste" <firstname.lastname@example.org...VB Control Positioning in MS Word
I have developed a control in VB 6 that works in MS Word. This control
needs to appear next to my cursor position as I type. If I provide hard
coded coordinates, I can manage the control position, but I need it to be
dynamic, irrespective of the number of toolbars open in MS Word and MS
Thanks in advance for the help.
I am doing a fairly easy programme on excel. It is a catchment runoff, and
evaporation calculator. But i would like to place a limit on a cell, and have
that exess go into another column, is this possible? EG 75 rainfall, soil can
hold only 10mm more. SO 10mm INFILTRATES, ie that cell should have a limit of
the max soil moisutre, the other 65mm RUNOFF's and thats a different column.
ANYBODY PLEASEEEEEEEEEE!!!! lol
You need a Workbook_Change event macro for that. The code you would write
in that macro should first check that the change occurred in a cell within
the range you want. ...words around a circle patch/ not w/o using word art
I want to put text around a circle. I want that text to follow the path of
the circle. I don't want the text to increase in size.
If I use word art, and create the circle text, the problem is the text
increases, or decreases with the size of the text?
I have a tutorial of sorts showing how this can be done in Publisher. Scroll way
"Bruce Leavitt" <Notthis1@noidea.com> wrote in message
>...Publish Forms in 2007
I have a custom form for contacts that I used in previous versions of
outlook. I have the form saved as "name.oft". Is there a way that I can
publish that form so I have access to it for all contacts in a given folder?
Turn on the Developer tab, using the instructions given at
http://www.outlookcode.com/article.aspx?ID=35 . Once you do that, the Publish
Form command will be available.
This newsgroup will be discontinued any day now. In the future, please use
one of these forums for your Outlook forms questions:
http://www.outlookcode.com/messages.as...adding numbers #2
I have a spreadsheet where I am storing hours.
So 1h or 5h, etc...
Is there a way I can select a bunch of cells. and add these numbers.
Even though there is "h" in the cell?
SUM works just as well on time, just format the result cell as [h]:mm if it
might exceed 24 hours.
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"greg" <email@example.com> wrote in message
> I have a spreadsheet where I am storing hours.
> So 1h or 5h, etc...
> I...sequential numbers
I simply want to sequentially number rows in a column. However, some of the
rows do not contain any data so do not need to be numbered. So there is in
fact a blank. It´s also possible that i´d want to add another row, and auto
update the number sequence. You cannot drag the auto numbering facility
across cells that you want to remain empty of course, because they will be
With your data in column A,:
Formula in B1 :1
In B2: =IF(A2="",B1,B1+1)
Cell Value is, Equal to, B1 (remove the $signs if you clic...PP 2007 themes effects
Can't seem to get this to work. Hints on how would be GREAT!
What are you trying to do?
"Gene Moirao" <GeneMoirao@discussions.microsoft.com> wrote in message
> Can't seem to get this to work. Hints on how would be GREAT!
> Can't seem to get this to work. Hints on how would be GREAT!
http://office.microsoft.com/en-us/powerpoint/HA102464571033.aspx?pid=...Problem using Match on columns of numbers with leading zeroes formatted as text ???
In my test run, I was using a column of first names in workbook A to
check and flag their
presence in workbook B, The code given to me by Marcus here worked
fine. No problem at all.
When I switched to the real problem by replacing my columns of data
with leading zeroes, the columns being already formatted as text, the
program did not find Matches.
In both workbooks columns of data, cells have an automatic Excel
comment that says :
"The number in this cell is formatted as text or preceded by an
What am I missing here ?
Is there a spe...2008 R2 dpm 2007 setup: SIS-Limited not found?
I'm trying to run the command line to install the SIS component via
ocsetup.exe SIS-Limited /quiet /norestart
but it tells me it cant find this SIS-Limited component (on 2008 r2 x64)..
Any ideas what i need to do to get past this?
It turns out you just need to add the file services role in r2, dont need the
> I'm trying to run the command line to install the SIS component via
> ocsetup.exe SIS-Limited /quiet /norestart
> but it tells me it cant find this SIS-Limited component (on 2008 r2 x64)..
...Help! IF function is too limited
I've created a drop-down list of cities in a cell, under which there
are two more cells to be filled out with the address and zip codes
corresponding to each of the cities. How can I do this, knowing that
the original list is a three-column list made of city-address-zip?
Ringo's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27502
View this thread: http://www.excelforum.com/showthread.php?threadid=470178
Use VLOOKUP into the original; list using the DV value
=VLOOKUP(B...Saving with Microsoft 2007
I am using a new laptop with Microsoft 2007 installed, whereas I am used to
the 2003 version. I am not sure how to "Save As", using the 2007 version. I
have saved documents to a travel drive and wish to save some of those files
to my laptop under different names, after I have worked on them. Just how can
I do that? The 2003 version contained "Save as" and "Rename" to do these jobs.
Thanks, A. Walker
Office button - Save As.
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"...Excel to word.
Can anyone help.....I want to create a Invioce within word
that would calculate above fields and and add Tax and
finally give the gross figure. Same as you would achieve
withon Excel. I do not want toinsert a table as I feel
this would be confusing to the user. Is there a field
that I can insert that would do the calculation for me in
the same way I would do in Excel.
MS Word does support some calculated fiels but I'd suggest you post
this question to the MS Word newsgroup :-)
<firstname.lastname@example.org&g...Rollup 1 and Custom Add On's (MS-CRM Word)
I have the Word anf GroupCalender from MS-CRM Addons. Will the Rollup1 affect
No. The Rollup will not affect GroupCalendar or WordMailMerge.
Your company for MS-CRM ADD-ONS!
WordMailMerge for MS CRM
GroupCalendar for MS CRM
Telephone Integration for MS CRM
EmailSignature for MS CRM
> I have the Word anf GroupCalender from MS-CRM Addons. Will the Rollup1
> affect these?
> Thanks, Lloyd
Temptus has WordConnect as full Office integration with Microsoft CRM 3.0...Q: Rules limit
There is a limit for Exchange Rules on a 32K-size (KB147298)
Whether there is a way to change this limit for single users?
For me already three users have addressed with such requests :-
This is not a configurable limit. It's limited by the size of one RPC
"Kenin Alexander" <email@example.com> wrote in message
> There is a limit for Exchange Rules on a 32K-size (KB147298).
> Whether there is a way to change this limit for single users?
> For me already thre...Can't import JPG in Word or Powerpoint, windows 7
Just downloaded windows 7 and now microsoft word and powerpoint won't import
any of my jpgs. Any ideas???
If it was me, I'd re-install ms word and ms powerpoint (ms office?)
awesome graphics for powerpoint
powerpoint pictures, tutorials, free samples...
"cortneyc" <firstname.lastname@example.org> wrote in message
> Just downloaded windows 7 and now microsoft word and powerpoint won't
> impor...GENERATE RANDOM NUMBERS BUT EXCLUDE A NUMBER IN THE SEQUENCE
I NEED TO GENERATE A RANDOM NUMBER BETWEEN 1-9 BUT NEED TO EXCLUDE WHATEVER
IS IN THE CELL ABOVE IT. IF THE CELL ABOVE IT SAYS 8. I NEED TO GENERATE
1,2,3,4,5,6,7,OR 9. IM STUMPED?
> I NEED TO GENERATE A RANDOM NUMBER BETWEEN 1-9 BUT NEED TO EXCLUDE
> WHATEVER IS IN THE CELL ABOVE IT. IF THE CELL ABOVE IT SAYS 8. I NEED
> TO GENERATE 1,2,3,4,5,6,7,OR 9. IM STUMPED?
In A2:A100, put
In B1, put
In B2, put
and copy down to B100
Use the values in column B.
I might of explained it wrong. I want to use random(1,9) but...Convert Wordstar to Word 2007?
Is there still a file converter for Wordstar (circa 1992 -- I no longer know
the version number) to Microsoft Word (I'm using Office 2007, but I still
have computers with 2003 and 2000 installed)?
I've searched the MS Knowldege Base, which refers to a Wordstar converter
ONLY in the Office 2000 Converter Pack. This pack has been withdrawn,
however, because of "security issues." The replacement Office 2003 Converter
Pack does not appear to contain any Wordstar converter, nor does there appear
to be one for Office 2007. It would appear that Microsoft has left m...Finding the number of records in a query
I want to restrict my users from running a query if there are records in a
second query. The second query has 2 parameters based on forms,
[Forms]![frmInvBusNums]![InventoryNum] and [Forms]![frmInvBusNums]![BusUnit]
The code I'm trying to run, which is totally wrong looks something like this:
Dim db As DAO.Database
' Dim rst As DAO.Recordset
' Set db = CurrentDb
' set rst=db.QueryDefs "Discrepancy_Report"
' If rst.RecordCount > 0 Then
' MsgBox "There are conflicts"
' Exit Sub
' ...Limiting Internet Email for Users
I want to stop users from sending Internet email from my Exchange 2000 server. I use it for a company wide mail server. Can anyone help me stop Internet Email.
This might help:
"Bob" <email@example.com> wrote in message
> I want to stop users from sending Internet email from my Exchange 2000
server. I use it for a company wide mail server. Can anyone help me stop...Convert Number to Word in Receipt
How can i convert Transaction amount to Words in receipt XML file.
Is any function like CurrencyToString there..?
thanks in advance,
VbCurrencyWords, this is one of the values of attribute 'type' of the SET
> Hi all,
> How can i convert Transaction amount to Words in receipt XML file.
> Is any function like CurrencyToString there..?
> thanks in advance,
> VbCurrencyWords, this is one of the values of attribute 'ty...