Re: multi-user combo-box refresh not working

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Glynn,

Nobody said that going to a split database will cure this particular
problem; that is PROBABLY NOT the case. Splitting the database, and giving
each user their own copy of the front end will make it much less likely that
your database will lock up and result in data corruption.

See the following for more info on this subject:
http://www.members.shaw.ca/AlbertKallal/Articles/split/
http://office.microsoft.com/en-us/access/HA102400961033.aspx
http://www.allenbrowne.com/ser-01.html

Without a little more information, it's hard to determine what is going on,
but since you are hiding that form between uses, you might consider using
the forms Activate event to either requery or refresh the control in
question. If that doesn't work, post back with more information about the
form in question (describe the various controls, what they do, and how they
affect one another (include SQL statements for the record / row source of
the various controls).

HTH
Dale

"wineguy via AccessMonster.com" <u48580@uwe> wrote in message
news:8fee340979c04@xxxxxx
Dale Fye wrote:
I agree with Tina. Split your database and provide each user with their
own
front end. Having multiple users running the same un-split application is
a
recipe for data corruption.

On which machine is the refresh not working? Unfortunately, the refresh
only work for the user whose application executes it. It does not refresh
the data for both users, so you need to add some mechanism in your code to
refresh whichever control or form this is affecting on a regular basis.
You
might put this in a timer event, although I think that would be overkill.
Another solution might be to put it in the afterupdate event of the
control
where you select the item.

I've read through a number of posts and tried many of the ideas &
suggestions.
.. apart from splitting the database, which is not a preferable option
at
[quoted text clipped - 13 lines]

glynn


I do appreciate the feedback... the refresh only works on each individual
pc..
i.e. if user A selects an item, the item qty is reflected after update and
user A sees that adjustment upon re-selecting the combo-box... the problem
is
user B only sees that update when user B's control is directed back to a
main
screen (the combo-box form is never closed, just made non-visible)...
therefore, if user A and user B remain on the same form with the combo
box,
each user doesn't see the other's activity... a requery and refresh was
put
on the combo-box events for the following: on click, got focus, before
update,
and after update... a requery and refresh was also put on the form's after
update... it's hard for me to believe that access as a single instance
can't
work for this situation and I'm doing something fundamentally wrong... but
it
also is somewhat disconcerting that going to a split database will fix the
problem... maybe I'm just being naive... also, I'm using Access 2007 on
the
latest version of XP.... again many thanks for assitance or thoughts...
glynn

--
Message posted via http://www.accessmonster.com



.

Quantcast