Function RATE does not work

[Guest]

I am programing in Access using VB. I want to use the function RATE. VB does
not recognise RATE. When I type in "RATE( "it should prompt me for the
arguements. It does not. If I type PMT or PV or FV or etc. they all work but
it is as if RATE is not part of the program yet the HELP section says it
should. Have you ever experienced anything like this? I need a solution.
Thank You, John

 

[David C. Holley]

I'm running Access 2004 and its there when I try it in the immediate
window. Have you tried it in the immediate window to ensure that its not
something related to the code?

David H
Come on baby light my fire: www.spreadFireFox.com

 

[Ken Snell [MVP]]

I'm running Access 2004

ACCESS 2004? Must be a knockoff version.. MS hasn't released an ACCESS 2004
version.

 

[Ken Snell [MVP]]

Your references may be messed up.

Try following these steps (from a post by Douglas Steele, MVP):

This can be caused by differences in either the location or file version of
certain files between the machine where the application was developed, and
where it's being run (or the file missing completely from the target
machine). Such differences are common when new software is installed.

On the machine(s) where it's not working, open any code module (or open the
Debug Window, using Ctrl-G, provided you haven't selected the "keep debug
window on top" option). Select Tools | References from the menu bar. Examine
all of the selected references.

If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need the reference(s) you
just unselected (you can tell by doing a Compile All Modules), go back in
and reselect them.

If none have "MISSING:", select an additional reference at random, back out
of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected. (NOTE: write down what the references are before you delete
them, because they'll be in a different order when you go back in)

For far more than you could ever want to know about this problem, check out
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

 

[David C. Holley]

Oh really, must be why its running so well and never craps out.

David H

Its Access 2003.

 

[Ken Snell [MVP]]

Could be < g >
--

Ken Snell
<MS ACCESS MVP>

Oh really, must be why its running so well and never craps out.

David H

Its Access 2003.

 

[Guest]

Thanks David. I do not know what an immediate window is. I just know that I
can use the function PMT and it works but when I use RATE on the same window
it does not work. hmmmmm!

 

[Guest]

Ken, Thank You. You have given me something to check out. Obviously you are
more advanced than I am. I will try to follow your directions and see if I
can figure it out. You have told me things that I have never done before. I
will mess with it a little later today. Thanks again.

 

[Dirk Goldgar]

I am programing in Access using VB. I want to use the function RATE.
VB does not recognise RATE. When I type in "RATE( "it should prompt
me for the arguements. It does not. If I type PMT or PV or FV or etc.
they all work but it is as if RATE is not part of the program yet the
HELP section says it should. Have you ever experienced anything like
this? I need a solution. Thank You, John

In addition to the other comments, it may be that you have a field or
variable that is named Rate, and Access thinks that's what you are
referring to when you type RATE. If the VB editor automatically
captializes "rate" to "RATE" when you type it in, that's almost
certainly the case.

 

[David C. Holley]

Ahhh, so you're new to Access VBA. You'll want to purchase the Access
Developer's Handbook. Here's a URL to the 2002 Version...

http://www.amazon.com/exec/obidos/A...7/sr=2-1/ref=pd_bbs_b_2_1/002-7556224-0606455

I highly recommend it.

David H

 

[Brendan Reynolds]

Do you have anything in your database named 'Rate' - for example a field in
a table or a variable in your code? If so, try renaming it.

 

[Guest]

Dear Mr. Ken,

I wanted to thank you for responding to my Rate Function question of a
couple days ago. If you will remember I could not get the Rate Function to
work while all my other money functions worked. Your answer was way over my
head so I stalled trying to go your route. I got back to my programing today
and just happened to stumble upon the answer.

I had named one of my textboxes or fields "Rate" which must have short
circuited the Rate Function. I renamed that field to Rate1008 and I now have
my Rate Function back. That is probably what you were telling me to do in a
more technological way.

I pass this along to you so that you might included this in any help you
might offer in the future.

Tanks again!

 

[Guest]

Dear Mr. Dirk

You were right on the money. Thank you for your response. I have learned
something new. Thank you sir!

 

[Guest]

Dear Mr Brendan,

You were right on the money. I had a field named Rate. I renamed it Rate1008
and I got my Rate Function back.

Thank you sir!

 

[Ken Snell [MVP]]

Glad you found the problem. What I'd posted was not that solution, so I'm
glad that you got additional help from my fellow MVPs.