[AccessD] Split form wizard

Susan Harkins ssharkins at gmail.com
Wed Nov 19 10:03:41 CST 2014


I'm thinking about this -- I'm wondering what the pros and cons are of
using the tabs to display subforms. It seems to complicate the whole
process, but the alternative might be a many-to-many relationship between
the necessary tables. There are four, so that could get a bit hairy.

Susan H.

On Wed, Nov 19, 2014 at 9:44 AM, Tony Septav <TSeptav at uniserve.com> wrote:

> Hey Susan
> Where applicable to a project I loved using the tabs. Some of the tabs had
> information that was static (enter once) other tabs would contain an
> embedded subform (most times a continuous form) to collect ongoing data.
> Again where applicable each tab would have it's own set of print buttons,
> eg. <Print History>, <Print Graph> etc, etc.  It became a no brainer "one
> stop shopping" for the client. They loved it everything was there in their
> face, no second guessing as what to do next. It was easy to use because it
> was intuitive.
>
> Tony Septav
> Nanaimo, BC
> Canada
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
> Sent: November-19-14 6:59 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Split form wizard
>
> In this case Tony, tabs might make good sense. Each animal has three sets
> of health related topics -- health exams, weight, and vaccines. I want to
> relieve the user of a lot of extra clicks to get there, regardless, so tabs
> seems like a good way to to. I'm thinking a tab for acquisition and
> disposition might be a good idea down the road too -- I already have those
> in place as individual forms, but in retrospect, yeah... they kind of go
> together -- the animal comes in, it leaves eventually.
>
> Susan H.
>
> On Tue, Nov 18, 2014 at 10:14 PM, Tony Septav <TSeptav at uniserve.com>
> wrote:
>
> > Hey Susan
> > It has been a long time since I responded to this list. I always used
> TABS
> > for multi-information forms.  I just found they provided a more intuitive
> > approach for the user.
> >
> > Tony Septav
> > Nanaimo, BC
> > Canada
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
> > Sent: November-18-14 5:59 PM
> > To: Access Developers discussion and problem solving
> > Subject: Re: [AccessD] Split form wizard
> >
> > I originally considered a set of tabs, but decided against them in the
> end,
> > but maybe I should reconsider them for this part -- worth thinking about.
> > Thank you for the reminder.
> >
> > Susan H.
> >
> > On Tue, Nov 18, 2014 at 5:58 PM, Charlotte Foust <
> > charlotte.foust at gmail.com>
> > wrote:
> >
> > > The tab control is your friend and is what I generally use for this
> > > purpose.  I don't know whether the navigation control was available in
> > > 2007.
> > >
> > > Charlotte
> > >
> > > On Tue, Nov 18, 2014 at 2:12 PM, Susan Harkins <ssharkins at gmail.com>
> > > wrote:
> > >
> > > > I'll check it out tomorrow Charlotte. At this point, I'm percolating
> > how
> > > to
> > > > combine three different "health" related topics into one form -- to
> > make
> > > > data entry, and my job, a bit easier. They'll enter general health
> > notes,
> > > > weight, and vaccines. I don't want to consider dumping them into one
> > > table,
> > > > but it would be so neat if I could display them all in one form.
> > Thinking
> > > > about it -- specify an animal and enter an item for any of these
> three
> > > > health-related items.
> > > >
> > > > Susan H.
> > > >
> > > > On Tue, Nov 18, 2014 at 1:38 PM, Charlotte Foust <
> > > > charlotte.foust at gmail.com>
> > > > wrote:
> > > >
> > > > > Don't know about 2007, but 2013 has a different take on "split
> > forms".
> > > > In
> > > > > 2013, a split form wizard is on the Create ribbon under More Forms
> > > > >
> > > > > Charlotte
> > > > >
> > > > > On Wed, Nov 5, 2014 at 8:00 AM, Susan Harkins <ssharkins at gmail.com
> >
> > > > wrote:
> > > > >
> > > > > > In 2003, you could base a form on a query with related tables in
> a
> > > > > > one-to-many relationship and one of the form wizards would help
> you
> > > > > create
> > > > > > a main/subform form. I can't find it in 2007 -- is it gone?
> > > > > >
> > > > > > Susan H.
> > > > > > --
> > > > > > 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
> > > >
> > > --
> > > 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
> >
> >
> > -----
> > No virus found in this message.
> > Checked by AVG - www.avg.com
> > Version: 2014.0.4765 / Virus Database: 4189/8593 - Release Date: 11/18/14
> >
> > -----
> > No virus found in this message.
> > Checked by AVG - www.avg.com
> > Version: 2014.0.4765 / Virus Database: 4189/8557 - Release Date: 11/11/14
> > Internal Virus Database is out of date.
> >
> > --
> > 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
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2014.0.4765 / Virus Database: 4189/8594 - Release Date: 11/18/14
>
> --
> 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