newbie help - refresh forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lex - 20 Apr 2006 00:58 GMT

Hello. I'm sure that this is a common issue, but I was unable to find a
good solution. I have a multiuser (~3 users at most) database which has
a Welcome form. This form has comboboxes to Add and Edit records. If
one user Adds a record, and another has already selected the Edit
Combobox, the 2nd users Edit Combobox will not refresh on click to show
the new record. I figured I could Requery OnClick (I *believe* the
OnClick event of the Combobox is the best solution, as it would Requery
for every click), but that doesn't work. I also read that I could
Requery on the OnClose event of the AddRecord form - but this doesn't
*seem* to work either. I tried the MouseDown - but then the Combobox
wouldn't save the value I want used to open the EditRecord form. Anyhow
- I'm getting frustrated, and have seen talk of problems with Access
and multiusers. Does anyone have suggestions?

Thanks
Lex

Reply to this Message

Keith Wilby - 20 Apr 2006 11:33 GMT

> Hello. I'm sure that this is a common issue, but I was unable to find a
> good solution. I have a multiuser (~3 users at most) database which has
[quoted text clipped - 9 lines]
> - I'm getting frustrated, and have seen talk of problems with Access
> and multiusers. Does anyone have suggestions?

More info required. Is your app split and does each user have their own
copy of the front end? I must admit that using a combo box to add a record
seems a little odd to me. How about using a command button with a "refresh"
command after the "add new"?

Keith.
www.keithwilby.com

Reply to this Message

Lex - 20 Apr 2006 18:30 GMT

Thank you for your help, Keith. The combobox allows the user to choose
which record in another table (Test table) to associate with the New
record (in the Contractor Table). Something I didn't state in my
previous post is that I *believe* the requery has to be a property of
the Welcome form, because if it is a property of the AddNewContractor
form, I don't *think* it would propogate back to any other user that
simply is sitting there with the Welcome form open. This is why I tried
to do it on the OnClick event of the Combobox.

Thanks again. Your help is GREATLY appreciated.
Lex

Reply to this Message

david epsom dot com dot au - 21 Apr 2006 03:06 GMT

It doesn't matter how you re-query: you can't see the new
record until it is written from the other computer back
to server file.

Write back happens automatically after about 5 seconds

Refresh does not collect new records. You have to actually
requery.

Requery sometimes is optimised out on those controls.

If the record still does not appear after 5 seconds,
check the record count of the control - that forces a
real requery in cases where requery does not work.

If you need it faster, you need to force the write back,
either by flushing the cache or by using synchronous updates.

(david)

> Hello. I'm sure that this is a common issue, but I was unable to find a
> good solution. I have a multiuser (~3 users at most) database which has
[quoted text clipped - 12 lines]
> Thanks
> Lex

Reply to this Message

Lex - 21 Apr 2006 11:45 GMT

Thank you, David. I *think* I've got it - I did a Form.Refresh on the
On Mouse Down event of the combobox - and it seems to work on my
network! I guess I'll have to add this to all comboboxes so that my 3
users will see eachothers work. I tried to change the Refresh rate in
Options - but that didn't work - do you know why? I'm probably not
understanding you correctly, as I thought refresh wouldn't requery -
but it seems to.

I'm really a rookie, and some of the terms you've mentioned are over my
head. Can you point me to suggested reading on flushing the cache or
using synchronous updates?

Thanks again

Reply to this Message

david@epsomdotcomdotau - 21 Apr 2006 14:36 GMT

to flush the cache:
application.DBEngine.Idle 8 'dbRefreshCache

To reduce the page time out,
application.DBEngine.SetOption(6,1000) 'dbPageTimeout

have a look in help at the other dbengine options.

(david)

> Thank you, David. I *think* I've got it - I did a Form.Refresh on the
> On Mouse Down event of the combobox - and it seems to work on my
[quoted text clipped - 9 lines]
>
> Thanks again

Reply to this Message