Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Continuous form refresh/requery in microsoft.public.access.formscoding
Started 1 month ago by slickdock
I have a continuous form, with the fields locked. In order to edit, the user clicks on a cmdButton in the left margin of the record they wish to edit. This opens a form in "single record view" for editing. When they close the single form view, I use REFRESH on the continous form to display changes they may have made to the ...
Site: Discussions in microsoft.public.access.formscoding  Discussions in microsoft.public.access.formscoding - site profile
Forum: microsoft.public.access.formscoding  microsoft.public.access.formscoding - forum profile
Total authors: 2 authors
Total thread posts: 4 posts
Thread activity: no new posts during last week
Domain info for: microsoft.com

Other posts in this thread:

Jack Leach replied 1 month ago
I use a recordsetclone of the subform to perform a FindFirst method on. Actually, I recently built a global function to handle "standard" record movements in a subform (first, last, previous, next, offset). Your question prompted me to write the below function, which will move to a given ID. You will still need to capture the ID ...
Size: 5,736 bytes
Customize:  Customize "<b>Reply 1</b>: Continuous form refresh/requery in microsoft.public.access.formscoding :: microsoft.public.access.formscoding :: Discussions in microsoft.public.access.formscoding"

Jack Leach replied 1 month ago
Well, come to think of it, this function won't help you because like an idiot I read too fast and assumed that you were working with a subform control. But, you can probably pull the recordsetclone/bookmark example from the function and fit to your needs. And for the record, it's not a good idea to count on an Autonumber ...
Size: 2,335 bytes
Customize:  Customize "<b>Reply 2</b>: Continuous form refresh/requery in microsoft.public.access.formscoding :: microsoft.public.access.formscoding :: Discussions in microsoft.public.access.formscoding"

Jack Leach replied 1 month ago
quick fix... '============================================== ================================ ' NAME: SubformGotoRecord ' AUTHOR: Jack D. Leach ' DATE: 11/6/2009 ' DESC: Moves the subform to a specified record ' Function is not yet set up to handle nested subforms - 1 layer only! ' ARGS: ' frm: ...
Size: 10 kb
Customize:  Customize "<b>Reply 3</b>: Continuous form refresh/requery in microsoft.public.access.formscoding :: microsoft.public.access.formscoding :: Discussions in microsoft.public.access.formscoding"

 

Top contributing authors

Name
Posts
Jack Leach
3
user's latest post:
Continuous form refresh/requery...
Published (2009-11-06 20:21:00)
&nbsp; quick fix... '============================================================================== ' NAME: SubformGotoRecord ' AUTHOR: Jack D. Leach ' DATE: 11/6/2009 ' DESC: Moves the subform to a specified record ' Function is not yet set up to handle nested subforms - 1 layer only! ' ARGS: ' frm: Form - parent form that holds the subform ' SubControlName: String - name of the subform...
slickdock
1
user's latest post:
Continuous form refresh/requery...
Published (2009-11-06 18:04:00)
&nbsp; I have a continuous form, with the fields locked. In order to edit, the user clicks on a cmdButton in the left margin of the record they wish to edit. This opens a form in &quot;single record view&quot; for editing. When they close the single form view, I use REFRESH on the continous form to display changes they may have made to the underlying record. That works fine...But when they add a NEW record, I'm having trouble...

Related threads on "Discussions in microsoft.public.access.formscoding":

Refresh/ Requery in microsoft.public.access.formscoding  Discussions in microsoft.public.access.formscoding - site profile microsoft.public.access.formscoding - forum profile Refresh/ Requery in microsoft.public.access.formscoding
Refresh/ Requery in microsoft.public.access.formscoding
Can't refresh/requery/repaint textboxes in...  Discussions in microsoft.public.access.formscoding - site profile microsoft.public.access.formscoding - forum profile Can't refresh/requery/repaint textboxes in microsoft.public.access.formscoding
Can't refresh/requery/repaint textboxes in microsoft.public.access.formscoding
Refresh, Requery, Repaint?? Which One? in...  Discussions in microsoft.public.access.formscoding - site profile microsoft.public.access.formscoding - forum profile Refresh, Requery, Repaint?? Which One? in microsoft.public.access.formscoding
Refresh, Requery, Repaint?? Which One? in microsoft.public.access.formscoding
Refresh/Requery combobox2 on combobox1 change in...  Discussions in microsoft.public.access.formscoding - site profile microsoft.public.access.formscoding - forum profile Refresh/Requery combobox2 on combobox1 change in microsoft.public.access.formscoding
Refresh/Requery combobox2 on combobox1 change in microsoft.public.access.formscoding
Repaint vs Refresh vs Requery in...  Discussions in microsoft.public.access.formscoding - site profile microsoft.public.access.formscoding - forum profile Repaint vs Refresh vs Requery in microsoft.public.access.formscoding
Repaint vs Refresh vs Requery in microsoft.public.access.formscoding
Not In List Event and Requery Errors in...  Discussions in microsoft.public.access.formscoding - site profile microsoft.public.access.formscoding - forum profile Not In List Event and Requery Errors in microsoft.public.access.formscoding
Not In List Event and Requery Errors in microsoft.public.access.formscoding
Subform Requery Doesn't Show Updates to Data in...  Discussions in microsoft.public.access.formscoding - site profile microsoft.public.access.formscoding - forum profile Subform Requery Doesn't Show Updates to Data in microsoft.public.access.formscoding
Subform Requery Doesn't Show Updates to Data in microsoft.public.access.formscoding
Viewing the current record after requery a form in...  Discussions in microsoft.public.access.formscoding - site profile microsoft.public.access.formscoding - forum profile Viewing the current record after requery a form in microsoft.public.access.formscoding
Viewing the current record after requery a form in microsoft.public.access.formscoding
Return to viewed record after requery in...  Discussions in microsoft.public.access.formscoding - site profile microsoft.public.access.formscoding - forum profile Return to viewed record after requery in microsoft.public.access.formscoding
Return to viewed record after requery in microsoft.public.access.formscoding
Requery Not Working in microsoft.public.access.formscoding  Discussions in microsoft.public.access.formscoding - site profile microsoft.public.access.formscoding - forum profile Requery Not Working in microsoft.public.access.formscoding
Requery Not Working in microsoft.public.access.formscoding

Related threads on other sites:

Pivot Table Refresh/Requery  Excel Help Forum - site profile Excel General - forum profile Pivot Table Refresh/Requery
Pivot Table Refresh/Requery
Refresh Requery Recalc ?  Dev Articles Forums - Programming Help and Tutorials for all developmenttechnologies - site profile Database Development - forum profile Refresh Requery Recalc ?
Refresh Requery Recalc ?
Repaint/Refresh/Requery too slow  MDBMakers.com - Powered by vBulletin - site profile Interface development - forum profile Repaint/Refresh/Requery too slow
Repaint/Refresh/Requery too slow
Difficulty getting a form to refresh/requery etc  MDBMakers.com - Powered by vBulletin - site profile Interface development - forum profile Difficulty getting a form to refresh/requery etc
Difficulty getting a form to refresh/requery etc
RecordSet Refresh / ReQuery  Xtreme Visual Basic Talk - site profile Database and Reporting - forum profile RecordSet Refresh / ReQuery
RecordSet Refresh / ReQuery
Refresh, requery, or what? in microsoft.public.access.forms  Discussions in microsoft.public.access.forms - site profile microsoft.public.access.forms - forum profile Refresh, requery, or what? in microsoft.public.access.forms
Refresh, requery, or what? in microsoft.public.access.forms
Can't refresh/requery/repaint textboxes in...  Discussions in microsoft.public.access.forms - site profile microsoft.public.access.forms - forum profile Can't refresh/requery/repaint textboxes in microsoft.public.access.forms
Can't refresh/requery/repaint textboxes in microsoft.public.access.forms
How do you refresh/requery a different for than you are...  Discussions in microsoft.public.access.forms - site profile microsoft.public.access.forms - forum profile How do you refresh/requery a different for than you are working on in microsoft.public.access.forms
How do you refresh/requery a different for than you are working on in microsoft.public.access.forms
How do we make the datagridview refresh(requery) if...  MSDN Forums - site profile Visual Basic Express Edition - forum profile How do we make the datagridview refresh(requery) if there's a new inserted row? - MSDN Forums
How do we make the datagridview refresh(requery) if there's a new inserted row? - MSDN Forums
Update/refresh/requery all fields in a form  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile Using Forms - forum profile Update/refresh/requery all fields in a form
Update/refresh/requery all fields in a form
Thread profile page for "Continuous form refresh/requery in microsoft.public.access.formscoding" on http://www.microsoft.com/communities/newsgroups.... This report page is a snippet summary view from a single thread "Continuous form refresh/requery in microsoft.public.access.formscoding", located on the Message Board at http://www.microsoft.com/communities/newsgroups.... This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity