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 » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Selecting the correct records for mailing labels based on SQL Serverview



 
 
Thread Tools Display Modes
  #1  
Old March 4th, 2008, 04:16 PM posted to microsoft.public.access.forms
[email protected]
external usenet poster
 
Posts: 28
Default Selecting the correct records for mailing labels based on SQL Serverview

I need to print some mailing labels. I work with an adp Access
frontend and a SQL Server backend.

The problem is this: I need to print address labels for all the people
whose birthday falls within a given month.

So far I have a SQL Server view that generates the names, addresses,
and birthday months (e.g. 1, 2, 3, ...) for the people I need to send
mail to.
I have a report for the labels that is based on this view and includes
the name and address.
I have a form that brings up the label report in preview mode. On this
form I have a combo box that allows the user to specify the birthday
month for which they want to print the labels.
So far my label report just brings up everybody who is included in
that view.

My question is the following: The user will use the form's combo box
to select the birthday month for which they want to print the labels.
How can I set up my report to accept this value as a parameter and to
only print the names and address associated with this month?

Thank you for your help.
 




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 08:58 AM.


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