Charlotte Foust
charlotte.foust at gmail.com
Wed Nov 19 11:22:44 CST 2014
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 >