Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old March 4th, 2006, 03:33 PM
Registered User
 
Join Date: Jan 2006
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Avoid 'jumping' in continous forms

I have 3 forms to manage people and groups. Form1 is the main form where I have a combobox to select which group to use. Form2 is a subform that lists all the people who are members of the selected group. Form3 is a subform that lists all the people who are not members of the selected group.

Form2 and Form3 are continuous forms. Form2 has a 'Remove'-button to drop people from the group and Form3 has a 'Add'-button to add people to the group.

Everything works quite well, when I add or drop a person from the selected group I refresh the current subform and requery the other subform.

When I refresh the current subform the cursor moves to the first record which can be pretty annoying if the user has to scroll down almost everytime there has been a refresh. My workaround is to use the recordsetclone to find the next row, and then I move to that row with DoCmd.FindRecord after the refresh. It works, but it's quite ugly since the list 'jumps' up/down depending on the situation.

In a perfect world I want the subform to be refreshed, the closest record selected and minimal vertical scroll whenever possible. Maybe I have to rethink the entire design... Any suggestions?
  #2 (permalink)  
Old March 6th, 2006, 10:14 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Without seeing the design, does Tab Order come into play (right click on the form, select Tab Order)?

HTH


mmcdonal
  #3 (permalink)  
Old March 6th, 2006, 04:54 PM
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

If you're sorting the lists by the person's name, your idea is great. I'm not quite sure about why the flickering occurs but here's one way to minimize it.

Sort the list by the descending date and time that the person was added to that particular list. In that way, the newest person will always be at the top of the list. When the subforms refresh, the person (and cursor) will always be at the top ANYWAY... no flicker. :D

Of course, if you want to sort by person name, then letting us see the design as MMcDonal asks may help.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
  #4 (permalink)  
Old March 7th, 2006, 04:05 AM
Registered User
 
Join Date: Jan 2006
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the feedback! I'll post some screenshots later, I'm at work right now :)

  #5 (permalink)  
Old March 7th, 2006, 05:15 PM
Registered User
 
Join Date: Jan 2006
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

http://www.avectris.com/jumping.gif

Here is a screenshot that shows the three forms. I have clicked the last row in the form to the right and the effect is shown in the bottom picture.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Jumping into java extensions to Saxon mphare XSLT 2 April 29th, 2008 10:02 PM
Continous Form, resize based on content (Tricky) hkmulligan Access 2 August 13th, 2007 12:02 PM
Is it possible to select record in continous form chiefouko Access VBA 0 July 18th, 2006 04:20 AM
Continous form problem Vince_421 Access VBA 10 June 1st, 2006 05:06 AM
Need help with dropdownlist jumping Tcook VB.NET 2002/2003 Basics 1 September 12th, 2004 09:48 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.