John Vinson is gone for two weeks can someone help me finish up this project?

[Duane Hookom]

What is the record source of your form?

I have provided suggested properties for a combo box on the form. What are
your properties:
Name:
Control Source:
Row Source:
Column Count:
Bound Column:
Column Widths:

If you have other text boxes as I suggested, what are their control sources
and names?

 

[Me]

I have two tables
tblStudentsList
StudentID LastName FirstName Grade HR Lunch Class

tblStudentsLunchAttend
ID (AutoNumber) StudentID

I Have A Form
with a list box which is now showing a list of the real first and last
name of students

Name cboStudentID
Control source Blank
Row Source Type Table/Query
Row Source SELECT StudentID, [FirstName] & " " & [LastName] AS
FullName, Grade, Lunch, HR FROM tblStudentslist;
Column Count 5
Column Heads No
Column Widths 0";1.5";0.5";0.5";0.5"
Bound Column 1
Default Value Blank
IME Hold No
IME Mode No Control
IME Sentance Mode None
Validation Rule Blank

First Text Box

Name Lunch
Control source =cboStudentID.Column(5)
Format Blank
Decimal Places Auto
Input Mask Blank
Default Value Blank
IME Hold No
IME Mode No Control
IME Sentance Mode None
Validation Rule Blank
Validation Text Blank

Second Text Box

Name Grade
Control source =cboStudentID.Column(4)
Format Blank
Decimal Places Auto
Input Mask Blank
Default Value Blank
IME Hold No
IME Mode No Control
IME Sentance Mode None
Validation Rule Blank
Validation Text Blank

Third Text Box

Name Lunch
Control source =cboStudentID.Column(7)
Format Blank
Decimal Places Auto
Input Mask Blank
Default Value Blank
IME Hold No
IME Mode No Control
IME Sentance Mode None
Validation Rule Blank
Validation Text Blank

 

[Me]

Sorry the third Text Box Name is Class

 

[Me]

I changed SELECT StudentID, [FirstName] & " " & [LastName] AS
FullName, Grade, Lunch, HR FROM tblStudentslist;
TO: SELECT StudentID, [FirstName] & " " & [LastName] AS
FullName, Grade, Lunch, Class FROM tblStudentslist;
I didn't realize until I scolled over that the List Box is showing the
real students name First and Last combined, Grade, Lunch, and Class

 

[Me]

I added another Text Box Student Name and changed the column numbers
so they all work

I changed the Column Widths: from 0,1.5,0.5, 0.5, 0.5 to 1,1.5,0.5,
0.5, 0.5 Now I can see the Student ID in the List Box

If I scroll through the Student ID and reverse video the number the
correct information show up in the other Text Boxes (WaaaHoo!)

If I try to type an ID number in just the first number typed matches
then the second number I type in brings up a different first number in
the student ID

 

[Me]

I changed the list box to a Combo box and it's working!!!!

Now is there a way that I can continously scan ID numbers in without
mouse clicking on the combo box after each ID number is entered?

Then there is the list of students that have attended the lunch.
Is there a way to only list student that have been scanned that belong
in that lunch.

Also is there a way to show a prompt to show that the number has been
scanned more than once during one luch period.

I hope this isn't too much to ask?

I can go on some of the Forums I found searching for Info.

I added another Text Box Student Name and changed the column numbers
so they all work

I changed the Column Widths: from 0,1.5,0.5, 0.5, 0.5 to 1,1.5,0.5,
0.5, 0.5 Now I can see the Student ID in the List Box

If I scroll through the Student ID and reverse video the number the
correct information show up in the other Text Boxes (WaaaHoo!)

If I try to type an ID number in just the first number typed matches
then the second number I type in brings up a different first number in
the student ID

I changed SELECT StudentID, [FirstName] & " " & [LastName] AS
FullName, Grade, Lunch, HR FROM tblStudentslist;
TO: SELECT StudentID, [FirstName] & " " & [LastName] AS
FullName, Grade, Lunch, Class FROM tblStudentslist;
I didn't realize until I scolled over that the List Box is showing the
real students name First and Last combined, Grade, Lunch, and Class

 

[Me]

Again
Thank You For All Your Help So Far!!!!!!!

I changed the list box to a Combo box and it's working!!!!

Now is there a way that I can continously scan ID numbers in without
mouse clicking on the combo box after each ID number is entered?

Then there is the list of students that have attended the lunch.
Is there a way to only list student that have been scanned that belong
in that lunch.

Also is there a way to show a prompt to show that the number has been
scanned more than once during one luch period.

I hope this isn't too much to ask?

I can go on some of the Forums I found searching for Info.

I added another Text Box Student Name and changed the column numbers
so they all work

I changed the Column Widths: from 0,1.5,0.5, 0.5, 0.5 to 1,1.5,0.5,
0.5, 0.5 Now I can see the Student ID in the List Box

If I scroll through the Student ID and reverse video the number the
correct information show up in the other Text Boxes (WaaaHoo!)

If I try to type an ID number in just the first number typed matches
then the second number I type in brings up a different first number in
the student ID

I changed SELECT StudentID, [FirstName] & " " & [LastName] AS
FullName, Grade, Lunch, HR FROM tblStudentslist;
TO: SELECT StudentID, [FirstName] & " " & [LastName] AS
FullName, Grade, Lunch, Class FROM tblStudentslist;
I didn't realize until I scolled over that the List Box is showing the
real students name First and Last combined, Grade, Lunch, and Class

 

[Duane Hookom]

Everything we have suggested has your form bound to tblStudentsLunchAttend
that has both the studentID and the LunchDate. Why do you not have a date
field in this table? You can also set a unique index on the StudentID +
LunchDate fields. Make sure the LunchDate field has a default of Date().
This will not let you scan the same student twice.

You also need to set the control source of the combo box to StudentID as
suggested earlier.

I have replied at least twice with the above mentioned design properties and
you seem to have completely ignored them. If you expect assistance from news
groups, you must learn how to follow instructions and comply.

--
Duane Hookom
MS Access MVP
--

I changed the list box to a Combo box and it's working!!!!

Now is there a way that I can continously scan ID numbers in without
mouse clicking on the combo box after each ID number is entered?

Then there is the list of students that have attended the lunch.
Is there a way to only list student that have been scanned that belong
in that lunch.

Also is there a way to show a prompt to show that the number has been
scanned more than once during one luch period.

I hope this isn't too much to ask?

I can go on some of the Forums I found searching for Info.

I added another Text Box Student Name and changed the column numbers
so they all work

I changed the Column Widths: from 0,1.5,0.5, 0.5, 0.5 to 1,1.5,0.5,
0.5, 0.5 Now I can see the Student ID in the List Box

If I scroll through the Student ID and reverse video the number the
correct information show up in the other Text Boxes (WaaaHoo!)

If I try to type an ID number in just the first number typed matches
then the second number I type in brings up a different first number in
the student ID

I changed SELECT StudentID, [FirstName] & " " & [LastName] AS
FullName, Grade, Lunch, HR FROM tblStudentslist;
TO: SELECT StudentID, [FirstName] & " " & [LastName] AS
FullName, Grade, Lunch, Class FROM tblStudentslist;
I didn't realize until I scolled over that the List Box is showing the
real students name First and Last combined, Grade, Lunch, and Class

 

[Me]

I am trying to follow your advice but some of the recommendations you
give I do not understand and it takes hours to find out what you mean.
I your old posts about the other table but could not get anything to
work.

First how do I make the form bound to the tblStudentsLunchAttend
table?

Setting the control source of the combo to studentID on the
tblStudentsLunchAttend?

I'm still researching setting a unique index.

I'm been kind of out of it the last few days my good friend and
neighbor who is a year younger than me (54) dropped dead of a heart
attack after working in his yard. It's taking a little longer for
thing to sink in to this thick skull. I tried working on it this
morning but I have to wait until my head is a little clearer.

 

[Duane Hookom]

How about you click this link www.access.hookom.net/studentlunch.zip to
download a zipped Access 2000 file that demonstrates what should happen in
your application. The student table is actually the Employee table from
Northwind so ignore the values.

--
Duane Hookom
MS Access MVP
--

I am trying to follow your advice but some of the recommendations you
give I do not understand and it takes hours to find out what you mean.
I your old posts about the other table but could not get anything to
work.

First how do I make the form bound to the tblStudentsLunchAttend
table?

Setting the control source of the combo to studentID on the
tblStudentsLunchAttend?

I'm still researching setting a unique index.

I'm been kind of out of it the last few days my good friend and
neighbor who is a year younger than me (54) dropped dead of a heart
attack after working in his yard. It's taking a little longer for
thing to sink in to this thick skull. I tried working on it this
morning but I have to wait until my head is a little clearer.

 

[Me]

Thank You So Much!!!!!!!!!!!!!!!!!!!!!!!!!!!!

You Are The Best!

Now all I have to do is figure out is how to print out all the scanned
Students as a form so I can give the list to the teachers so they will
know who went to lunch and didn't go to class.

 

[Me]

Just figured out how to print it.

Thanks Again for all your assistance and time

 

[Duane Hookom]

You shouldn't print forms. You should print reports.

--
Duane Hookom
MS Access MVP

Just figured out how to print it.

Thanks Again for all your assistance and time

 

[Me]

I checked five different books on Access and could not get a form to
work from the two tables. Not only didn't it work but it screwed
evrything else up. Glad I did a bunch of saves.I just changed the
frmLunchEntry to a datasheet view and export it to an Excel file pull
it into Excel and print from there.

Little blasted after the funeral today.

Again! Thanks for all the help!!!

 

[Duane Hookom]

"Get a form to work from the two tables" Huh? I thought you were needing to
print some records?

 

[Me]

I can I just save as an an Excel file and print from there!

 

[Me]

All I have to print is the students that attend the lunch each day
because for 20% of the students in my school that is the only "class"
they attend!

 

[Duane Hookom]

This would be a very simple report to create. If you don't want to try, just
continue to use Excel.

 

[Me]

If you want to help me create a report I am willing to try it.

 

[Duane Hookom]

Start a new thread in the Reports news group on how to create a report. The
important thing is to first see how far you get on your own. Google is your
friend.

Then ask a specific question. Questions like "How do I create a report" are
not good. Also, asking several questions in one posting is not adviseable.

Providing table and field names, sample records, and desired output will
help you get a better answer in less time.