Search results

Thanks Paul, what I suppose I am lacking is what would the code be to call a particular query. I think the best place for it would be CurrentRosterList: event: after update? Oh, and thanks for the Multiselect listbox idea. Perfect way to go. Ken

I have been reverse engineering the form, but this last statement has me a bit confused. Can anyone clarify? I mean I am not sure how I would trigger this query/ arrange it in the form.:confused:

spikepl, that is exactly what I was envisioning. Would you be willing to share the 'magic behind the curtain' for that form? And when I say exactly, I am not exaggerating; I also need to filter students by a JobCode, and each JobCode has a different training need. Your 'select department'...

I have been working on a training database, and keep trying to find a solution to the following problem: I have a form that the Training Admin will use to select students to a new class. they select the Class Name from a ComboBox tied to TblClass they select an Instructor from a ComboBox tied...

Thanks jdraw; that database diagram allowed me to see what I was trying to do wasn't necessary if I further normalized by making a TblClassRoster, and did some filtering by adding a Current Employee field to the TblEmployee and using a query. Just the push I needed.

Hello all, I am building a database for employee training. In the FrmNewTrainingGroup I am trying to create a form that will allow selection of a single class, a completion date, one or more instructors (or none at all) and a list of students by LName, FName, MI, EMP#. in my latest attempt, I...

Greetings, my name is Ken and I am an Access Newbie from Jacksonville, FL in the US. I have lots of experience from networking to cryptography and general computer science. But relational databases; not so much. I have done some reading but am now trying to make my first wee-DB. For...