Label Project Woes

[marnik]

Hi all

I am working on a labelling database, the basic concept involves handling
client setups, and creating sequential labels for them. For instance a
client might request 200 labels starting at 10000 to 10200. Using the Label
Wizard in Access 2002 I have been able to work out the printing part of this
if I generate a query that contains the sequence, but that seems a bit
sloppy . . .

I was then thinking that I could create a macro that does the job for me as
part of the report, starts at the sequence_start and then just loops until
the sequence_end..... Am I on the right track? I am by no means a macro
guy when it comes to Access. I am hoping for ideas. The query has the
start and end sequence numbers, I just need a macro to work in the report to
generate the labels for the requested sequence, and loop until completed.

Any assistance is greatly appreciated.

 

[jimmythegeek]

In the criteria row of the query, put the following:

Between [Enter Starting Sequence Number] And [Enter Ending Sequence Number]

This will prompt you (parameter pop-up boxes) to enter what sequence number you want to start with, and what number you want to end with. Your query will now be limited to only the records between the two numbers you have entered.

When you double click the report, since the query has parameters in it, it will prompt you. That should be your only step.

Don't know for sure if this is what you are looking for or not. This method allows you to save a query and use it over and over again with different parameters (hence, a parameter query). Jim Lunde
compugeeks@hotmail.com
We all agree your theory is crazy, but is it crazy enough?