Automatic Requery of Form??

simo7923

Registered User.
Local time
Today, 22:28
Joined
Jul 21, 2003
Messages
15
I've set up a form comprising of several combo boxes nad free text fields. Now, 8 people run the same form at the same time and are constantly entering new records and need to see other peoples records. I'm not too sure if i can set the system up to refresh the database automatically. Using the 'shift-f9' for a requery works fine but i cant get my head round it as i'm self teaching at the moment. All i would like is the database to basically requery every couple of minutes if i could. Cheerz guys
 
refrsh problem

Hi

I think I may *have* s solution for you as I have a similar problem with refreshing but in a single user environment.

Access defaults to 60 updates in multi user environment


Go to

TOOLS
OPTIONS
ADVANCED

then chnage the settings for refresh intervals or something in this panel.

Hope this helps

Paul
 
The below is straight from Access Help (entered "form update"), always a great place to start looking.

Change how often data is updated automatically in an Access database in Datasheet or Form view
Open a table, query, or form in Datasheet view, or a form in Form view.


Click Options on the Tools menu.


Click the Advanced tab.


In the Refresh Interval box, type the number of seconds you want between each automatic update of data. For example, if you type 120, the data is updated every 2 minutes.
Note This setting takes effect only if the database is shared on a network. It updates only data that already exists in your datasheet or form. It doesn't reorder records, display new records, or remove deleted records and records that no longer meet specified criteria. To perform those actions, requery the records by pressing SHIFT+F9.

The Missinglinq
 
I tried this at first and found (as it says in access help) thaqt this will only refresh any existing records that have been changed and will not refresh the database with any new records. It will not add the records to anyone elses version unitl they hit 'shift-f9' or restart the application.
 

Users who are viewing this thread

Back
Top Bottom