R
Rick
When I open my 'Clients' form in AC2003 the controls load from the recordset
in the underlying query. One of the fields is LastDateOfContact (short date
format). I use a tab control in the form and within the tabs I have
subforms. One of these subforms is a calendar which displays course dates
attended (by looping throught the Attendance table and setting the date
buttons to red for dates attended). The user can update the Client's
attendance by toggling the buttons on and off. The LastDateOfContact is
updated at this time using dbs.execute (a SQL string).
Here's the issue. If I return to the main tab of the form where the
LastDateOfContact is displayed it has not updated. This is to be expected
since I havent moved off the record. If I move off (to another Client
record) the return, the updated date is displayed. BUT, if I update a Client
and do not return, then exit (close) the database, then go to the backend
tables (tables are split) the record has not been updated. HOWEVER, if I the
run the Clients form and go to the Client in question the record has been
updated.
It seems that the update only occurs when the Client form is opened again
following the update. This d/b has been running well for 4 years and I just
now discovered this when we started running Crystal Reports against the
tables. One user runs the d/b, updates the attendance for a client, closes
the d/b then runs the CR and the new data is not there. So they go back to
the d/b, open the client and, voila!, it is there.
How does the update process work? I am not using a recordset clone (although
maybe I should) but are the records maintained in hidden system tables?
By the way, I am developing/maintaining the d/b in Access2007 but keeping
the d/b in 2003 format. Would this have anything to do with it? And, in
2007, how do you show the hidden system files??
Thanks for your advice.
...Rick
in the underlying query. One of the fields is LastDateOfContact (short date
format). I use a tab control in the form and within the tabs I have
subforms. One of these subforms is a calendar which displays course dates
attended (by looping throught the Attendance table and setting the date
buttons to red for dates attended). The user can update the Client's
attendance by toggling the buttons on and off. The LastDateOfContact is
updated at this time using dbs.execute (a SQL string).
Here's the issue. If I return to the main tab of the form where the
LastDateOfContact is displayed it has not updated. This is to be expected
since I havent moved off the record. If I move off (to another Client
record) the return, the updated date is displayed. BUT, if I update a Client
and do not return, then exit (close) the database, then go to the backend
tables (tables are split) the record has not been updated. HOWEVER, if I the
run the Clients form and go to the Client in question the record has been
updated.
It seems that the update only occurs when the Client form is opened again
following the update. This d/b has been running well for 4 years and I just
now discovered this when we started running Crystal Reports against the
tables. One user runs the d/b, updates the attendance for a client, closes
the d/b then runs the CR and the new data is not there. So they go back to
the d/b, open the client and, voila!, it is there.
How does the update process work? I am not using a recordset clone (although
maybe I should) but are the records maintained in hidden system tables?
By the way, I am developing/maintaining the d/b in Access2007 but keeping
the d/b in 2003 format. Would this have anything to do with it? And, in
2007, how do you show the hidden system files??
Thanks for your advice.
...Rick