p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Printing labels from a database


Message #1 by "MonicaR" <mrwarrior2001@h...> on Fri, 14 Jun 2002 23:08:49 -0400
Hello,

I have the following problem:

I am generating labels from a table.  One of the fields in the table gives
me the number of labels of that particular record that I need.  But when I
generate the report (labels) for printing, I only get one label for each
record.  I have been going around this problem, but I don't see a solution.

Is this possible?

Thanks,

-- MR



Message #2 by ProDev <prodevmg@y...> on Sat, 15 Jun 2002 14:30:00 -0700 (PDT)
--0-777359750-1024176600=:57827
Content-Type: text/plain; charset=us-ascii


The first thing that comes to my mind is to create a second or temporary table to run the lables from. You would incorporate a step
in your process using vba to append records to a new table. The number of times it gets appended would depend on your field that has
this number each record should be printed. 
 
Just a thought...
 
 
  MonicaR <mrwarrior2001@h...> wrote: Hello,

I have the following problem:

I am generating labels from a table. One of the fields in the table gives
me the number of labels of that particular record that I need. But when I
generate the report (labels) for printing, I only get one label for each
record. I have been going around this problem, but I don't see a solution.

Is this possible?

Thanks,

-- MR





Lonnie Johnson 
ProDev, Builders of MS Access Databases
http://www.galaxymall.com/software/PRODEV 




---------------------------------
Do You Yahoo!?
Sign-up for Video Highlights of 2002 FIFA World Cup

  Return to Index