If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Refresh versus Requery
Hello!
I have Form, SubForm and SubSubForm. When change data in SubSubForm, not refresh data in SubForm and Form. Which the difference between: Refresh versus Requery, please? Help will not be very enlightening. Thanks in advance. an |
#2
|
|||
|
|||
Straight from querying "Refresh Requery" in the Help screens .. . .
" Refresh or requery data Show All Hide All If you are using a Microsoft Access project (Microsoft Access project: An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects such as tables and views.), or a Microsoft Access database (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose. The Microsoft Jet database engine manages the data.) that's shared on a network, other users could be changing data while you are viewing the same data in a datasheet or form. Microsoft Access updates the data you see at regular intervals. However, you can immediately display the most current data by refreshing the records. In an Access database (.mdb), refreshing records only updates the 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 tasks, requery the records. " "an" wrote in message ... Hello! I have Form, SubForm and SubSubForm. When change data in SubSubForm, not refresh data in SubForm and Form. Which the difference between: Refresh versus Requery, please? Help will not be very enlightening. Thanks in advance. an |
#3
|
|||
|
|||
Thanks for your reply.
an -----Original Message----- Straight from querying "Refresh Requery" in the Help screens .. . . " Refresh or requery data Show All Hide All If you are using a Microsoft Access project (Microsoft Access project: An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects such as tables and views.), or a Microsoft Access database (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose. The Microsoft Jet database engine manages the data.) that's shared on a network, other users could be changing data while you are viewing the same data in a datasheet or form. Microsoft Access updates the data you see at regular intervals. However, you can immediately display the most current data by refreshing the records. In an Access database (.mdb), refreshing records only updates the 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 tasks, requery the records. " "an" wrote in message ... Hello! I have Form, SubForm and SubSubForm. When change data in SubSubForm, not refresh data in SubForm and Form. Which the difference between: Refresh versus Requery, please? Help will not be very enlightening. Thanks in advance. an |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Complex Query (was: Refresh vs. requery vs. Remove Filter in FormsCoding NG) | rgrantz | Running & Setting Up Queries | 1 | November 23rd, 2004 01:59 AM |
Refresh w/out Requery? | Jerry Crosby | Using Forms | 4 | November 22nd, 2004 06:23 PM |
Diff between refresh & requery | Andrew Backer | Using Forms | 2 | August 9th, 2004 10:21 PM |
A macro to open files, refresh data, and close file in background? | Don Guillett | Worksheet Functions | 1 | May 5th, 2004 12:20 PM |
A macro to open files, refresh data, and close file in background? | denisecook | Worksheet Functions | 1 | May 4th, 2004 03:16 PM |