A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

labels for filtered forms



 
 
Thread Tools Display Modes
  #1  
Old April 9th, 2010, 07:39 PM posted to microsoft.public.access.gettingstarted
shumate62
external usenet poster
 
Posts: 13
Default 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?

Ads
  #2  
Old April 9th, 2010, 07:58 PM posted to microsoft.public.access.gettingstarted
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default 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  
Old April 17th, 2010, 12:04 AM posted to microsoft.public.access.gettingstarted
shumate62
external usenet poster
 
Posts: 13
Default 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  
Old April 19th, 2010, 04:20 PM posted to microsoft.public.access.gettingstarted
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:46 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.