If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
labels for filtered forms
Help the desperate newbie!
Did I design my database wrong? I created a form with basic name, address etc. then also include about 10 yes/no boxes to be selected depending on the type of client, some clients have no boxes checked, some have one and some have several. I see how to filter the form to search it- and that narrows it down, but when I run a report for labels every name comes up! How do I run mailing labels for a filtered result? |
#2
|
|||
|
|||
labels for filtered forms
If you created your form before you had any tables for data, then yes, you
did it backwards. Access is a relational database ... it all starts with the data. By the way, if you have need for "10 yes/no boxes" today, what's to prevent you from needing 9 or 11 (or 23) tomorrow? This is also something of an indication that your database/application may not be designed in a way that lets Access do what it does best. If you'll provide more specific description of your data, folks here may be able to offer more specific suggestions. Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "shumate62" wrote in message ... Help the desperate newbie! Did I design my database wrong? I created a form with basic name, address etc. then also include about 10 yes/no boxes to be selected depending on the type of client, some clients have no boxes checked, some have one and some have several. I see how to filter the form to search it- and that narrows it down, but when I run a report for labels every name comes up! How do I run mailing labels for a filtered result? |
#3
|
|||
|
|||
labels for filtered forms
well it's not too late, I knew there was something wrong with what I
created... I created a table of data with fields for names, address, phone etc but then I wanted to be able to filter each person based on one or several characteristics. (It's a collection of names for an annual event so the yes/no fields I created as Author, Speaker, Boardmember, Speaker's Guest, but of course some people are more than one box, then I created my form so I could just enter the names and check whichever box pertained- but that's wrong huh? "Jeff Boyce" wrote: If you created your form before you had any tables for data, then yes, you did it backwards. Access is a relational database ... it all starts with the data. By the way, if you have need for "10 yes/no boxes" today, what's to prevent you from needing 9 or 11 (or 23) tomorrow? This is also something of an indication that your database/application may not be designed in a way that lets Access do what it does best. If you'll provide more specific description of your data, folks here may be able to offer more specific suggestions. Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "shumate62" wrote in message ... Help the desperate newbie! Did I design my database wrong? I created a form with basic name, address etc. then also include about 10 yes/no boxes to be selected depending on the type of client, some clients have no boxes checked, some have one and some have several. I see how to filter the form to search it- and that narrows it down, but when I run a report for labels every name comes up! How do I run mailing labels for a filtered result? . |
#4
|
|||
|
|||
labels for filtered forms
Unlike a spreadsheet, in which you'd just "add more columns" to get more
categories, when you use a relational database like Access, you use the "relational" aspect. You are describing a "one-to-many" relationship between a person and the "characteristics". This means that a person could have one or none (?!OR ALL?!) of the characteristics. To get the best use of Access' features/functions, you need to feed it well-normalized data. If "normalized" and "relational" are unfamiliar, plan on spending some time coming up to speed on them before expecting Access be able to use its strengths... .... or you could just do this in Excel and use the "filter" capabilities there ...! Good luck! Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "shumate62" wrote in message ... well it's not too late, I knew there was something wrong with what I created... I created a table of data with fields for names, address, phone etc but then I wanted to be able to filter each person based on one or several characteristics. (It's a collection of names for an annual event so the yes/no fields I created as Author, Speaker, Boardmember, Speaker's Guest, but of course some people are more than one box, then I created my form so I could just enter the names and check whichever box pertained- but that's wrong huh? "Jeff Boyce" wrote: If you created your form before you had any tables for data, then yes, you did it backwards. Access is a relational database ... it all starts with the data. By the way, if you have need for "10 yes/no boxes" today, what's to prevent you from needing 9 or 11 (or 23) tomorrow? This is also something of an indication that your database/application may not be designed in a way that lets Access do what it does best. If you'll provide more specific description of your data, folks here may be able to offer more specific suggestions. Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "shumate62" wrote in message ... Help the desperate newbie! Did I design my database wrong? I created a form with basic name, address etc. then also include about 10 yes/no boxes to be selected depending on the type of client, some clients have no boxes checked, some have one and some have several. I see how to filter the form to search it- and that narrows it down, but when I run a report for labels every name comes up! How do I run mailing labels for a filtered result? . |
Thread Tools | |
Display Modes | |
|
|