A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #41  
Old February 10th, 2005, 02:55 PM
Ken Snell [MVP]
external usenet poster
 
Posts: n/a
Default

Agreed, Duane.

I will discontinue this thread and we'll let the new thread continue this
exchange.

:-)

--

Ken Snell
MS ACCESS MVP

"Duane Hookom" wrote in message
...
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?







 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
HELLLLLLLLP!! I Need To Pull This Excel File Into Access And... - Sample.xls (0/1) [email protected] New Users 1 February 18th, 2005 05:29 PM


All times are GMT +1. The time now is 12:02 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.