Recent content by Missus_Nat

Hello again, I've been scouring the forum trying to find other threads on what I want to do. This one sounds like what I want, but I am not sure how to add more code to the After Update Event of my last combo box, as I already have code there to auto-fill the other Fields in the Form. This...

I tried to physically paste it in, but it said my text was too long.. Hopefully you can open the jpeg. THANK-YOU!

What I'm trying to do is select a Student ID, then have the Course selections limited to the ones for that Student ID, then auto-fill the other fields. (this is working right now) Then I want to change some of the data (ex. put in a new date), and have it update that record, rather than...

1. Awesome, thanks!! 2. How do I change the Form_Load event so that it opens blank, but not on a New Record? 3. Someone else gave me this code... In effect, once I select a Student ID, it limits my Course Combo Box selections to only the ones associated with that particular Student ID.

Ok, I opened my Form in Design View and clicked the 'View Code' button; this is what I have: Option Compare Database Private Sub Course_AfterUpdate() Me.[Date of Training] = Me.Course.Column(2) Me.Location = Me.Course.Column(3) Me.Instructor = Me.Course.Column(1) Me.Grade =...

Thanks for the tip about code tags!! I am totally new to this. I'm not sure what you mean by 'post the entire module', so I'm posting a zipped copy of my database... The form I am working on is called 'Training Records'. I've tried playing with the overall Form 'Data' settings, such as Allow...

Hello All! I want to put an 'After Update' code (or possibly an 'On Change' code) on my Text Boxes so that changing the auto-filled data in the Form updates the record, rather than creating a new record. Here is the After Update code I am using in my Combo Box to produce the auto-fill data...

Testing... My apologies to all!!

It won't let me send a PM until I have more posts... I will put in a 'dummy' post and try again. Thank-you btw!! I know I can scroll through and update records, that's what I'm trying to avoid... I will be updating over 400 records in the next month, and don't want to have to scroll/search...

Yes!! Hurray!! And then when I choose the Course, I want it to auto-fill the form so that I can change the date/grade/etc. on THAT record instead of making a NEW record. Does that make sense?? And is it possible with my teeny-tiny amount of Access knowledge?? You are my hero right now Sketchin :)

So I've been looking around trying to learn some more terms and such, and I think this http://www.baldyweb.com/Autofill.htm is kind of what I want, except I have to select the student first, then select the course, and have it auto-fill from the second combo box choice. Also, I don't really...

I'm not sure how all the VBA stuff works, but once you've built your foundation merge document, there might be a way to create a button in your database, or some sort of command structure to automate the merge... I really don't know if that's even possible though. So I just tried to 'modify' my...

I use Word for merge documents a lot. :) The easiest way to merge from Access is to make a query in your db that contains all the fields you want to end up in your Word doc. If you already have a query that has all of these fields great! If it has more fields than you want in your merge, don't...

How did you add CourseID to the Training table?? I tried to add it, but it doesn't have any data, and now I 'can't delete this field'??

I was thinking that maybe I don't need a table for the certificate numbers, as they only appear in one table already anyway (the Training table); and the Student table already has a one-to-many relationship with the Training table. Does that make sense?? Most of the work to merge from Access...