creating a large number of labels

  • Thread starter Thread starter Kenneth_J
  • Start date Start date
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
 
I think it would help if you gave us an idea of the structure of your
question database.

In addition, if you can get hold of a copy of Litwin et al's excellent
"Access 2002 Desktop Developer's Handbook" (it should be on every
Access developer'd bookshelf, IMHO), read pages 660-662, which also
answer some other questions you haven't asked yet!

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
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
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
 
Back
Top