Search results

THANK YOU THANK YOU THANK YOU.... oh I have been banging my head against a wall for so long on this I cannot tell you how grateful I am !!!!! :) Can I buy you a beverage ???

The attached database would not allow me to add new records and appeared to be the unchanged database? Now if I try to download it, it keeps asking to save it as attachment.php? Am I doing something wrong?

Thank you for your suggestion. I have made the following changes based on your suggestions: Private Sub AllowedSubformRecords() Dim rst As Object Set rst = Me.RecordsetClone If Me.AllowAdditions = RecordCount >Forms!f_t_Main!Main_Form_Number Then Me.AllowAdditions = False...

I'm not sure if you meant to attach a new version as the version attached here does not allow any new main form records?

It was much easier for me to simply create an array of all of the possible roles and course types in Excel, and simply import them as a lookup table back into Access to reference. I apologize for not getting back to you on this sooner, however, that project had to be put on hold and with...

Hi, Please see attached database. There is a one to many relationship between t_Main and t_Sub. A bound textbox on f_t_Main contains a number which is the total number of subform records there are allowed to be. So, I am thinking that I would need some VBA Code such as: Private Sub...

We have 2 course types: CFSC and CRFSC. All we need to track is: How many Instructors taught the course, What role number they were (Lead, secondary etc) and what students were in that course. (it's a 10 hour course taught over a weekend). Beyond my original question is I will also need to...

Three tables: Courses, Instructors, and Roles. Each course can have anywhere from 1 to 5 instructors, so a junction table works for that. However, we also need to say which instructor was the Lead Instructor, and each subsequent number is assigned for each additional instructor used up to a max...

Hi to everyone and thanks for such a great website and help !!! I have basic MS Access skills and have developed some applications we use here at work. I think Access is an AWESOME application development tool, and I try to learn a bit more every day! Really looking forward to being a member...