creating a large number of labels

K

Kenneth_J

It seems that many people have brought this up, but i still haven't
been able to find a suitable answer to my problem...

basically i wish to create a report for an exam, by somewhat randomly
pulling 100 test questions out of a database. I'm new to access vba
stuff so i'm not really sure the best way to go about it. Originally
i had thought that i would loop 100 times creating labels and editing
their captions. But apparently there is no way to create labels on a
running report !?

....So i would assume this means there is a more elegant way to do
this. If anyone could lend me a hand it would be much appreciated.

thanks,
keith
 
K

Kenneth_J

oops, this thread is a double post of sorts, i posted another thread
with the same question, at
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&th=d30d4a24862d8260&rnum=2
and i guess we should try and keep everything over on that one from
now on ... sorry about that.

Well, the database that this is coming from is hardly a database at
all, it was given to me as a project to try to get this workin real
quick... so i'd rather not get into how awfully designed it is and
such... but i'm having no problems pulling the data out of the
database in whatever format i want. i'm just trying to find a way to
have 100 questions printed out on a report that i can then print
hardcopies of without having to create 100 different sets of controls.

and thanks for the book recommendation, i'll be sure and check it out,
keith
 
Top