Search results

Since I'm not getting any responses for the Dlookup procedure, I thought I'd check if I can achieve the same goal differently. I need to get the randomizing in the application to start at a different point each time it is started. I tried to put the Randomize, Randomize Timer and Rnd at...

I am working on an application that uses an access db and was having a problem where randomizing kept starting at the same point all the time. On the Access forum they helped me get randomizing to work but through using Dlookup and Dcount as follows: Randomize...

Any control over showing only the MS Access form by itself when you execute activate it from within VB6. Right now I get the form and access as well. Is there some sort of filtering statement or something. Appreciate any advice.

Update on what I was able to achieve with your help Jon K and of the changes to the database: 1: I am able to execute the MS Access form directly from inside VB6 and the randomness is satisfactory for what I need...but, is there a way to see only the form itself without the whole Access window...

That 's a great improvement ..it seems to do the job of starting with a different choice each time at least on the Access form. Initially I want to use it the way it is setup in the Access db (as is that is). When I tried it with VB6 I got the error of " undefined function in expression getCA"...

Thanks The _Doc_Man for the enlightening explanation which makes a lot of sense and that's why I suspect I was having all this trouble. But still I am not very good at this and I do not need it to be really, really random. I just do not want it repeating the choices in such an obvious...

Yes I tried that and it seems like it has no effect ...maybe because the choice is done through an embbeded Access query.Take a look at the attached file. Any other suggestions? Thanks

sorry forgot to convert to zip first

Sorry for the delay...It's the difference in time zones. I attached the file and used only 10 rows with Q's and A's as choices.When you doubleclick frmQuestions you will notice that it always starts with choice 9. Cosmos75 were would this code go in vb or vb6? Thanks for your help guys *Hope...

I tried your sample and it works ok but I have to see if I can adapt the code in vb to vb6 .. What's more impotrtan tis how do I accomplish the two queries one after the other. I wouldn't mind uploading a small sample of my db if you don't mind taking a look at it and helping me out.

The queries go like this at present : SELECT TOP 1 [Table].[QuestionText], [Table].[Answer] AS CorrectAnswer FROM [Table] GROUP BY [Table].[QuestionText], [Table].[Answer], rnd([IDQuestion]) ORDER BY rnd([IDQuestion]); SELECT TOP 3 Table.Answer AS Correct, qQuestionTextAndAnswer.QuestionText...