Re: Forcing printing of a record multiple times

From: Wayne Morgan (comprev_gothroughthenewsgroup_at_hotmail.com)
Date: 01/26/05 

Date: Tue, 25 Jan 2005 20:54:16 -0600

Yes, it is possible. If the qty value is available, VB code can find it and
adjust the number of times that record is printed. It would be similar to
printing labels with multiple copies. There is a sample in a Microsoft
Knowledge Base article that shows how to print multiple labels or skip used
labels on a ***. You will need to modify this to adjust the copy value for
each record.

http://support.microsoft.com/default.aspx?scid=kb;en-us;299024 

-- 
Wayne Morgan
MS Access MVP
"MustBNuts via AccessMonster.com" <forum@AccessMonster.com> wrote in message 
news:33f7178bd87d45c9bcb5e256f56aebd9@AccessMonster.com...
> Would that it were that easy.  The data available is the part, the 
> quantity, and some misc. specs.  This is not a calculated query - I do not 
> have a table with the individual items listed out....that is the problem. 
> I was hoping someone knew of some VB code that might be able to look at 
> each record, determine the value of QTY and dup the record x number of 
> times.