[AccessD] Split form wizard

Tony Septav TSeptav at Uniserve.com
Wed Nov 19 16:04:31 CST 2014


Hey Susan
Now I can go out and rake the leaves.

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 1:11 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Split form wizard

It's already done Tony. :)

Susan H.

On Wed, Nov 19, 2014 at 12:59 PM, Tony Septav <TSeptav at uniserve.com> wrote:

> Hey Susan
> You are making a mountain out of a mole hill. Listen to Charlotte. The use
> of tabs and subforms is so easy. As I have been saying and same with
> Charlotte "You can present a clean, intuitive interface".  Step back and
> look at the simple not the complex. Yes it will take a little bit of work
> but hey the end result for the client will make you sparkle. You can
always
> ask for my assistance and I assume Charlotte would also provide support.
> Or are you ageing so fast that you cannot see the forest for the trees?
>
> Remember it is fun to be able to laugh at yourselve.
>
> Tony Septav
> Nanaimo, BC
> Canada
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
> Sent: November-19-14 11:23 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Split form wizard
>
> Susan,
>
> There are lots of tricks to keeping subforms in sync on tabs, and it
> simplifies the whole process rather than complicating it.  You can present
> a clean, intuitive interface where the use can see the categories
available
> to them and quickly find what they're looking for without being overloaded
> with information at any one time.  All the parent form needs to do is hold
> the primary keys you need to link the subforms.  Your queries for the
> subforms are simplified because they don't need to include multiple tables
> to get the right records.
>
> Charlotte
>
> On Wed, Nov 19, 2014 at 8:03 AM, Susan Harkins <ssharkins at gmail.com>
> wrote:
>
> > 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
> > >
> > --
> > 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/8596 - Release Date: 11/19/14
>
> --
> 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/8596 - Release Date: 11/19/14



More information about the AccessD mailing list