Search results

I have a question about your excellent program about MoveRecords. On the MoveUp-button there is a code: Set frm = Me![Report Detail].Form I have a form with 2 listboxes. The data in the first listbox I need, I move it to the second listbox. And in the second listbox I want to move or down...

Yes, it works fine now! Thanks, Jon!

Thanks, but they count all the participants together, for example: as for Australian Open it counts 13 participants and for Wimbledon 19 participants.

I want to count how many participants join in each tournament. I have a table which is manipulated by a recordset, so an example: Tournament; Participant; MatchID; Round; Player Australian Open; John; 1; 2e; Hantuchova Australian Open; John; 2; 2e; Sharapova Australian Open; John; 3; 2e...

You mean in the combobox cboTournament? I tried it like: Private Sub cboTournament_AfterUpdate() For i = 1 To 32 [Forms]![frmTournament]("cboSpeler" & i).Requery Next For j = 1 To 31 [Forms]![frmTournament]("cboWinner" & j).Requery Next...

I think I need to refresh. But I don't know how and where. Something like: Forms("frmTournament").Refresh ? Well, he still doesn't work. :(

It works good but not at all. If you select Tournament (cboTournament) which you haven't selected the comboboxen (cboPlayer and cboWinner) yet, those comboboxen are empty, which is good. And if you have selected the comboboxen of a certain tournament and then select another Tournament, the...

I think it is solved now thanks to: = '" & [Forms]![frmTournament]![cboTournament] & "'" Thank you, Wayne! :)

It says he cannot find frmTournament. :confused:

Thanks for your reply. I have a table tblDraw with the fields PlayerID, Player, Seed and Tournament, and tblTournament with fields WinnerID, Winner and Tournament. I made a form which will write down to these tables. And if you select a certain tournament, the tournament should retrieve the...

What is wrong with this line? .Source = "SELECT Player, Seed, Tournament FROM tblDraw WHERE Tournament=" & [Forms]![frmTournament]![cboTournament].Value I wanted if you click the combobox cboTournament, all the datas of Tournament from tblDraw will appear. The program stopped at here.

What do you suggest then? I don´t understand you. Don´t you think it is possible to write down the names of the winner in every round?

Thank you for the reply. Crilen007, I need that comboboxes to select the players from the one to the other rounds (first, second, quarterfinal, semifinal and final). I am making a tennis program with the elimination rounds.

I don´t know why this Recordset doesn´t work. It won´t write down to the table tblPrediction. Maybe you know why? I have many comboboxen, which is called cboPlayer1, cboPlayer2, and so on. Function WritedownToTable() Dim rst As New ADODB.Recordset Set rst.ActiveConnection =...

It is already solved with the commando Me.Winnaar.RowSource = Me.Speler_A.Value & ";" & Me.Speler_B.Value Still thanks for your reply. :)

I have a table: ID, Player A and Player B and Winner. In column Winner I want to select between Player A and Player B. How am I gonna do this?

Hello, I want to make an tennis prediction program. I have made something, but I don´t know what I can do now. I want to learn about Access, but I don´t know much. In the Form I made a Tournament where you can select the players in the first round and then you have to select one of 2 players...