Recent content by mwb

Automatic Export to txt Hello! I try to export my qurey to a tabdelimitered txt file via a button. When doing this I will not get the header row in the file. If I do the export manually I can choose to get the header row. If I save the exportspecification the selection of header row will not be...

If I have understand your question the answer is. It is possible in desing mode use Format-conditional formatting. Hope it will solve your question

Anyone wha can give me a hint?

Thank so far for help I have found in the different forums. Hop you can help me with this. Here is the tables for this. The db is far bigger, but this is the affected tables.

Hello! I'm rather new in access but I have mange to do a result database, but now I have a problem. I need to do some ranking in a special way and I think I must do it via VBA. Is there anyone who can help me? I'm totally lost in VBA. At least I hope you can give me some hints or solve part of...

I'm not so familiar with this. Is it possible for you to explain a little bit more.

Hello and thanks for a very good forum. I have a tbl where I haver several fields, but I want to update the heat field with a query. Say that I want to have the first 50% set to 1 and second 50% set to 2. Anyone who can give me a hint. Hope you can help me. Example ID Heat StartNo 1...

Thank you both. I have missed one thing. In the table i will have several classes where I use a query to select what class to put in result for, how does this affect the code? Can you also help me how with two more things: 1) If the value in the first count cells is more than three the...

Hello! I'm rather new here and I have a question that I can't solve. I have a table with following fields and data: Startno A B C D E 101 1 2 1 4 4 102 2 3 2 3 3 103 3 1 3 1 1 104 4 4 4 2 2 A, B, C, D E is ranking set by different people What I want is to count how many...