Search results

Thanks a lot Minty but I solved the problem myself with the use of a combo box.

I already got the humour ;)

Never mind.

What code is behind the button 'Add training records'?

I was thinking to do it with a combo box. In the combo box Station you can chose witch Station and then you have to ad the Level and Revision. But if you want multiple Stations I tought I just could at a second, thirth, ... combo box to make a new selection. The upper selection subject...

And what code should I use then?

Hi Is it possible to fill in one team members name and then at multiple trainings. This in different records. Example: The trainings need to be different records. But it could be helpfull if the name (and other things) can be tiped one. Thanks JessicaVdb

Deffinetly, I've already found what was wrong.

OMG! I can't thank you enough for what you have done. :D

Thank you! I'm realy greatfull you found this already.

I've tried this solution from microsoft, but that doesn't work eather. Has anyone a solution for me? I still can't see the names or the values in my report. https://support.microsoft.com/nl-be/help/328320/how-to-create-a-dynamic-crosstab-report-in-access-2002

Okay, the query works and the report works. But still the names and values doesn't appear in the report.

If I put parameters in, this is the error I get. This is the code I am using now: "PARAMETERS [forms]![MainMenuF]![txtShift] Text (3 ), [forms]![MainMenuF]![txtType] Text ( 15);" & _ "TRANSFORM Last(TrainingMatrixQ.LevelOfTraining) AS LastOfLevelOfTraining" & _ "SELECT...

I use differend headings, so I need to specify parameters? How do I exactly need to specify them? Only for the Shift and Type that I run through a textbox in a Form, or as well for the FullNames?

Thank you, I apprechiate it. The code you gave worked well. I'm gonne use my sql (sinds it works) but I'm gonne look at you're code.

Also I can't exactly find in the code where I need to change the query that need to be used for my names to appear. This is what I get in my report write now:

I'm sorry, it was late last night. My crosstab query works perfectly now. Only one problem, how do I set my combobox value to the textbox? I have set some code, but that doesn't work. The code (that is not working) that I use now: Private Sub cmbShift_Change() txtShift = cmbShift End Sub...

I have been triyng what you said. I removed the total row code. Also have I the first and second row as you that need to be different. But I still get some issues -> Someting is wrong in the code I think. The heading should be Name, as you can find in the query's. Obviously there are a lot more...

I don't know what you mean with this. The rest I am trying. Thanks

It really doesn't wont to work for me. Everytime I add someting, someting else doesn't work again. Could you help me? https://ufile.io/ogfs0 Thank JessicaVdb