[AccessD] Continuous form on a continuous form

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Fri Jun 18 11:33:00 CDT 2004


Ken:

Thank you.  I'll run this by the client and see if datasheet view (which is
ugly but functional) is acceptable.

Regards,

Rocky Smolin
Beach Access Software
http://www.e-z-mrp.com


----- Original Message ----- 
From: "Ken Ismert" <KIsmert at TexasSystems.com>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Friday, June 18, 2004 8:42 AM
Subject: RE: [AccessD] Continuous form on a continuous form


>
> Rocky,
>
> Sure you can do it - it's called SubDatasheets - introduced in A2K.
>
> Both the parent and sub forms must have their Default View set to
Datasheet.
> On the SubForm control, you link Child and Master fields just like any
> other. The parent datasheet can be a subform as well. You can nest
> subdatasheets at up to 8 deep.
>
> What you get is a tree-like hierarchy where you can expand the subdata by
> clicking on the + next to the parent record.
>
> As long as you are willing to live with the Datasheet view, this solution
> fits the bill.
>
> -Ken
>
> -----Original Message-----
> From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com]
> Sent: Thursday, June 17, 2004 6:46 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Continuous form on a continuous form
>
>
> So if I don't really like this client then this is the design I'm looking
> for?
>
> Rocky
>
> ----- Original Message -----
> From: "Christopher Hawkins" <clh at christopherhawkins.com>
> To: <accessd at databaseadvisors.com>
> Sent: Thursday, June 17, 2004 2:57 PM
> Subject: RE: [AccessD] Continuous form on a continuous form
>
>
> > Placing a continuous form on a continuous form will open up an
> > interdimensional vortex that will suck you, your app, and your users
> > into it, never to be seen again.
> >
> > A similar effect happens in your clothes dryer, which is why your
> > socks are always disappearing.  ;)
> >
> > -C-
> >
> > ---- Original Message ----
> > From: bchacc at san.rr.com
> > To: AccessD at databaseadvisors.com,
> > Subject: RE: [AccessD] Continuous form on a continuous form
> > Date: Thu, 17 Jun 2004 12:39:22 -0700
> >
> > >Dear List:
> > >
> > >I have been chastised by Access that I can't put a continuous form
> > >on a continuous form.  OK.  Is there some way around this
> > >restriction?
> > >
> > >For example, you want to show purchase order header information
> > >followed by lines of the purchase order detail.  But you want to be
> > >able to scroll up and down showing the header followed by the detail
> > >for all the POs in your system.
> > >
> > >Any clever tricks to do this or even simulate it?
> > >
> > >MTIA
> > >
> > >Rocky Smolin
> > >Beach Access Software
> > >http://www.e-z-mrp.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
>
>
>
> -- 
> _______________________________________________
> 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