Thanks Lawrence! You hit on the key which I did not explain very well. I wanted to print multiple copies of (1) record on the same sheet. I will play around with the temp tables some and see what I get. Also, I suppose to use a partial printed sheet of labels I could place the correct number of rows filled with NULL values to "SKIP" over the already printed labels. (Assuming I did not have any text box, lines, or graphics on the labels.)
Sharon, Thank you for your idea about the "multiple" label setup. If I decide that I always need (2) labels per record, this would be a good way to go! Thank you all for your input. -----Original Message----- From: Lawrence Lustig <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Tuesday, May 14, 2002 12:40 AM Subject: Re: Printing labels - Razzak's Reply >> How do I get the program to print on all (4) labels of >> of a sheet? > >Bob: > >AFAIK, if you want multiple copies of a single label you need to build a >temporary table that has identical rows for each label that you want. >R:Base prints one label per row in your source table or view -- there's no >way to ask it to "repeat" a given row X number of times. > >To make sure that your routine is multi-user safe, check out the CREATE >TEMPORARY and PROJECT TEMPORARY commands, which will build temporary tables >that don't get stored in the database. > >Alternatively, you could base the label on variables, rather than columns. >You still need a table with the same number of rows as labels you want to >print but you could just keep a permanent table with enough records around. >Then, when you want to print your labels you would set your variables and >issue LBLPrint MyLabels WHERE LIMIT = X and you would get X identical >labels, based on the variables. >-- >Larry > > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
