Trying to create a interest rate tracker for a mortgage co. in acc

[Kyle]

I am currently working on a new project at work and want to do it in access.
I currently have a table with the consumers information and i was wondering
how to set up something to alert the user when a certian number appears in my
"targeted rate" column. It could be a flash to read or a pop-up notification
when you open the program. Also importing daily rates will be a problem and I
have no idea of where to start with that other than finding the daily rates.

Heres the plan:
Create a database that can upload daily rates onto the program, and flash
alerts when a certian rate hits for a certian consumer in the database
This will be used for consumers that would want to refinance their loans and
mortgages or want to lower their monthly payments. In most of these cases
these plans will only work when a certian interest rate hits the market.
I have been using two main columns on my table. [Current Rate] and [Targeted
Rate] The [current rate] column will be the rate that the consumer is
currently paying on thier loan or mortgage. The [Targeted Rate] will be the
rate that the mortgage company feels that they can help the consumer at. The
rates change everyday so you can see how this will be very useful for the
company.

Right now I have been fooling around with the validation numbers (rule and
text) and I have the basic plan in place. I just have to figure out how to
alert the user onthe updated rates and how to import the daily data into the
database.

Any help is appriciated

 

[Madhan]

If the user uses this application in your PC, then you can display a message
box with the appropriate message. If the user is on another PC and does not
access this application directly, then you may need to send messages using
any one of the VBA Messaging systems. You can find help about VBA messaging
in the internet.

 

[Kyle]

I actually also need help on trying to change colors in the boxes if anybody
could send the code for boxes in forms so far i have:

Private Sub TargetRate_AfterUpdate()

If IsNull(ContactTitle) = True Then
ContactTitle.BackColor = vbRed
Else
ContactTitle.BackColor = vbWhite
End If

End Sub

Private Sub Form_Current()

If IsNull(ContactTitle) = True Then
ContactTitle.BackColor = vbRed
Else
ContactTitle.BackColor = vbWhite <-------- ACCESS SAYS THERE IS A
PROBLEM HERE
End If

End Sub

If the user uses this application in your PC, then you can display a message
box with the appropriate message. If the user is on another PC and does not
access this application directly, then you may need to send messages using
any one of the VBA Messaging systems. You can find help about VBA messaging
in the internet.

I am currently working on a new project at work and want to do it in access.
I currently have a table with the consumers information and i was wondering
how to set up something to alert the user when a certian number appears in my
"targeted rate" column. It could be a flash to read or a pop-up notification
when you open the program. Also importing daily rates will be a problem and I
have no idea of where to start with that other than finding the daily rates.

Heres the plan:
Create a database that can upload daily rates onto the program, and flash
alerts when a certian rate hits for a certian consumer in the database
This will be used for consumers that would want to refinance their loans and
mortgages or want to lower their monthly payments. In most of these cases
these plans will only work when a certian interest rate hits the market.
I have been using two main columns on my table. [Current Rate] and [Targeted
Rate] The [current rate] column will be the rate that the consumer is
currently paying on thier loan or mortgage. The [Targeted Rate] will be the
rate that the mortgage company feels that they can help the consumer at. The
rates change everyday so you can see how this will be very useful for the
company.

Right now I have been fooling around with the validation numbers (rule and
text) and I have the basic plan in place. I just have to figure out how to
alert the user onthe updated rates and how to import the daily data into the
database.

Any help is appriciated

 

[Kyle]

I'm actually now looking at how to display a pop-up notification if two
fields are within a certian close value of eachother. Is there any code for
this at all?

I actually also need help on trying to change colors in the boxes if anybody
could send the code for boxes in forms so far i have:

Private Sub TargetRate_AfterUpdate()

If IsNull(ContactTitle) = True Then
ContactTitle.BackColor = vbRed
Else
ContactTitle.BackColor = vbWhite
End If

End Sub

Private Sub Form_Current()

If IsNull(ContactTitle) = True Then
ContactTitle.BackColor = vbRed
Else
ContactTitle.BackColor = vbWhite <-------- ACCESS SAYS THERE IS A
PROBLEM HERE
End If

End Sub

If the user uses this application in your PC, then you can display a message
box with the appropriate message. If the user is on another PC and does not
access this application directly, then you may need to send messages using
any one of the VBA Messaging systems. You can find help about VBA messaging
in the internet.

I am currently working on a new project at work and want to do it in access.
I currently have a table with the consumers information and i was wondering
how to set up something to alert the user when a certian number appears in my
"targeted rate" column. It could be a flash to read or a pop-up notification
when you open the program. Also importing daily rates will be a problem and I
have no idea of where to start with that other than finding the daily rates.

Heres the plan:
Create a database that can upload daily rates onto the program, and flash
alerts when a certian rate hits for a certian consumer in the database
This will be used for consumers that would want to refinance their loans and
mortgages or want to lower their monthly payments. In most of these cases
these plans will only work when a certian interest rate hits the market.
I have been using two main columns on my table. [Current Rate] and [Targeted
Rate] The [current rate] column will be the rate that the consumer is
currently paying on thier loan or mortgage. The [Targeted Rate] will be the
rate that the mortgage company feels that they can help the consumer at. The
rates change everyday so you can see how this will be very useful for the
company.

Right now I have been fooling around with the validation numbers (rule and
text) and I have the basic plan in place. I just have to figure out how to
alert the user onthe updated rates and how to import the daily data into the
database.

Any help is appriciated