Duplicating data

[cliff7376]

I have a bit of an issue. My comany wants me to make a label program to print labels out. I have some variables. each piece of tape has different amount of lines we have to print depending on the size of tubing (ie. 1" tubing uses 29 lines per piece and 1.5" tubing uses 43 lines per piece of tape.) . also depending on the information we have to put on the tape it could be only (for a 1" tube) 3 lines repeated 9 times and 2 lines . or 6 lines repeated 4 times and 5 lines. The maximum number of unique lines they would type in would be ten before it had to start repeating itself. so I thought of making a table with 43 fields and a form with ten fields they could type in. when they were done typing in non repeating information the form could somehow try to find the first empty field and copy the first field into it and and then find the second empty field and copy the next line and so on until all 43 fields were filled to account for maximum tape size. It seems kind of bulky and i am not quite sure how to do it. If someone has an Idea i would very much like to hear it. Thank you

 

[lynsey2]

ill give this a go but i am not verry good!
if i have got what you are saying correct you have 3 different sizes of lable each can hold a different number of lines of text!?

what i would do is create a form with text boxes for the stuff they want to type in to go on a lable, then, have 3 reports (which you could have 3 buttons on your form going to) one that you have set up to get the data from the text boxes on the form and fit it into the smallest amount of lines on the lable (1" tubing uses 29 lines per piece ) then do another report that takes the data from the form and fits it into the bigger amount of lines on the lable!(1.5" tubing uses 43 lines per piece )
someone else will possably come up with something better but i think that would do the trick if i am on the right track!

 

[cliff7376]

I have been thinking about it and what i think I am going to do is make a form with 10 fields on it. and then let the user type in however many distinct rows they need to. then i will do a check to see the first row that is null. that will give me the amount of distinct rows for that record. I guess my worst problem i am facing is trying to get these lines on my label to repeat when i want them to. if i have 5 distinct lines how can i make them repeat until it stops at 43 lines on a report. then when i have 3 distinct lines how do i make them repeat on my report until it stops a 43 lines and so on. and then after all that print the 43 lines 50 times for the 50 pieces of tubing i need to put them on.

Maybe I am looking at this in the wrong perspective.

 

[lynsey2]

ooh! em... maybe a qry you know what i dont get this!sorry! em...best letting someone like PAT answer, thats the person that i would recomend! knows everything!