[AccessD] Synchronizing two subforms

Bill Benson bensonforums at gmail.com
Wed Apr 12 13:15:35 CDT 2017


Then use a bookmark and recordsetclone  might work but I don't know for
sure whether that forces the scroll to move for the form

>From my non-flammable Note 3,
Bill Benson

On Apr 12, 2017 1:13 PM, "Rocky Smolin" <rockysmolin at bchacc.com> wrote:

> 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
>
> --
> 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