Search results

David.. Thanks again for the reply. I also have another question about your code: What does the "ff" variable do? What does the "TempStr" variable do?

Thanks for the quick response guys. I tried using the following code: Private Sub cmdTest_Click() Dim ff As Integer Dim TmpFile As String Dim nLines As Integer Dim TempStr As String ff = FreeFile TmpFile = "z:\ProgjeJeroen\Temp.txt" Open "Z:\ProgjeJeroen\uitslagen_kopie.txt" For Input As #1...

Then is there a way to delete the first 6 rows in the table automatically? Without any interaction of the user.

Always at the top.

Hello, I want to import a .txt file into my access application. However there are 6 lines of comment I wish to delete from the textfile. I have a button on a form. when I press the button the 6 lines should be deleted. Does anybody have an idea how to go about this?

Hello, How can I get rid of the access logo (4 coulored puzzle looking thing in top left) when I deploy my programm?

Solved it with an iif statement

Solved it with an iif statement.

Dear Mike, If I use your method my table tblTournamentRound gets randomly filled with some numbers. But the ID from the team may be something else. for example.. If i use rnd() the number could be 170. But there is no team with the ID 170. i hope that you understand what I mean.

I have a query that looks like this: TeamAway TeamHome Jury ---3----------6--------4 ---9----------4--------2 ---7----------8--------3 ---2----------3--------4 How do I get a horizontal max so my query looks like this: TeamAway TeamHome Jury Winner ---3----------6--------4--TeamHome...

Thats exactly what I mean. Escpecially how to generate random numbers from the 10 teams. But also how to fill the 5 rows in the tblTournamentRound. Thanks so far

I realy need some help on this please.

I would like to know more about that :)

I hope that anybody can help me. I tried to explain my problem as good as I could.

thanks AJ, It's not exactly what I need. I will describe the situation more clearly: I have I table called tblTeams containing the participating teams of a tournament. Then I have a table called tblTournamentRound containing the HomeTeam and the AwayTeam. Now here is my problem: When I...

OK.... outer join did the trick. Thanks guys..

OK... Right now I have a table (tblTeams) that contains all the teams participating in a tournament. Then I have a query that contains the ID's of the teams that allready have played in the tournament. Now this may be a very stupid question of mine, but how can I get the teams that do not have...

This is the problem I think. I just don't want to see the value in the combo if it has already been used.

You are not mean. I just didn't explain myself good enough. I will try again ;-) So I have a form that contains tournament data (Name of the tournament, date, etc... that is stored in the table tblTournament). form1 is based on tblTournament. On form1 resides a subform called...

Thanks for the reply but that is not what I need. Basically it's this: I have a query and a table. 1 query (query1) where I hold all available teams and the table (table1) is where I see the teams I added to a tournament so far. Now.... query1 is the rowsource for a combobox that I use on a...