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
Automatic Requery of Form??
- Thread starter simo7923
- Start date
S
siwy
Guest
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
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
missinglinq
AWF VIP
- Local time
- Today, 13:11
- Joined
- Jun 20, 2003
- Messages
- 6,420
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
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.
Similar threads
