[AccessD] Synchronizing two subforms

Rocky Smolin rockysmolin at bchacc.com
Wed Apr 12 12:12:04 CDT 2017


Bill:

I don't think filtering the right hand form to one record will satisfy the
client.  It should look more or less like a spreadsheet with the first six
columns frozen so as it's scrolled vertically, the dates running out to the
right stay in synch with the course data on the left. 


Rocky
'
-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Bill Benson
Sent: Wednesday, April 12, 2017 10:01 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Synchronizing two subforms

Rocky, can the right-hand form be filtered to just the active record on the
left form? If so, I would actually put it under the 1st continuous form, and
in the On_Current event of the 1st child form, refresh the 2nd child form.

On Wed, Apr 12, 2017 at 12:38 PM, Rocky Smolin <rockysmolin at bchacc.com>
wrote:

> Dear List(s):
>
>
>
> A client has a requirement for a Gantt chart which would be a piece of 
> cake to automate out of the back end - the first six columns would be 
> frozen and so scrolling to the right would keep those first six in view.
>
>
>
> However, he wants it in a form inside the front end.  So my first 
> design thought was to make two continuous sub-forms - the left one 
> would be the first six fields, the right one would be dates with 
> colors and notes describing the status of various tasks.
>
>
>
> The records to be displayed are courses given all over the country for 
> CPA's continuing education.
>
>
>
> The problem is that as the left subform was scrolled vertically to 
> show more courses, the right one should keep pace so the records on 
> either side stay aligned.  But I'm not sure how to do that.
>
>
>
> Or is there's another approach using one form but would keep those 
> first six fields on the display while the user scrolled to the right 
> to display more calendar.
>
>
>
> Any ideas?
>
>
>
> MTIA,
>
>
>
>
>
> Rocky Smolin
>
> Beach Access Software
>
> 760-683-5777
>
>  <http://www.bchacc.com> www.bchacc.com
>
>  <http://www.e-z-mrp.com> www.e-z-mrp.com
>
> Skype: rocky.smolin
>
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list