Ok I have a program which prints out match lists. There are 4 games for 4 match lists will be printed out.

The problem I have is that when I print a match list out once or twice they are all the same combination of names. I need a combination of names to be able to only be used twice and not 4 times.

I.e. of how it comes out at mo

Match list 1

brad VS charlie


Match list 2

brad VS Charlie

match list 3

Brad VS Charlie

match list 4

brad VS charlie


I.e. of how it should be


match list 1

brad VS charlie

match list 2

Brad VS helen

Match list 3

Brad VS charlie

match lsit 4

Brad VS egga

each of the match lists would be on sperate pages and would have 18 names in total to them this is the code I have so far produced for it:



But this produces only one set of the results I want and four blank pages...
the thing I cant get around is how to stop one combination of names appearing in more than two games I tried using a falg like the stryellowused but it was no use...does anyone have any ideas..I was thinking that the entire row the would be printed out neds to be stored and have a variable added to it like 1 to process wehter its been used once but Im not a vb programmer and I dont really like vb lol...

PLZ help this has been bugging me for so long

thanks,

sammaye

 

 

 

Reply

I have made some progress due to help form vbcity but still no one seems to be able to make it right, not even the professional programmers lol..

but I thought is there some way I can put in a variable which will grab the pair of names used which a 1 or 0 can be added (1 and 0 for falgging) in the same way as stryellowused has been used. So the method I have thought up of is to use a strused to grab each pair of names that has been used and store them in a variable which can have a 1 or 0 added to it to make sure that the names dont appear again...does anyone have any ideas has how to go about this

Reply