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 » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Update linked field immediately from form



 
 
Thread Tools Display Modes
  #1  
Old June 25th, 2009, 04:27 PM posted to microsoft.public.access
gg
external usenet poster
 
Posts: 86
Default Update linked field immediately from form

This is probably simple, but I can't seem to get around it. I have a form
that is sourced to a query. The query main source is a linked to table in
another db file that sources a similar form in that file.

When I make a change on a form in either file, I would like it to show on
the form in the linked file immediately. The only way that I can seem to do
that is to close the form that I just updated, then go to the other file and
open the desired form . What code (onUpdate?) or whatever else do I have to
do to make the change show up immediately in the linked file's form without
closing and opening? I am using Ac2000 with W2000. Thanks in advance for
any help.
  #2  
Old June 25th, 2009, 05:09 PM posted to microsoft.public.access
Shannon Bini
external usenet poster
 
Posts: 1
Default Update linked field immediately from form


"gg" wrote in message
...
This is probably simple, but I can't seem to get around it. I have a form
that is sourced to a query. The query main source is a linked to table in
another db file that sources a similar form in that file.

When I make a change on a form in either file, I would like it to show on
the form in the linked file immediately. The only way that I can seem to
do
that is to close the form that I just updated, then go to the other file
and
open the desired form . What code (onUpdate?) or whatever else do I have
to
do to make the change show up immediately in the linked file's form
without
closing and opening? I am using Ac2000 with W2000. Thanks in advance for
any help.


  #3  
Old June 25th, 2009, 05:26 PM posted to microsoft.public.access
gg
external usenet poster
 
Posts: 86
Default Update linked field immediately from form

Shannon-Typo? this is just a repeat of my question.

"Shannon Bini" wrote:


"gg" wrote in message
...
This is probably simple, but I can't seem to get around it. I have a form
that is sourced to a query. The query main source is a linked to table in
another db file that sources a similar form in that file.

When I make a change on a form in either file, I would like it to show on
the form in the linked file immediately. The only way that I can seem to
do
that is to close the form that I just updated, then go to the other file
and
open the desired form . What code (onUpdate?) or whatever else do I have
to
do to make the change show up immediately in the linked file's form
without
closing and opening? I am using Ac2000 with W2000. Thanks in advance for
any help.


  #4  
Old June 25th, 2009, 05:55 PM posted to microsoft.public.access
Clifford Bass[_2_]
external usenet poster
 
Posts: 1,295
Default Update linked field immediately from form

Hi,

So, do I understand that you have both databases open at the same time?
And want changes made to the second database, while you are in the first
database, to then show up in the second database? If that is the case, you
may want to set up a timer on the form in the second database's form. Maybe
set to requery every minute or so. In the On Timer event you could then do a
Requery. Note that this can be somewhat problematic as you will want to test
to see if the current record being displayed is being edited. In which case
you should not do the requery. Very annoying to the user. After the requery
you may also want to make sure you are repositioned onto the same record as
before the requery. As an alternative, you could just add a "Requery" button
to the form that the user can click whenever the user desires to see changes
made elsewhere. Requery is useful when new records may be added. If the
only changes that are being made through the first database are updates, you
could do a Refresh instead. That will refresh the data in the current set of
records being displayed. Note that Access does an automatic refresh
periodically anyway.

Hope that helps,

Clifford Bass

"gg" wrote:

This is probably simple, but I can't seem to get around it. I have a form
that is sourced to a query. The query main source is a linked to table in
another db file that sources a similar form in that file.

When I make a change on a form in either file, I would like it to show on
the form in the linked file immediately. The only way that I can seem to do
that is to close the form that I just updated, then go to the other file and
open the desired form . What code (onUpdate?) or whatever else do I have to
do to make the change show up immediately in the linked file's form without
closing and opening? I am using Ac2000 with W2000. Thanks in advance for
any help.

  #5  
Old June 25th, 2009, 06:47 PM posted to microsoft.public.access
gg
external usenet poster
 
Posts: 86
Default Update linked field immediately from form

Thank you for the quick replay and for covering the various possibilities. I
opted for the refresh button-works great.

"Clifford Bass" wrote:

Hi,

So, do I understand that you have both databases open at the same time?
And want changes made to the second database, while you are in the first
database, to then show up in the second database? If that is the case, you
may want to set up a timer on the form in the second database's form. Maybe
set to requery every minute or so. In the On Timer event you could then do a
Requery. Note that this can be somewhat problematic as you will want to test
to see if the current record being displayed is being edited. In which case
you should not do the requery. Very annoying to the user. After the requery
you may also want to make sure you are repositioned onto the same record as
before the requery. As an alternative, you could just add a "Requery" button
to the form that the user can click whenever the user desires to see changes
made elsewhere. Requery is useful when new records may be added. If the
only changes that are being made through the first database are updates, you
could do a Refresh instead. That will refresh the data in the current set of
records being displayed. Note that Access does an automatic refresh
periodically anyway.

Hope that helps,

Clifford Bass

"gg" wrote:

This is probably simple, but I can't seem to get around it. I have a form
that is sourced to a query. The query main source is a linked to table in
another db file that sources a similar form in that file.

When I make a change on a form in either file, I would like it to show on
the form in the linked file immediately. The only way that I can seem to do
that is to close the form that I just updated, then go to the other file and
open the desired form . What code (onUpdate?) or whatever else do I have to
do to make the change show up immediately in the linked file's form without
closing and opening? I am using Ac2000 with W2000. Thanks in advance for
any help.

  #6  
Old June 25th, 2009, 08:35 PM posted to microsoft.public.access
Clifford Bass[_2_]
external usenet poster
 
Posts: 1,295
Default Update linked field immediately from form

Hi,

Good, glad to hear it was helpful. And your are welcome.

Clifford Bass

"gg" wrote:

Thank you for the quick replay and for covering the various possibilities. I
opted for the refresh button-works great.

  #7  
Old July 8th, 2009, 04:25 PM posted to microsoft.public.access
denise
external usenet poster
 
Posts: 388
Default Update linked field immediately from form

How is the requery command different from "refresh all" button in Access 2007?

"Clifford Bass" wrote:

Hi,

So, do I understand that you have both databases open at the same time?
And want changes made to the second database, while you are in the first
database, to then show up in the second database? If that is the case, you
may want to set up a timer on the form in the second database's form. Maybe
set to requery every minute or so. In the On Timer event you could then do a
Requery. Note that this can be somewhat problematic as you will want to test
to see if the current record being displayed is being edited. In which case
you should not do the requery. Very annoying to the user. After the requery
you may also want to make sure you are repositioned onto the same record as
before the requery. As an alternative, you could just add a "Requery" button
to the form that the user can click whenever the user desires to see changes
made elsewhere. Requery is useful when new records may be added. If the
only changes that are being made through the first database are updates, you
could do a Refresh instead. That will refresh the data in the current set of
records being displayed. Note that Access does an automatic refresh
periodically anyway.

Hope that helps,

Clifford Bass

"gg" wrote:

This is probably simple, but I can't seem to get around it. I have a form
that is sourced to a query. The query main source is a linked to table in
another db file that sources a similar form in that file.

When I make a change on a form in either file, I would like it to show on
the form in the linked file immediately. The only way that I can seem to do
that is to close the form that I just updated, then go to the other file and
open the desired form . What code (onUpdate?) or whatever else do I have to
do to make the change show up immediately in the linked file's form without
closing and opening? I am using Ac2000 with W2000. Thanks in advance for
any help.

  #8  
Old July 8th, 2009, 06:46 PM posted to microsoft.public.access
Clifford Bass[_2_]
external usenet poster
 
Posts: 1,295
Default Update linked field immediately from form

Hi Denise,

Refresh All only updates the contents of the existing set of rows. So
if you open up a form and it displays say ten records, the refresh will
update only those ten records with changes made by other users. Deleted rows
will now show with #Deleted in the fields. New rows added by other users
will not show. It also does not reposition your location in the recordset.
So if you are on record three, you stay on record three.

Requery goes out and re-executes the original query used to get the set
of rows. New rows will now be included. Deleted rows will be removed.
Updated rows will of course show their updates. And finally, it repositions
you to the beginning of the set of records.

Clifford Bass

"Denise" wrote:

How is the requery command different from "refresh all" button in Access 2007?

 




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


All times are GMT +1. The time now is 12:06 AM.


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