Search results

Hi guys, Something that's been bothering me. I have a unbound subform which acts as a placeholder for other subforms rotating on it (by changing the SourceObject), that way all the relevant subforms appear in the right place when required. It works great except, it's this great big white box...

THANK YOU!! This is perfect. So I should have got the listbox to populate by ID number rather than name. I really appreciate it, lots of karma points for you, and less gray hairs for me for today :p

Could anyone help me please? I have incorporated a search form (previously posted on this forum) and it is not cooperating when there's a duplicate name on the listbox. There can be more than one, say, John Smith on the database. In order to differentiate between two John Smiths, I need to be...

Thank you!!! :D Just shows how much I have to learn still huh?

I love the look of the database - would have been nice to see what's going on in the background though. For those of us who are still learning the ropes, seeing the actual structure, coding etc is very useful.

Ooh, thank you for that suggestion. I'm not great at writing VB code, but I'll try :)

Could anyone see what is wrong with the code below? I am trying to produce 10 questions randomly chosen from a set of criteria. Number of questions to grab from each criteria is different so I did these using case (this was originally written by a very helpful forumer here). Most of the time it...

:) Thank YOU!!! I don't know how I missed that! I'll probably need to work more on my searching skills :rolleyes: I'll leave now, with a red-face, thank you for replying master Rich :D

mmm, post viewed 20 times and no suggestions??? Hi everyone, Although I haven't been working on this particular problem, I STILL can't find an answer to this. Is it even possible???? Please, your response (any response) would be much appreciated.

Erm, I feel really silly asking this because it's probably simple to do, but my brain is refusing to work.. I searched a little bit for this, but can't find an answer (probably too simple). I have a table and would like to prompt the user to enter multiple IDs of these records, separated by a...

thank you very much Uncle Gizmo! I will try this code and see if I can modify it to suit my needs. :) Obviously, this project is a little over my head, I just don't have the experience to do all this, but I definitely learn better from examples, so thanks again.

mmm, you come up with solutions I've never even thought of! :D I can make the form up I think, no problems there. Code-wise, could you possibly give me an example based on the line of code that appends my data into a table please? CurrentDb.Execute "INSERT INTO tblMCQRandomAppend SELECT...

can append now, here's the next problem It took a while for me to figure out, but I managed to append the data into a new table called tblMCQRandomAppend, which will hold the records that I want to keep for future re-production. So, now, I have encountered another problem. The records on the...

mmm, how do I do that??? Could you possibly give me an example? Here's the randomisation code I'm using, is it there that I need to append? I tried zipping the database, but it's still too big, otherwise I'd post it here for you to look at. Thank you very much for your replies, I really...

Not quite. Just as I explained above, I have a questions table that stores all the info about the questions (question itself, choices and the right answer). In addition I have a temporary table that renews its contents everytime the randomisation process is run (this table also contains the...

Hi there, I think I understand your explanation of the table, THANK YOU! I will try to do that and see what happens. I had thought I had understood how to make tables, but obviously not! Back to the drawing board I go... Your question about randomisation: I have a table of questions with...

Thanks for replying Uncle Gizmo (loving the username by the way). This sounds good to me, but I need to store 40 questions per person for the multiple choice test (let's say), not just one question on the field "tblTestDetail". So, do I need 40 fields (Q1, Q2 etc) :confused: ? Also, how do I...

Oh god, I will try to explain this as clearly as I can I have a testing database, where candidates sit through MCQ test and an oral test. The questions for these are selected randomly from a bank (40 questions for multiple choice and 10 questions for oral), gets put in a new table and reports...

ByteMyzer, You are my GOD!! It's working and it's perfect!! Thank you very much. (I have so much to learn...) I think I'm going to make a sample database using Mile-O-Phile's example of capitals of various cities (I hope he won't mind me using his data set) and use these fantastic codes you...

Hi everyone, My previous post (randomisation help for total beginner) and ByteMyzer's reply helped me so much, I feel compelled to present another problem to the community. I thought I may be able modify ByteMyzer's code to do something slightly different for this new problem but I'm obviously...