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. |
|
|
Thread Tools | Display Modes |
#41
|
|||
|
|||
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 | |
|
|
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 04:29 PM |