again im in need of help =(

how can i show a random cell in a field on a textbox??

suppose my database(access2003, and using ADO) is -->MAINDB-->tblQuiz-->the field inside is "Question"

and my form have 3 textbox..

when i run it, how can it display a random data from -->tblQuiz-->field "Question"

really nid your help guys and kind sir

Recommended Answers

All 2 Replies

try to use the RND fuction with the total no of records (using COUNT) as the max value.

teen use MOVE method to move to that particular record no.

NOTE:- that might repeat the same record.

umm could u pls give me some sample syntax sir, i cant imagine it in my head =( sorry ...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.