473,320 Members | 1,862 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Using multi select list box

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
8 2636
PianoMan64
374 Expert 256MB
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
frys
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
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
32,556 Expert Mod 16PB
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
frys
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
32,556 Expert Mod 16PB
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
frys
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
32,556 Expert Mod 16PB
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

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

Similar topics

2
by: google | last post by:
Hello everyone, I am having an issue using the "Multi Select" option in a list box in MS Access 2003. I am making a form that users can fill out to add an issue to the database. Each issue can...
5
by: Parahat Melayev | last post by:
I am trying to writa a multi-client & multi-threaded TCP server. There is a thread pool. Each thread in the pool will handle requests of multiple clients. But here I have a problem. I find a...
2
by: Zlatko Matiæ | last post by:
Hello. How to reference selected values from a multi-select list box, as a criteria in a query ? Is it possible at all? Regards, Zlatko
5
by: dkelly925 | last post by:
Is there a way to add an If Statement to the following code so if data in a field equals "x" it will launch one report and if it equals "y" it would open another report. Anyone know how to modify...
1
by: freetime | last post by:
Greetings, This is my first post so I will try to be brief and accurate. I have a report that uses 9 user selectable filters (Dates, Y/N's as Combo Boxes and 4 Multi-Select List Boxes. ...
4
by: John | last post by:
Hello All, Can someone help me with a problem I am having? I have a form which has a multi-select list where the user can select more than one company name from a list and I need to pass those...
11
by: woodey2002 | last post by:
This problem is driving me crazy. Hello there, i am trying to create a search form for records in my access database. The search form will contain text boxes and a multi select list box. The user...
2
by: woodey2002 | last post by:
Hi Guys and thanks for your time. I have a search form for my database that allows users to select multiple criteria from multi select list boxes. I successfully integrated a multi select...
6
by: woodey2002 | last post by:
Hi Everyone. Thanks for your time. I am trying to create a search form that will allow users to select criteria from multiple multi select boxes. So far i have managed to achieve a search option...
1
by: woodey2002 | last post by:
Hi Everyone and many thanks for your time.. I am trying to begin access and a bit of VBA i am enjoying it but I have a annoying problem I just can’t get any where on. My databse mostly includes...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.