Interest Formula #3
Does anyone know of a formula that will calculate the amount of interest that
is in each instalment of a monthly repayment. Eg amount of borrowing £5000
repayment over 3 years interest (say) 7%. What is the capital element and the
interest element of each instalment.
Have a look at...
Hope this helps!
In article <46D82352-8E60-4617-B5DF-FBA2B4B9CBE5@microsoft.com>,
"Allan" <Allan@discussions.microsoft.com> wrote:
> Does anyone know of a formula that will calculate the amount of interest that
> is in each instalment of a monthly repayme...How to use custom field in email view
Using Outlook 2003 in English
I've added a some custom text fields (eg. "Request ID") to the current view
(inbox folder). I was hoping to be able to type a value into this new text
field for each email in the inbox, so I could easily sort and reference the
I see the empty column in the view on screen, but how can I enter a value in
that column? Double-click opens the message and it's not in the message
properties or options...
Any ideas? Thank you in advance,
YOu can do that if you set the view for in-cell editing. It's on the =
Other S...Search Date Field
How does one seach a 'type date' field (e.g.; 11/17/2007) for a bank entry?
Create a query.
In the Criteria row below your date field, enter:
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"OldManEd" <email@example.com> wrote in message
> How does one seach a 'type date' field (e.g.; 11/17/2007) for a bank
...Populating cells by selecting items from Combo Box? How to?
I have a combo box with three different house models. I need th
spreadsheet to show the square footage of each side of the house fo
each model when it is selected from the combo box.
Basically I have four cells in a column, Side 1, Side 2, Side 3,Side
for each side of the house. Then, next to each of those cells I woul
like the values of the square footage to show up when that particula
house model is selected from the combo box (the square foot #s ar
always the same and can be inputted beforehand)
I'm not sure if there is a way to do this without using much code(don'
have much kno...How do I create drop down form fields in Excel?
Is it possible to create dropdown lists in Excel? If so, how do I do it?
You can use Data Validation to create the dropdown lists. There are
instructions in Excel's Help, and here:
> Is it possible to create dropdown lists in Excel? If so, how do I do it?
Excel FAQ, Tips & Book List
...Try this corrective update for Windows
Content-Type: multipart/related; boundary="dxslqsnvlsnz";
Content-Type: multipart/alternative; boundary="mcsszxsuxwtdg"
this is the latest version of security update, the
"September 2003, Cumulative Patch" update which resolves
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install ...Out of Office AutoReply #3
I would like to ask you a question regarding one function of Outlook Express
Since I got a mail from someone with the subject: Out of Office AutoReply
Of course I sent them mail before and they just out of their office and I
think they did some setting so that the system can auto reply to the sender
So do you know how to make it?? Thank you very much!
If you are in an Exchange environment (ask your administrator if you do
notknow) you can set the Out of the Office Assistant which is located under
If you are not in an Exchange environment you can c...Trying
Trying the outlook news.
Also trying the news outlook
"user00" <firstname.lastname@example.org> wrote in message
> Trying the outlook news.
...Programatically place cursor insertion point at the end of Unbound Textbox field
I've placed Unbound TextBox and subform to show records from a table.
By default when form stats all records are shown in subform.
As user enters 1 character at a time in Unbound TextBox the OnChange()
event is triggerred and I filter the records matching what user is
The problem I am facing is after the character is entered and records
are filtered when focus is back to Unbound Textbox:
The cursor is placed infront of the first character entered. I would
like to ensure the cursoer is at the end of the last character enered.
I did a lot or searching and reaching and I did mad...Drop Lookup from Jet table field
My table was created using design mode and has a lookup table.
I now need to remove the lookup table using VBA
docmd.runsql "ALTER TABLE mytable COLUMN myfield DROP LOOKUP"
I have been unable to find any documentation on how to do this but any
suggestions would be appreciated.
>My table was created using design mode and has a lookup table.
>I now need to remove the lookup table using VBA
>docmd.runsql "ALTER TABLE mytable COLUMN myfield DROP LOOKUP"
>I have been unable to find any documentation on how to do this but any
>s...Error when trying to import data that was exported on another computer on networ
A file error has occurred in Comma Separated Values
(Windows) translator while initializing a translator to
build a field map.
The file \\Laptop\claptop\documents and settings\All....
The disk is locked, the file is a read-only, in use by
another program, or because you don't have permission to
use a network path.
...Error when trying to copy worksheet within workbook
I keep receiving a prompt when trying to copy a worksheet within a
workbook....goes along the lines of
A formula or sheet you want to move or copy contains the name "...." which
already exists on the destination worksheet. Do you want to use this version
of the name?
Select Yes and it goes through a list of nameswhich could be upto 50 or so.
DO you know what is meant by a named cell? Cell A1 can be given a name such
as Rate. Now suppose a cell on Sheet1 is named Rate and a cell on Sheet2 is
named Rate. Want happens when you copy from Sheet1 to Sheet2? Excel ...Exchange oma dataprovider gives error whenever try to access
Checked permissions and SSL on oma virtual site.
Whenever anyone tries to access the oma virtual site an error appears in
the error log and they are denied access.
An unknown error occurred while processing the current request:
Message: The remote server returned an error: (400) Bad Request.
Microsoft.Exchange.OMA.ExchangeDataProvider.ExchangeServices...Try Catch Finally in MFC
Iam using latest MFC Version, i believe 7.0. I could only find TRY CATCH
block in MFC.
How can i implement try -catch- finally in MFC?
One thought i have is to throw an exception while iam in try block when i
want to return.
Is this a good idea?
//When i want to return due to improperly formatted parameter to the
function, i will throw a custom exception.
> Iam using latest MFC Version, i believe 7.0. I could only find TRY
> CATCH block in MFC.
> How can i implement try -catch- finally in MFC?
> One thought i have...listbox highlight selection
Hi, after sorting information that I show in a listbox I would like to
highlight the first item showing up at top of the listbox(right now I
get by default a dotted line under the first item)
Thank's ahead for any hint!
Dim NoDupes As New Collection
Dim i As Integer, j As Integer
Dim Swap1, Swap2, Item
i = 1
Set NoDupes = New Collection
For Each ws In Worksheets
i = i + 1
' Sort the collection
For i = 1 To NoDupes.Count - 1
For j = i + 1 To NoDupes.Count
If NoDupes(i) > NoDupes(j) Then
...trying to concatinate based on values matching in certain cells
I have the following info:
Sarah Schwartz A1 1163233
Anne Schwartz A2 1163233
Marcus Lehr A2 1582167
Eric Lehr A1 1582167
Matthew Weiss A2 2194223
Kari Weiss A1 2194223
Ryan Mc Cartney A1 2299079
Kelly Mc Cartney A2 2299079
Cornelius Brendan-Guiney A1 2301508
Roberta Guiney A2 2301508
Nancy Trojan A3 2302575
Kenneth Trojan A2 2302575
Debra Wittington A1 2302575
Shannon Kozlowski A2 2348145
Shannon Kozlowski A1 2348145
Jesse Zoller A1 2383021
Gary Zoller A3 2383021
Jeremy Zoller A2 2383021
I need to concatenate a string in colu...3 pressing problems!
After CRM 3.0 redeployment, there are three problems:
1, Anyone can not import data, i am sure that the authority setting is
2, If I add any link-reports(non-reporting-service), the reports list will
show error message.
3, workflow can not send the e-mail to appointed mailbox, and also i am sure
the e-mail address are right!
I deploy the CRM server 3.0 and SQL Server 2005 on different computers.
...format cell #3
how can I format cell so when I want to enter, say, time I just type
1427 and it will come as 14:27?
thanks for any response,
this requires VBA
> how can I format cell so when I want to enter, say, time I just type
> 1427 and it will come as 14:27?
> thanks for any response,
If you wish for 14:27 to be a usable time, you cannot format.
You must use VBA code to convert the 1427 to 14:27
Chip Pearson has code for this........
http://www.cpearson.co...I've tried DSUM, SUMIF....
Can anyone please help me solve this frustrating problem!
I have 5 columns of info about my phone calls (the standard stuff: date,
start time, no called, duration, cost). Column E is the 'amount' column,
and I want to total all the amounts for calls which (in column 3) START with
a 7. In other words, I'm trying to find out how much was spent on all calls
to mobile phones (all leading zeros are removed).
Its easy to find totals for calls to particular numbers, but I can't figure
out how to total them all. The only criteria I can think of is that they do
all begin with...Trying to close year with a bad journal entry
I'm trying to close out the year for a company in GP 9. I get an error
that states: "account assigned to transaction is missing". So I find
the offending journal entry, but it has been voided. I cannot edit it
or delete so I can close out the year. Suggestions?
have you checked KB Article 855209 - Account assigned to a transaction is
missing? if not, go ahead and look it up in partnersource. this kb should
the reason why you are receiving this messahe is because of a record that
has an ACTINDX = 0. you may need to update it with ...selecting rows of data
I have an excel worksheet with 4 columbs.
I want to automatically select multiple rows of data according to
search which will partly match one cell in the row and put the full ro
as results in a new worksheet.
If the search string is "New" how can I produce a new worksheet whic
Any suggestions would be appriciated
Message posted from http://w...test #3
...Trying to connect......!
For a while I had the Outlook 2003 HTTP/RPC setup working smoothly for my
users, but now I'm behaviour that I can't determine the cause. When a user
attempts to log into exchange via the HTTP/RPC connector in Outlook, they
are first asked to provide username and password with the usual popup box.
Everything seems ok, and "Trying to connect..." stage shows. Soon after, it
Disconnects. Then tries again. Then disconnects. Then tries again. This
has been repeatable from different locations, with different laptops at
different times. So, I believe this is a setting problem,...selection and visibility, lost charts
Chart 1 appears in the selection and visibilty window, however I can't
locate it. Decreased magnification, print preview, and toggled the eye on
and off. Help.
...Excel on the web #3
I am trying to put excel worksheets on my website and want
visitors to be able to open them as excel. In Netscape
only the code appears and in Explorer it opens but in
Explorer. The word files open word and the files look
fine in both Netscape and Excel. I have tried it on
different computers, MAC's, etc. but nothing. Is there a
way to do this or have the excel file download?
I have my users Right Click the mouse button and use the options there. (IE
You may be able to look at the MIME area of Internet Explorer and see if you can change how IE reacts. Maybe turn off th...