Flash card (record) - Poup up & autoexec

[fabioltj]

Piece of cake for you !!! Flash card (record) - Poup up & autoexec

Hello every one,

I'll really appreciate any help. I'm beginner in code issues, so that any directions will help me. I've already read a lot of threat posted here, but I'm not able to define what I need yet.

What I wanna to do is: (sounds simple! )

1)To create one database to store words. Like a dictionary. 9no problem to do that.)

2) Durind the day, that I'm working on the computer I would like to receive some poup-up on the screen showing one of those records in my databse. The idea is, through repetition to learn new words of a foreign language (like English in my case..!)

3) I supose that software could get a record (word) randomily from my database.
And that could happen in a randomily time interval, or even in a fixed time interval.

4) Then the ideia is just to see the word and then minimize the screen, to wait the new poup-up. Any other action is required.
But you can include new record as long as you continue studing.

This application is not intentioned for school or something else. It is just for help me learn more, and take advantage from the long hours that i'm working....

I'm not sure if Access is the best software choice to do that. So any directions and help I will appreciate.

Thanks in advance and sorry for that long thread

 

[reclusivemonkey]

Personally, whilst this could be a nice project to learn Access, I think you would be better off getting an English course on CD Rom. If you can, then you could listen to it while you work, or during your regular "typing breaks" if this is not possible.

 

[fabioltj]

Help ...

Hello,
I'm writing a simpel code to execute ± what I want..that's simple and amateur..but it starts working..

I wrote the code below (that I learnt in this forum) and I need an Interruption in the program. For example, until a button action (e.g. minimize the form). That it means that I saw the record, and then the software can choice another one...

That kind interruption I can do it using a MSGBOX. But how can I do a link to a button action? Like a command14_click action !!!



Private Sub Form_Timer()
Dim record, num As Integer
Dim myvalue, clock
Randomize

' define clock time
range = 5400000 ' superior range
range1 = 900000 ' inferior range

clockAux = (Int(range1 * Rnd) + 300000)
Me.TimerInterval = clock


clock = (Int(range * Rnd) + clockAux) 'define the TIME that form will show me up in the screen
Me.TimerInterval = clock

'define recod to be showed

record = DCount("[ID]", "base")
myvalue = (Int(record * Rnd) + 1) ' Choice randomily - record
DoCmd.OpenForm "base", , , "ID =" & myvalue

num = ((clock / 1000) / 60)

MsgBox ("The time for the next record is ") & num & (" minutes") ' This is a interruption that I'm talking about. The code just restart (recount the time) if I press the OK in msgbox.

End Sub

___________________________________________________________
Private Sub Command14_Click()
DoCmd.Minimize
End Sub


Thanks in adavance

 

[fabioltj]

Nice !

Congrats for this forum. Here you can learn a lot. There are a lot of Access experts...
I started here an idea that could help me, and here I could learnt how to do what I suggested...that's awesome..
This is the result....even being an amateour database.
If somebody would like to hang out in this code...go ahead...but post the improvement later...