Search results

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...

2) Okie dokie :) 4) I think I understand your original note now... but wouldn't it be redundant to 'name' each Certificate as it is already attached to a CourseID / CourseDescription in the Training table? Also, I feel like it would take a lot of work to change my existing data to fit that...

1) Ok :) 2) if I do this can I put both CourseID and Course Description in, and then 'hide' the ID column?? Or will this mess things up? Most of the people who will be using this database are even less savvy than me, so the names should always be visible. 3) Ok. 4) *confused* won't this mix up...

Hi again, I've been looking through the forums trying to find a solution for myself, and the more I read, the more it looks like I need to do something involving cascading combo boxes and writing some code, which I have NO idea how to do...but at least I'm learning some of the proper terms. I...

Sorry, I think I'm confused... but I really appreciate your help!! I already have the following tables: Courses - Primary Key is Course ID (autonumbered) - just has each course name Students - Primary Key is Student ID (student name) - contains student information...

Thanks for responding so quickly!! I do already have my tables set up, and am trying to build the form(s) but got stuck with this... The Student ID and Course fields are already Combo Boxes... but right now it just pulls up those individual fields when I start typing, not the whole record. I...