Recent content by fixty100

I've got very far with pbaldys help with the problem now fixed. Thanks for the help. As for my database our IT class had a selection of areas to do our coursework on (this would mean the database would never be used and deleted shortly after). I went out to my primary school and asked if they...

Ok, I've attatched the relationships of my database so your can see everything going on. They all lead into the level tracker. The TrackerID can have many ObjeciveIDs and many StudentIDs over many records. It also stores the level and so on. Maybe this will be enough to give you an insight. My...

I'm basically creating a Student Objective Tracker database for a primary school to use. It is part of my IT coursework (A-Level) and I've asked the two of my IT teacher about this, they've both understand the issue I'm having but haven't been able to fix it. At the moment I'm learning about...

With the append query, how do I allow all of my around hundred objectives to be made into new records on another table while using the the frmStudents to put in the currently open StudentID?

I'll give it a go and report back

First time here guys, trying to solve my problem. I'm not very experienced in VBA but can understand and follow it. I need to create a macro which after an event does some, in my mind, complicated things. Here's a quick screenshot of my database to set the scene (think its in the attachments)...