Problem with Append Query

[Tanya]

? I can't see this in the version I uploaded or my current copy???

 

[RainLover]

Your upload failed.

 

[Tanya]

This is the db up to the moment.

Thank you for your time on this, I really appreciate it.

Regards
Tanya

 

[Tanya]

Success!! At last

I created a new field on with yes/no tick box and attached an event to open form readonly to run command to append the studentclassID. Finally........

Thank you for all your time and effort, it is greatly appreciated.

Kind Regards
Tanya

 

[RainLover]

Glad to hear of your success.

 

[RainLover]

Tanya

I don't know if you want more help or not, but out of interest I downloaded your file and it does not work.

If you are trying to add a Student to the list that appears on your form the attached copy does this. It is untidy but it works.

 

[Tanya]

Hi
My apperoach changed, because of the problems I was having, I went back to simply selecting a new student from combobox on subfrmAttClassList, then an event on click for Enroll to open the form frmAddunitstostudent which has a commandbutton to run the append query.
I will look at your version though. Thanks..

 

[Tanya]

OOps Looks like I uploaded the wrong copy. Sorry

 

[RainLover]

I attached the wrong file

edit

Looks like we both did

 

[Tanya]

This version is up to date. I have been working on another problem all morning.
A while ago I was working on attendance totals and didn't realise I had messed up another part of the process, so back to square one. At the moment I am trying to get studentClassID in frmqryAttendancesub2 to cooperate when I select a student from SubfrmAttClassList

 

[Tanya]

Thanks for looking at this problem, but you haven't seen the whole picture. What I was hoping to do was add a new student AND then run the append query from one command. Your copy doesn't append the student, at least the append part didn't work.
Thats ok though, as I mentioned earlier my latest version of this achieves this through two steps, one adding new student from dropdown, then selecting Enroll runs event to open next form with command to run query.
I really appreciate your efforts, I'm sorry I didn't make my problem a little clearer for you to understand.
Cheers
Tanya

 

[RainLover]

Hope this helps.

See attached

 

[Tanya]

Your code works well for adding a new student but it doesn't run the append query. That is ok, as I said, I finally managed to work it all out in the end.
I really do appreciate your time on this.
Thanks