Tony Septav
TSeptav at Uniserve.com
Wed Nov 19 16:02:42 CST 2014
Hey Susan About time. What took you so long???? 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