Recent content by kuifje_007

  1. K

    Moving records to a specific position in a recordset

    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...
  2. K

    Number of participants

    Yes, it works fine now! Thanks, Jon!
  3. K

    Number of participants

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

    Number of 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...
  5. K

    Something wrong with the SQL-line in VBA

    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...
  6. K

    Something wrong with the SQL-line in VBA

    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. :(
  7. K

    Something wrong with the SQL-line in VBA

    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...
  8. K

    Something wrong with the SQL-line in VBA

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

    Something wrong with the SQL-line in VBA

    It says he cannot find frmTournament. :confused:
  10. K

    Something wrong with the SQL-line in VBA

    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...
  11. K

    Something wrong with the SQL-line in VBA

    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.
  12. K

    ADO Recordset

    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?
  13. K

    ADO Recordset

    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.
  14. K

    ADO Recordset

    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 =...
  15. K

    Select one of two players

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