By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,176 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

How to update a table while the record is still open?

P: n/a
Hi All,

When a table is linked to a form, Access normally updates the entire table
when that record is closed. The fields don't get get updated in the table
as they become changed.

I've got multiple users accessing my database, so I need the fields in a
record to be updated immediately when they change. I cannot wait until the
user closes that record for the fields to be updated, as other users will
be using old data.

There must be a simple way to update the record fields as they get changed.
What am I missing here???

Thanks,
Norm
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Norm

me.dirty = true, or me.refresh will save a record. But if someone else
has the record open this will not be noted unless that form is
requeried or refreshed.

neil
Norm <od*****@comcast.net> wrote in message news:<Xn*******************************@216.196.97 .136>...
Hi All,

When a table is linked to a form, Access normally updates the entire table
when that record is closed. The fields don't get get updated in the table
as they become changed.

I've got multiple users accessing my database, so I need the fields in a
record to be updated immediately when they change. I cannot wait until the
user closes that record for the fields to be updated, as other users will
be using old data.

There must be a simple way to update the record fields as they get changed.
What am I missing here???

Thanks,
Norm

Nov 12 '05 #2

P: n/a
Thanks Neil!

What seems to be working well is if I do me.refresh whenever a field gets
the focus. The me.dirty automatically gets set to true. Is that the
typical way to handle this situation - to do a refresh on the getFocus
event?

Norm

ne***********@boroughmuir.edin.sch.uk (NeilAnderson) wrote in
news:83**************************@posting.google.c om:
Norm

me.dirty = true, or me.refresh will save a record. But if someone else
has the record open this will not be noted unless that form is
requeried or refreshed.

neil

Nov 12 '05 #3

P: n/a
Norm

I don't know about typical, but I use the requery method to reset a
combo box's recordsource based on various fields on a form on the
getFocus event a lot. The help file (access 97) says that a requery is
often faster than a refresh by the way - I've never noticed any
differnce!

Neil

Norm <od*****@comcast.net> wrote in message news:<Xn*******************************@216.196.97 .136>...
Thanks Neil!

What seems to be working well is if I do me.refresh whenever a field gets
the focus. The me.dirty automatically gets set to true. Is that the
typical way to handle this situation - to do a refresh on the getFocus
event?

Norm

ne***********@boroughmuir.edin.sch.uk (NeilAnderson) wrote in
news:83**************************@posting.google.c om:
Norm

me.dirty = true, or me.refresh will save a record. But if someone else
has the record open this will not be noted unless that form is
requeried or refreshed.

neil

Nov 12 '05 #4

P: n/a
Refresh and Requery are the opposite of each other.

Refresh updates the table(s) from the Form; Requery updates the Form
from
the table(s).

When a user enters data into a control on a Form, Refresh will send that
data
to the table. For another user to obtain the latest data from the
table, he/she
needs to use Requery.

To achieve the earliest update of new data, place Me.Refresh in the
AfterUpdate event of each control. Bit excessive but there is the least
delay.

If other users have that record open, they may need to do a Requery -
but will
they know when to do it??

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.