A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Refresh versus Requery



 
 
Thread Tools Display Modes
  #1  
Old January 20th, 2005, 10:38 AM
an
external usenet poster
 
Posts: n/a
Default 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  
Old January 20th, 2005, 11:14 AM
JohnFol
external usenet poster
 
Posts: n/a
Default

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  
Old January 20th, 2005, 01:06 PM
an
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 05:41 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.