By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 2,161 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

Using multi select list box

P: 29
I have a database that tracks peoples attendance in classes. I have 3 tables

1 Class
2 student
3 Attendance

I have to track between 30 and 40 people each class. i currently have a form to input the class and the description of the class. i then have a subform that tracks the students in the class.

right now i have a combo box that has the sudents names listed i choose a name and the box closes the name is generated into the attendance record. what i would like to be able to do is select all 30 people that attened a class and have access gererate the records for each of those students.

is this possible

thanks

chris
Jun 3 '08 #1
Share this Question
Share on Google+
8 Replies


Expert 100+
P: 374
Yes, it is possible. Can you include what table and query structure you have, and I'll be able to give you a more detailed answer, or if you want to send me a copy of what you have with some example data, that would even be better.


Hope that helps,

Joe P.
Jun 4 '08 #2

P: 29
Yes, it is possible. Can you include what table and query structure you have, and I'll be able to give you a more detailed answer, or if you want to send me a copy of what you have with some example data, that would even be better.


Hope that helps,

Joe P.
Joe i would love to send you a test copy of what i am working on can you send me a e mail to ** email address removed as per site rules ** so i can attach it for you
Jun 5 '08 #3

P: 23
In the meantime have a look at this. Some additional help can go a long way

http://www.msaccesstips.com/2008/05/...-dynamic.shtml

Creates a Dynamic Query using selected items from a List Box to filter records from an underlying table.

Regards,
Jun 5 '08 #4

NeoPa
Expert Mod 15k+
P: 31,307
Chris, Joe,

If you must converse directly, please exchange your details via the PM system provided. We remove all private contact details in threads for your own protection (as per the rules).

In fact, we really prefer questions to be asked and answered in the threads, as that is the point of the site. It exists, not only to answer individual members' questions, but also to be a repository of answers that can be found by anyone.

There may develop requirements that make this more complicated, but this question certainly hasn't reached that point yet.
Jun 6 '08 #5

P: 29
sorry .. something went a little squirrelly with my account.. could you please help me out with this issue. The query is currently

Main Table: Course
Lists all course information

Sub Table: Attendance
Lists all attendees to each course

Attendance Table is showing all attendance based on Course
Jun 20 '08 #6

NeoPa
Expert Mod 15k+
P: 31,307
Yes, it is possible. Can you include what table and query structure you have, and I'll be able to give you a more detailed answer, ...

Hope that helps,

Joe P.
I suggest you provide the information requested (at least) before re-iterating your request for help.

You may want to consider clearing up the question too. I notice three tables mentioned in the first post. After a request for clarification and fuller information, you mention only two - and one of those is a new one.

PS. Here is a (copyable) example of how to provide table layout information.
Expand|Select|Wrap|Line Numbers
  1. Table Name=[tblStudent]
  2. Field; Type; IndexInfo
  3. StudentID; AutoNumber; PK
  4. Family; String; FK
  5. Name; String
  6. University; String; FK
  7. Mark; Numeric
  8. LastAttendance; Date/Time
Jun 23 '08 #7

P: 29
I hope this is what you are looking for me to show you.. If it is not i apologize and will attempt to give you the information needed to resolve my question

Expand|Select|Wrap|Line Numbers
  1. Table Name=[ProgID]
  2. Field; Type; IndexInfo
  3. ProgID; AutoNumber; PK
  4. ProgName;String;FK
  5. ProgDate;Date/Time
  6. StaffID,Numeric
Expand|Select|Wrap|Line Numbers
  1. Table Name=[StudentID]
  2. Field; Type; IndexInfo
  3. StudentID; AutoNumber; PK
  4. FirstName;String;FK
  5. LastName;String;FK
  6. ClassNumber;Numeric;
Expand|Select|Wrap|Line Numbers
  1. Table Name=[AttendanceID]
  2. Field; Type; IndexInfo
  3. AttendanceID;AutoNumber;PK
  4. ProgID; Number; FK
  5. StudentID; Number;FK
  6. Notes;String
thanks for your help
Jun 23 '08 #8

NeoPa
Expert Mod 15k+
P: 31,307
That's a good example of what's required, but it seems like Joe has gone awol.

If you still need help with this then I'll step in and do what I can.
Aug 20 '08 #9

Post your reply

Sign in to post your reply or Sign up for a free account.