Search results

Hi Pat, Not sure what I did with the first version but no matter what I tried it wouldn't work, so I scrapped the whole thing and started again and NOW it works. Thanks for all your help.

Hi Pat, again you were right, I had the wrong RecordSource. However, now it only shows people who have been assigned a course. It doesn't show people who haven't been assigned a course. E.g. Student 1- Class 101 Student 2 - Class 101 Student 3 - Class 202 Student 4 - no class assigned...

Thanks Pat, I did try, as you suggested, making a query of the Student_Class table and then a combo for StudentID but when I click the combo it doesn't show a list, instead it shows a one line blank? What am I doing wrong?

Hi There, I have three tables: Students STUDID (pk) txtFname txtLname etc. Classes CLASSID (pk) txtClassName txtClassRoom etc. Student_Class (join table) STUD_CLASSID (pk) fk_StudID fk_ClassID I am trying to set up a form which shows a "Class" and a subform which I can add a student to it...

Thanks to all for providing answers to my question.

Thanks CJ_London, That worked just fine except for one little thing and it is probably something that I have done. I've noticed that if I have one class with 2 students in it the combo box shows the students that are not connected to that class which is great. But when I change to the next...

Hi There, I'm sure there is an easy way to do this but I have not clue. I have three tables: Students STUDID (pk) txtFname txtLname etc. Classes CLASSID (pk) txtClassName txtClassRoom etc. Student_Class (join table) STUD_CLASSID (pk) fk_StudID fk_ClassID On my Class form when assigning...

Hi There, I'm trying to add a record(s) in a join table but I'm not sure what is the best way to do this. Here are my tables: tblStudents StudID (pk) txtFname txtLname etc tblClasses ClassID (pk) txtClassName txtClassCode etc tblStud_Class StudClassID (pk) fk_StudID fk_ClassID I would like...

Argh! Hit the Submit button before answering your questions: It is sorted based on the Students ID.

Sorry, I should have been more specific. Yes, it is a custom button called "cmdbutAddRecord". I have disabled all the MS Access record navigation buttons because it was confusing to my client.

On my form I have a "New Record" button which works fine. However, the people I am working for ONLY want that button enabled IF they are on the last record. Apparently their issue is, if they are on record # 123 and press the "New" button it throws them off if the "New" record is, for example...

Thanks to everyone, a REAL NEWBIE move, I just realized what I did. In my code I put: Me.DRID - which will give me the current record instead of the new one. When I changed it to: !DRID - THEN it gave me the new record. LOL. I am laughing at myself, but I do wish to thank everyone for...

ARGH! I thought I had it but I still can't get the form to update to the new record. What happens now is that when I click the "Add Record" button it does create the new record and the program pauses for a second but goes back to the record I was at instead of moving to the new one. E.g. I on...

Oh Brother, never mind!!! I realize what I did wrong. I got the record information after the update instead of the other way around. Such a newbie move. Thanks JHB for your help.

Hi JHB, I tried as you suggested but it still goes back to the previous record. When I stepped through using F8, I noticed that when I got to the line: rs.Bookmark = rs.LastModified It was the previous record and not the one I had just added. What am I doing wrong?

Hi There, Yes, still a newbie AND trying to change somebody else work. I am working with Access 2003. I have a new record button on a form and I can get it to add a new record but I can't get it to display. However, if I close the form and re-open it there is the new record, what am I doing...

If you could only see how much I am laughing about all this. Yes, thank you, gemma-the-husky, that worked. However, now when I want to show to the new record, instead it goes back to the same record as before. What is the code to show the new record once it has been created? This REALLY is...

OK I'm not sure what to do now. Maybe I will make a query to see what's up. Because I can go into the table and populate the field (fkStudCourID) but when I set up a recordset it doesn't see it. I even tried copying the field name while I was in design mode from the table and then putting...

Thanks to Beetle and Spikepl for answering so quickly, However, the weird part at least for me is when I try the intellisense it doesn't show fkStudCourID as an option although all the other fields are shown. Is this because it is a foreign key and get its number from a different table? Again, I...

Oops, sorry, real noob here, I was going too fast when I copied the code. I did in fact put it in: Dim db As Database Set db = CurrentDb Dim rs As DAO.Recordset Set rs = db.OpenRecordset("tblDailyReport", dbOpenDynaset) With rs .AddNew !fkStudCourID = Me.fkStudCourID !numDailyNum =...