never used macros

  • Thread starter Thread starter dkstockstill
  • Start date Start date
D

dkstockstill

I'm using Access 2007. We have a database of names and addresses that we
send 3 different publications to. We also have International clients. I
know how to use the filter to just show people with certain publications and
people that are internationals. When I go to print labels for clients I have
to use filters and then create labels. Is there a way to do this with less
steps? I have never used macros, is that what I need?
 
Macros are primarily used in Access to automate a collection of different
instructions. In your case I would create a Macro which:
- opens the required query
- opens the label report using the query as a filter
- closes everything when its finished.
 
Dkstockstill

The basic concept of doing this task does not involve macros.

You need a Report that does your lables.

The Record Source of the report is a Query.

The Criteria in the query is what you use to limit the records returned
by the query to the applicable client group.

This would most often be done by referring in the query's criteria to
the value of controls on a form which ic open at the time. Sometimes
you would make a form specifically for this purpose. The syntax for the
query criteria, then, would look something like this:
[Forms]![NameOfForm]![NameOfControl]

So, you get the idea? From the user point of view, you just have the
form with the criteria data, and then you just print the labels report.
Behind the scenes, the query is selecting the data according to the
criteria from the form, and then feeding that data through to the labels.

Hope that makes sense.
 
Back
Top