Recent content by teetertotter57

Yea, I told you I was new at this. It's 365...lol. I still have another week in my class, as well. My instructor also provided a link. I'll work on this, but you may hear back from me as I run into problems with the execution. Hay, Jdraw, Thanks a Bunch, Regina

Jdraw, Thanks for the reply. Office 360, I should have said, is on the cloud, I think. We can load it on all our computers and it's updated automatically with all kinds of benefits. We subscribe annually. I checked the sample out, and I'll need to study it a bit. I may need a little help...

Hi, I have an Email field on a form. Is it possible to send an email by clicking on the email address? Now, I only have a vague familiarity with VBA as I've taken an Access Intermediate class. We were just introduced to it at the end of the class, so you may have to walk me through it like a...

Jdraw, I think I like your way best. Thank you, so much for the help. I really appreciate it. Regina

Plog, You are right and I've corrected that, but thank you for pointing it out. I just as easily could have missed it, especially in my frantic state of trying to work this out. Thanks, Regina

Jdraw, Thank you, very much. That helped. I don't know how I did it and I know I still don't quite get it, but I managed to create a main form for my students with a subform, based on the junction table. I changed the ClassId to a combo box and in the window selected the ScheduledClasses...

Jdraw, I'm not seeing a model, just an ad for the cloud. Thank You, Regina

I started a brand new database just to play with designing a junction table. This is what I have. ScheduledClasses Table ClassID PK ClassDate Host Location Address City State Zip Students Table StudentID PK Agency Title First Last Address Phone...

jdraw, The tutorial looks like it's exactly what I need. I just printed it. I actually learn best this way. Thank You, Regina

Ok, I created my junction table. I think I'm going to love this, by the way. Now it looks like this: tblInstructor InstructorID (PK) tblScheduledClasses ClassID (PK) junctionClassParticipants InstructorID ClassID So, now, do I add fields to the junction table, for example ClassDate...

Plog, Ok, I see. The instructor table is actually the participant. We train law enforcement in less lethal. Each agency sends one instructor to a class. The instructor may attend 3 classes, then is recertified in each annually. I was looking at another one of your posts, which was...

jdraw, Ok, so the ScheduledClasses table would be the junction table. Thank Ya'll, so much. I'm going to play, now. Regina

Plog, I don't see a link. There is just an ad. Where do I find your link? Thank You, Regina

I'm really new at this. I just finished a basic class. What do you mean by junction table? Thank You, Regina

I should have posted this under a different forum (Tables), but I'm new at this. I think I've figured it out, but if someone could take a look, please. Tbl Instructor Instructor (PK) Name Add...etc Tbl Locations LocationID (PK) Address...etc Tbl ScheduledClasses ClassID (PK) InstructorID...