Recent content by JessicaVdb

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.