HELLLLLLLLP!! I Need To Pull This Excel File Into Access And... - Sample.xls (1/1)

On Tue, 08 Feb 2005 21:17:17 GMT, wrote:

Private Sub TxtIDScan_AfterUpdate()

End Sub

Private Sub TxtIDScan_BeforeUpdate(Cancel As Integer)

End Sub

Delete up to here. The above four lines do absolutely nothing.

Private Sub txtStudentID_AfterUpdate()
Dim rs As DAO.Recordset
Set rs = Me.RecordsetClone ' get the form's list of records
rs.FindFirst "[Student ID] = '" & Me!txtStudentID & "'"
If rs.NoMatch Then ' see if this ID exists
MsgBox "Check this card, this ID was not found", vbOKOnly
Else
Me.Bookmark = rs.Bookmark ' open the found student's record
End If

Private Sub txtStudentID_BeforeUpdate(Cancel As Integer)

End Sub

And delete these two lines.

The AfterUpdate event (what's left) LOOKS ok. I'm assuming that the
Form's Recordsource is the table of students; that that table has a
field named Student ID, of Text type, which contains the unique
student ID which is also on the barcode; and that the textbox named
txtStudentID is Unbound (has no control source), but that there is
some other textbox on the form bound to the StudentID field.

If these assumptions are incorrect, I'm afraid it's up to you to fix
them - or you should start a new thread, with enough information to
allow another volunteer to help. I'm leaving tomorrow morning for the
rest of the week and won't be able to check the newsgroups. I'll ask
some of the other MVP's to look in on this thread to see if they can
help.

I'm sorry this has taken so long! What you're doing isn't trivial, and
it's doubly difficult at this remove both in space and time to figure
out what's boing wrong.


John W. Vinson[MVP]

On Wed, 09 Feb 2005 01:31:39 GMT, wrote:


What if I sent this to you and you straightened it out for me? What
would be your consultation fee? I have spent too many hours on this
and I am about at my wits end. We have it pretty much set up and I
would like to do two more things with it. One I would like to be able
to have a printout of the students that were scanned and entered the
lunch each day and show some kind of alert if the same ID was scanned
more than once during the same lunch period.

As noted elsethread, I'm going to be unavailable, actually for at
least two weeks. Sorry!

John W. Vinson[MVP]

Me -

I'm one of John's MVP peers and have read through the thread. It appears
that you want to have a form that allows you to "scan" the entry of students
into a lunch room, and to store all the students who're scanned so that you
can print out the info later? Is this correct?

--

Ken Snell
MS ACCESS MVP


wrote in message
news
On Tue, 08 Feb 2005 10:59:50 -0700, John Vinson
wrote:

On Tue, 08 Feb 2005 07:44:09 GMT, wrote:

I did what you said. Now when I enter an ID number in the unbound box
it moves the other information to the next students ID number, name,
etc.? Is there any information I can post so you can look at this and
see what is wrong?

Ah!

Ok, set the Form's Cycle property to Current Record. It's going on to
the next record because this is the last control in the tab order.

Now it does nothing

As for the Event Property appearing on every field, I do not
understand that at ALL. Please open the Form in design view; click the
Code button on the toolbar; and copy and paste *everything* in the
form's code to a message here.

Private Sub TxtIDScan_AfterUpdate()

End Sub

Private Sub TxtIDScan_BeforeUpdate(Cancel As Integer)

End Sub

Private Sub txtStudentID_AfterUpdate()
Dim rs As DAO.Recordset
Set rs = Me.RecordsetClone ' get the form's list of records
rs.FindFirst "[Student ID] = '" & Me!txtStudentID & "'"
If rs.NoMatch Then ' see if this ID exists
MsgBox "Check this card, this ID was not found", vbOKOnly
Else
Me.Bookmark = rs.Bookmark ' open the found student's record
End If

Private Sub txtStudentID_BeforeUpdate(Cancel As Integer)

End Sub


John W. Vinson[MVP]

Yes that is it!

On Wed, 9 Feb 2005 11:07:58 -0500, "Ken Snell [MVP]"
wrote:

Me -

I'm one of John's MVP peers and have read through the thread. It appears
that you want to have a form that allows you to "scan" the entry of students
into a lunch room, and to store all the students who're scanned so that you
can print out the info later? Is this correct?

I would appreciate some help. I have now put many hours into this and
the new semester has started and we are getting swamped with students
who don't belong in this lunch because of the incompetence of my
superiors.

On Wed, 9 Feb 2005 11:07:58 -0500, "Ken Snell [MVP]"
wrote:

Me -

I'm one of John's MVP peers and have read through the thread. It appears
that you want to have a form that allows you to "scan" the entry of students
into a lunch room, and to store all the students who're scanned so that you
can print out the info later? Is this correct?

What information do you need to help me finish this project?

On Thu, 10 Feb 2005 00:01:41 GMT, wrote:

I would appreciate some help. I have now put many hours into this and
the new semester has started and we are getting swamped with students
who don't belong in this lunch because of the incompetence of my
superiors.

On Wed, 9 Feb 2005 11:07:58 -0500, "Ken Snell [MVP]"
wrote:

Me -

I'm one of John's MVP peers and have read through the thread. It appears
that you want to have a form that allows you to "scan" the entry of students
into a lunch room, and to store all the students who're scanned so that you
can print out the info later? Is this correct?

Let me recap and see if this is what you have set up so far:

(1) you have a form with various textboxes; all are locked/disabled except
for one, which is the one you want to use for the barcode scanner's output.

(2) the form's RecordSource is set to a table where the data will be stored
to show that a student was at the lunch.

(3) the textbox that will be used for the barcode results is not bound to
any field in the form's Recordsource.

(4) the textboxes that will show the student's information (to be displayed
after the barcode result is received by the form) are either bound to fields
in the form's RecordSource (so that the data can be stored in the table for
later printing/reviewing) or are unbound (because the info that they will
display does not need to be stored in the table).

(5) the intent is to use the barcode textbox's AfterUpdate event to "fill
in" the student's information by searching the table where the student's
information is stored (I assume that the barcode information does not
contain any info other than the ID for the student, and that the student's
name and other info are in a table in the database).

Ok so far?

Now this is where I need information.

(A) What is the form's recordsource? (Open the form in design view, click on
Properties icon on toolbar, click on Data tab, and copy the information in
the box next to the Record Source line.) Paste it here.

(B) What is the name of the table where the student's information is stored?
What are the fields in that table?

Post this information and we'll see what we can do.
--

Ken Snell
MS ACCESS MVP



wrote in message
...
Yes that is it!

On Wed, 9 Feb 2005 11:07:58 -0500, "Ken Snell [MVP]"
wrote:

Me -

I'm one of John's MVP peers and have read through the thread. It appears
that you want to have a form that allows you to "scan" the entry of
students
into a lunch room, and to store all the students who're scanned so that
you
can print out the info later? Is this correct?

It seems there is a new thread started with this same question. It didn't
occur to me earlier that the questions would be the same since this thread
began with a mention of Excel.

Please at least read my response which found several errors in the
code/solution that was posted.

--
Duane Hookom
MS Access MVP


"Ken Snell [MVP]" wrote in message
...
Let me recap and see if this is what you have set up so far:

(1) you have a form with various textboxes; all are locked/disabled except
for one, which is the one you want to use for the barcode scanner's
output.

(2) the form's RecordSource is set to a table where the data will be
stored to show that a student was at the lunch.

(3) the textbox that will be used for the barcode results is not bound to
any field in the form's Recordsource.

(4) the textboxes that will show the student's information (to be
displayed after the barcode result is received by the form) are either
bound to fields in the form's RecordSource (so that the data can be stored
in the table for later printing/reviewing) or are unbound (because the
info that they will display does not need to be stored in the table).

(5) the intent is to use the barcode textbox's AfterUpdate event to "fill
in" the student's information by searching the table where the student's
information is stored (I assume that the barcode information does not
contain any info other than the ID for the student, and that the student's
name and other info are in a table in the database).

Ok so far?

Now this is where I need information.

(A) What is the form's recordsource? (Open the form in design view, click
on Properties icon on toolbar, click on Data tab, and copy the information
in the box next to the Record Source line.) Paste it here.

(B) What is the name of the table where the student's information is
stored? What are the fields in that table?

Post this information and we'll see what we can do.
--

Ken Snell
MS ACCESS MVP



wrote in message
...
Yes that is it!

On Wed, 9 Feb 2005 11:07:58 -0500, "Ken Snell [MVP]"
wrote:

Me -

I'm one of John's MVP peers and have read through the thread. It appears
that you want to have a form that allows you to "scan" the entry of
students
into a lunch room, and to store all the students who're scanned so that
you
can print out the info later? Is this correct?

On Thu, 10 Feb 2005 00:02:26 -0600, "Duane Hookom"
wrote:

It seems there is a new thread started with this same question. It didn't
occur to me earlier that the questions would be the same since this thread
began with a mention of Excel.

Please at least read my response which found several errors in the
code/solution that was posted.

I'm sorry for starting a new thread I didn't know someone would pick
up the thread for John Vinson

On Wed, 9 Feb 2005 23:14:21 -0500, "Ken Snell [MVP]"
wrote:

Let me recap and see if this is what you have set up so far:

(1) you have a form with various textboxes; all are locked/disabled except
for one, which is the one you want to use for the barcode scanner's output.

(2) the form's RecordSource is set to a table where the data will be stored
to show that a student was at the lunch.

(3) the textbox that will be used for the barcode results is not bound to
any field in the form's Recordsource.

(4) the textboxes that will show the student's information (to be displayed
after the barcode result is received by the form) are either bound to fields
in the form's RecordSource (so that the data can be stored in the table for
later printing/reviewing) or are unbound (because the info that they will
display does not need to be stored in the table).

(5) the intent is to use the barcode textbox's AfterUpdate event to "fill
in" the student's information by searching the table where the student's
information is stored (I assume that the barcode information does not
contain any info other than the ID for the student, and that the student's
name and other info are in a table in the database).

Ok so far?

Now this is where I need information.

(A) What is the form's recordsource? (Open the form in design view, click on
Properties icon on toolbar, click on Data tab, and copy the information in
the box next to the Record Source line.) Paste it here.
Student List 2-5

(B) What is the name of the table where the student's information is stored?
What are the fields in that table?

Post this information and we'll see what we can do.