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

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?

--
Duane Hookom
MS Access MVP


wrote in message
...
This is making me crazy!!!!

Now I have a all the FirstName Last Name(It is not the actual names
but FirstName LastName) in the student ID Combo Box

The Lunch textbox has #Name?

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








On Mon, 14 Feb 2005 22:07:55 -0600, "Duane Hookom"
wrote:

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?

Sorry the third Text Box Name is Class

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

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









On Tue, 15 Feb 2005 10:43:43 GMT, wrote:

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

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.






On Tue, 15 Feb 2005 11:36:58 GMT, wrote:

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









On Tue, 15 Feb 2005 10:43:43 GMT, wrote:

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

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

On Tue, 15 Feb 2005 12:30:20 GMT, wrote:

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.






On Tue, 15 Feb 2005 11:36:58 GMT, wrote:

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









On Tue, 15 Feb 2005 10:43:43 GMT, wrote:

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

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
--

wrote in message
...
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.






On Tue, 15 Feb 2005 11:36:58 GMT, wrote:

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









On Tue, 15 Feb 2005 10:43:43 GMT, wrote:

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

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.

On Tue, 15 Feb 2005 18:19:32 -0600, "Duane Hookom"
wrote:

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

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
--

wrote in message
...
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.

On Tue, 15 Feb 2005 18:19:32 -0600, "Duane Hookom"
wrote:

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