Comments

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table in a subform that allows for memo text or comments. There is
a date associated with this entry and the user can view all comments in a
report where the entries appear chronologically. The date field has the
default of today's date but the user can erase and enter a different
date...they frequently have to enter data days later than the event. The
comments are numbered and it was discovered that a date 6/22 was found for
entry #4 and the date 7/05 was found as entry #3. The user swore that they
have not entered it late and adjusted the date. How did this happen? Since
the report still gives the comments in chronological order, I am not
concerned but wondering how it happened?
Thanks!
 
How do you determine which is entry #3 and #4? How are they numbered? If
autonumbers, they are not guarenteed to be sequential.

When dealing with users.
Rule #1: They lie.
Rule #2: When the swear that they didn't, see Rule #1.
Rule #3: When proficient at #1 and #2, they become management.
 
(Smiling) Yes, indeed. I discovered that the form was ordered by the
autonumbers (it is helpful to know that autonumbers are not guaranteed to be
sequential!) and I have changed the form to be ordered by entry date for the
comments so even if they enter a comment on 7/10 and change the date to 6/22
when they return to the form it will look as though they entered it on the
date listed. Thanks! Ya havta laugh with Access users or you are doomed.
 
Back
Top