Multiple Entries for One Record

[MRG55]

Hi,
I have created a DB to hold training records for a company and have been using it for some years. When I record training I have to enter the data for one person at a time which is fine when you only need to do 10 or 12 but recently I had twenty people complete the same training and I don't really want to enter them one at a time.

What I would liket to be able to do is to bring up the Training Form, select the one Training Description (TrainingDescriptionQuery) and then select multiple Employees from the EmployeeDetailsQuery. IS there a simple way of doing this.

I'm not over conversant with Access - I built the DB after a little training and a lot trial and error - but it works.

Any help greatly appreciated
MRG55

 

[pbaldy]

If it fits your design:

http://www.baldyweb.com/MultiselectAppend.htm

 

[MRG55]

Thanks Paul,
A bit time poor at the moment so I will have a look over the next few days and see how I go.

Cheers
Marty

 

[pbaldy]

No worries Marty.

 

[MRG55]

Hi Paul,

Apologise for taking so much time in getting back to you.

I have had a look at the db you sent and the code but I am afraid I am still none the wiser - guess that comes from dabbling in something that you don't know enough about.

In the db I wasn't sure what 'value' was required - I tried a couple of things but nothing seemed to give me the result I was after and although I have played with code a bit I don't necessarily understand it.

I have attempted to attach a skeleton copy of my db with, I believe, the necessary tables, queries and form that I want to adjust. So, all I am after is to be able to select one training description and record multiple employees as having completed it.

If you could perhaps have a look and advise me it would be greatly appreciated. I don't expect an immediate response to this - I have been pondering the solution and playing when I have the time for the past couple of years so this is definitely not urgent.

Thanks for looking at my problem.

Cheers
Marty

 

[pbaldy]

The key to my method is using a multiselect listbox. You just have a combo, which only allows the selection of 1 person.

 

[MRG55]

Thanks Paul,
I will have a play with the listbox and see how I go.

Cheers
Marty