Search results

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

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.

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

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