Hi.
I'm a beginner to Access. I'm trying to make a database for language learning. I want to have about 100 words (give or take) that I'm learning at any one time. I have a table with the fields: ID, EnglishWord, KoreanWord, SoundFileLink, DateLearned, NumberRelearns, Comments, TimesSuccessful. The KoreanWord field is an automatic Korean typing field. The SoundFileLink is an mp3 link to a folder on my computer, Number of Relearns is just the number of times I have the word on my list to relearn (I often forget words), Comments is just a memo for notes, Times Successful is a field that I want to increment each time I get the word successfully (at a certain number I'll consider the word learned, at which point I'll no longer want that particular record included in my random list each day.).
What I want to do is, when I open my form to practice I want it to create a random list of my table (a random QUERY on ID fed into an array??), excluding learned words, so that each day I practice I get a different appearance order, every record only comes up once for that form, and stops with a message once I have finished. I also want a total count of the number of records on the list each day, so that I know how many I'm learning, and can add more when required.
I also want to then replicate a similar senario for the opposite side of the card (English to Korean - speaking).
I've successfully created the form. It has a button that plays the sound file and the English Word/Korean Word displays when I click on the field (the font colour changes), for if I need to see it.
I've found this: SELECT * FROM MyTable ORDER BY Rnd(MyTable.MyID), but I don't know how to code it into a way that will shuffle my table temporarily for me each day.
Could someone please help me with the code? I've tried unsuccessfully to find a simple program that does this, and tried it with PowerPoint, but 100 slides on PowerPoint is simply too many and the program freezes at the 68th slide each time.
Thanks in advance! :-)