ING Direct #2
I am trying to set up an ING Direct account in Ms Money 2003 following
the directions on the ING web site. After completing step 12 which is
"make sure ING DIRECT is selected" in the Online setup window, click
next. When I do this it prompts me for a username and password. This
is not what the instructions say should happen. They say Money should
connect to the internet and download information for ING DIRECT. If I
try to enter my customer # and PIN as the user name and password it
tells me the password must not contain any numeric characters. Upon
close inspection, under the passwor...Managed User #2
Testing to see if this setup allows me to be properly identified as a
...Problems inserting pictures in Excel 2002 sp-2
When inserting a picture into a work sheet, nothing shows up but the
outline/edit box. If you grab the box and move it on the sheet, the picture
will appear. If you scroll up or down, the portion of the picture that goes
off screen will not show up when you scroll back to the center of the screen.
Grab and move it again and it shows up again....
My IT guy is lost on this one!
It sounds more like a windows display problem to me.
Do you have the zoom factor set to 100%? (It may help.)
But maybe you could try closing other applications or changing the display
I use...Potential customer field in Quote
Is there a way to make the Potential customer field in Quote entity as
Thank you in advance for any suggestions,
The entire sales process from opportunity up to the invoice requires a
customer. If you don't need the field, create a dummy account and set the
customer id to this dummy account in OnLoad.
Michael H�hne, Microsoft Dynamics CRM MVP
CRM Blog on http://www.stunnware.com
"crsb" <firstname.lastname@example.org> schrieb im Newsbeitrag
news:76d7f1b1-c86f-470b-bbec-0329d9d29f...need help with formula #2
how to write a formula?
if cell =>24 multiple by 22. if cell is <24, multiply 24 by 22, multiply
difference by 33 add together
Where do I find the difference
"Kerri Olsen" wrote:
> how to write a formula?
> if cell =>24 multiple by 22. if cell is <24, multiply 24 by 22, multiply
> difference by 33 add together
See Help for "IF worksheet function"
I can't be more specific without a better description of the alternative
"Kerri Olsen" wrote:
> how to write a formula?
> if cell ...2 pivot tables on one tab
Is it possible to put 2 Pivot tables on the same tab in my workbook?
Or does anyone have any ideas on what would be the best way to chart Capital
Pircahses? I have 5 coums and 4 rows. The rows are per division, and the
columns are for the disposal amount, gain or loss, book value, depreciation &
purchase price. I already have one pivot table in my report. Would this be
You can put multiple pivot tables onto a worksheet. If the second one is
based on the same data, select and copy the first, select a cell some
distance away, and paste it. Each pivot table...What version of Excel converts Lotus 1-2-3 spreadsheets?
I had a 30-day trial version of Microsoft Office (which I do not know what
version it was) and purchased the Student 2003 Office which no longer
converts Lotus 1-2-3 spreadsheets to the Excel spreadsheet. I'd like to
upgrade and do not know which one to purchase.
I don't know if the S&T sku for Excel limits the files to open, but in
XL2003 (part of Office 2003 Pro) there is a Lotus 1-2-3 option under
File>Open...>Files of type drop-down>Lotus 1-2-3
Microsoft MVP - Excel
www.ni...2003 Form fields losing formatting in 2007
I have some forms, created in Word 2003, which when opened as a .docx, all
form fields revert to Times New Roman font but if they are opened as a .doc,
they are in the correct font of Arial.
Anyone got any ideas why and how I can fix this?
Thanks very much.
This doesn't make any sense. Documents always open in the format in which
they are saved. What *exactly* are you doing?
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
...Click on link problems #2
When I click on a url link in email---a box opens saying "Open Link
Browser". And also a browser window.
How do I get rid of the smaller link browser?
Read your reply on your post of the 17th?
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1
"Robin" <email@example.com> wrote in message
> When I click on a url link in email---a box opens saying "Open Link
> Browser". A...Socket relared problem (getting free port number dynamically) #2
i have one problem related to thread. i am having my main thread
running which will
on some event create a thread for validation purpose and then will
and now this validator thread will create a socket and it will bind to
and then will wait for client to connect.
but before waiting for client to connect it will send a message to the
main thread that
validation is done.
but in this way i need to stick with port 20111.which i really don't
Is it possible for me to get a free port from operating system or from
library and then i should bind t...graphic deleting #2
I have made myself a simple macro that copy a cell and paste it 50 cells below. It work fine with text and numbers but I have tried it with graphic recently and strangly enough it is adding a other graphic the same as the first one each time it copies. I have discover that because when I tried to correct my graphic and want to erase the others there was one more graphic to erase each cell down below, very long process and I would like to know why it is doing that and if there is a command to erase all the selected cells contents all at once like the text contents. Thank you very much
Show th...Grid Pane Field Expressions
Ordinarily, I would put field expression code in the
OnFormat_Detail event section. However, if it's possible
to build the expression I want directly into a query
grid pane while in grid design, I would prefer to do
that in the current instance.
Current case: I have a field "Title" (happens to be
the title of a classical music piece.) and I also have
the cataloging system and values in separate fields,
CatSystem and CatSystemVal, e.g., "Op.", "78".
So, if the current piece has a chronological catalog
value, I want the query to return it appended to the
title ...Field with running count of records
I have a query with fields such as date, Item Number and Quantity. I want
to create an additional field called Count that will act like an autonumber.
It will assign a value of 1 for the first record, 2 for the second number
etc. Can someone tell me how to do this?
There are tons of posts on how to create a "ranking" query. You must have a
field or fields that uniquely identify the sort order. If you provided
significant table and field names as well as your desired sort order, someone
could create the SQL for you if you can't search for and fi...Set form field on double click
I am using MS Access 2003.
I have a continuous form that is run off of a query "srbScientific Review".
The query's criteria is set to [Enter Last Name] in the LastName field. That
part works fine. I get my continuous form that shows LastName, DocID, and
Title of Document.
I would like to double click on the DocID and have the following happen:
1. Open another form "publications"
2. Set the SRBId field to the DocId field that I double clicked on.
PLEASE help. I think I need to bookmark, clone.... I'm very confused.
As a kick in the right ...Locate a Cell based upon criteria
I'm trying to locate a cell based upon certain criteria. For example:
=CELL("row",min(C6:C11)). What doesn't seem to work is using the Min
function. Any thoughts on the best way to return a cell location?
Many thanks for any help you can provide!
Hope this helps!
In article <C598DBDD-0D25-48E3-AA44-6B6250176D67@microsoft.com>,
"Stan" <Stan@discussions.microsoft.com> wrote:
> I'm trying to locate a cell based upon certain criteria. For example:
> =CELL("ro...Wait Activity Condition
We have an activity that is added to the lead record automatically at the
time the lead is created. It is a phone call activity for our reps to
followup with the lead.
We also have a sales process (workflow) set up for once the lead is
converted to an opportunity. My question is:
How can I keep the lead from being converted to an opportunity until the
phone call activity on the lead is completed? I have looked at the Wait
Activity Condition but can't seem to get anything to work.
Any suggestions appreciated.
...Add a number based on list of criteria ??
Example: Cell A = 50, Cell B = 96%, Cell C = Cell A + (Cell A x Cell
B) = 98
I want to be able to compare the list of criteria and add a number to
Cell C accordingly
For example: If Cell B is between 95 and 100%, Add 1 to the total in
If between 85 and 94%, add 2... etc.
There are more than 7 so I know I can't simply nest If statements...
Any advice on how I could fairly simply accomplish this?
Put your % bands in a table (say in J1:Kx, e.g.:
1 0 11
2 5% 10
3 15% 9
10 85% 2
11 ...Hide/Unhide #2
I have two questions regarding Excel 2007 hide features:
1. What caused my entire Excel worksheet to disappear from view? When I
tried to reopen the file, Excel kept saying the file was already open, but I
saw NOTHING. A colleague finally told me what he did to solve the problem,
but in what situations will selecting Hide hide the entire worksheet?
2. I have a split in my worksheet and when I point to the double arrows, the
pop-up message reads "Hide White Space." I have no idea what that means; how
do I get rid of the split?
Nothing in the Help feature assists me with my ques...Tax withholding 2 states
We have a client that wishes to have correct state tax withholding for two
states - for example, they have employees that work in IL and live in MA.
The Massachusetts state income tax is 5.3% of wages. The difference between
the residential rate of 5.3% and the actual Illinois state income tax needs
to be withheld as an additional tax attached and remitted to Massachusetts.
...AUTO NUMBERING #2
hi all,i have made an invoice template for my work.how can i get these
invoices to sequentially number each time i use the invoice and save as iun
the customers name?any suggestions will be greatly appreciated. thanks wyn.
one way (using the Windows registry for storing the last number). Put
the following code in the workbook module (not in a standard module) of
- It changes cell A1 of the first sheet
- you may change the key identifiert according to your needs (e.g.
DEFAULTSTART, MYLOCATION, etc.)
Private Sub Workbook_Open()
Const DEFAULTSTART As Int...Conditional formatting #87
Can I do a conditional formatting on a range if the value
in one cell in the range = X
in other words can I format the back ground for line 5 if
C5 = X
Use conditional formating.
Select the whole row
Set the condition Formula Is =$C$5="X"
Choose the Format you want for the cells in that row.
"ESREI" <firstname.lastname@example.org> wrote in message
> Can I do a conditional formatting on a range if the value
> in one cell in the range = X
> in other words can I format the b...Customization guide #2
Anyone out there want to give up a copy of the developers guide? My store is
on a very tight budget, and has a hard time calling support everytime we want
to see what can be done with RMS. If you want to email it anonymously, I
won't say anything.....
Is there a developer's guide?
Every time I called MS about development information all I get is routed to
a salesperson or told we can put you in touch with "a partner" I even went
thru the route of trying to become a partner in order to have more dev
No luck so far.
"New RMS User" <N...I can't install the 12.2.1 update on Snow Leopard
Operating System: Mac OS X 10.6 (Snow Leopard)
Office 2008 12.2.1 Update can't be installed on this disk. A version of the software required to install this update was not found on this volume. I guarantee a legitimate copy of Office 2008 for Mac is on my iMac. Any suggestions?
On 9/30/09 3:43 PM, in article email@example.comR9absDaxw,
"firstname.lastname@example.org" <email@example.com> wrote:
> Office 2008 12.2.1 Update can't be installed on this disk. A version of the
> software required to install this update was n...File format is not valid #2
Can anyone help me with this. I tried to open an existing file (which a
number of people have access to) and it has come up with this error.
Can it be fixed?
Is it an xls file?
> Can anyone help me with this. I tried to open an existing file (which a
> number of people have access to) and it has come up with this error.
> Can it be fixed?
> Thanks heaps.
Yes. And it worked just fine a week ago prior to someone doing something to
> Is it an xls file?
> "FB" wrote:
>...How do I save a worsheet from Excel 2002, for a user with Excel 2.
I know to use save as, I just don't know which one to save as.
excel 2000 will read version 2002 or 2003 files without any problems, so
just a normal save should do it.
BTW your question got trucated in the subject line, so it's a good idea to
repeat the full question in the message body.
Hope this helps
"vkirkman" <firstname.lastname@example.org> wrote in message
>I know to use save as, I just don't know which one to save as.