Search results

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

In my database, I have 2 tables, well there are more but the questions pertains to 2 specific tables. Table1 ScheduledClasses, Table2 Participants. I want to put several participants into the scheduled class. Each participant takes multiple classes, which I want to show in the Participant...

Bob, Thank you. I didn't realize this was VBA until I asked my instructor. This apparently goes beyond the scope of my class.....again, so it's not something we'll be getting in to. I have been googling this same question for 6 weeks and not one tech in the US offered your method for...

Bob, You are a "Rock Star"!!! :D It works perfectly and....I can edit. Sometimes it helps to sleep on it. When you phrased it the way you did I realized I was working in the wrong field. I had it reversed. I was entering that code in the After Update of the field I wanted updated. I do have...

Ok, Bob, I'm back. I have racked my brain over and over. Thought if I slept on it...well, you know. I googled my question and everything I came up with says this should be working. I checked my properties to make sure the control source was correct and I didn't see anything that should cause...

Yes, tomorrow. I'm going home for the night. Sweet dreams, Bob, and thank you. Talk to you tomorrow. Regina.