Access Help

[Guest]

I am some what new to Access, I can create simple database and relationships
with ease. I have come into a problem where I have a field that a # gets put
into it and I want to make sure that when the # is entered if some one goes
back and tries to change it it will give the an "Are you sure you want to
change the laon #" Warning. Sounds like a Macro solve but how do I make it
specific to that field. Also I have a formula that calcutaltes days
outstanding. It is not staying update when I create new tables or queries.

Please help me

 

[John Vinson]

I am some what new to Access, I can create simple database and relationships
with ease. I have come into a problem where I have a field that a # gets put
into it and I want to make sure that when the # is entered if some one goes
back and tries to change it it will give the an "Are you sure you want to
change the laon #" Warning.

YOu cannot do this in a Table - tables have no usable events, and are
not intended to be used for data entry. What you can do is to base a
Form on the table, and put code on the form control's BeforeUpdate
event; click the ... icon by the Before Update line on the textbox's
Properties, invoke the Code Builder, and edit the two lines Access
will give you to something like

Private Sub mytextboxname_BeforeUpdate(Cancel as Integer)
Dim iAns As Integer
iAns = MsgBox("Are you sure you want to change the loan #?", vbYesNo)
If iAns = vbNo Then
Cancel = True ' cancel the update
Me.mytextboxname.Undo ' erase the user's changes
End If
End Sub

Sounds like a Macro solve but how do I make it
specific to that field. Also I have a formula that calcutaltes days
outstanding. It is not staying update when I create new tables or queries.

Since we have no way to know what your formula is, nor how you're
using it, it's more than a bit difficult to help you here - other than
to say that if you have a calculation, DON'T store it in any table;
recalculate it in a Query or Form as needed.

John W. Vinson[MVP]

 

[susiedba]

you could do this in a table if you used an Access Data Project.

ADP has triggers; MDB is for retards and lepers